My Ignite 2018 SQL PowerShell Scripts now available in GitHub
It appears that I forgot to post my SQL PowerShell Scripts from my talk at Ignite 2018 (video here). Big thanks to Tony Green ( t ) for bringing...
2019-04-27
67 reads
Blog Posts
“SSPI handshake failed” \ “The login is from an untrusted domain” errors
I’ve recently encountered an issue that was difficult to resolve and I didn’t find the particular cause that was troubling...
2019-04-26 (first published: 2019-02-12)
2,960 reads
A Cool Image
Maybe we can get Chris Spalton to do some of these for all our events? I really like it. Just a few days until SQL in the City Summit...
2019-04-26
47 reads
Alter Multiple Databases at Once
This is a quick and dirty method I often use when I want to make a change to multiple databases...
2019-04-26 (first published: 2018-06-26)
2,505 reads
ASF 021: Guy in a Cube interview (part 1)
Introduction Guy in a Cube is all about helping you master business analytics on the Microsoft Business analytics stack to allow you to drive business growth. They are just...
2019-04-26
52 reads
Auditing Data Access in SQL Server for GDPR Compliance
In relation to the GDPR, I’ve recently been looking at the tools available within SQL Server to support auditing our...
2019-04-26 (first published: 2017-09-26)
5,782 reads
Automatic Sample Sizes for Statistics Updates
I mentioned in my previous post about manually updating statistics that you can specify whether they’re updated using a full...
2019-04-26 (first published: 2017-08-15)
1,482 reads
Avoid “Constants” in T-SQL
Unlike some other languages, T-SQL doesn’t have the concept of a constant.
As good coders, we’ve all at some point tried...
2019-04-26 (first published: 2017-10-10)
3,657 reads
Capture the most expensive queries across your SQL Server using Query Store
I’m a big fan of using queries based on the dynamic management view sys.dm_exec_query_stats to capture the most resource hungry...
2019-04-26 (first published: 2017-11-01)
5,086 reads
Checking for Membership of a Specific Active Directory Group
As part of my job I manage a bunch of SQL instances for Development and Test.
Access is managed though Active...
2019-04-26 (first published: 2018-10-02)
2,320 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 Syariah KC Samanhudi Hub/Wa 08216977701
Komplek Perkantoran Mitra Krekot, Jl. Samanhudi No.21 1, RT.1/RW.7, Ps. Baru, Kecamatan Sawah Besar,...
Bca Kcp Pembangunan Hub/Wa (08216977701)
Jl. Pembangunan I No.25A, RT.11/RW.1, Petojo Utara, Kecamatan Gambir, Kota Jakarta Pusat, Daerah Khusus...
BCA KCP Pintu Air Hub/Wa (08216977701)
Jl. Pintu Air Raya No.36 Q, Ps. Baru, Kecamatan Sawah Besar, Kota Jakarta Pusat,...
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