Test Your Situation
One of the important things is to be able to recover your environment. That doesn't mean you need to know everything about SQL Server and potential disasters, but you should know their affect on your situation.
Importance of Statistics and How It Works in SQL Server – Part 1
SQL Server Query Optimizer uses statistical information to estimate the cardinality in a query result. This enables the SQL Server Query Optimizer to create a high-quality query execution plan. Read on to learn how to use statistics and why it’s needed.
Recovering from Bad Deployments
When you deploy software, what do you do if things don't go well? Steve Jones talks about a few options you might have.
Add a linear trendline to a graph in SQL Server Reporting Services
In this article, Koen Verbeeck illustrates how to add a linear trendline to a graph in SSRS, similar to the way it would appear if done Excel.
SQL Monitor Custom Metric: Identity Columns Near Limit
If your application relies on identity columns, this metric is a useful measure of the number of identity columns that are near to the limit per database. You can then avoid logical problems in your application and SQL Server errors.
Adding an Article Without a Full Snapshot
Have you got transactional replication in your SQL environment? Do you need to add a new table to your publication, but can't afford the time necessary to create a full new snapshot? Here is a step-by-step guide. Thankfully, adding a single table is easier than I thought.
DBA of the World
Conference travel enhances our minds with more than just SQL. It exposes us to new cultures, people and possibilities.
Staying Successful
What helps people be successful in a company? Perhaps a little analytic work can help employers determine this.
Salesforce: A Very Straightforward Cloud Development Platform
Force.com is an enigma; a Platform-as-a-Service that is designed to appeal to a broad church of developers, to make it quick and easy to write simple cloud-based applications. Robert Sheldon explains, as simply as possible, why this unusual data-centric, and metadata-driven platform is attracting so much interest in the industry.
Creating a heat map in Reporting Services
Use custom assemblies to generate a heat map matrix in SQL Server Reporting Services
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