SQL Server Monitoring: Keeping track of missing index requests
A lot of us turn to execution plans when we see a slow running query, and it’s not uncommon to...
2019-02-04
190 reads
Blog Posts
Step-by-Step: How to configure a SQL Server 2008 R2 Failover Cluster Instance in Azure
Introduction
If you are reading this article you probably are still using SQL Server 2008/2008 R2 and want to take advantage...
2019-02-04
1,011 reads
Tidier PowerShell Scripts with Default Parameter Values
I was recently working on a PowerShell script to set up some new databases for my users and found myself writing the same things over and over again.
1 2...
2019-02-04
15 reads
Undercover Catalogue 0.2 Released
We’re pleased to announce the release of the Undercover Catalogue 0.2 and can be downloaded from https://github.com/SQLUndercover/UndercoverToolbox/tree/master/SQLUndercoverCatalogue
The new version brings...
2019-02-04
121 reads
Weekly reading #1
Damian. My name is Damian. Maybe you already know me from the previous blog which I had to leave. I...
2019-02-04
44 reads
#Python101 with Dominika
Take a look into first article about Python prepared by Dominika. You can find it here.
2019-02-03
60 reads
Last Week Reading (2019-02-03)
Press Webinar Follow-Up: Top 4 Data Technology Trends for DBAs in 2019 Very interesting discussion panel led by Kevin Kline...
2019-02-03
169 reads
SQLServerCentral SSAS Tabular Series: 5th Article Cleaning Up Dimensions
The fifth article in the SQL Server Analysis Services Tabular Model has been released on SQLServerCentral.com. Please start at the...
2019-02-03
180 reads
SQLServerCentral SSAS Tabular Series: 5th Article Cleaning Up Dimensions
The fifth article in the SQL Server Analysis Services Tabular Model has been released on SQLServerCentral.com. Please start at the beginning article before reading this one in order to...
2019-02-03
39 reads
SQL Server Monitoring: What queries should you monitor?
I previously wrote about measuring wait statistics. This matters a lot, because you can track historically what wait statistics are...
2019-02-02
368 reads
Blogs
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,...
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Forums
Microsoft Security Changes and SQL Server
Comments posted to this topic are about the item Microsoft Security Changes and SQL...
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Downtime Caused by the Postgres Transaction ID Wraparound Problem
Comments posted to this topic are about the item Downtime Caused by the Postgres...
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers