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,276 reads
Articles
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,332 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,759 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,272 reads
Estimated Number of Rows to be Read
Rob Farley uses this month's T-SQL Tuesday to show off the results of one of his Connect items : Estimated Number of Rows to be Read.
2017-02-06
3,839 reads
Performance of the SQL MERGE vs. INSERT/UPDATE
The SQL MERGE statement offers convenience, safety and elegance, but how does it perform compared to other methods?
2017-02-03 (first published: 2013-10-28)
168,245 reads
PowerShell Invoke-SQLCmd outputs DataTables you can INSERT into SQL Server
Aaron Nelson explains how you can take an existing SQL query, run it against a SQL Server and then take the results and save them to a different SQL Server without using Linked Servers.
2017-02-03
5,215 reads
Blogs
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Forums
Foreach Loop still executes after process and delete all the folders
I have two challenges XML source control not displaying the XML file parent node...
Which 'Where' statement conditional upon a variable
Thanks in advance for any clues on this. I am trying to write a...
Backup to Immutable Storage
Comments posted to this topic are about the item Backup to Immutable Storage
Question of the Day
Backup to Immutable Storage
In SQL Server 2025, a backup can be made on Azure Immutable Storage. What changes in how the backup is created?
See possible answers