This white paper presents an overview of cryptographic functionality and discusses how this applies to authentication, signed procedures, permissions, and encryption. Because the target audience is the database professional and not necessarily security experts, the focus is on practical ways to use cryptography in SQL Server.
2008-09-26
3,859 reads
Inspired by what he recently found in some SQL Server shops, database architect Brian Walker shares advice for improved database design – and SQL Server performance.
2008-09-26
5,999 reads
A new SQL Server system has claimed the top spots in the TPC-E benchmark, but Steve Jones doesn't think it's that impressive.
2008-09-26
780 reads
A new SQL Server system has claimed the top spots in the TPC-E benchmark, but Steve Jones doesn't think it's that impressive.
2008-09-26
481 reads
A new SQL Server system has claimed the top spots in the TPC-E benchmark, but Steve Jones doesn't think it's that impressive.
2008-09-26
535 reads
Continuing on with his series on XML, Jacob Sebastian looks at some more advanced XML techniques in SQL Server 2005.
2008-09-25 (first published: 2007-05-09)
29,498 reads
Integration Services is an ETL programming environment that gives you a tremendous number of options. In this video, MVP Brian Knight shows how you can change your connections dynamically.
2008-09-25
6,027 reads
Profiler is a fantastic tool for SQL Server DBAs to enable them to examine how batches and code is submitted to the server. Expert SQL Server trainer, Andy Warren, brings us a new article that exaamines how you can log that data in another SQL Server table for later analysis.
2008-09-25
4,134 reads
This fifth installment of the “Check your SQL Server using Windows PowerShell” series illustrates how to access SQL Server instance properties and SQL Server configuration details using Windows PowerShell.
2008-09-25
2,762 reads
Read the first page of the linked article and then cast your vote in this Friday's poll.
2008-09-25
76 reads
By HeyMo0sh
DevOps is about shortening the system development lifecycle. Plan faster, build faster, test faster,...
A short blog post about an issue with Fabric Mirroring (with Azure SQL DB...
By Steve Jones
I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an...
Comments posted to this topic are about the item PostgreSQL String Functions Part 1
Comments posted to this topic are about the item Working Better Under Pressure
Comments posted to this topic are about the item Identities and Sequences V
When thinking about the identity property and sequence objects, which of these can generate values before an insert statement is executed?
See possible answers