The Secret Password
The secret passwords we store in systems might be secure from discovery, but are they secure from use?
Azure Load Balancers and SQL Server
Load balancing in Azure has more importance for the DBA, because it is essential for Windows Server Failover Clustering in Azure, whether it is for AlwaysOn Availaiblity Groups, Failover Clustered Instances, or any other highly-available solution. Azure load balancing works out the location of the availability group, and routes traffic there. The load balancer detects a failure, and routes traffic to the new primary replica. Joshua Feierman gives an overview of what is required.
How to implement a T-SQL code formatting standard using SQL Prompt
Louis Davidson shows how to save a defined SQL formatting style as a shareable template that you can quickly share with your coworkers.
Why deadlines stink, and are so necessary
I hate deadlines. Really. I truly hate them. The problem is: they are usually unrealistic, often not much more than a wild guess. They restrict the amount of time that I can spend in preparation and research so that I can do things right; they squeeze the artistic quality out of my work as a […]
Introducing a DevOps Workgroup to Farm Credit Services of America
If you are introducing DevOps workflows into a large organization, you’ll need to plan carefully and prioritize tasks, adapt, maintain a thick skin, communicate constantly, and ensure that all...
What the heck is a DTU?
Andy Mallon explains DTUs (Database Transaction Units) and the differences you might see between the documentation and practical usage.
Display SSIS package version on the Control Flow design surface
In this article I will show a simple trick to display version information on the Control Flow surface, so we immediately see which version and build we are modifying.
Starting to Use SQL Server 2017
Today Steve Jones looks forward to the next version of SQL Server, with his curiosity to see if you feel the same way.
Getting Started with Azure SQL Data Warehouse - Part 3
Microsoft introduced Azure SQL Data Warehouse, a new enterprise-class, elastic petabyte-scale, data warehouse service that can scale according to organizational demands in just few minutes. In this article, Arshad Ali discusses the different types of tables you can create in SQL Data Warehouse, how they impact performance and the best practices around them.
Blogs
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Advice I Like: In 100 Years
By Steve Jones
In 100 years a lot of what we take to be true now will...
Forums
Lots of FKs
Comments posted to this topic are about the item Lots of FKs
Real-time On-prem SQL Server Data in Excel – Over the Internet
Comments posted to this topic are about the item Real-time On-prem SQL Server Data...
Can You Let Go of Determinism
Comments posted to this topic are about the item Can You Let Go of...
Question of the Day
Lots of FKs
In SQL Server 2025, what are the most outgoing and incoming FK references a table can have?
See possible answers