As a SQL Server DBA or developer, how do you measure the success of your projects? What about your users? Here is an interesting look by Janet Wong at a few of her projects and how their success was perceived. See if any of your experiences are similar.
Discusses Index Selection impact when functions are wrapped around WHERE clause filtering columns
Steve Jones takes a look at the world of energy news and a few projects out at the ranch.
This next post on Full Text search from MVP Simon Sabin examines how you can examine the details of what your indexes contain.
How important is disk encryption to you? Do you think about all those replicated or copied databases on laptops? Let us know.
How important is disk encryption to you? Do you think about all those replicated or copied databases on laptops? Let us know.
Part 2 of this article illustrates how to enable Change Data Capture on a database, on a table and how SQL Server tracks the data changes of the CDC enabled table.
This is the seventh article in a continuing series, and this installment discusses the tactical layer of the Data Governance Framework.
SQL Server 2008 launches today and there's are additional events all across the country coming up.
Longtime author Paul Ibison brings us a short look at a common problem in Integration Services: your source has no column names.
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