(Moshe Plotkin) This is going to be part of a three part series on using Linq2Sql together with WPF.

(Thomas LaRock) Databases keep getting larger, and the time we are given for backups to complete seldom keeps pace. With SQL 2008 you have the ability to compress your database backups, saving disk space but more importantly saving time.

(Kevin Beaver) Whether through manual poking and prodding or the use of security testing tools, malicious attackers employ a variety of tricks to break into SQL Server systems — both inside and outside your firewall. It stands to reason then, if the bad guys are doing it, you need to carry out the

(vijay kumar) The robust Transact-SQL (T-SQL) syntax in SQL Server provides developers with an efficient way to handle errors within stored procedures. This article discusses the @@ERROR, SP_ADDMESSAGE, and RAISERROR functions within SQL Server.

(Cindy Gross) This DMV returns information for the current database context. It can tell you how many rows are in each table (per partition) and how much of the space is used and reserved for in-row, overflow, and LOB data (with or without the metadata overhead).

(Thomas LaRock) Auditing your SQL Server instances has become more of a concern these days. SQL Server 2008 introduced a new feature named SQL Server Audit. Enabling this feature can be done in just a few simple steps, but so could disabling this feature. And when it comes to audits, many times you

(Anu Chawla) This is a continuation of our series on designing a SQL Server file subsystem. Our post on March 30 discussed software RAID (redundant array of independent disks) and RAID level 0. Today, we discuss the RAID levels that provide data redundancy—the ones that you really care about if you

(Siddharth Mehta) Development of any analytical solution normally ends with a form of report, whether it is a normal tabular report or a sophisticated interactive dashboard. In the first part of our BI-Satellite project, we devised a way to geocode location based spatial data using SSIS and Bing

(Suprotim Agarwal) Here’s a practical example of using CASE expression in SQL Server. I am creating a computed column using CASE expression where I will automatically calculate the value of a column based on the value of other columns:

(Jason Thomas) To be frank, I was extremely happy when I got to work on SSRS 2008. The 2008 version has changed so much for the better when you compare to the 2005 version, be it on terms of aesthetics or developer friendliness, you just name it.