Automation starts by doing something once, very very carefully: T-SQL Tuesday #110
After a while the intros for my T-SQL Tuesday posts get a little boring. So without any further ado, it’s...
2019-01-08
207 reads
Kenneth Fisher
Identity in a SELECT
Always be learning right? So when I saw this I had to go HU?! That’s new. What’s going on here?
SELECT
IDENTITY(INT,...
2019-01-02 (first published: 2018-12-19)
7,166 reads
SQL Homework – January 2019 – Baselines
Happy New Year! Every year for New Years we all make a big deal of coming up with New Years...
2019-01-02
1,076 reads
Using Microsoft Learn
I’ve just signed up on Microsoft’s new learning opportunity Microsoft Learn. The main categories are Azure, Business Apps, and Windows...
2018-12-31
428 reads
Oh Query, Query, Query
I thought I would post this a bit early so everyone can memorize the words before Hanukka starts next week.
I...
2018-12-18 (first published: 2018-11-28)
2,756 reads
Savings changes is not permitted. The changes you have made require the following tables to be dropped and re-created.
Microsoft does a lot of things to try to help us not shoot ourselves in the foot. This little error...
2018-12-17
1,014 reads
Bulk insert and an identity column
TL;DR; BULK INSERT doesn’t have an easy way to specify a column list so the columns in the insert file...
2018-12-12
989 reads
Moving SSISDB is not as easy as it sounds
We’ve been doing a lot of upgrading recently and at one point had to move an instance from one 2016...
2018-12-10
233 reads
My backup script (where, how, how big, etc.)
A while back I wrote about how to find where your backups are. And I’ve also written about I use...
2018-12-10 (first published: 2018-11-26)
2,080 reads
UDL files and connection strings
A co-worker showed me a really neat trick the other day. We deal with a lot of connection problems and...
2018-12-05
7,197 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
BCA KCP Permata Kota HUB/CS 08216977701
Komplek Permata Kota, Jl. Pangeran Tubagus Angke No.170 Blok L Kav 8 & 9,...
Kantor BCA KCU Magelang Telp/wa 085169998803
Telp/wa 085169998803 Jl. Ahmad Yani No.1, Magelang, Kec. Magelang Tengah, Kota Magelang, Jawa Tengah...
BCA KCP Abdulrahman Saleh Telp/wa 085169998765
Telp/wa 085169998765 Jl. Abdulrahman Saleh No.101 Kav C-D, Kalibanteng Kulon, Kec. Semarang Barat, Kota...
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