Using strace inside a SQL Server Container
So, if you’ve been following my blog you know my love for internals. Well, I needed to find out exactly how something worked at the startup of a SQL...
2019-09-03
10 reads
Anthony Nocentino
Persisting SQL Server Data in Docker Containers – Part 1
What’s the number one thing a data professional wants to do with their data…keep it around. Let’s talk about running SQL Server in Containers using Docker Volumes on a...
2019-09-01
6 reads
Persisting SQL Server Data in Docker Containers – Part 1
What’s the number one thing a data professional wants to do with their data…keep it around. Let’s talk about running SQL Server in Containers using Docker Volumes on a...
2019-09-01
800 reads
Persisting SQL Server Data in Docker Containers – Part 2
So in my previous post, we discussed Docker Volumes and how they have a lifecycle independent of the container enabling us to service the container image independent of the data...
2019-09-01
112 reads
Persisting SQL Server Data in Docker Containers – Part 2
So in my previous post, we discussed Docker Volumes and how they have a lifecycle independent of the container enabling us to service the container image independent of the data...
2019-09-01
7 reads
Persisting SQL Server Data in Docker Containers – Part 3
In the first two posts in this series we discussed the need for data persistency in containers then we discussed where the data actually lives on our systems. Now...
2019-09-01
3 reads
Persisting SQL Server Data in Docker Containers – Part 3
In the first two posts in this series we discussed the need for data persistency in containers then we discussed where the data actually lives on our systems. Now...
2019-09-01
188 reads
Microsoft Most Valuable Professional – Data Platform for 2019-2020
Today, I’m proud to announce that I have been renewed as an Microsoft MVP – Data Platform for the 2019-2020 award year, my third MVP award. This is an truly an honor and...
2019-07-03
29 reads
Microsoft Most Valuable Professional – Data Platform for 2019-2020
Today, I’m proud to announce that I have been renewed as an Microsoft MVP – Data Platform for the 2019-2020 award year, my third MVP award. This is an truly an honor and...
2019-07-03
4 reads
Microsoft Most Valuable Professional – Data Platform for 2019-2020
Today, I’m proud to announce that I have been renewed as an Microsoft MVP – Data Platform for the 2019-2020 award year, my third MVP award. This is an truly an honor and...
2019-07-03
Blogs
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...
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
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