(Leland Richardson) Learn several little-known SQL tricks/techniques used to improve query times and enforce business rules with common everyday web-development scenarios.

(Ted Krueger) In SQL Server 2005 to 2012, row limits took on a slightly new limit expectation when variable length data types were used: varchar, nvarchar, varbinary, sql_variant or CLR. Essentially, this is done by the addition of a large object page: Row Overflow Pages or pages in the ROW_OVERFLOW

(Brian Smith) At SP1 Project Server 2010 and SharePoint introduced support for SQL Server 2012. I had a question posted on some issues a customer had hit – so I thought I’d set my server up for building an OLAP cube against SQL Server 2012 – just to see if I could. I already knew I’d need to set u

(Pinal Dave) Let me start today’s blog post with a direction question. How many of you have ever used Template Browser? Template Browser is a very important and useful feature of SQL Server Management Studio (SSMS). Every time when I am talking about SQL Server there is always someone comes up with

(Rajendra Gupta) SQL Server 2012 introduces two new analytical functions, LEAD() and LAG(). In this tip we will be exploring these functions and how to use them.

(fraser125) As most things this idea started with a simple wish spoken out loud, “I wish I could make a change to a table in SQL and have all of the CRUD sprocs automatically update”. Everybody and their brother have created a sproc generating program of one type or another but it always has to be r

(Ashish Kumar Mehta) The FileTable feature of SQL Server 2012 is an enhancement to the FILESTREAM feature which was introduced in SQL Server 2008. In this tip we will take a look at how to use FileTable feature of SQL Server 2012.

(Buck Woody) With such a large platform, Windows Azure has a lot of moving parts. We’ve done our best to keep the interface as simple as possible, while giving you the most control and visibility we can. However, as with most Microsoft products, there are multiple ways to do something – and I’ve alw

(Robert Sheldon) Whenever Microsoft releases a new version of SQL Server, the new version inevitably contains enhancements to Transact-SQL (T-SQL), as is the case with SQL Server 2012. The latest updates to T-SQL include numerous new and modified elements that extend the language’s capabilities.

(Gregory Larsen) Have you ever wondered what records are being inserted, updated and deleted in one or more SQL Server tables? When SQL Server 2008 was released the Microsoft product group came out with a new feature called “Change Data Capture”.