Favorite community scripts and their parameters
Here’s some of my favorite community scripts and how I like to run them. If you haven’t tried the optional...
2019-03-09
677 reads
Blog Posts
Speaking
A place to collect abstracts & links to presentations I’ve given. Please be sure to check out my Sessionize profile as well.
Backup Basics with PowerShell and dbatools Abstract As...
2019-03-09
5 reads
Adding Objects to our SCA Project
In my last post, I started out with a new SCA project, getting a connection to my database up and...
2019-03-08 (first published: 2019-02-13)
2,684 reads
I’ve added data classifications. Now what?
About a year ago I wrote about a new feature in SSMS that allows you to add a data classification...
2019-03-08 (first published: 2019-02-20)
2,539 reads
Pausing the Learning for March
In my last update, I was disappointed with my February progress. Busy with life and work, I didn’t do much...
2019-03-08
865 reads
VMware vExpert for 2019
I’m honored and humbled to be awarded the VMware vExpert award for the seventh year in a row! Thank you...
2019-03-08
306 reads
Writing my presentation 2: Designing the presentation
This series is about my process for writing my upcoming presentation at SQL Saturday Chicago #825.
Today’s goals
Today I’m going to...
2019-03-08
342 reads
Can you speak at my User Group or Conference? No? Sweet As – can you help people register please?
This blog post is not going to be a technical one…. but it’s about technology – well more accurately about bringing...
2019-03-07
291 reads
Creating custom SQL Server Helm charts
In my previous post I went through how to deploy SQL Server to Kubernetes using Helm in which I used...
2019-03-07 (first published: 2019-02-20)
3,028 reads
Finding single use plans in the plan cache
A single use plan is an entry in the SQL Server plan cache that was only used once. When a...
2019-03-07 (first published: 2019-02-19)
3,883 reads
Blogs
Future IT Roles – Agentic Architect and AI Boom!!
By Vinay Thakur
These days everything is changing to AI World, IT roles are getting changed and...
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them Introducing PlanTrace — a free, browser-based...
A Cloud Dependency Failure from Amazon
By Steve Jones
I went to sleep while reading a Kindle book on my phone. I know...
Forums
SPAM Issues May 2026
We suffered a SPAM attack from May 1-6, which unfortunately corresponded with time off...
SQL Password enforcing
Hi to all We have situation at a client where someone is illegally changing...
SQL Password enforcing
Hi to all We have situation at a client where someone is illegally changing...
Question of the Day
Creating a JSON Document III
I have this data in a table called dbo.NFLTeams
TeamID TeamName City YearEstablished ------ -------- ---- --------------- 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960 5 49ers San Francisco 1946 6 Broncos Denver 1960 7 Seahawks Seattle 1976 8 Patriots New England 1960If I run this code, how many rows are returned?
SELECT TOP 2
json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers