Getting SQL Services, Starting, Stopping and Restarting them with dbatools
There was a question in the #dbatools slack channel
Getting dbatools
dbatools enables you to administer SQL Server with PowerShell. To get...
2018-12-03
306 reads
Blog Posts
Overview of DML Operations – SQL Delete
This article on the SQL Delete is a part of the SQL essential series on key statements, functions and operations...
2018-12-03
375 reads
Query Store and Plan Cache Plans Compared
Query Store plans and the plans in cache are identical, right? There won’t be differences because the plan that is...
2018-12-03 (first published: 2018-11-19)
2,017 reads
Running SQL Server with Docker on the Mac
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2018-12-03 (first published: 2018-11-19)
2,683 reads
SHUTDOWN SQL Server
I explore the question of if it is possible to reboot the server from within SQL Server or even simply shut down the entire server. Well, you can certainly...
2018-12-03
9 reads
SQL Homework – December 2018 – Configure SSMS
I’ve committed to posting a piece of homework for you to do each month. I post at the beginning of...
2018-12-03
198 reads
Three tips to help your database team avoid burn out this holiday season
As you’re enjoying the festivities this month, spare a thought for your database administrators and IT teams. It’s one of...
2018-12-03
356 reads
Three tips to help your database team avoid burn out this holiday season
As you’re enjoying the festivities this month, spare a thought for your database administrators and IT teams. It’s one of the busiest and most stressful times of the year...
2018-12-03
13 reads
Updating SSMS to 17.9.1
I went to download the SSMS v17.9.1 package the other day and saw this:
I remember some issues with a C++...
2018-12-03
994 reads
Where do data breaches come from?
I recently did a bit of research on the source of data breaches. In this post, I’ll talk a bit about my current favorite source for breach information, and...
2018-12-03
13 reads
Blogs
Identity Columns Can’t Be Updated: #SQLNewBlogger
By Steve Jones
I’m not sure I knew identity column values could not be updated. I ran...
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Forums
Can someone please explain what happens?
I have mentioned this several times over several years. Can someone please help me...
SELECT COUNT(DISTINCT) returns null when nothing is found instead of 0
SELECT COUNT(DISTINCT Component) AS Found FROM tblComponents WHERE(Component NOT LIKE '%[a-z]%') AND(LTRIM(RTRIM(Component)) = 'GM13622')...
Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
Question of the Day
Creating JSON III
In a SQL Server 2025 table, called Beer, I have this data:
BeerIDBeerName 1Becks 2Fat Tire 3Mac n Jacks 4Alaskan Amber 8KirinI run this code:
SELECT JSON_OBJECTAGG(
BeerID: BeerName )
FROM beer;
What are the results? See possible answers