Dipping into the Cookie Jar
This post is a response to this month's T-SQL Tuesday #112 prompt by Shane O'Neill. T-SQL Tuesday is a way for the SQL Server community to share ideas about different database and...
2019-03-12
13 reads
Dipping into the Cookie Jar
This post is a response to this month's T-SQL Tuesday #112 prompt by Shane O'Neill. T-SQL Tuesday is a way for the SQL Server community to share ideas about different database and...
2019-03-12
13 reads
Using Kubernetes Deployments for Updating SQL Server
In Kubernetes we can leverage Controllers to help manage our application state, keeping them in the desired state. In this blog post, we’re going to look at how to...
2019-03-12
18 reads
Using Kubernetes Deployments for Updating SQL Server
In Kubernetes we can leverage Controllers to help manage our application state, keeping them in the desired state. In this...
2019-03-26 (first published: 2019-03-12)
858 reads
T-SQL Tuesday Sharing Cookies
It has been a while since I have participated in a T-SQL Tuesday but I felt the urge to do...
2019-03-12
461 reads
T-SQL Tuesday #112 - The Cookie Jar
This month’s T-SQL Tuesday comes from Shane O’Neill (blog | twitter). He starts us off with this:
Dipping into the Cookie Jar is about when the going gets tough and...
2019-03-12
25 reads
Fix For Using Azure Active Directory to Connect to SQL
Hello! The other day someone was kind enough to get in touch with me to thank me for some post I wrote back last year. For the sake of...
2019-03-12
53 reads
WIT Panel for Women’s History Month
I cannot write this without stating some history. I have been part of PASS community since 1999. That is 21...
2019-03-11
227 reads
Weekly reading #6
Coding Family is late this week with the blog post! It is due to heavy storms and wind! It started...
2019-03-11
242 reads
Scalar UDF Inlining in SQL Server 2019 – Simpler functions
Scalar UDF Inlining, introduced in SQL Server 2019, promises to improve the performance of Scalar UDFs. Let's look into the performance gains this offers.
The post Scalar UDF Inlining in...
2019-03-11
28 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