SQL SERVER ON LINUX INSTALLATION – PART4 – INSTALL SQL SERVER AGENT ON RHEL
In my previous tips, I explained about install RHEL Server on the virtual machine, install SQL Server 2017 on Red Hat Enterprise...
2017-11-25
593 reads
SQL Geek
SQL SERVER ON LINUX INSTALLATION – PART3 – INSTALL SQL SERVER COMMAND-LINE TOOLS ON RHEL
As installing SQL Server on Linux doesn’t install SQL Server command-line tools by default. So, you have to install it...
2017-11-23
747 reads
SQL SERVER ON LINUX INSTALLATION – PART2 – INSTALL SQL SERVER ON RHEL
In the previous blog, we discussed how to install RHEL Server on the virtual machine. In this quick tutorial, we...
2017-11-22
818 reads
SQL Server on Linux Installation On RHEL Server – PART1
In the previous posts, we learned how toinstall SQL Server on Ubuntu Server&install SQL Server on CentOS. Today, we’ll walk...
2017-11-21
1,044 reads
SQL Operation Studio Tool
Microsoft finally has launched most awaited tool – SQL Operation Studio (aka OpsStudio)!!!
SQL Operation studio is a lightweight open source...
2017-11-20
1,558 reads
Finding Input Parameters in an Execution Plan
The query execution plan is a map of work which SQL Server is going to perform to execute a query....
2017-11-22 (first published: 2017-11-11)
7,080 reads
Figuring out Time-Out Prone queries
Recently, I was helping one of the community attendees on the SQL Server Query Time-Out issue. Once we are done...
2017-11-20 (first published: 2017-11-09)
680 reads
Getting Query Execution Statistics
If you hate things that are slow, I bet you certainly want to know the reason for the slowness. So,...
2017-11-17 (first published: 2017-11-06)
6,077 reads
Over-Indexing can hurt your SQL Server performance
Indexes are a vast subject and well documented elsewhere on the web. But, it is still a very commonly asked...
2017-11-15 (first published: 2017-11-05)
5,223 reads
SQL Replication SubscriptionStreams setting
In this blog, we will talk about improving distribution agent throughput by modifying the profile parameter – “SubscriptionStreams”. I will be...
2017-10-23 (first published: 2017-10-14)
6,939 reads
Blogs
Get a Range of Sequence Values: #SQLNewBlogger
By Steve Jones
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?”
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) ...
Forums
data compare between 2 tables with same structure for any changes after etl run
i have huge table with lot of data and is also wide. i took...
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...
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