Tags » SQL Authority

SQL SERVER - A Practical Use of Backup Encryption

 Backup is extremely important for any DBA. Think of any disaster and backup will come to rescue users in adverse situation. Similarly, it is very critical that we keep our backup safe as well. 836 more words

SQL Authority

SQL SERVER - UPDATE From SELECT Statement with Condition

An email from an old college friend landed my mailbox:

“Hey Pinal,”

I have two tables. I want to conditionally update data in one table based on another table. 262 more words

SQL Authority

SQL SERVER - How to Check Snapshot Isolation State of Database

It is very easy to know the snapshot Isolation State of Database and here is the quick script for the same.

SELECT name
, s.snapshot_isolation_state…
103 more words

SQL Authority

SQL SERVER - SQL Server 2008 R2 Service Pack 3 - Download

It has been a long time since SQL Server 2008 R2 got Service Pack Update. Microsoft has finally released SQL Server 2008 R2 service pack  3and its feature pack.  121 more words

SQL Authority

SQL SERVER - Performance Dashboard: Historic Information

There are a lot of games that I play with my daughter in spare time. Some of them are for just for fun and a lot of them are fun filled with some learning. 1,245 more words

SQL Authority

SQL SERVER - Database Taking Long Time to Create - Notes from the Field #047

: There are few things which confuse us when we encounter first time, however, there are few concepts which confuses us even though we face them multiple times. 475 more words

SQL Authority