By Denny Cherry, 08/25/2009
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 ...
By Brendon Schwartz, 08/24/2009
Prevent embedded data connections by storing connection files in DCLs.
By Michael Otey, 08/24/2009
These 7 essential T-SQL functions work with SQL Server’s classic datetime data type and can help you in myriad ways.
By Teo Lachev, 08/21/2009
Table-value parameters, a new feature in SQL Server 2008, makes it easier to pass multivalued parameters. Learn how to use them.
By Yaniv Etrogi, 08/17/2009
This process watches for events and sends you a daily email so you can stay on top of your servers.
By Jameel Ahmed, 08/12/2009
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. ...
By Luther Miller, 08/07/2009
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 ...
By Itzik Ben-Gan, 08/06/2009
Learn which insert methods can benefit from minimal logging, to improve your statements' performance.
By Michael Otey, 07/25/2009
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 Gennadiy Chornenkyy, 07/23/2009
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 ...