Monday Coffee: SQL Saturday Dublin
Last weekend was SQL Saturday Dublin, and it was a good one.
My session on An introduction to SQL Server & Containers...
2017-06-19
307 reads
Blog Posts
PASS Board Elections
Well, it is almost that time of the year again. Elections for the PASS Board. This is a great way to show your passion for this wonderful community...
2017-06-19
8 reads
PASS Board Elections
Well, it is almost that time of the year again. Elections for the PASS Board.
This is a great way to...
2017-06-19
507 reads
PASS Security VC Presentation – The Dirty Business of Auditing
On Thursday, June 22, at 1 PM EDT / 10 AM PDT, I’ll be presenting for the PASS Security Virtual Chapter.
Registration...
2017-06-19
367 reads
Powershell Module Improvements for SQL Server in 2017
simple setup
A major improvement that seems to have quietly slipped into the sql developers world is an improved SQLServer powershell...
2017-06-19 (first published: 2017-05-31)
2,220 reads
SQL Server Installed and Running on macOS In Less Than 5 Minutes (With Video)
SQL Server 2017 is the first version of SQL Server that will also run natively on Linux and on macOS...
2017-06-19
43 reads
SQL Server TDE – Is TempDB Encrypted?
A really quick one today, something that made me think for a minute and I thought it might make others...
2017-06-19
674 reads
T-SQL Tuesday #91 – Start Talking
T-SQL Tuesday is a monthly blog gathering for the SQL Server/Data Professional community It is the brainchild of Adam Machanic (B|T)...
2017-06-19 (first published: 2017-06-13)
986 reads
Webinar with Rubrik: Simplifying SQL Server Data Protection – Near Zero RTO
I am very proud to contribute to a new webinar with Rubrik on Thursday, June 22 at 8AM PT / 11AM ET...
2017-06-19
372 reads
Great to see you at SQLSaturday Houston 2017
Great to see all of you at #SQLSatHouston today, an awesome event put on by a great crew of volunteers....
2017-06-17
298 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