SQL Server Magazine September 2009
[Focus]
Add high-availability to your SQL Server 2008 environment by following these steps to configure a Windows Server 2008 cluster and install SQL Server 2008 instances on the cluster nodes.
By Denny Cherry
[Features]
Easily change input parameters for SQL Server Integration Services (SSIS) packages at execution time, by using this handy technique that calls a Windows Form from an SSIS 2005 package.
By Gennadiy Chornenkyy
Prevent embedded data connections by storing connection files in DCLs.
By Matt Ranlett , et al.
Table-value parameters, a new feature in SQL Server 2008, makes it easier to pass multivalued parameters. Learn how to use them.
By Teo Lachev
Three common methods for querying AD are using a linked server, using an SSIS ADO.NET connection manager, and using an SSIS Script component. But these three methods aren't equal. Learn how they work and why their results differ.
By Jameel Ahmed
This process watches for events and sends you a daily email so you can stay on top of your servers.
By Yaniv Etrogi
[Editorial]
Mike Otey looks at the lengthy release line-up from Microsoft in 2009 and 2010 and considers the value of moving to SQL Server 2008 R2. Is a BI-focused release for you?
By Michael Otey
[Reader to Reader]
The DATEPART function uses the DATEFIRST value when returning the day of the week. Because the DATEFIRST value can differ between regional settings and can be changed, DATEPART can return incorrect results. Here's how to avoid any problems.
By Luther Miller
[T-SQL Black Belt]
Learn which insert methods can benefit from minimal logging, to improve your statements' performance.
By Itzik Ben-Gan
[SELECT TOP(X)]
These 7 essential T-SQL functions work with SQL Server’s classic datetime data type and can help you in myriad ways.
By Michael Otey
|
