3/10
NoSQL databases offer an alternative to traditional relational databases, but they might not be the right fit for everyone. 3/08
In his latest article, Marcin Policht demonstrates a variety of tools that can be employed to execute SQL Server Integration Services packages, focusing in particular on the method leveraging functionality available within the Business Intelligence Development Studio.
3/05
Views can be an effective tool for speeding up your selects and simplifying complex queries. Learn what indexed views are, where you might want to use them, how to create them, and what constraints exist with their use.
3/03
Learn how to use the SQL Server 2008 catalog view and dynamic
management view to access the audit details of existing server and database
level audits.
2/26
Determining which columns to select for your indexes is critical. Having a little knowledge of how your application is using your database columns and how SQL Server processes indexes helps you make good decisions when you create your indexes.
2/18
Marcin Policht delves deeper into the specifics of SQL Server 2008 and 2008 R2's Integration Services by presenting the most straightforward method of creating SSIS packages using Import and Export Wizard.
2/17
XQuery and SQL/XML standard are processors for XML. SQL/XML
was designed to try to match the capabilities of XQuery as closely as possible and XQuery was designed not only to support XML, but also to support relational processing. Read on to learn why this may have a negative influence on their capabilities.
2/12
SQL Server impersonation, or context switching, is a means to allow the executing user to assume the permissions of a given user or login until the context is set back, set to yet another user, or the session is ended. Deanna Dicken shows you two mechanisms for accomplishing this task and walks through some examples.
2/09
Learn how to create a database
level audit at a granular level and retrieve the audit records in this 9-step tutorial.
2/03
MAK shows us how easy it is to create a database level audit, test the audit and retrieve the audit records in
Microsoft SQL Server 2008.
2/02
Internet.com launches a new daily newsletter to provide one-stop coverage of all the database technology information and trends that matters to you.
2/01
Marcin Policht shows you how to install and configure
SQL Server 2008 and 2008 R2 Integration Services.
1/29
The creation of database indexes is the last thing developers and database designers think about--almost an afterthought. Greg Larsen shows you some of the dos and don'ts of indexing to help you pick reasonable indexes at design time.
1/25
The latest release of SSIS strengthens its position as one of the primary foundations of Business Intelligence, delivering a powerful framework for solutions that combine data from disparate sources, facilitating its analysis and reporting. Join Marcin Policht as he reviews its general characteristics.
1/22
Join BI Architect Bill Pearson in this introduction to Security in
Analysis Services 2008. Here we explore security concepts and implementation,
and look forward to hands-on practice with security in other articles of this subseries.