2020 Year In Review
TL;DR – It was great and not great I think we can all pretty much agree that in some regards 2020 was horrible, globally. So lets move on… Good...
2021-01-01
19 reads
Blog Posts
Basic Cursors in T-SQL–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. Cursors are not efficient, and not recommended for...
2021-01-01 (first published: 2020-12-23)
527 reads
Daily Coping 1 Jan 2021
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-01-01
14 reads
DirectQuery for Power BI datasets and Azure Analysis Services (preview)
Announced last week is a major new feature for Power BI: you can now use DirectQuery to connect to Azure Analysis Services or Power BI Datasets and combine it...
2021-01-01 (first published: 2020-12-23)
787 reads
Easy Monitoring: Application Timeouts in SQL Server with XEvents
Application timeouts can be surprising little problems causing grey hairs. Never fear, this article with the XEvents session I shared are the perfect solution.
The post Easy Monitoring: Application Timeouts...
2021-01-01
543 reads
Easy Monitoring: Application Timeouts in SQL Server with XEvents
Application timeouts can be surprising little problems causing grey hairs. Never fear, this article with the XEvents session I shared are the perfect solution.
The post Easy Monitoring: Application Timeouts...
2021-01-01
12 reads
Easy Monitoring: Application Timeouts in SQL Server with XEvents
Application timeouts can be surprising little problems causing grey hairs. Never fear, this article with the XEvents session I shared are the perfect solution.
The post Easy Monitoring: Application Timeouts...
2021-01-01
14 reads
Easy Monitoring: Application Timeouts in SQL Server with XEvents
Application timeouts can be surprising little problems causing grey hairs. Never fear, this article with the XEvents session I shared are the perfect solution.
The post Easy Monitoring: Application Timeouts...
2021-01-01
14 reads
Easy Monitoring: Application Timeouts in SQL Server with XEvents
Application timeouts can be surprising little problems causing grey hairs. Never fear, this article with the XEvents session I shared are the perfect solution.
The post Easy Monitoring: Application Timeouts...
2021-01-01
7 reads
Easy Monitoring: Application Timeouts in SQL Server with XEvents
Application timeouts can be surprising little problems causing grey hairs. Never fear, this article with the XEvents session I shared are the perfect solution.
The post Easy Monitoring: Application Timeouts...
2021-01-01
9 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