Database Offline – Redux
A database can be offline at the time that you take over responsibility of the database. You will be asked when it was taken offline. This script will help...
2019-04-15
147 reads
Blog Posts
Database Offline – Redux
A database can be offline at the time that you take over responsibility of the database. You will be asked when it was taken offline. This script will help...
2019-04-15
6 reads
Generating an SSH key on Windows
I needed an SSH key. First I needed to the WSL subsystem, and once I had that working, I could do the work I needed to do: get an...
2019-04-15
918 reads
How do I let someone execute a SQL Agent job they don’t own?
In my last post I discussed the fact that SQL Ids can, in fact, be useful on an instance that ... Continue reading
2019-04-15
3,117 reads
Indexed Views – Performance Panacea or Plight
An indexed view is a view where the result set from the query (the view definition) becomes materialized in lieu of the virtual table result set of a standard (non-indexed) view. Many...
2019-04-15 (first published: 2019-04-01)
897 reads
Presentation 5: Presenting Performance Tuning with Memory Grants
So it’s about a week after SQL Saturday Chicago 2019. The event was amazing, tons of great people and in a great venue. Here’s the details of what happened...
2019-04-15 (first published: 2019-04-01)
606 reads
Scaling SQL Elastic Pools
There are a few ways to scale a SQL elastic pool. For this blog post I show you how to scale up. It can be done via the Azure...
2019-04-15
63 reads
Weekly reading #11
Good day folks! Let’s make this week great (again)! It is spring already there so it is easy to get up at 6am and write the blog! Now looking...
2019-04-15
53 reads
Global AI Night at WSB in Chorzów
The 2nd of April 2019 was a big day because of the two global IT events. The one was for developers as a new Visual Studio 2019 was born....
2019-04-13
42 reads
Notes from Orlando Code Camp 2019
Notes: Speaker party was well attended which makes it more interesting, the only downside was that the restaurant overall was LOUD, so much so that sometimes you’d have to...
2019-04-13
16 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
Kantor BCA KCP Mekar Wangi Telp/wa 085169998803
Telp/wa 085169998803 Jl. Taman Mekar Utama No.3 & 5, Mekarwangi, Kec. Bojongloa Kidul, Kota...
Berapakah nomor call center Kartu Kredit
Ya nomor call center UOB layanan 24 jam kini tersedia melalui WhatsApp UOB 0882-201-14008...
BCA KCP Cikarang Central City Telp/wa 085169998765
Telp/wa 085169998765 Ruko Cikarang Central City, Jl. Raya Cibarusah KM 10. 88 Blok B...
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