Feeds:
Posts
Comments

Archive for the ‘SQL Security’ Category

SQLAuthority News – Database Encryption in SQL Server 2008 Enterprise Edition

Posted in SQL, SQL Authority, SQL Query, SQL Security, SQL Server, SQL Tips and Tricks, SQL White Papers, SQLAuthority News, T SQL, Technology, tagged on October 3, 2009 | Leave a Comment »

With the introduction of transparent data encryption (TDE) in SQL Server 2008, users now have the choice between cell-level encryption as in SQL Server 2005, full database-level encryption by using TDE, or the file-level encryption options provided by Windows. TDE is the optimal choice for bulk encryption to meet regulatory compliance or corporate data security standards. [...]

Read Full Post »

SQL SERVER – Cryptography in SQL Server 2008

Posted in Pinal Dave, SQL, SQL Authority, SQL Query, SQL Security, SQL Server, SQL Tips and Tricks, T SQL, Technology on September 15, 2009 | 1 Comment »

SQL Server, particularly the 2005 and 2008 versions, offers the functionality of cryptography. In the following, this functionality is briefly explained.
Introduction
Any database professional will support the encryption of data. However, the encryption of data has to be carried out at the database engine level. This is quite tricky as there the database performance can be [...]

Read Full Post »

SQL SERVER – Reason for SQL Server Agent Starting Before SQL Server Engine Service

Posted in Database, Pinal Dave, Readers Question, SQL, SQL Authority, SQL Query, SQL Security, SQL Server, SQL Tips and Tricks, T SQL, Technology, tagged on August 13, 2009 | 10 Comments »

Nakul, a dedicated member of the Gandhinagar SQL Server User Group, recently emailed me with a very interesting, but quick question. He asked me why the SQL Server Agent starts before SQL Server Engine does? He made the very valid point that as the SQL Server Engine is the core service, it should start first, [...]

Read Full Post »

SQL SERVER – Forgot the Password of Username SA

Posted in Pinal Dave, SQL, SQL Authority, SQL Query, SQL Scripts, SQL Security, SQL Server, SQL Server Management Studio, SQL Tips and Tricks, T SQL, Technology, tagged , on August 4, 2009 | 8 Comments »

I just received a call from an old friend with whom I used to work in Las Vegas. He told me about a password-related issue he faced in his organization. They had changed the password of username SA and now they are not able to recall the new password. I am sure that he is [...]

Read Full Post »

SQL SERVER – 2008 – Policy-Based Management – Create, Evaluate and Fix Policies

Posted in Pinal Dave, SQL, SQL Authority, SQL Query, SQL Scripts, SQL Security, SQL Server, SQL Tips and Tricks, T SQL, Technology, tagged on June 30, 2009 | 1 Comment »

This article will cover the most spectacular feature of SQL 2008 – Policy-based management and how the configuration of SQL Server with policy-based management architecture can make a powerful difference. Policy based management is loaded with several advantages. It can help you implement various policies for reliable configuration of the system. It also provides additional [...]

Read Full Post »

SQLAuthority News – Using SQL Server 2008 Extended Events – White paper By Jonathan Kehayias

Posted in SQL, SQL Authority, SQL Documentation, SQL Query, SQL Security, SQL Server, SQL Tips and Tricks, SQL White Papers, T SQL, Technology on June 7, 2009 | Leave a Comment »

Strange it may sound but being a SQL Server pro has its downside too. Common information on SQL does not interest me, while a good document is hard to find. So the reader in me is mostly discontented and constantly keeps looking for interesting documents.  Recently, I chanced upon a really good white paper by [...]

Read Full Post »

SQL SERVER – Find Hostname and Current Logged In User Name

Posted in Pinal Dave, SQL, SQL Authority, SQL Function, SQL Query, SQL Scripts, SQL Security, SQL Server, SQL Tips and Tricks, T SQL, Technology, tagged on May 26, 2009 | 9 Comments »

I work in an environment wherein I connect to multiple servers across the world. Time and again, my SSMS is connected to a myriad of servers that kindles a lot of confusion. I frequently use the following trick to separate different connections, which I mentioned in my blog sometime back SQL SERVER – 2008 – [...]

Read Full Post »

SQL SERVER – FIX : ERROR : is not a valid Win32 application. (Exception from HRESULT: 0×800700C1)

Posted in Pinal Dave, Readers Question, SQL, SQL Authority, SQL Error Messages, SQL Query, SQL Security, SQL Server, SQL Tips and Tricks, T SQL, Technology on April 30, 2009 | 1 Comment »

Just a day ago, one of my friend sent me email requesting help with following error:
is not a valid Win32 application. (Exception from HRESULT: 0×800700C1)
In fact this is not SQL Server error but it is of .NET application. The solution of this error is just changing configuration of IIS7.
Fix/Solution/Workaround:
Go to IIS.
Click on Application Pool.
Look for [...]

Read Full Post »

SQL SERVER – Introduction to SQL Server Encryption and Symmetric Key Encryption Tutorial with Script

Posted in Pinal Dave, SQL, SQL Authority, SQL Query, SQL Scripts, SQL Security, SQL Server, SQL Tips and Tricks, T SQL, Technology, tagged on April 28, 2009 | 14 Comments »

SQL Server 2005 and SQL Server 2008 provide encryption as a new feature to protect data against hackers’ attacks. Hackers might be able to penetrate the database or tables, but owing to encryption they would not be able to understand the data or make use of it. Nowadays, it has become imperative to encrypt crucial [...]

Read Full Post »

Older Posts »