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.
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.
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.
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.
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.
Continuing on with his series on XML, Jacob Sebastian looks at some more advanced XML techniques in SQL Server 2005.
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.
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.
The myth of Prometheus has some relevance to technology workers. How? Read what Steve Jones thinks.
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.
By Brian Kelley
I am guilty as charged. The quote was in reference to how people argue...
By Steve Jones
Learn how to tie a bowline knot. Practice in the dark. With one hand....
By HeyMo0sh
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...
Hi, I have a SQL Server instance where users connect to via Windows Authentication,...
Comments posted to this topic are about the item Multiple Deployment Processes
Comments posted to this topic are about the item How to Use sqlpackage to...
I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?
See possible answers