Running SQL Server 2019 CTP in a Docker container
If you’ve been anywhere near social media this week you may have seen that Microsoft has announced SQL Server 2019.
I...
2018-10-04 (first published: 2018-09-25)
4,441 reads
Where Are Your Data Leaks?
It has been almost impossible to avoid reading about the numerous large-scale data breaches reported on a seemingly daily basis....
2018-10-02 (first published: 2018-09-25)
1,961 reads
Shortchanged with International Money in SQL Server
Imagine you have to perform some salary analysis for your employer International Mega Corp.
The data you have to work with...
2018-10-03 (first published: 2018-09-25)
1,753 reads
Shortchanged with International Money in SQL Server
Watch this week's video on YouTube
Imagine you have to perform some salary analysis for your employer International Mega Corp.
The data you have to work with looks something like this:
DROP...
2018-09-25
17 reads
Shortchanged with International Money in SQL Server
Watch this week's video on YouTube
Imagine you have to perform some salary analysis for your employer International Mega Corp.
The data you have to work with looks something like this:
DROP...
2018-09-25
15 reads
Table Variable Performance “Fixed” in SQL 2019
Reading the new features for SQL 2019 I spotted this:
One of the most popular posts on my blog last year...
2018-10-03 (first published: 2018-09-25)
2,560 reads
Notes from the September 2018 SQLOrlando Meetup
Notes:
30 registered, 11 attended. No weather or traffic issues. Same as the last meeting we did not send a day...
2018-09-25
272 reads
Query Store Best Practice and Configuration
In my previous blog post I have talked about What is the Query Store and How to setup the Query Store. In this blog post today, I will explain...
2018-09-25
84 reads
SOS to ADS
When Microsoft announced SQL Operations Studio last year, I wasn’t thrilled. The move to a VS Code shell was less...
2018-10-05 (first published: 2018-09-24)
2,478 reads
Where to watch Ignite
In case you aren’t familiar with #MSIgnite, it’s a huge event where Microsoft debuts all the new shiny software that...
2018-09-24
275 reads
Blogs
Why AI isn’t paying off yet, and what to invest in first
Why isn’t AI paying off yet? Drawing on lessons from digital transformation, Joyful Craftsmen...
Flyway Tips: Analytics Platforms (Snowflake and Databricks)
By Steve Jones
I’m really excited about some growth in Flyway support. I’ve been asking about this...
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,...
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