PASS Summit: Planting Seeds of Knowledge
On the eve of this year’s PASS Summit, I find myself reflecting on my first Summit in 2012. My employer was generous enough to pay for not only Summit...
2018-11-04
20 reads
SMO "leaks" SQL login passwords (in memory) and (some) SecureStrings in clear-text
Updated 2018-11-04: Expanded test code, renamed the
title of the post so it's clearer.
SMO (SQL Server Management Objects) are the .NET...
2018-11-03
768 reads
How I Work: Data Professionals at Work
It has been a busy year so far. Last March, I did a review, as a Technical Reviewer, for a...
2018-11-02
311 reads
Watch: The single question to predict success for DevOps (31 minutes)
What if you could assess the performance level of your team by asking one simple question? In his recent webinar with Redgate, Gene Kim (@realgenekim) suggests that you can....
2018-11-02
32 reads
Register for my upcoming session on digital transformation
I’m excited to have a session accepted to GroupBy, a free online conference targeting the Microsoft data platform community. The conference is sponsored by Brent Ozar Unlimited, and sessions...
2018-11-02
28 reads
Adding SQL Search to Azure Data Studio
There are a limited number of extensions available for Azure Data Studio (ADS), but one that came out early is...
2018-11-16 (first published: 2018-11-02)
1,905 reads
The No-Election PASS Election
I was disheartened to read the post that shows we have three candidates for three positions this year. Started with...
2018-11-02
342 reads
Moving a Google Form Between Google Domains
If you are anything like me, you might have a few different Google accounts that you work with on a...
2018-11-01
63 reads
Reading execution plan sql server use of Plan Explorer
AdvertisementsPlan Explorer
I recently started using this. Since it was licensed earlier, now it’s free. This is an awesome tool for...
2018-11-01
2,786 reads
Azure SQL Database – Who Changed My Auto Tuning Settings?
One of the features Microsoft wants us to use for Azure SQL Database is Automatic Tuning. Automatic Tuning is a...
2018-11-01
296 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