The Service Pack Fiasco
The recent SQL Server 2014 Service Pack fiasco wasn't the first, but hopefully it won't be the last.
2015-05-11
212 reads
Editorial
Not Only a Meeting of Minds, but of Open Minds.
In which Phil Factor claims that professional application development requires a broad knowledge base.
2015-05-11
104 reads
How Virtualized?
This week's poll asks about virtualization in your environment. Let us know if you are moving your SQL Server to virtual machines.
2019-03-20 (first published: 2015-05-08)
193 reads
vNext 2016
Steve Jones looks at the next version of SQL Server, SQL Server 2016. Until this week, it was known as vNext.
2015-05-07
275 reads
Idempotent
There are all sorts of coding practices that produce better code. Steve Jones talks about one today.
2024-11-04 (first published: 2015-05-06)
560 reads
Can Auditing Fail?
It doesn't seem to be a feature that an auditing system can fail, but the application being audited continues to run.
2018-10-26 (first published: 2015-05-05)
144 reads
2015-05-04
72 reads
Complete Definitions
When we write scripts, we often assume many settings will be at some default value. When we generate scripts, that's not the case. Perhaps we should be sure that we always include the settings we expect.
2015-05-04
129 reads
Finding Problem Code
This week Steve Jones has a poll on performance tuning code. Since many people aren't experts, the answers this week might help them learn where to focus their efforts.
2015-05-01
225 reads
Is It Time to Upgrade?
Today Steve Jones looks at the reasons for upgrading, or not, from SQL Server 2005.
2015-04-30
205 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 Antasari TLP/WA 08216977701
Jl. P Antasari No.21, Tlk. Lerong Ulu, Kec. Sungai Kunjang, Kota Samarinda, Kalimantan Timur...
BCA KCU SAMARINDA TLP/WA 08216977701
Jl. Jend. Sudirman No.30, Ps. Pagi, Kec. Samarinda Kota, Kota Samarinda, Kalimantan Timur 75111
BCA KCP Bintaro Telp/WA.0821°3111°179
By Cakhia TV Bóng Đá Trực Tuyến
Telp/WA.0821°3111°179 Jl. RC. Veteran. 9, dan No.9A, Daerah Khusus Ibukota Jakarta 12330
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