SQL Server Education (by the geeks, for the geeks)
Dear Friends, Every release of SQL Server shipped with full of new features so is SQL Server 2012. Some of them are Availability Groups, Contained Databases, Column Store Indexes, User Defined roles, …
SQL Server 2012 Restore Page using SSMS Read MoreHi Friends, Last week I took a webcast “Tap is the only Solution Ver.2 (SQL Server Resource Governor)“. The webcast was very well received and there were a lot of questions …
SQL Server Resource Governor Webcast – Demo Scripts Read MoreHi Friends, Recently Microsoft introduced a few changes in SQL Server 2012 in Memory Manger, and a DBA should be aware of such changes before upgrading or installation of SQL 2012 …
SQL Server – Memory Configuration Changes | SQL Server 2012 Read MoreLike we already know, Windows-based applications can use Windows AWE (Address Windowing Extensions) APIs to allocate and to map physical memory into the process address space. AWE allow 32-bit operating systems …
SQL Server AWE Enabled Option | Deprecated Read MoreHi Friends, In my last blog “Contained Databases in SQL Server 2012 – Denali” I wrote about the basics of Contained /Partially Contained Databases and its advantages. In this article I’ll …
SQL Server – Step-by-Step guide to Implement Contained Databases – SQL Server Denali Read MoreSQL Server Password audit is a must for all SQL Servers. Weak or Blank passwords are invitation to trouble and such type of passwords may result in security breach. Everybody knows …
SQL Server Password Audit for SQL Server Logins Read More