Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I wouldn’t do this anymore, but I ran...
2019-11-22 (first published: 2019-11-13)
419 reads
In this month’s Power BI Digest Manuel Quintana [Blog | Twitter] and Mitchell Pearson will again guide you through some of the latest and greatest
2019-11-22
31 reads
Check out this new series that I’ve started on Power Platform Quick Tips. This series is all about solving problems quick with videos less than
2019-11-22 (first published: 2019-11-14)
341 reads
Starting with SQL Server 2017, Microsoft introduced the ability to pause and then resume index rebuilds. This was a great feature and with the release of SQL Server 2019,...
2019-11-22
13 reads
We have just published SQL Saturday Rochester 2020. We took last year off but we’re back for 2020 on a very special day - it’s Leap Day, February 29th!
What...
2019-11-22
Now that Azure Data Studio has PowerShell Notebooks and there is a PowerShell Module for creating notebooks. I have been asked, more than once, what is the point? What...
2019-11-21
18 reads
Event notifications are kinda like a trigger in the sense that they respond to specific event, specifically in response to DDL statements and SQL Trace events.
The major difference between...
2019-11-21 (first published: 2019-11-13)
941 reads
It is that time of year again. The NTSSUG has two spots coming open on the board. Last year I decided at the last minute to opt in as...
2019-11-21
3 reads
Yesterday in this post I described a method to correct permissions when upgrading a SQL Server 2017 container using Data Volumes to 2019’s non-root container on implementations that use...
2019-11-21
2 reads
Yesterday in this post I described a method to correct permissions when upgrading a SQL Server 2017 container using Data Volumes to 2019’s non-root container on implementations that use...
2019-11-21
1 reads
By Steve Jones
anderance – n. the awareness that your partner perceives the relationship from a totally...
By gbargsley
We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?”...
By Chris Yates
In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...
Hello, I think I need a recursive cte query but unsure of the logic....
Comments posted to this topic are about the item The Security of Old Tech
Comments posted to this topic are about the item Revisiting SQL Server Window Functions-...
True or False: Tables with a SPARSE column consume more space than regular columns if most values are NOT NULL.
See possible answers