SQL Server SET STATISTICS IO ON Deep Dive
In this article we look at how to interpret and use the results of STATISTICS IO when tuning SQL Server queries.
Azure Data Factory Pipeline Logging Error Details
In this article we will cover how to capture and persist Azure Data Factory pipeline errors to an Azure SQL Database table.
Getting Comfortable Writing Code in Azure Data Studio
Learn some of the ins and outs of working with Azure Data Studio to develop SQL code.
President's Day 2021
It's a holiday in the US, President's Day, and I'm off. Hopefully, I'm coaching and enjoying a day with kids away from work and the stress of the world. I hope you have a good day as well.
Execute Dynamic SQL commands in SQL Server
In some applications having hard coded SQL statements is not appealing, because of the dynamic nature of the queries being issued against the database server. This is where dynamically building SQL statements can be useful.
The Future of Database DevOps
Join Pramod Sadalage, Director at Thoughtworks, and a stellar line up of speakers for Redgate Summit: The Future of Database DevOps on February 17 & 18. You’ll discover the latest trends in DevOps, brand new insights from the 2021 State of Database DevOps report, an introduction and technical demos of Redgate’s solutions for Database DevOps, and more.
Looking to Role Models
Each of us can inspire and be a role model for others. Steve notes that the WIT group is doing that with an event on March 5th.
Offline R Services installation and patching
The R Services installation package is not included in the MS SQL Server installation package. When you install MS SQL Server with R Services the installer actually download the package from the Internet.
Blogs
Troubleshooting SQL Server – Starting with the Error Log
By gbargsley
We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?”...
From OLTP to Analytics: Bridging the Gap with Modern SQL Architectures
By Chris Yates
In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...
Free Online Sessions – Building the €100 DWH and Indexing for Dummies
I’m giving two online sessions soon on virtual events that are free to attend....
Forums
The Security of Old Tech
Comments posted to this topic are about the item The Security of Old Tech
Revisiting SQL Server Window Functions- A Practical Walkthrough
Comments posted to this topic are about the item Revisiting SQL Server Window Functions-...
Tables with a SPARSE Column and Consumption
Comments posted to this topic are about the item Tables with a SPARSE Column...
Question of the Day
Tables with a SPARSE Column and Consumption
True or False: Tables with a SPARSE column consume more space than regular columns if most values are NOT NULL.
See possible answers