High Availability Lingo
You have got to love the way the SQL Server team change the lingo in all of their high availability...
2012-08-13
1,117 reads
SQL Server 365
Cost Savings and Backup Compression
Let me set the scene, one of our internal IT SQL Servers which stores a whole host of performance metrics...
2012-08-08
1,840 reads
Database Tables
Today I was asked for "a list of all tables in all databases" on a particular instance of SQL Server. ...
2012-06-13
876 reads
Rebuilding System Databases
Today’s post is something I thought I would share as there is an awful lot of incorrect commands I have...
2012-04-02
813 reads
Why I don’t like maintenance plans
If you create a maintenance plan (SQL 9.0.3042) to backup databases and select All databases as below;
Then at some point...
2012-03-16
896 reads
How Resilient Is Your Recovery Plan?
In this modern age of technology DBA’s face an ever increasing demand from businesses; our databases must perform, be secure,...
2012-03-14
612 reads
A Script A Day Finished!
Well that's it, my "A Script A Day" series is finished. I hope you found the scripts I provided useful, I've used...
2012-03-03
574 reads
A Script A Day - Day 29 - The Importance of Being Idle
Today’s script is also one I used in my migration on Wednesday. It again uses string manipulation to generate a...
2012-03-02
521 reads
A Script A Day - Day 28 - String Manipulation
Today’s script is one that I used earlier this week. On Thursday I migrated a server from SQL Server 200...
2012-03-02
527 reads
A Script A Day - Day 27 - Missing Database Backups
Today’s script is one I have used many times in the past to check for missing backups. The script will...
2012-02-29
3,481 reads
Blogs
A Fabric solution can be very cost effective
By ChrisJenkins
Are you currently using Microsoft Fabric or considering migrating to it? If so, there...
Track SQL Server Configuration Changes Using the Error Log
By SQLPals
Track SQL Server Configuration Changes Using the Error Log If you...
Data Engineering Books Worth Having on Your Shelf (or your tablet)
Good documentation gets you started. Good books get you deep. After years of working...
Forums
Alamat kontak resmi BCA KCP Taman Melati Telp:0817866887
WhatsApp:0817866887 Gedung Taman Melati Margonda Jl. Margonda No.525 A, Pondok Cina, Kecamatan Beji, Kota...
SQL Server Showing Out of Space But Plenty of Drive Space
We have a SQL Server installed. We have a 500GB drive for the database....
Creating a JSON Document IV
Comments posted to this topic are about the item Creating a JSON Document IV
Question of the Day
Creating a JSON Document IV
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 YearEstablished, json_objectagg(city : TeamName) FROM dbo.NFLTeams GROUP BY YearEstablished;See possible answers