If you are a Database Administrator, Developer or IT team lead, take part in our survey and you could win one of three $50 Amazon gift certificates. It will only take you 10-15 minutes.
Why are sites still being hit by SQL Injection on a large scale? Steve Jones talks about a recent large scale attack that affected over a million sites.
In this article, Ron Johnson shows how you can use DMVs for proactive real-time SQL Server performance monitoring.
The deadline for entering the DBA in Space competition has been extended until Nov 22, 2011, noon GMT. Enter today and get the chance to fly into space or take the vacation of your dreams.
On Thursday November 17th at 8PM Eastern, Steve Simon will discuss "No Matter how well planned and executed, data structures sometime resembles something out of a Dr. Seuss book."
With the DBA in Space contest ending this week, Steve Jones has some thoughts on the contest, and what he'd do if he were to win.
We have a new forum setup for your Powerpivot questions. If you are working with Powerpivot, please feel free to ask questions here.
SQL Server 2008 and later offers the ability to create compressed backup files. When creating the compressed backup, how much space is really needed and when does the space get allocated for the backup file?
Check out the final question for the DBA in Space contest. It's a math tease that needs research. If you can solve it, and you work with databases, enter the contest at dbainspace.com
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 everyone I asked this earlier but the desired outcome is a bit different...
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
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