One thing I have noticed in forums is that people are curious about features available with different flavors of SQL Server. Most of the times questions comes like I installed SQL Server…
Have you ever done a point in time restore? If not,then consider yourself lucky. In case you are forced to do a point in time restore in near future,then this…
TDE was introduced in SQL Server 2008 as an Enterprise/Developer edition feature.This feature allows to encrypt the whole database and includes database backup’s. I was interested to test TDE in…
As we have a new version of Adventureworks database for SQL Server 2012 RC 0 I wanted to start my testing on the same.I downloaded the mdf file from the…
I have been playing around earlier CTP versions of Denali and focus was mainly on contained databases.Today I had a chance to review Contained Databases on SQL 2012 RC 0…
I have been waiting to deploy SQL Server 2012 RC0 on a x64bit Windows Server,and today I was able to grab a VM to start of my core testing with…
If you like Adventureworks database for your testing,then you might have faced issues previously while trying to deploy to SQL server 2008/R2. Currently all the issues are resolved and deployment…
.NET team has just released Update 4.0.2 for .NET Framework 4. I definitely prefer this latest version to be on my servers when I roll out SQL server 2012. What…
SQL Server express has now a light weight version which is called as Local DB.This is mainly intended for Developer and does not require any management. Super easy to install…
Configuration changes like Max/Min memory,MDOP(Max Deg of Parallelism) will indeed flush the plan cache and this should be on your mind while scheduling configuration changes during a very busy server…