SQL SERVER – Reseting Identity Values for All Tables
SQL SERVER – Color Coding SQL Server Management Studio Status Bar – SQL in Sixty Seconds #023 – Video
I often see developers executing the unplanned code on production server when they actually want to execute on the development server. Developers and DBAs get confused because when they use SQL Server Management Studio (SSMS) they forget to pay attention to the server they are connecting. It is very easy to fix this problem. You can select different color for a different server. Once you have different color for different server in the status bar, it will be easier for developer easily notice the server against which they are about to execute the script.
SQL SERVER – Installing Data Quality Services (DQS) on SQL Server 2012
SQL SERVER – Winners – Contest Win Joes 2 Pros Combo (USD 198)
SQLAuthority News – 2 Security Updates for SQL Server 2000 SP 4 Users
SQLAuthority News – Presented at Bangalore DevCon August 4, 2012
SQL SERVER – Curious Case of Disappearing Rows – ON UPDATE CASCADE and ON DELETE CASCADE – T-SQL Example – Part 2 of 2
SQL SERVER – Curious Case of Disappearing Rows – ON UPDATE CASCADE and ON DELETE CASCADE – Part 1 of 2
Social media has created an Always Connected World for us. On the second day of the event after the learning was over, I noticed lots of notification from my friend on my various social media handle. He had connected with me on Twitter, Facebook, Google+, LinkedIn, YouTube as well SMS, WhatsApp on the phone, Skype messages and not to forget with a few emails. I right away called him up. Let us learn about ON UPDATE CASCADE and ON DELETE CASCADE.
SQLAuthority News – Technical Review of Learning
I had enrolled for three days training so my routine each of the three days was very much same. However, the content every day was different as I was learning something new every day. Let me describe a few of the interesting details of my daily routine. Let us see a technical review of learning.