VSCode Tips–Remove the Highlighted Line
VSCode was making me crazy as I was writing a script. I like a light theme, and every time I went to type, I saw this: The highlight was...
2019-09-05 (first published: 2019-08-23)
2,580 reads
Use T-SQL, not the GUI
There’s a very good reason to do most of your DBA work using T-SQL, and not the SSMS object explorer. Let me tell you about it...
The post Use T-SQL,...
2019-08-23
68 reads
Cloud Computing: Myths, Mysteries, Vampires & Vultures - a free seminar to help you learn more about "the cloud".
To be honest you probably think that migrating to the cloud sounds great, and it can be, but… it’s not without risks and many people do not sufficiently understand...
2019-08-23
38 reads
DBCC CHECKDB – Msg 7928, Level 16, State 1, Line 3 The database snapshot for online checks could not be created.
Do you execute DBCC CHECKDB on your Azure SQL Database? From past experience I know some people do, I would suggest not to bother. Why? Well I have mentioned...
2019-08-23
43 reads
Introducing Data Céilí Dublin 2020 – Ireland’s newest Data Platform event
Today we have launched Data Céilí Dublin 2020, Ireland’s free, community led, Microsoft Data Platform event. (It’s pronounced kay-lee btw ?? ) Brought to you by the team behind...
2019-08-23
37 reads
The 99 Flavours of SQL Server are all Vanilla
There are so many options for running SQL Server now. It can feel a little intimidating. You’ve spent years gaining experience with SQL running on Windows Server. On bare...
2019-09-03 (first published: 2019-08-22)
575 reads
Key Findings for Database Professionals from the Accelerate State of DevOps Report 2019
The Accelerate: State of DevOps Report 2019 has just been published. This report is the latest in six years of research. With more than 31,000 survey responses, Accelerate is...
2019-08-22
18 reads
Why do DBAs dislike loops?
If you started out as a developer you were probably taught how important loops are. They are one of the ... Continue reading
2019-09-02 (first published: 2019-08-22)
1,262 reads
Public and Demo Data Coming Soon!
Any database professional that has been around the Microsoft world for more than about 3 minutes will be familiar with the old, faithful sample dataset created and published by...
2019-08-22
14 reads
Public and Demo Data Coming Soon!
Any database professional that has been around the Microsoft world for more than about 3 minutes will be familiar with the old, faithful sample dataset created and published by...
2019-08-22
32 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