SSDT DevPack + Visual Studio 2017
I have upgraded the ssdt dev pack to support visual studio 2017 and fixed a couple of minor annoyances and...
2017-05-08
62 reads
SSDT DevPack + Visual Studio 2017
I have upgraded the ssdt dev pack to support visual studio 2017 and fixed a couple of minor annoyances and have started to think about how to improve it...
2017-05-08
12 reads
Copy-SqlJob, a handy dbatools cmdlet
One of the things I’ve often needed to do is move jobs around between instances of SQL Server. I’ll often...
2017-05-23 (first published: 2017-05-08)
1,786 reads
General Notes on Security in Azure SQL Data Warehouse
I’m still learning about Azure SQL Data Warehouse (ADW, cause I’m lazy). ADW is a deceptively deep topic. Initially you...
2017-05-22 (first published: 2017-05-08)
1,182 reads
Slides from SSWUG 2017 Spring Virtual Conference
As promised, here are the slides for my two presentations from SSWUG’s 2017 Spring Virtual Conference:
SSWUG_Spring_Building an Auditing Framework for...
2017-05-08
330 reads
SQL Saturday Louisville precon – interview Andy Leonard
This will be year #9 of sql saturdays in Louisville. Every year (starting with 3rd or 4th), it has been...
2017-05-08
447 reads
SQL Server Recovering Data via a Hex Editor
I got bored (really bored) one weekend I decided to challenge myself. I had corruption within a specific table (localised...
2017-05-08
417 reads
Monday Coffee 2017-05-08
Asking stupid questions
Oh boy have I asked some stupid questions in my time. Most recent was this question that I...
2017-05-08
337 reads
Using The SQL Server Merge Statement
Note : Since publishing this I’ve been notified that there are a number of outstanding issues with the SQL Server merge...
2017-05-08
66 reads
SQL Azure Databases - Active Secondary - How to configure? - Part 1
Dear all,I have taken the azure dive at last 🙂
In case if you are new to azure, azure is the Microsoft cloud platform service, offering lots of services for...
2017-05-07
12 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