All About SQL

My take on presenting

by Arun Sirpal

All About SQL

This idea basically started from Andy Bek’s TSQL Tuesday last year #84 growing new speakers (https://sqlbek.wordpress.com/2016/10/25/t-sql-tuesday-84-growing-new-speakers/ – thanks Andy) and I have...

2017-03-10

379 reads

Copying your SQL Database

by Arun Sirpal

All About SQL

If you ever need to move a copy of a SQL database in Azure across servers then here is a...

2017-03-07

350 reads

Blog Challenge: I am watching you!

by Arun Sirpal

All About SQL

I decided to accept Grant’s (TheScaryDBA) challenge found here- http://www.scarydba.com/2017/03/02/random-blog-post-challenge/ where we have to write a technical blog post that incorporates a certain...

2017-03-03

329 reads

Tempdb settings in SQL Server 2016

by Arun Sirpal

All About SQL

A nice little error log feature that I noticed in SQL Server 2016 regarding tempdb. Tempdb, a system database in...

2017-03-02

405 reads

SQL Server Target vs Total Memory

by Arun Sirpal

All About SQL

For this blog post I want to discuss the meaning behind SQL Server: Memory Manager\Target Server Memory (KB) and SQL...

2017-03-01

442 reads

SSMS Presenter Mode

by Arun Sirpal

All About SQL

SQL Server Management Studio (SSMS) release candidate 17.0 RC2 works side-by-side with generally available releases (16.x), but it is not...

2017-02-22

557 reads

SQL Server vNext: sys.dm_db_stats_histogram

by Arun Sirpal

All About SQL

Since installing SQL Server vNext CTP 1.3 I found out that there is a new way to return statistics histogram...

2017-02-21

371 reads

Setting up SQL Server to SQL Database (Azure) Replication

by Arun Sirpal

All About SQL

I had a need to setup transactional replication from my SQL Server to SQL Database (Azure) where I only needed...

2017-02-20

389 reads

True story: Encryption in progress stuck

by Arun Sirpal

All About SQL

Working with a couple of databases that needed TDE I noticed when I enabled one of them that it was...

2017-02-16

375 reads

Azure Advisor Recommendations

by Arun Sirpal

All About SQL

Logging into the Azure portal is a daily task of mine and my eyes light up when I see features...

2017-02-15

334 reads

Blogs

How to Connect to SQL Server When Nothing Else Works – DAC

It's 2 AM. Your phone is going off. Users can't connect to the application,...

Get a Range of Sequence Values: #SQLNewBlogger

I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...

The Agent Era: When “How do I…?” Replaces “Where do I click?”

After a year away getting to grips with AI and its application across the...

Read the latest Blogs

Forums

Are luxury packages in Andaman suitable for a honeymoon?

By andamantourtravelpackage

Yes, luxury packages in Andaman are highly popular among honeymooners due to their romantic...

Hiring: Financial SQL Systems Administrator

By Tracy Rivers

Fisher Phillips is looking for a Financial Systems Administrator to help support and improve our financial...

Job Opening for ERP Systems Administrator - Hybrid

Employee owned company, been around for over 50 years. Hybrid opportunity, looking folks in Pacific...

Visit the forum

Question of the Day

Creating a JSON Document II

I want to create a JSON document that contains data from this table:

TeamID TeamNameCity         YearEstablished
1      Cowboys  Dallas       1960
2      Eagles   Philadelphia 1933
3      Packers  Green Bay    1919
4      Chiefs   Kansas City  1960

If I run this code, what document(s) is/are returned?

SELECT json_objectagg( n.city : n.TeamName)
FROM dbo.NFLTeams;

See possible answers