Query Performance Tuning – A Methodical Approach
Learn how to approach performance tuning in this piece from SQL Server MCM and MVP, Gail Shaw.
2017-02-10 (first published: 2015-06-08)
16,750 reads
Articles
Wildcard Searches
Using wildcard to find patterns in strings going from the basics to some more complicated conditions.
2017-02-10 (first published: 2015-09-29)
19,238 reads
Reconciling Data Across Systems Using a Reconciliation Hub
In many enterprises, where there are a number of separate systems engaged in processing data, there arises the daunting task of checking and reconciling data as it flows between systems. Discrepancies in data must be detected, tracked and corrected as quickly as possible: there is no room for error in doing this. A Reconciliation Hub can provide the answer, as Rahul Gupta explains.
2017-02-10
3,524 reads
Fix Commvault Backup Failures After an Upgrade
In this article, you will learn how to troubleshoot backup failures in SQL Server 2016 when you run using commvault backup tool
2017-02-09
4,265 reads
How Incorrect SQL Server Table Statistic Estimates Can Cause Slow Query Execution
Ben Snaidero explains that if you are updating your SQL Server table statistics nightly, but still seeing occasional poor performance with some of the queries being executed against my database, statistics could be the issue.
2017-02-09
4,089 reads
Building Angular2 Apps with SQL Server Data
This article demonstrates using Angular2 and the CData API Server to build dynamic Web pages using SQL Server data.
2017-02-08
6,329 reads
Simple Row Level Security for SQL Server 2016
Have you ever had a need to place some simple row level security on a SQL Server table? Well now you can do that in SQL Server 2016 by...
2017-02-08
6,513 reads
Determining What Happens When You Force an Execution Plan via the Query Store
When you force a query plan via the Query Store, you will need to track what happens: Sometimes the request to force a plan will fail, and you will want to know when and why. There are several ways of getting feedback, ranging from the built-in reports to using extended events. Enrico explains the details.
2017-02-07
3,584 reads
Create and Connect to an Azure SQL Database
Demonstration on how to create and connect to a Microsoft Azure SQL Database with Microsoft Management Studio (SSMS) and Powershell
2017-02-06
2,758 reads
Inside the SQL Server Query Optimizer
This book will take you from the fundamentals of Statistics, Cost Estimation, Index Selection, and the Execution Engine, and guide you through the inner workings of the Query Optimization process, and throws in a pragmatic look at Parameterization and Hints along the way.
2017-02-06
27,268 reads
Blogs
Using AI for Git Hooks
By Steve Jones
Recently I had someone internally ask about whether SQL Source Control supports Git Hooks....
Flyway Tips: AI Helps with Commit Messages
By Steve Jones
At Redgate, we’re experimenting with how AI can help developers and DBAs become better...
Startup scripts in SQL Server containers
I was messing around performing investigative work on a pod running SQL Server 2025...
Forums
sys.query_store_query question
All, My query is as follows: SET DATEFORMAT dmy SELECT p.query_id, DATEADD(MICROSECOND,-rs.max_duration,rs.first_execution_time) AS starttime,...
Encoding Strings
Comments posted to this topic are about the item Encoding Strings
Deep Learning and Craftsmanship Matter
Comments posted to this topic are about the item Deep Learning and Craftsmanship Matter
Question of the Day
Encoding Strings
I have this code in SQL Server 2025. What is the result?
DECLARE @message VARCHAR(50) = 'Hello SQL Server 2025!'; DECLARE @encoded VARCHAR(MAX); SET @encoded = BASE64_ENCODE(@message); SELECT @encoded AS EncodedResult;See possible answers