No More Mysterious Truncation
If you read the Microsoft White Paper on SQL Server 2019, there’s a gem buried on page 17. It mentions...
2018-10-09 (first published: 2018-09-26)
3,374 reads
My Experiences Tech Editing Pro SQL Server on Linux
The Opportunity Earlier this year I received an email from Jonathan Gennick, an editor at Apress books. The subject of the email was “Tech edit a book” and he...
2018-09-26
20 reads
My Experiences Tech Editing Pro SQL Server on Linux
The Opportunity
Earlier this year I received an email from Jonathan Gennick, an editor at Apress books. The subject of the...
2018-09-26
287 reads
Data Types Word Search
Just for fun here is a word search with all of the data types available in SQL Server. Well, two...
2018-10-05 (first published: 2018-09-26)
1,843 reads
Cycle SQL Server Error Logs
I saw this again recently and see it too often in environments so wanted to take a second to remind...
2018-10-04 (first published: 2018-09-26)
2,746 reads
Coming Soon to Minnesota...Lincoln...and Seattle!!!
It's that time of year when SQLSaturdays start to slow down (in the U.S. anyway) as we march towards Summit...
2018-09-26
341 reads
Why you should always build an Azure based VM in a Resource Group
This blog post is based on conversations I witnessed between MVPs around commissioning and more importantly de-commissioning virtual machines (VMs)...
2018-09-26
769 reads
Extended Events Made Easy: Using XEvent Profiler
In this post we’ll look at how quick and easy it is to use the XEvent Profiler to create an...
2018-10-08 (first published: 2018-09-25)
6,156 reads
Azure Cognitive Services – Knowledge APIs
This week’s Azure Every Day posts are focused on the different APIs available within Azure Cognitive Services. Today I’ll focus...
2018-09-25
191 reads
Practical Refactoring
Today I hosted a webinar with Gene Kim (@RealGeneKim) and we had a fantastic discussion. I was slightly star struck...
2018-09-25
254 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