Microsoft Data Platform – MVP 2017!!!
I’m very pleased and delighted to share that I have been awarded Microsoft Most Valuable Professional (MVP) award 2017. This...
2017-04-14
437 reads
SQL Geek
Read Statistics Histogram using DMV
DMV: sys.dm_db_stats_histogram (object_id, stats_id)
For a long time, the DBCC SHOW_STATISTICS command was the only way to get information about statistics....
2017-02-22
980 reads
Out of memory error because of the very low virtual address space – Error 701 – Trace Flag 8075
If you are dealing with a SQL Server which got a lot of memory, you may encounter the out of...
2017-02-20
1,278 reads
After migrating SQL Server from 2005 to higher version, the waits type PAGELATCH_UP increased
Recently, I experienced an interesting issue where I found SQL Server wait type PageLatch_UP went up drastically after migration. Let’s...
2017-02-06
524 reads
SQL Server Service Information
DMV: sys.dm_server_services
Microsoft SQL Server 2008 R2 SP1 and SQL Server 2012 has a new set of DMVs. One of them...
2017-01-11
367 reads
Disk Space Monitoring using SQL Server DMV
DMV : sys.dm_os_volume_stats
Being a SQL Server database administrator, you may often receive alerts or asked by Senior DBAs to check, if...
2017-01-09
17,775 reads
New String Function – TRIM – in SQL Server vNext
As SQL developer, you must have often come across a scenario where you need to remove the empty spaces at...
2017-01-06
2,068 reads
When was SQL Server installed?
In this blog post. Let us learn about how to retrieve date and time when the SQL Server was installed. To retrieve...
2017-01-04
13,634 reads
Identifying Blocking Chain in SQL Server
HAPPY NEW YEAR 2017!!
I hope you all had a good Christmas and New Year. I always try to review my...
2017-01-01
12,198 reads
Configure Internal and Private Networking for Hyper-V Virtual Machines
In the previous tutorial, we went through how to setup “External Network” to access the internet on Hyper-v client machine....
2016-12-25
2,835 reads
Blogs
The Agent Era: When “How do I…?” Replaces “Where do I click?”
By Arun Sirpal
After a year away getting to grips with AI and its application across the...
Beware of Generic SQL Server License Keys (What to Use Instead)
By SQLPals
Beware of Generic SQL Server License Keys (What to Use Instead) ...
On Speaking Well
By Brian Kelley
Professor Patrick Winston of MIT used to give a one-hour talk about how to...
Forums
Creating a JSON Document II
Comments posted to this topic are about the item Creating a JSON Document II
Backing Up Azure Key Vault EKM Key: Stairway to TDE Level 6
By VishnuGupthanSQLPowershellDBA
Comments posted to this topic are about the item Backing Up Azure Key Vault...
Every Database Has Problems
Comments posted to this topic are about the item Every Database Has Problems
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 1960If I run this code, what document(s) is/are returned?
SELECT json_objectagg( n.city : n.TeamName) FROM dbo.NFLTeams;See possible answers