Alerts From Azure Automation
In a previous post, I showed how to set up statistics maintenance for your Azure databases using Azure Automation. However,...
2017-04-04
641 reads
How I Became A…SQL Server Data Professional
Last night I saw a tweet from Matt Gordon (b|t); the topic caught my eye – “How I Became A…SQL Server...
2017-04-04
410 reads
The Foundry–Data Masking Research
For most of the time I’ve been working for Redgate, we’ve had some sort of R&D group that tries out...
2017-04-04
508 reads
Azure: SQL Database Elastic Pool and using Elastic Jobs
I want to show you how I went from having multiple single SQL databases in Azure to a database elastic...
2017-04-04
591 reads
Step by Step Configuring AlwaysOn with Log Shipping
One of my clients came up with a requirement to use log shipping along with an AlwaysOn Availability Group. They cannot extend an AlwaysOn replica to the disaster recovery...
2017-04-04
19 reads
Step by Step Configuring AlwaysOn with Log Shipping
One of my clients came up with a requirement to use log shipping along with an AlwaysOn Availability Group. They...
2017-04-04
778 reads
Only as Good as Your Auditor
I wrote Only as Good as Your Auditor for SQLServerCentral because its something I’ve explained to people over and over...
2017-04-04
650 reads
T-SQL Tuesday #89 Invitation – The times they are a-changing
T-SQL Tuesday is a monthly blog party for the SQL Server community (or Microsoft Data Platform community. Although it’s called...
2017-04-04
424 reads
Columnstore Indexes – part 102 (“CCI with Secondary Rowstore Indexes on SQL 2014”)
Continuation from the previous 101 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
In SQL Server 2014 we have received...
2017-04-03
441 reads
Understanding Keys and Certificates with Always Encrypted
This post attempts to explain in simple terms what keys are involved in Always Encrypted, how they get used, and the implications of those facts.
2017-04-03
16 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...
Trigger isn't working
Hi, I have a trigger, that works fine elsewhere but is not working at...
Question of the Day
Hyperscale Replicas IV
In Azure SQL Database Hyperscale Edition, how many geo-replicas can be created?
See possible answers