Default Database Reports – Disk Usage by Table
Every now and again you need to know how big a table is. Or several tables. Or all of the...
2017-08-03 (first published: 2017-07-19)
1,833 reads
Kenneth Fisher
Default Instance Reports – Configuration Changes History
Hey, who changed the max memory setting for the xyz instance? The good news is that this information is captured...
2017-08-02 (first published: 2017-07-17)
1,392 reads
SQL Homework – August 2017 – Create a table
If you didn’t see it last month I’ve started doing monthly SQL Homework. The first month was backups, this month...
2017-08-02
417 reads
DBA Dice
I’ve always thought it would be fun to have a DBA themed magic 8-ball. Now you may not be aware...
2017-07-31
581 reads
Default reports in SSMS
As DBAs our stock in trade is information and there is certainly an impressive amount available. The diagnostic views are...
2017-07-27 (first published: 2017-07-13)
2,628 reads
SQL Crossword #1
Today we start a new puzzle series, with a crossword puzzle from MVP Kenneth Fisher.
2017-07-26
941 reads
Default SQL Agent Reports – Top Jobs
Looking at what a job has been doing is important. Particularly if something is going wrong. Now there are several...
2017-07-24
459 reads
What is the system_health extended events session?
Similar to the default trace the system_health session is automatically started up when the instance starts and collects information about...
2017-07-19 (first published: 2017-07-05)
2,105 reads
Save and save often
It’s the second Tuesday of the month, and as I’m sure you remember that means it’s time for T-SQL Tuesday!...
2017-07-11
440 reads
SQL Crossword : T-SQL Keywords : June 2017
I did a SQL crossword last month (not my first one either) and it was pretty popular so I asked...
2017-07-07 (first published: 2017-06-28)
2,426 reads
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
BCA KCP Royal Square TLP/WA 083800209966
Royal Square, Jl. Raya Menganti Lt. 1 / Lt. Dasar RG 11, Babatan, Kec....
BCA KCU MENARA BIDAKARA Telpon/wa:0813.7887.595
BCA KCU MENARA BIDAKARA Telpon/wa:0813.7887.595.Menara Bidakara, Jl. Gatot Subroto No.Kav.71-73 Lt. Lobby dan Lt....
Alamat kantor resmi BCA KCU SCBD Telp: 0817-82-5533
WhatsApp: 0817825533, Equity Tower, Ground Floor, Unit D & Lantai 8, Unit E, Jl....
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