SQL Security « SQL Server Journey with SQL Authority

Archive for the ‘SQL Security’ Category

SQL SERVER – 2012 Auditing Enhancement – On Audit Log Failure Options – Maximum Rollover Files

Posted in Pinal Dave, PostADay, SQL, SQL Authority, SQL Query, SQL Security, SQL Server, SQL Tips and Tricks, T SQL, Technology on December 16, 2011 | Leave a Comment »

Recently I was exploring SQL Server Audit and found something very interesting. I found two enhancements in the SQL Server 2008 Create Audit Screen. SQL Server 2012 Create Audit Screen SQL Server 2008 Create Audit Screen On Audit Log Failure Options You can see that in SQL Server 2012 they have added two more options [...]

Read Full Post »

SQL SERVER – ‘Denali’ – A Simple Example of Contained Databases

Posted in PostADay, SQL, SQL Authority, SQL Query, SQL Security, SQL Server, SQL Tips and Tricks, T SQL, Technology on March 31, 2011 | 10 Comments »

Recently I was asked with the question: What is new for Database Security in SQL Server “Denali”? I think this is a very interesting question as I always wanted to talk about Contained Database, and this question gives me the chance to do so. Let us start with discussing contained database. A Contained Database is [...]

Read Full Post »

SQL SERVER – Securing TRUNCATE Permissions in SQL Server

Posted in Best Practices, Pinal Dave, Readers Contribution, Readers Question, SQL, SQL Authority, SQL Query, SQL Scripts, SQL Security, SQL Server, SQL Tips and Tricks, T SQL, Technology on December 20, 2010 | 9 Comments »

Download the Script of this article from here. On December 11, 2010, Vinod Kumar, a Databases & BI technology evangelist from Microsoft Corporation, graced Ahmedabad by spending some time with the Community during the Community Tech Days (CTD) event. As he was running through a few demos, Vinod asked the audience one of the most [...]

Read Full Post »

SQL SERVER – Best Practices for DBA Before Taking Vacation

Posted in Best Practices, Pinal Dave, SQL, SQL Authority, SQL Query, SQL Security, SQL Server, SQL Tips and Tricks, T SQL, Technology on August 10, 2010 | 23 Comments »

This blog post is written in response to T-SQL Tuesday hosted by Jason Brimhall. Everybody wants to take a vacation. Who does not love vacation, anyway? However, it seems that it has been getting more and more difficult to take vacation recently. There are two reasons why a person is not able to enjoy his [...]

Read Full Post »

SQLAuthority News – Wireless Router Security and Attached Devices – Complex Password

Posted in SQL, SQL Authority, SQL Query, SQL Security, SQL Server, SQL Tips and Tricks, SQLAuthority News, T SQL, Technology on May 6, 2010 | 11 Comments »

In the last week, I have received calls from friends who told me that they have got strange emails from me. To my surprise, I did not send them any emails. I was not worried until my wife complained that she was not able to find one of the very important folders containing our daughter’s [...]

Read Full Post »

Older Posts »