Organized Learning
Learning to become a DBA is often a winding and twisty road. Steve has a little advice today.
Redgate Takes over the SQLCop Project
I am happy to announce the Redgate Software and I are supporting and taking over stewardship of the SQL Cop project at this point. With permission from its founder, George Mastros, we will host the main repository for the project at https://www.github.com/red-gate/sqlcop. This should be considered the official repository for the code from this point […]
Executing Dynamic SQL Using sp_executesql
Learn how to create and execute dynamic SQL in your SQL Server projects!
How to convince your boss you need SQL Server monitoring
You’ve read the State of SQL Server Monitoring Report and you’ve decided you need a SQL Server monitoring tool to cover your estate fully. Now you just need to convince your boss to get on board. Read our blog to find out how to do it.
Dynamic SQL for beginners in 33 minutes
Learn some of the basics of using Dynamic SQL in a short series of videos.
How to boost team productivity with SQL Clone 4
Wednesday August 21 16.00-17.00 BST/ 10.00-11.00 Central - SQL Clone enables dev, test and CI environments to be created and refreshed in seconds, on demand or through self-service, with the latest copy of production data, masked for compliance.
Measuring the Right Things
In this weeks Simple Talk editorial Kathi Kellenberger discusses how to measure the performance of a development team and why you should always make sure you are measuring the right thing, not just the easy thing.
The Sequel to SQL
Phil Factor tacks a few new buzzwords onto his CV and looks forward to joining the new wave of "digital innovators".
The 2019 Home Lab
Steve wants to know what's in your current home lab. Leave a note and help others learn to set one up.
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 Kantor Kas Thamrin City HUB/CS 08216977701
Jl. Kb. Melati 5 No.26, Kb. Melati, Kecamatan Tanah Abang, Kota Jakarta Pusat, Daerah...
BCA KCU KELAPA GADING Hub.0851•8812•0691
BCA KCU KELAPA GADING Hub.0851•8812•0691 Menara Satu Sentra Klp. Gading, Jl. Boulevard Bar. Raya...
BCA KCP Gunung Sahari Hub/CS 08216977701
Pert, Indah Blok B, Jl. Gn. Sahari Jl. Budi Mulia No.13 11-12, Pademangan Bar.,...
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