Using All Your Tools
Steve looks at a number of tools that you should spend time learning and building a level of comfort that enables you to use them in your daily work.
Performance Tuning Using Extended Events: Part 1
In this article, learn how to identify performance tuning opportunities using Extended Events.
What's a forgivable mistake?
Today Steve wonders if your company is understanding of your human frailty.
From Source Control to Database using SQL Compare Command Line
Giorgi Abashidze explains how his team use SQL Compare Command line to automate database deployments for their customers, without having access to the real staging or production databases, merely by using our development database contained under TFS Source Control.
Understanding Azure Storage Options
The choices found when provisioning storage in Azure can be overwhelming. In this article, Monica Rathbun explains the options to help your organization research which storage might be right for your solution.
Expect the Unexpected with DiRT
Disaster recovery is no joke at Google, where they really test their systems, people, and processes.
UNION vs. UNION ALL in SQL Server
Sometimes there is a need to combine data from multiple tables or views into one comprehensive dataset. This may be for like tables within the same database or maybe there is a need to combine like data across databases or even across servers. I have read about the UNION and UNION ALL commands, but how do these work and how do they differ?
Proactive Performance Tuning
Being proactive in trying to improve your system is good, but sometimes your team might cause you problems with their efforts.
Stairway to Biml 9 – Refactoring a Simple Custom Biml Framework
This level of the Stairway to Biml examines how to refactor your Biml into an easier to maintain format.
HSA for Training
Is there a good way to ensure employees get trained? Steve has a few thoughts today on an idea that could help.
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
Liability for AI Errors
Comments posted to this topic are about the item Liability for AI Errors
Running a Parameter-Sensitive Stored Procedure on a Secondary Replica
Hello , I would like to run a stored procedure on a secondary replica...
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers