A disconnected model is only really needed in the absence of a properly-defined database interface. We, as developers, create a rod for our own backs by insisting on treating a database in a way we wouldn't treat an object, let alone an assembly or namespace.
When rounded detail quantities are created by an allocation, often the total must foot back exactly to the allocated amount.
Today Steve Jones talks about one of the classic software developer debates. When formatting code, how should you do it?
The database field contains long string with data for Quantity and Parts. The challenge is to parse the data into separate (Quantity and Parts) fields for displaying in a report.
The first SQL Saturday event in Turkey, on Mar 31, 2012 at the Microsoft office in Istanbul. Sign up and come for a free day of SQL Server training.
A look at the information that helps SQL Server make better decisions.
This Friday Steve Jones wants to ask a poll about SQL Server 2012. Do you think it's ready for your production servers?
What do you do when you need to remove an orphaned user, but they are the owner of a Schema or Role on that database?
This article describes how to add a log shipping monitor to a log shipping configuration that is already in place.
Today we have a guest editorial from Andy Warren as Steve is on vacation. Was this a good week for you? How do you know? Do you have a definition that helps you determine if it was a good week? Today Andy Warren talks about how we view our jobs.
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