Clearing Plan Cache in SQL Database (Azure)
Sometimes when in a testing mode I do like to clear cache within my SQL database (Azure). Nowadays a lot...
2017-01-05
711 reads
Blog Posts
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
623 reads
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
564 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
569 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
13 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
434 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
355 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,074 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,566 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
500 reads
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
Risk Vs Reward, The never ending ROI discussion.
Comments posted to this topic are about the item Risk Vs Reward, The never...
Hyperscale Replicas IV
Comments posted to this topic are about the item Hyperscale Replicas IV
The SQL Server Date Magic: When CAST and CONVERT Keep Your Index Seek
Comments posted to this topic are about the item The SQL Server Date Magic:...
Question of the Day
Hyperscale Replicas IV
In Azure SQL Database Hyperscale Edition, how many geo-replicas can be created?
See possible answers