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
22 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)
541 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
22 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)
790 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
550 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
13 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
15 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
Reflections on the Life of a DBA
The DBA life is fraught with pain. Those battles that we endure are mostly...
Moving On-Prem PostgreSQL to the Cloud: Picking the Right Path for Big Tables
Every PostgreSQL migration eventually hits the same fork in the road. The database is...
A Spread of Vacation
By Steve Jones
I’m off on vacation today. Which is a little weird as I just got...
Forums
Inquiry – Enforcing ApplicationIntent=ReadOnly via GPO
Hello, I would like to ask whether it is technically possible to redirect a...
Calculating Geometric Mean in Power BI
Comments posted to this topic are about the item Calculating Geometric Mean in Power...
TempDB Facts I
Comments posted to this topic are about the item TempDB Facts I
Question of the Day
TempDB Facts I
Can I set Accelerated Database Recovery on tempdb?
See possible answers