Single-cloud versus Multi-cloud
A discussion I have seen many companies have is if they should be single-cloud (using only one cloud company) or multi-cloud (using more than one cloud company). The three...
2021-08-26
1 reads
Blog Posts
Daily Coping 25 Aug 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-08-25
10 reads
Divide the rows in equals batches
Here is the simple and practical use case of NTILE function. We’ve used it to divide the rows of sys.columns into N batches. N is the batch size. We’ve...
2021-08-25 (first published: 2021-08-15)
2,064 reads
SSMS and SQLCMD: Prevent T-SQL Batch From Not Only Executing, but Also From Parsing (Cruel Joke #3)
(last updated: 2021-08-13 @ 19:50 ET / 2021-08-13 @ 23:50 UTC ) In a previous post, Prevent Full Script Execution (Understanding and Using PARSEONLY and NOEXEC), I explained how...
2021-08-25 (first published: 2021-08-13)
510 reads
Think twice about storing JSON in your SQL Server database
During routine maintenance on a customer’s production server, I discovered that they have one table consuming 40% of the storage in their database. That table contains just under 10...
2021-08-25
53 reads
Daily Coping 24 Aug 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-08-24
14 reads
Error: Cannot continue the execution because the session is in the kill state.
This was a rather interesting error. I’d certainly never seen it before, and based on one of the answers to ... Continue reading
2021-08-24
144 reads
Tackling security vulnerability at an early stage in SDLC
As a Software Engineer, I will like to detect security vulnerabilities early enough in my codebase before committing my code.
Detecting security vulnerability is very important in SDLC (Software Development Life...
2021-08-24
4 reads
Timeseries Analytics Capabilities, and Azure Data Explorer (ADX)
I've had a few recent conversations where customers/partners were encountering scale concerns in existing timeseries database applications hosted outside of Azure, and wished to explore the native services in...
2021-08-24
13 reads
Daily Coping 23 Aug 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-08-23
9 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
Pivot Help
Hi Guys I need help pivoting the following SELECT [ID],[code_name],,[retail_price] FROM products 1 |...
Writer methods in PowerQuery (LOL)
I'm using PowerQuery in Excel on my desktop. (Yeah, I know you can do...
Need help with GROUP BY...
Here's my data... I am trying to return total days in status for each...
Question of the Day
The Density Vector
When building statistics, there is the concept of density that refers to the duplicates in a table. How is this calculated?
See possible answers