Minimizing Fragmentation when Moving data using a Switch

Yesterday was the first day of the SQL Server 2008 R2 airlift.I attended a great session on Implementing a Fast...

SQL Server 2008 R2 Multi-server Administration - A First Look

One of the most useful new features of SQL 2008 R2 for DBA’s is the ability to manage and administer multiple instances of SQL Server from a central location using the new SQL Server Utility tool.

Dynamically name report/file export in SSRS

Wouldn't it be nice if you could have the report's name and filename be changed to something more specifically related to the particular run of that report.

Configure Windows Firewall for SQL Server 2008 Database Engine in Windows Server 2008 R2

I have installed SQL Server 2008 Developer Edition on Windows Server 2008 R2 and I am unable to get connect to SQL Server 2008 Instance from SQL Server 2008 Management Studio which is installed on another remote server. As I am new to Windows Server 2008 R2 it would be great if you can let me know the step by step approach to enable the default port of SQL Server 2008 in Windows Firewall for user connectivity.

TSQL Challenge 26 - Identify weekly schedule of training programs by course, classroom and timing

Here is another scheduling problem that deals with the allotment of classrooms for various training programs. Your chalenge is to read the source data and build an output result set that shows the weekly schedule of each training topic and the class room in which training is scheduled.

SQL Server 2008 T-SQL Enhancements Part - III

Continuing with his series on T-SQL enhancements in SQL Server 2008, Arshad Ali brings us a look at the HierarchyID and Large UDTs.

Microsoft SQL Server identify I/O bottlenecks

You can also identify I/O bottlenecks by examining the latch waits. These latch waits account for the physical I/O waits...

SSIS Packages - the Simplest Way to Create Them

Martin 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.

Thoughts on SQL Server Certification

This is probably part 1 of a series, but no guarantees.

Why Certify?
I've been working with SQL Server for 10 years...

XML Workshop 25 - Inserting elements and attributes to an XML document

This article from MVP Jacob Sebastian looks at the modify method for changing an XML document.