T-SQL Tricks – Custom Templates
I wrote about the Template Explorer, which comes with the SQL Server tools and is visible in Management Studio (SSMS)....
2014-11-25 (first published: 2014-11-19)
8,351 reads
Fast Track Data Warehouse Reference Architecture for SQL Server 2014
I have previously blogged about the Fast Track Data Warehouse, a reference configuration optimized for data warehousing (see Microsoft SQL Server...
2014-11-19
1,630 reads
You don’t really need ORDER BY do you?
You see dozens of blog posts and articles about how the order of a result set is not guaranteed without...
2014-12-01 (first published: 2014-11-19)
9,671 reads
SOA and message based integration - the challenge of bulk data changes
I'm working on problems of enterprise data integration in the role of enterprise architect, but I am and have been...
2014-11-24 (first published: 2014-11-19)
6,400 reads
For better Sql code use fake tables
When unit testing code there is a really powerful feature that is either called mocking or faking or sometimes using stubs and what these mean is creating objects that...
2014-11-18
22 reads
For better Sql code use fake tables
When unit testing code there is a really powerful feature that is either called mocking or faking or sometimes using...
2014-11-18
52 reads
For better Sql code use fake tables
When unit testing code there is a really powerful feature that is either called mocking or faking or sometimes using...
2014-11-18
65 reads
Thoughts On A State of the Chapter Statement (and Doing More)
This is a follow up to a thought I voiced on Twitter last week – the value of a once a...
2014-11-18
582 reads
Changing Delay Between Responses for SQL Alerts with Powershell
So you have read that you should have alerts for severity levels 16 to 24 and 823,824 and 825 on...
2014-11-28 (first published: 2014-11-18)
7,158 reads
More on that Cyberwar
As a follow-up to my post on being at war, cyberwar:
State Department Hacked
If the experts are correct, this trend is...
2014-11-18
587 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