Watch this week's video on YouTube
SQL Server has several ways to store queries for later executions.
This makes developers happy because it allows them to follow DRY principles: Don't Repeat Yourself. The more...
2019-10-22
25 reads
Watch this week's video on YouTube
SQL Server has several ways to store queries for later executions.
This makes developers happy because it allows them to follow DRY principles: Don't Repeat Yourself. The more...
2019-10-22
26 reads
Our 13th SQLSaturday is done. Some quick notes about the overall event, then as time/energy allow I’ll post separately on some things that went well (or didn’t) and some...
2019-10-22
58 reads
When attempting to connect a worker node to the current Master node of a SQL Server Integration Services (SSIS) Scaleout, for on-prem SQL Servers, if you receive the error:...
2019-11-04 (first published: 2019-10-22)
810 reads
I’ve rarely thought about licensing my code, but it’s something to be aware of for your work. Most of us freely share code, though I have started to add...
2019-10-21
66 reads
The Data Breach Game: The 9 Worst IT Security Practices Joey D’Antoni shows bad practices for security in SQL Server. He summarizes all the most important areas you should...
2019-10-21
57 reads
The Data Breach Game: The 9 Worst IT Security Practices Joey D’Antoni shows bad practices for security in SQL Server. He summarizes all the most important areas you should...
2019-10-21
61 reads
One of the other things I learned from the Powershell class I’m taking this week is that there is an ... Continue reading
2019-11-01 (first published: 2019-10-21)
483 reads
In this episode of the podcast, Adrian looks at the scripting options available in SSMS.
2019-10-31 (first published: 2019-10-21)
449 reads
So I started blogging in 2016: So why blog….now? It is very interesting going back and reading that first blog post. It was mostly thanks to my late great...
2019-10-21
40 reads
By Rayis Imayev
"I've seen things you people wouldn't believe..."— Roy Batty, Nexus-6 Replicant, Blade Runner (1982)(2026-Nov-08) Yep,...
By Steve Jones
We’ve celebrated our birthday many times at Redgate. In the Book of Redgate –...
Discover how Palantir connects enterprise data, supports AI-driven decision-making and helps companies turn insights...
Comments posted to this topic are about the item Pay for Performance, which is...
Comments posted to this topic are about the item Too Many Choices
Comments posted to this topic are about the item Table Partitioning in SQL Server:...
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