Who Wants to Be Rich?
With all the concern over the economy lately, Steve Jones talks about about finances and tries to bring perspective to those of us in the real world.
SQL Server 2000 Useful Undocumented Stored Procedures
In this article, Alexander Chigrik looks at some useful undocumented stored procedures that shipped with SQL Server 2000.
The Financial Crisis
With the economy slowing the the world facing a financial crisis, Steve Jones polls the man on the street this Friday.
Who was that Affinity Masked Man?
Getting the number of processor cores that SQL Server is using is not as straitforward as it could be. Enter the affinity mask, bitwise operations and good old fashioned computer science.
Enough - Database Weekly (Oct. 20, 2008)
The loss of data is getting ridiculous. Steve Jones wants companies and government to do something about it.
Enough - Database Weekly (Oct. 20, 2008)
The loss of data is getting ridiculous. Steve Jones wants companies and government to do something about it.
Introduction to New Data Warehouse Scalability Features in SQL Server 2008
This paper introduces the new performance and manageability features for data warehousing across all these components. All these features contribute to improved scalability.
Setting up a Two-NODE SQL Server 2008 Cluster from the Command Prompt - Integrated Installation
Part 1 of this series discussed how to prepare for SQL Server cluster installation on a two-node Windows Server 2003 cluster. This installment explains how to install SQL Server Database Engine on the cluster using the Integrated Installation option.
Row Count Transform - SQL School Video
Integration Services contains a tremendous number of ways to transform and work with data. MVP Brian Knight dives into the Row Count transform in this edition of SQL School. This shows how you can monitor the number of rows in a transform.
Blogs
“We love to debate minutiae”
By Brian Kelley
I am guilty as charged. The quote was in reference to how people argue...
Advice I Like: Knots
By Steve Jones
Learn how to tie a bowline knot. Practice in the dark. With one hand....
Shifting Mindsets: Why FinOps is Essential for Cloud Efficiency
By HeyMo0sh
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...
Forums
Windows logins for users migrated from DomainA to DomainB
Hi, I have a SQL Server instance where users connect to via Windows Authentication,...
Multiple Deployment Processes
Comments posted to this topic are about the item Multiple Deployment Processes
How to Use sqlpackage to Detect Schema Drift Between Azure SQL Databases
Comments posted to this topic are about the item How to Use sqlpackage to...
Question of the Day
Upgrading Admin Queries
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