Monday, August 8, 2016

SQL SERVER 2016

›
Learn more about SQL Server 2016 : https://www.microsoft.com/en-us/cloud-platform/sql-server-features Get Started with SQL Server 20...
Saturday, September 29, 2012

SQL Server 2012 New feature:Data Quality Services (DQS)

›
Refer the below link to learn about SQL Server 2012 new feature Data Quality Services (DQS) http://technet.microsoft.com/en-us/sqlserver/...
Monday, September 3, 2012

Introducing IIF() to SQL Server Family !!!

›
IIF() function is new to SQL Server family of functions. It is a brand new logical function being introduced with SQL Server 2012 that al...
Thursday, May 24, 2012

INTRODUCING SEQUENCE IN SQL SERVER 2012

›
T here are many applications that require incremental numbers for maintaining unique rows in a table. For several years, we’ve been using ...
Monday, April 23, 2012

Verify SQL Backups!!!

›
       This is something everyone of us  give least preference and times feel this is not required at all, confident on our latest backup t...
Friday, February 24, 2012

BEST PRACTICES: LOCK DOWN YOUR SA ACCOUNT/PASSWORD

›
            Many of the services we run within Microsoft uses Windows Authentication. However, there are some services that still uses Mixe...
Wednesday, November 30, 2011

Some of the best practices for shrinking T-Log files.

›
Hi  all,                 There are fixed boundaries from which a transaction log file can be shrunk. The size of the virtual log files w...