Transactions: What commands aren’t allowed?
Transactions are great tools that every DBA and developer should learn how to use. Unfortunately not everything can be put...
2014-02-13 (first published: 2014-02-05)
4,576 reads
Transactions are great tools that every DBA and developer should learn how to use. Unfortunately not everything can be put...
2014-02-13 (first published: 2014-02-05)
4,576 reads
If you’re a data warehouse developer, chances are you use T-SQL Merge statement to process slowly changing dimensions. If you’ve...
2014-02-05
1,371 reads
While every organization is different, their “big data” is often very similar. It typically comprises massive amounts of data across...
2014-02-05
414 reads
Wrote this email exchange with some developer colleagues about to embark on performance tuning.
Subject: bag o' tricks from DMV talk
From: A. Developer
Hey...
2014-02-12 (first published: 2014-02-05)
2,092 reads
Inventory is a vital information,whether you’re a consultant or an in-house DBA, you need to have a reliable inventory of...
2014-02-04
2,084 reads
Today John Sterrett (blog | twitter) and I are announcing a new SQL PASS Virtual Chapter dedicated to High Availability and Disaster...
2014-02-10 (first published: 2014-02-04)
1,402 reads
Place Your Bets All bets on the table please. This is the last call for bets, no new bets will be allowed. This marks the 51st invitation for TSQL...
2014-02-04
13 reads
Place Your Bets
All bets on the table please. This is the last call for bets, no new bets will be...
2014-02-07 (first published: 2014-02-04)
2,307 reads
I suspect most DBAs have a script in their T-SQL toolbelt which scripts out database permissions for a specific user...
2014-02-04
1,124 reads
Have you ever had an error when using a SQL Server Proxy Account? I ran across a misleading error. Let...
2014-02-10 (first published: 2014-02-04)
1,905 reads
By DesertDBA
I did not expect 27 responses to my T-SQL Tuesday #204 invitation, but it...
Should you adopt an off-the-shelf AI tool, partner with a specialist, build in-house, or...
By ReviewMyDB
Part 1 of my What's New in SQL Server for the Developer series. IIF,...
Comments posted to this topic are about the item Server-level Roles
Comments posted to this topic are about the item Pay for Performance
Comments posted to this topic are about the item Tracking Inserted, Updated, and Deleted...
In SQL Server 2025, can I alter a fixed server role?
See possible answers