The Scientific Method: a call to action
Gail Shaw issues a rallying call for the SQL Community to adopt the Scientific Method when investigating and reporting on SQL Server behavior.
2019-09-09 (first published: 2015-05-25)
620 reads
Editorial
Native Audits
This week Steve Jones asks if you're using the SQL Audit feature built into SQL Server.
2015-05-22
147 reads
Naming Confusion
The naming of systems and other technological constructs is always a debate within groups. Steve Jones points out a few places where this might actually prevent mistakes.
2015-05-21
137 reads
Controlling Alerts
Being on call is not much fun for anyone, but it can certainly be hard on those that receive lots of calls for systemic issues. Are there better ways to manage this?
2015-05-20
136 reads
2019-06-14 (first published: 2015-05-19)
596 reads
Awareness
This week Steve Jones looks back at the T-SQL Tuesday blog part and its theme of monitoing.
2015-05-18
80 reads
Boring or Scripting
There is no shortage of mundane tasks at work. Steve Jones notes that you might not want to depend on those to fill your day in the future.
2024-11-20 (first published: 2015-05-18)
448 reads
Documenting with Tests
The idea of using more unit tests to improve code quality has been around for some time. However Steve Jones notes today that some people use tests for documentation.
2019-10-04 (first published: 2015-05-14)
279 reads
2015-05-13
840 reads
Opening Up Data
Tim O'Reilly, head of O'Reilly publishing, has been an advocate of better date movement in the world. Steve Jones has a few comments on an interview he gave earlier this year.
2015-05-12
105 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 KCU TASIKMALAYA TLP/WhatsApp 08216977749
Jl. HZ. Mustofa No.300, Tuguraja, Kec. Cihideung, Kab. Tasikmalaya, Jawa Barat 46124
BCA KCP Gandaria City Telpon/wa:0813.7887.595
BCA KCP Gandaria City Telpon/wa:0813.7887.595.Gedung Mal Gandaria City Mainstreet-Upper Ground M-U25, Jl. Sultan Iskandar...
BCA KCU MENARA BIDAKARA HUB.Tlpn.0821•3111•185
BCA KCU MENARA BIDAKARA HUB.Tlpn.0821•3111•185 Menara Bidakara, Jl. Gatot Subroto No.Kav.71-73 Lt. Lobby dan...
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