|
|
-
|
|
I have been doing some research with DBM(Database Mirroring) repair features and today I came across this little tricky situation and decided to write about it.Scenario is something like below -
1. I tried to setup mirroring on a virtual environment and t...
|
|
-
|
|
Yesterday there was an interesting question which was floating around twitter.The question was when was the stored procedure last executed,Is it stored some where?
Immediate answer which came to my mind was there is no way we can get this information until...
|
|
-
|
|
It was a great news for me to hear that TechEd India 2012 will be streamed LIVE.TechEd is one of the best events where you learn a lot and get a chance to connect with the #SQLFamily.
The decision to stream the event LIVE is truly amazing and it gives a ch...
|
|
-
|
|
Today I was dealing with one of the questions related to local language support for SQL Server sys messages and suddenly this idea came to my mind to check whats the improvement for SQL Server 2012.
I was surprised to see that SQL Server 2012 now supports ...
|
|
-
|
|
SQLServer2012 virtual launch was a great event, and I am still preparing a lengthy blog post on my experiences with the event.
One of the sessions about File Table functionality in SQLServer 2012 attracted me a lot and couldn’t resist writing about t...
|
|
-
|
|
Extended events are one of most powerful feature which was exposed from SQL server 2008(On wards).Till SQL 2012 most of your actions involving extended events used to be through TSQL codes.I strongly believe that TSQL is really powerful and still the best ...
|
|
-
|
|
March 7th 2012 ! This was the day when SQL Server 2012 was launched virtually to everyone.I was looking forward for this event with great expectations.Even though we had a initial delay for the launch,everything was in place very soon and the platform www....
|
|
-
|
|
With SQL Server 2012 RTM GA on April 2012 some of you might have already started planning to migrate your database environments to 2012.
Migrating to SQL Server 2012 is a great idea from various angles and a right budget will ease your efforts too(Keeping ...
|
|
-
|
|
Today I was doing some test cases around model database, and was querying some of the tables.I just missed to close that session and was creating a new database.
Straight away I was hit by this error
We all know that a new database inherit the model st...
|
|
-
|
|
Recently I had a blog post related to Transparent Data Encryption(TDE) on SQL Server 2012 RC 0 and today I wanted to clean up my test environment and started the whole process.
Accidentally I wrote the command to delete the Master Key as a first setup a...
|
|