(Buck Woody) This tutorial is a two-part series where I’ll cover two new features introduced in SQL Server 2008 R2. I make a point of not covering features in a beta state, since that’s not as useful to “real world” data professionals. Things change during a beta or more accurately the “Community Te

(Jamie Thomson) A question on the SSIS forum earlier today asked: I need to dynamically unpivot some set of columns in my source file. Every month there is one new column and its set of Values. I want to unpivot it without editing my SSIS packages that is deployed

(Allan Mitchell) In SQL Server 2005 and SQL Server 2008, Microsoft has added some fantastic visualizations around data-mining algorithms. These visual aids allow us to see exactly what a particular algorithm is predicting or describing—making a difficult subject easier to understand.

(Andy Novick) When looking for impending problems due to lack of disk space it’s necessary to know how much space is available on each drive. There have been other tips written about how to do this, but in this tip I show you a way this can be done using SQLCLR.

SQL Server 2008 R2 has introduced SQL Server utility as part of it’s multi-server administration enhancements – it is the center of operations for consolidating and monitoring the managed instances of SQL Server. You can launch the utility explorer from the View option in the Menu in SSMS. If you

(Jorg Klein) Quite often one or more sources for a data warehouse consist of flat files. Most of the times these files are delivered as a zip file with a date in the file name, for example FinanceDataExport_20100528.zip

(balnee) SQL injection attacks have been on the rise in the last two years, mainly because of automated tools. We first witnessed these automated attacks in December 2007, and since then very little has changed in the way that these attacks work.

(Edwin Sarmiento) In a previous tip on creating a Function to Return Default SQL Server Backup Folder , you’ve seen how you can create a T-SQL function to query the registry and retrieve the default SQL Server Backup folder. Is there an easier way to do it in Windows PowerShell?

(Wayne Berry) SQL Server ships with a fantastic graphical user interface: you might say the iPhone of database administration. It is called SQL Server Management Studio. SQL Server Management Studio gives the part-time SQL Server database administrator who is running Workforce Central a big advantag

(Suprotim Agarwal) I was recently preparing a query for a report where the client needed to find out the following information from a small table – – Products that have been Discontinued but are receiving Orders – Products that have not been Discontinued but do not generate Orders