Splunk is a search engine for collecting and analyzing all sorts of "machine data", including log data and metrics for SQL Server. SQL Monitor gives you the detailed diagnostic view of all your SQL Server instances, and databases. If you have Splunk to monitor your applications and server infrastructure, and SQL Monitor to help you understand the behavior of a complex database system such as SQL Server, then you have a powerful and capable monitoring tool set.

Prevent SQL Server Blocking using Lock_Timeout

by Additional Articles

MSSQLTips.com

Concurrency

In this tip we look at a way to minimize the length of blocking using SQL Server lock timeout.

Stable Marriages Using SQL Server

by R Glen Cooper

SQLServerCentral

T-SQL

In this article, we see how SQL can be used to determine matches between two groups, given a set of preferences.

Comments and More in PowerShell

by Additional Articles

SimpleTalk

PowerShell

Comments are helpful when programming in any language, and PowerShell is no exception. In this article, Greg Moore demonstrates how to use comments to document code and to add prerequisites in PowerShell with #Requires.

Prevent SQL Server Blocking using Lock_Timeout

by Additional Articles

MSSQLTips.com

Concurrency | T-SQL | Code Samples - In this tip we look at a way to minimize the length of blocking using SQL Server lock timeout.

The Downside of Tool Autonomy

by Steve Jones

SQLServerCentral.com

Editorial

Too many tools spoil the process.

Database Security, People and Processes

by Additional Articles

SimpleTalk

Protecting data is not easy, but it is critical. In this article, David Poole discusses database security and the behaviors needed to build secure systems.

Removing the Square Bracket Decorations with SQL Prompt

by Additional Articles

Redgate

SQL PROMPT

If you avoid illegal characters and reserved words in your identifiers, you'll rarely need delimiters. Sadly, SSMS applies square bracket delimiters indiscriminately, as a precaution, when generating build scripts. Phil Factor provides a handy function that adds quoted delimiters only where they are really needed and then sits back and lets SQL Prompt strip out any extraneous square brackets, in a flash.

Move Data from SQL Server to Azure Blob Storage with Incremental Changes – Part 2

by Ginger Daniel

SQLServerCentral

Azure Data Factory

In part 2 of this article, learn how you can move incremental changes in a SQL Server table using Azure Data Factory.

New release: SQL Change Automation 4.1

by Additional Articles

Redgate

SQL Change Automation

We’ve heard from users that they really care about static data and were missing the feature in the SQL Change Automation SSMS plugin. In v4.1, we’ve added support for the tracking of static data tables to the SSMS extension, alongside existing support in the VS extension. Maya Malakova has written a technical summary showing how to use this feature. Learn more about the release here.

Monitoring SQL Server with Splunk and SQL Monitor

Prevent SQL Server Blocking using Lock_Timeout

Stable Marriages Using SQL Server

Comments and More in PowerShell

Prevent SQL Server Blocking using Lock_Timeout

The Downside of Tool Autonomy

Database Security, People and Processes

Removing the Square Bracket Decorations with SQL Prompt

Move Data from SQL Server to Azure Blob Storage with Incremental Changes – Part 2

New release: SQL Change Automation 4.1

Blogs

A New Word: Anderance

Troubleshooting SQL Server – Starting with the Error Log

From OLTP to Analytics: Bridging the Gap with Modern SQL Architectures

Forums

The Yutes

Work out closing balance using opening balance of prior month

The Security of Old Tech

Question of the Day

Tables with a SPARSE Column and Consumption