Creating Inferred Dimension Members with SSIS
This article will show you how to use SSIS to create inferred dimension members on the fly during a fact table load process.
How Do You Find a DBA?
Looking for a new DBA can be a daunting process, and a lot of work as the resumes flood in. Steve Jones talks about a better way that might work for some of you.
Reporting Services Performance and Optimization
This technical note provides guidance for Reporting Services. The focus of this technical note is to optimize your Reporting Services architecture for better performance and higher report execution throughput and user loads.
Creating A SQL Server 2008\2008 R2 Failover Cluster
Details how to install a SQL Server 2008\2008R2 Failover Cluster Instance
It’s About the Journey, Not the Exam
Achieving a certification is less about the actual accomplishment, and how you get there. Read some of Andy Warren's thoughts.
Terrifyingly Accurate Technology Predictions for 2014
The end of a year is a time for reflection, but it’s also a time for running full-pelt at the new year with some ill-thought-out predictions under ones belt. It’s with this in mind that I fire up my 100%-accurate Criswell-Brand crystal ball, and peer into next year’s world of technology.
Next-Level Parallel Plan Forcing: An Alternative to 8649
The trace flag 8649 is incredibly useful. Alas, the flag is undocumented, unknown, and its full impact difficult to understand. Adam Machanic presents an alternative which you might find useful.
Infographics
Today Steve Jones has a poll that asks about the visualizations or infographics that you find to be most effective.
Recognizing community leaders
Voting is open for the Tribal Awards finalists. Choose which community warriors you think went above and beyond the call of duty with their blog, presentation, advice, user group, and more.
Repairing a Broken Log Shipping Plan From a Differential Backup
This article details how to reinitialise a Log Shipping scenario from a primary differential backup
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