SQL Server 2012 Service Pack 4 is released. I stopped writing service pack news long ago, but this one is worth a note. Here is what you need to know.
SQL SERVER – Vertical Select Mode feature in SQL Server Management Studio
Balmukund showed me the Vertical Select Mode in SSMS: hold ALT, select a block, then type on every row at once. It works in SQL Server 2012 and later.
SQL SERVER – Find Weekend and Weekdays from Datetime in SQL Server 2012
Is today a weekend or a weekday? A question from the very first SQL Bangalore User Group meeting, answered with the CHOOSE function in SQL Server 2012.
SQL SERVER – Four Tutorial for SQL Server 2012 New Features
Looking for a tutorial for SQL Server 2012 new features? Here are four Microsoft tutorials, from multidimensional to tabular modeling with Adventure Works.
SQL SERVER – Fundamentals of Columnstore Index
Row store vs column store, explained simply. A Columnstore Index can make searches much faster, but it is not for every table. Learn where each one fits.
SQL SERVER 2012 – DateTime Functions – DATEFROMPARTS() – DATETIMEFROMPARTS() – DATETIME2FROMPARTS()
SQL Server 2012 adds seven new datetime functions, such as DATEFROMPARTS, DATETIMEFROMPARTS and EOMONTH. A quick look at building dates from their parts.