Hello Denver! I’m speaking this weekend
For those of you in the Denver area, SQL Saturday is this weekend! I’m speaking and hope to see you...
2018-09-11
233 reads
Reduce your Azure Development Subscription Cost
Azure VMs
Usually you should convey to developers and testers to shut down the VMs manually when they are not using...
2018-09-11
185 reads
Faking Temporal Tables with Triggers
This post is a response to this month’s T-SQL Tuesday #106 prompt by Steve Jones. T-SQL Tuesday is a way...
2018-09-26 (first published: 2018-09-11)
2,514 reads
Faking Temporal Tables with Triggers
This post is a response to this month's T-SQL Tuesday #106 prompt by Steve Jones. T-SQL Tuesday is a way for the SQL Server community to share ideas about...
2018-09-11
12 reads
Faking Temporal Tables with Triggers
This post is a response to this month's T-SQL Tuesday #106 prompt by Steve Jones. T-SQL Tuesday is a way for the SQL Server community to share ideas about...
2018-09-11
21 reads
Why I Love DML Triggers in SQL Server
It’s TSQL Tuesday today! If you’re not familiar, TSQL Tuesday is a monthly blogging event where a Microsoft Data Platform community member chooses a writing prompt. This is a great...
2018-09-11
34 reads
Azure Hybrid and Security
Data Security. These words are in the forefront of many people’s minds and just hearing them may bring on an...
2018-09-11
160 reads
Triggers: The hidden logic that will strike back - TSQL Tuesday #106
This month’s T-SQL Tuesday is brought by Steve Jones (b | t) and he wants to know if triggers causes headaches or happiness to us.
This is the 106nd edition...
2018-09-11
15 reads
PASS FY2019 Budget Notes Updated
PASS has updated the notes supporting the FY 2019 budget to answer the questions I raised in my earlier post....
2018-09-10
287 reads
Different methods to generate query execution plans
One of the things I enjoy about my job is when I have to develop or review some T-SQL code, for my own projects or reviewing someones else code....
2018-09-10
25 reads
Blogs
Paginated Reporting at Scale: Choosing the Right Microsoft Platform
By Rayis Imayev
"I've seen things you people wouldn't believe..."— Roy Batty, Nexus-6 Replicant, Blade Runner (1982)(2026-Nov-08) Yep,...
The Book of Redgate: Fun with Images
By Steve Jones
We’ve celebrated our birthday many times at Redgate. In the Book of Redgate –...
Why companies use Palantir and how we help implement it in the Czech Republic
Discover how Palantir connects enterprise data, supports AI-driven decision-making and helps companies turn insights...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Too Many Choices
Comments posted to this topic are about the item Too Many Choices
Table Partitioning in SQL Server: A Practical Guide to Managing Very Large Tables (VLDBs)
Comments posted to this topic are about the item Table Partitioning in SQL Server:...
Question of the Day
Too Many Choices
I have a table, dbo.MasterBrands, with this data:
BrandID OfficialName 1 Samsung 2 Apple 3 Microsoft 4 Adidas 5 Coca-ColaI run this query. What is returned for Coca-Cola?
SELECT CHOOSE(BrandID, 'Conglomerate', 'Tech and Design', 'Desktop', 'Apparel') FROM dbo.MasterBrands;See possible answers