SQL Server 2008 and R2 Diagnostic Information Queries
It has been a couple of months since I have posted an update to my “SQL Server 2008 and R2...
2010-08-16
1,693 reads
Glenn Berry
Using the Windows Experience Index as a Shopping Tool
One easy to use and useful tool that you can use to compare relative performance between different machines that are...
2010-08-11
1,514 reads
Speaking at 24 Hours of PASS on September 15, 2010
I will be one of the presenters for the 3rd installment of the 24 Hours of PASS: Summit Preview, which...
2010-08-11
780 reads
Windows Azure Platform One Month Pass
According to all of their public pronouncements and the flurry of recent activity, Microsoft seems extremely serious about Windows Azure...
2010-08-06
997 reads
Testing Native Backup Compression in Combination with SQL Server 2008 R2 Data Compression
SQL Server 2008 introduced native backup compression and data compression as features that were only available in the Enterprise Edition...
2010-08-04
3,824 reads
SSWUG Ultimate Virtual Conference October 20-22, 2010
I will be presenting four sessions for the SSWUG Ultimate Virtual Conference that will be held online October 20-22, 2010....
2010-08-02
789 reads
A Small Collection of DBCC Commands
There are a number of pretty useful DBCC Commands that have nothing to do with checking the consistency of a...
2010-08-02
1,989 reads
SQL Saturday #51 in Nashville
I just found out today that I will be one of the speakers at SQL Saturday #51 in Nashville, Tennessee...
2010-07-27
861 reads
New Laptop Time
I’ve been looking for a new “thin and light” laptop to use for teaching, and for presentations and demonstrations at...
2010-07-26
820 reads
Project Houston For SQL Azure
Microsoft has released CTP1 of Project Houston for SQL Azure. Project Houston is a Silverlight web based database management tool...
2010-07-22
658 reads
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