SQL Server Security Archives - Page 30 of 47 - SQL Authority with Pinal Dave

SQL SERVER – Securing TRUNCATE Permissions in SQL Server

December 20, 2010

Best Practices, SQL Scripts, SQL Server Security

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…

SQL SERVER – Best Practices for DBA Before Taking Vacation

August 10, 2010

Pinal Dave

SQLAuthority News

Best Practices, SQL Server Security

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…

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

May 6, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

SQL Server Security

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…

SQL SERVER – Difference Between GRANT and WITH GRANT

April 3, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL Server Security

What is the difference between GRANT and WITH GRANT when giving permissions to the user? This is a very interesting question recently asked me to during my session at TechMela Nepal. Let us first see the syntax and analyze. GRANT: USE master; GRANT VIEW ANY DATABASE TO username; GO WITH GRANT: USE…

SQL SERVER – Get the List of Object Dependencies – sp_depends and information_schema.routines

February 4, 2010

Pinal Dave

SQL Tips and Tricks

SQL Dependency, SQL Scripts, SQL Server, SQL Server Security, SQL System Table

Recently, I read a question on my friend‘s SQL site regarding the following: sp_depends does not give appropriate results whereas information_schema. routines do give proper answers.

SQL SERVER – Fix: Error: 262 : SHOWPLAN permission denied in database

January 5, 2010

Pinal Dave

SQL Server

Execution Plan, SQL Error Messages, SQL Scripts, SQL Server, SQL Server Security

During one of my recent training class when I asked students to check the execution plan using (can be enabled using CTRL+M), they received error as following.

Msg 262, Level 14, State 4, Line 1
SHOWPLAN permission denied in database ‘AdventureWorks’.

SQLAuthority News – Database Encryption in SQL Server 2008 Enterprise Edition

October 3, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

SQL Server Encryption, SQL Server Security, SQL White Papers

Database Encryption in SQL Server 2008 Enterprise Edition SQL Server Technical Article Writers: Sung Hsueh Technical Reviewers: Raul Garcia, Sameer Tejani, Chas Jeffries, Douglas MacIver, Byron Hynes, Ruslan Ovechkin, Laurentiu Cristofor, Rick Byham, Sethu Kalavakur Published: February 2008 TDE does not replace cell-level encryption, EFS, or BitLocker. This white paper…