|
Solution Search:
|
SQL Server Resource Center
The short course on how SQL Server really works
we start diving into real-world tasks, however, a little bit of background information will be helpful. So how does SQL Server work? Believe it or not, understanding this...
More...
Jun 10, 2009
Understanding transparent data encryption in SQL Server 2008
period. Consult Microsoft's page on understanding TDE for more information on what these limitations are.
Replication is "TDE unaware", and replicated data will... More... Jun 9, 2009
Working with sparse columns in SQL Server 2008
table:
USE AdventureWorks2008
GO IF EXISTS (SELECT table_name FROM information_schema.tables WHERE table_name = 'Products') DROP TABLE Products GO CREATE TABLE... More... Jun 2, 2009
Determining the source of full transaction logs in SQL Server
A full transaction log is a sporadic, yet common problem for SQL Server DBAs. It can cause a transaction to be terminated prematurely... More... May 27, 2009
SQL Related Articles
Minding the data and databases
As business reliance upon the availability and accessibility of information grows, so does the need for those specifically skilled in data design delivery, maintenance and its protection. As businesses...
More...
Jul 20, 2006
Best practices for improved database management
all of which rely on databases for the storage and exchange of information. Routinely verifying database management practices helps uncover rogue changes, security problems and even helps locate...
More...
Jul 14, 2006
|