Database snapshots for everyone!
If you're lucky enough to have SQL Server 2016, go on and upgrade to SP1....you get extra-lucky special database snapshots...
2017-01-05
618 reads
Blog Posts
gethynellis.com 2016 Review
The year gone was an interesting year for gethynellis.com and GRE Solutions. Any year that has a new release of...
2017-01-05
554 reads
How to attach a new data disk to Azure VM using Azure Portal
In this blog I will tell you how we can attach a data disk to an Azure Virtual Machine using...
2017-01-05
557 reads
Looking Back: 2016 was Awesome!
With 2017 starting this week I would like to take a moment and reflect on 2016. I have to admit that 2016 was a great year for many different...
2017-01-05
7 reads
Looking Back: 2016 was Awesome!
With 2017 starting this week I would like to take a moment and reflect on 2016. I have to admit...
2017-01-05
429 reads
On Stepping Down and Out… For a Bit
For those of you on the Denver SQL Server User Group e-mail list, you probably heard the news I am...
2017-01-05
340 reads
Power BI Custom Visuals Class (Module 32 – Percentile Chart)
In this module you will learn how to use the Percentile Chart Power BI Custom Visual. The Percentile Chart is...
2017-01-05 (first published: 2016-12-29)
2,070 reads
Query tuning 101: Non-trusted Foreign Keys
Foreign keys are an interesting feature of relational databases. They help enforce data integrity, sometimes help improve performance by eliminating...
2017-01-05 (first published: 2016-12-30)
3,542 reads
Sequence – Long awaited feature
As per BOL (https://msdn.microsoft.com/en-us/library/ff878058(v=sql.110).aspx) : A sequence is a user-defined schema-bound object that generates a sequence of numeric values according to...
2017-01-05
481 reads
Announcing SQL Saturday Chicago Precon Training Session
Heraflux is proud to announce that I am teaching a preconference training session at this year’s upcoming SQL Saturday in Chicago....
2017-01-04
355 reads
Blogs
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Forums
Creating JSON II
Comments posted to this topic are about the item Creating JSON II
Engineer Lessons
Comments posted to this topic are about the item Engineer Lessons
Question of the Day
Creating JSON II
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( N'City':N'Denver' RETURNING JSON) GOSee possible answers