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

SQL SERVER – Change Collation of Database Column – T-SQL Script

December 20, 2008

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

SQL Collation, SQL Scripts, SQL Server Security, SQL Utility

Just a day before I wrote about SQL SERVER – Find Collation of Database and Table Column Using T-SQL and I have received some good comments and one particular question was about how to change collation of database. It is quite simple do so. Let us see following example. USE…

SQLAuthority News – Download RML Utilities for SQL Server

November 12, 2008

Pinal Dave

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

Best Practices, Database, SQL Download, SQL Server Security

Note: Download RML Utilities for SQL Server by Microsoft The RML utilities allow you to process SQL Server trace files and view reports showing how SQL Server is performing. For example, you can quickly see: Which application, database or login is using the most resources, and which queries are responsible…

SQLAuthority News – SQL Server Security Whitepapers

November 3, 2008

Pinal Dave

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

SQL Download, SQL Server Security, SQL White Papers

Microsoft has published following three security related white papers. I suggest to all my readers to read them. Read the summary know what is covered in those white papers. Engine Separation of Duties for the Application Developer – Separation of duties is an important consideration for databases and database applications.…

SQL SERVER – Fix : Error : Login failed for user ‘UserName’. The user is not associated with a trusted SQL Server connection

November 2, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages, SQL Server, SQL Server Security

Recently I have got two desktop computers at home and both of them are very powerful machine. Machine 1 : Windows Vista SP1 with SQL Server 2008 Machine 2 : Windows 2003 with SQL Server 2005 with SP2 When I was trying to connect from SQL Server 2008 to SQL…

SQL SERVER – Stored Procedure WITH ENCRYPTION and Execution Plan

November 1, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL Server Security

Stored Procedures are very important and most of the business logic of my applications are always coded in Stored Procedures. Sometime it is necessary to hide the business logic from end user due to security reasons or any other reason. Keyword WITH ENCRYPTION is used to encrypt the text of…

SQL SERVER – Fix : Error : Incorrect syntax near. You may need to set the compatibility level of the current database to a higher value to enable this feature. See help for the stored procedure sp_dbcmptlevel

October 21, 2008

Pinal Dave

SQL Tips and Tricks

SQL Error Messages, SQL Scripts, SQL Server, SQL Server Security, SQL Stored Procedure

I have seen developers confused many times when they receive the following error message. Incorrect syntax near. Let us learn.

SQL SERVER – Transaction and Local Variables – Swap Variables – Update All At Once Concept

October 20, 2008

Pinal Dave

SQL Tips and Tricks

SQL Scripts, SQL Server, SQL Server Security, SQL Transactions

This article is inspired from two sources. Let us learn today about how to swap variables by updating everything at once concepts.

1) My year old article – SQL SERVER – Effect of TRANSACTION on Local Variable – After ROLLBACK and After COMMIT
2) Discussion with SQL Server MVP – Jacob Sebastian – SQLAuthority News – Author Visit – SQL Hour at Patni Computer Systems

I usually summarize my article at the end, but this time let me summarize first and we will understand the article next.