#PowershellBasics: Running a .sql script file.
As with all programming tasks there are a number of ways to do something, this is just one that I ... Continue reading
2021-09-27 (first published: 2021-09-16)
553 reads
Blog Posts
A Successful Blogger on Making the Switch
For Kyla Marie Charles, switching to WordPress.com opened up possibilities for her website and brand that she never thought was possible.
2021-09-27
44 reads
Book Review: Lights Out
I have always been interested in GE since I was a kid. My best friend in high school had a parent that worked for the company for a bit...
2021-09-27
46 reads
Daily Coping 27 Sep 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-09-27
36 reads
Login Timeouts
I was recently approached at work about a company that was seeing tons of timeouts in SQL Server. I was asked how to troubleshoot this. There are lots of...
2021-09-27
6 reads
My upcoming Online Trainings and Speaking Engagements
Over the next few weeks I have again some online training and speaking engagements that I want to share with you today: On September 29, I’m speaking at the...
2021-09-27 (first published: 2021-09-15)
177 reads
Wednesday Webinar with Pavilion – SQL Server Performance
I’m thrilled to announce a new webinar with Pavilion Data for this Wednesday, September 29, 2021, at 10:00am Pacific time entitled “Achieve 3x SQL Server Performance While Doubling VM...
2021-09-27
105 reads
Daily Coping 24 Sept 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-09-24
46 reads
How to Design Backups in SQL Server?
The Recovery Point Objective (RPO) and Recovery Time Objective (RTO) are basic concepts related to the information to be recovered and the time that it will take to recover....
2021-09-24
15 reads
Slides and Video from Building a Regret-free Foundation for your Data Factory Now Available
Last week, Kerry and I delivered a webinar with tips on how to set up your Data Factory. We discussed version control, deployment, naming conventions, parameterization, documentation, and more....
2021-09-24 (first published: 2021-09-16)
167 reads
Blogs
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...
Deploying AI in logistics (the unfiltered version)
A conversation with Jan Laš, CIO at HOPI, about what deploying a data agent...
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