MVP for Another Year 2020-2021
Early this afternoon I received an email from Microsoft presenting me with the 2020-2021 Microsoft Most Valuable Professional (MVP) award. This is my 7th award and I am just...
2020-07-01
1 reads
Blog Posts
Presenting on Ethics in Modern Data at Houston HASSUG/SQL BI Group July 2020 Meeting
Looking forward to presenting with my wife Christine Assaf our talk on Ethics in Modern Data at the Houston Area SQL Group and BI Group's virtual meeting on Tuesday...
2020-07-01
13 reads
Restoring a SQL Server Database in Docker
Last month I blogged about using Docker to run SQL Server as a quick and easy way to get SQL Server up and running. While it continues to be...
2020-07-01 (first published: 2020-06-19)
618 reads
Surprised and Honoured and Proud
I have always been extremely proud to be a Cloud and Datacenter Management MVP, and lucky enough to be involved with both the PowerShell community as well as the...
2020-07-01
10 reads
TIL: Dismount-DbaDatabase and Mount-DbaDatabase
We have a double feature for today’s dbatools blog post, as these two commands go hand-in-hand. Todays commands: Dismount-DbaDatabase and Mount-DbaDatabase Detach-DbaDatabase and Attach-DbaDatabase can be used as aliases....
2020-07-01 (first published: 2020-06-24)
211 reads
What is Azure SQL Database Serverless?
What is Azure SQL Database Serverless? When I hear the term serverless my mind gets confused. How can a database exist without a server? Azure is a cloud platform,...
2020-07-01
350 reads
What is Azure SQL Database Serverless?
What is Azure SQL Database Serverless? When I hear the term serverless my mind gets confused. How can a database exist without a server? Azure is a cloud platform,...
2020-07-01
5 reads
Daily Coping 30 Jun 2020
I’ve 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...
2020-06-30
21 reads
End an ALTER DATABASE immediately if anyone is in the database.
The development team has told me they’ve shut down the application, there are no more connections and I can go ... Continue reading
2020-06-30 (first published: 2020-06-11)
661 reads
New Pluralsight Course – Maintaining, Monitoring and Troubleshooting Kubernetes
My new course “Maintaining, Monitoring, and Troubleshooting Kubernetes” is now available on Pluralsight here! Check out the trailer here or if you want to dive right in head over to https://app.pluralsight.com/library/courses/maintaining-monitoring-troubleshooting-kubernetes/! This course will...
2020-06-30
31 reads
Blogs
A New Word: Anderance
By Steve Jones
anderance – n. the awareness that your partner perceives the relationship from a totally...
Troubleshooting SQL Server – Starting with the Error Log
By gbargsley
We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?”...
From OLTP to Analytics: Bridging the Gap with Modern SQL Architectures
By Chris Yates
In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...
Forums
Work out closing balance using opening balance of prior month
Hello, I think I need a recursive cte query but unsure of the logic....
The Security of Old Tech
Comments posted to this topic are about the item The Security of Old Tech
Revisiting SQL Server Window Functions- A Practical Walkthrough
Comments posted to this topic are about the item Revisiting SQL Server Window Functions-...
Question of the Day
Tables with a SPARSE Column and Consumption
True or False: Tables with a SPARSE column consume more space than regular columns if most values are NOT NULL.
See possible answers