Identity Gaps–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2019-01-04 (first published: 2018-12-26)
2,309 reads
Upgrading From SQL Server Profiler
How to correlate all of your favorite trace/profiler options into the shiny new XE equivalents.
As luck would have it, there is a means to correlate trace/profiler events to Extended...
2018-12-26
14 reads
Upgrading From SQL Server Profiler
I just shared an article describing how to use Extended Events to perform your SQL Server Profiler duties. If not,...
2018-12-26
1,040 reads
How To: XEvents as Profiler
Despite the controls in place there always seems to be some change that is unknown or even some cowboy that makes changes as s/he sees fit and forgets to...
2018-12-25
24 reads
How To: XEvents as Profiler
A common excuse for not delving into extended events seems to be the jump from Profiler to extended events. There...
2018-12-25
780 reads
Merry Christmas
Wish you all a Merry Christmas and may this festival bring abundant joy and happiness in your life!
From
Technology with Vivek Johari
2018-12-24
39 reads
Merry Christmas
Wish you all a Merry Christmasand may this festival bring abundant joy and happiness in your life!
From Technology with Vivek Johari
2018-12-24
184 reads
2018 Advent of Code–Day 1
I enjoy when the Avent of Code comes around each year. I seem to make this a December (or sometimes...
2018-12-24
331 reads
Running Windows and Linux SQL Containers together
Just for fun I decided to spend Christmas Eve getting Windows and Linux SQL containers running together.
WARNING
This is NOT a...
2019-01-04 (first published: 2018-12-24)
1,900 reads
Quick and Easy XE for Azure DB
This is a very simple introduction into the creation of an Extended Event session using a template for Azure SQL DB. I demonstrate the use of the GUI to...
2018-12-24
28 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