SQL Server Data Collection and Management Data Warehouse
We all have the need to collect system and performance information regarding our SQL Servers. Some of us use third-party...
2018-10-17 (first published: 2018-10-03)
3,540 reads
Azure SQL Database Managed Instance
As of October 2018, Azure SQL Database Managed Instance is now generally available in the general purpose tier. Business Critical...
2018-10-03
71 reads
Generate a random number of children for each parent
I was asked an interesting question the other day.
Is it possible to get a different random number of rows...
2018-10-17 (first published: 2018-10-03)
2,069 reads
Query to determine XE Session status
On a previous post, we discussed what is an extended event (XE) and how to create one.
With the following T-SQL...
2018-10-03
293 reads
how to embed a PowerBI report into HTML code
PowerBI is a powerful reporting solution for Business Intelligence for analytical reports, it is not meant to replace SSRS, the...
2018-10-16 (first published: 2018-10-03)
3,024 reads
Data Factory V2 Activity Dependencies are a Logical AND
Azure Data Factory V2 allows developers to branch and chain activities together in a pipeline. We define dependencies between activities as...
2018-10-16 (first published: 2018-10-03)
1,867 reads
Why Wont SQL Server Use My Filtered Index?
As with most of my posts of late all examples here are using the StackOverflow SQL Server database that can...
2018-10-02
249 reads
Why Wont SQL Server Use My Filtered Index?
As with most of my posts of late all examples here are using the StackOverflow SQL Server database that can...
2018-10-02
130 reads
Checking for Membership of a Specific Active Directory Group
As part of my job I manage a bunch of SQL instances for Development and Test.
Access is managed though Active...
2018-10-15 (first published: 2018-10-02)
2,354 reads
Go Green with Blue Using Azure
Is your company working on ways to become more environmentally friendly? Taking care of the environment is an important topic,...
2018-10-02
227 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