Tags » SQL Security

SQL SERVER - Transparent Data Encryption and Frequently Asked Questions

In the recent past, I have been traveling to Delhi to meet customers and also attend a few conferences which my company has been sponsoring. These travel experiences give me an opportunity to meet folks who read my blog regularly as a face-to-face interaction. 576 more words

SQL Authority

SQL SERVER – SPID is KILLED/ROLLBACK state. What to Do Next?

I always recall my fun days after talking to my friends and blog readers. Recently killed/rollback discussion came back when my close DBA friend called me for help. 455 more words

SQL Authority

SQL SERVER - Secure by Default - The Mantra

Generally the talks I give at conferences revolve around performance and tuning. These are always the most sought after topic and I don’t disappoint the requests because they give me an opportunity to learn something new too. 614 more words

SQL Authority

SQL SERVER - Basic Statistics Maintenance - Notes from the Field #083

: This is a 83rd episode of Notes from the Field series. Maintenance of the database is very critical activity and I have always seen DBA taking it very seriously. 864 more words

SQL Authority

SQL SERVER - Adding Reference Data to Master Data Services - Notes from the Field #081

: This is a 81th episode of Notes from the Field series. Master Data Services is one of the most important, but very little explored feature of SQL Server.  830 more words

SQL Authority

SQL SERVER – Create Login with SID – Way to Synchronize Logins on Secondary Server

How many times you had a problem where you have deployed a high availability solution, but the application is not able to use database and getting login failed for user after failover? 282 more words

SQL Authority