Azure Data Catalog
Azure Data Catalog
Now available in public preview is the Azure Data Catalog. The Data catalog provides an enterprise data repository...
2015-09-08
659 reads
Blog Posts
Enterprise Strategies – A #TSQL2sDay post
This months TSQL2sDay blog post party is hosted by Jen McCown and is about Enterprise Strategy.
Adam Mechanic started TSQL Tuesdays...
2015-09-08
595 reads
Extended Events Objects
Today I want to start diving into some of this data a little deeper as we progress some of the of the core concepts surrounding Extended Events.
Related Posts:
Correlate SQL...
2015-09-08
6 reads
Learning Extended Events in 60 Days
This post will serve as the landing page for a series I am calling 60 Days of Extended Events. The...
2015-09-08
767 reads
Learning Extended Events in 60 Days
Want to Learn Extended Events over the course of your lunch break for a couple of months? This is the Table of Contents for learning Extended Events over the...
2015-09-08
50 reads
Setting Up Alerts in Azure SQL Database
Setting Up Alerts in Azure SQL Database
SEPTEMBER 8, 2015
IntroductionIf I've learned one thing with my on premise versions of SQL Server, it is to automate as much as possible....
2015-09-08
68 reads
SQL Server – Using Window ranking function with UPDATE statement
Hi friends, I was working on a scenario in which I need to assign a unique values to a column....
2015-09-08
621 reads
SQL Server Data Tools is now a separate installer – Things to know!
Recently I had to develop some SSRS report, and my desktop machine had SQL Server 2014 installed on it. I...
2015-09-08
1,290 reads
The Fastest Way to Combine DATE and TIME Data Types to a DATETIME
Recently while working with a table where there were two columns, one a DATE datatype and a second TIME datatype,...
2015-09-08 (first published: 2015-08-28)
81,730 reads
T-SQL Tuesday #70 - SQL Server In the Enterprise
PearlKnows WeB log, Stardate 2015.9.8: This week’s topic is strategies for
managing an enterprise, brought to us by one half of...
2015-09-08
3,111 reads
Blogs
How to Connect to SQL Server When Nothing Else Works – DAC
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
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...
Forums
Are luxury packages in Andaman suitable for a honeymoon?
Yes, luxury packages in Andaman are highly popular among honeymooners due to their romantic...
Hiring: Financial SQL Systems Administrator
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...
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