Some time back I wrote about the new data classification features in Azure and SQL Server Management Studio. If you’ve done quite a bit of work classifying your data...
2020-04-24 (first published: 2020-04-11)
999 reads
I have an idea! Let’s have a “Worst Code Contest.” Why do this? Bad code is really fun — at least, when you write it on purpose. And other...
2020-04-24
34 reads
Dear Friends We are launching the YouTube Channel “Decode ITES”. Decode ITES will be sharing technical videos over multiple IT infra skills like SQL Server, Postgres, Oracle, Windows, Public...
2020-04-24
86 reads
Dear Friends Apologies for less knowledge sharing articles for a long time and Big thanks for stay connected with me. I will be coming up with the “SQL Server...
2020-04-24
28 reads
Some of us have been lucky enough to have already been working from home (WFH) prior to the world events. This has allowed most of us the ability to...
2020-04-24
137 reads
I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is helping me deal with the issues in the world. I’m adding my responses for each...
2020-04-23
12 reads
I recorded my first class for the Live Stairways – Learning DAX and Power BI. My apologies for anyone that wanted to join. We had an error in the...
2020-04-23
60 reads
As always, the script from this post can also be found on our GitHub repo, HERE You’ve got a SQL Server with a few hundred databases on it (to...
2020-04-23 (first published: 2020-04-15)
732 reads
My new course “Designing a Site Recovery Strategy on Microsoft Azure” in now available on Pluralsight here! Check out the trailer here or if you want to dive right in go here! This course...
2020-04-23
7 reads
My new course “Designing a Site Recovery Strategy on Microsoft Azure” in now available on Pluralsight here! Check out the trailer here or if you want to dive right in go here! ...
2020-04-23
5 reads
By SQLPals
Track SQL Server Configuration Changes Using the Error Log If you...
Good documentation gets you started. Good books get you deep. After years of working...
By Vinay Thakur
In previous posts, we looked at the SQL Server engine. for us DBAs, the...
WhatsApp:0817866887 Jl. Bukit Barisan No.3, Kesawan, Kec. Medan Bar., Kota Medan, Sumatera Utara 20111
WhatsApp:0817866887 Jl. Sudirman No.59, Bukit Cangang Kayu Ramang, Kec. Guguk Panjang, Kota Bukittinggi, Sumatera...
We have a SQL Server installed. We have a 500GB drive for the database....
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 YearEstablished, json_objectagg(city : TeamName) FROM dbo.NFLTeams GROUP BY YearEstablished;See possible answers