Intro to AKS – Azure Kubernetes Service
What is Azure Kubernetes Service? Probably makes sense to tell you what Kubernetes is first. As Kubernetes states themselves “also known as K8s, is an open-source system for automating...
2021-07-21
57 reads
Blog Posts
Join me at the EightKB virtual conference on 28 July 2021
Next week on Wednesday 28 July 2021, I will be presenting a brand-new session titled “How SQL Server stores that data type” for the free EightKB virtual conference. I’ve...
2021-07-21
15 reads
Scale your SQL Server MDF database data files
Do you have quite large MDF files on your database? By large, I mean hundreds of gigabytes (or larger). Have you ever noticed that your SQL Server disk stall...
2021-07-21 (first published: 2021-07-08)
667 reads
Daily Coping 20 Jul 2021
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-07-20
9 reads
Experiment: If I have Dynamic Data Masking enabled will BCP pull the non masked data.
Hypothesis: If I have Dynamic Data Masking enabled on a column then when I use something like BCP to pull ... Continue reading
2021-07-20
8 reads
Microsoft Data Platform Continuity VG Presentation – July 2021
I’m pleased to announce that this month’s presentation for the Microsoft Data Platform Continuity Virtual Group will be on July 29th at 2pm Eastern time. This presentation from Edwin...
2021-07-20
6 reads
WordPress.com Managed Hosting Webinar with Rudy Faile, Automattic Systems
Learn how WordPress.com's managed hosting powers fast, secure websites.
2021-07-20
11 reads
Add DBCC INPUTBUFFER to Your Performance Tuning Toolbox
A command I like to use when performance tuning is DBCC INPUTBUFFER. If you have ever run sp_whoisactive or sp_who2 to find out what sessions are executing when CPU...
2021-07-19 (first published: 2021-07-07)
844 reads
Daily Coping 19 Jul 2021
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-07-19
23 reads
Filtering Extended Events Using Actions
Did you know, you can use Actions to Filter Extended Events? Well, you can. Filtering is one of the greatest ways in which Extended Events differentiates itself from other...
2021-07-19
2 reads
Blogs
Spark Connect Dotnet November 2024 Where are we?
By Ed Elliott
All Spark Connect Posts Introduction There have been quite a few changes in the last...
A New Word: Ochisia
By Steve Jones
ochisia – n. the fear that the role you once occupied in someone’s life...
Create a Numbers Table in Power Query
This is a quick blog post, mainly so I have the code available if...
Forums
Issue with DBMail
Hi all We've got 3 servers with the same setup for dbmail. They...
Counting values with hysteresis in Report Builder
Hi, I have a set of data (for instance sine wave) and I need...
Export Data-tier Application vs Generate Script: Why Does SQL Server Have Both?
Hey everyone, SQL Server has two mechanisms for deploying and moving a database to...
Question of the Day
What's the Ceiling?
What do I get as the results from this code?
SELECT CEILING (999.999), CEILING (-999.999);See possible answers