[Video] Office Hours: Abrupt Intro Edition
Today’s Office Hours had a ton of technical difficulties because it was my first live stream on both Twitch and TikTok. The first few minutes were cut off, and you can’t see the questions onscreen. Nonetheless, there are good answers in her …
The Big IT Outage: Where are we going?
As you all know about, just a few weeks ago we had the big CrowdStrike global IT outage. Some lucky IT guys like me had it in double: Microsoft was also suffered an outage in North Europe on the same week. I have worked in IT for more years than I can …
Query Exercise Answers: Solving the 201 Buckets Problem
In this week’s Query Exercise challenge, I explained SQL Server’s 201 buckets problem. SQL Server’s statistics only handle up to ~201 outliers, which means that outliers ~202-300 get wildly inaccurate estimates. In our example, I had …
Bad Data and Dirty Databases
Many years ago, my wife and I wrote an article for Datamation, a major trade publication at the time, under the title, “Don’t Warehouse Dirty Data!” It’s been referenced quite a few times over the decades but is nowhere to be found using Google these d …
Microsoft Fabric Warehouse Security: Object-Level, Column-Level and Row-Level
The post Microsoft Fabric Warehouse Security: Object-Level, Column-Level and Row-Level appeared first on SQLServerCentral.
Is your DevOps strategy missing a vital link?
The post Is your DevOps strategy missing a vital link? appeared first on SQLServerCentral.
About Half Of You Don’t Have Your Databases Under Control.
I ran a poll over on LinkedIn to find out if people have 100% of their databases under some kind of source control or version control. I broke the answers up into two sets, developers and non-developers, because I had a hunch that the developers’ …
EsProc SPL and SQL, Complimentary , But Different Technologies
Have you ever surfed the internet and felt overwhelmed by personalized advertisements that appear to know your every desire? Have you ever been amazed at how accurate some weather forecasts can be? These actions are based on data processing. EsProc SPL …
Big Northwind with AI
As part of my work with Redgate, I wanted to do some testing on our subsetting and masking tools. Subsetting needs a big data set, and while Stack Overflow is big, it’s kind of simple. I wanted something a little different. Since our engineers use Nort …
Effective Strategies for Storing and Parsing JSON in SQL Server
Like XML, JSON is an open standard storage format for data, metadata, parameters, or other unstructured or semi-structured data. Because of its heavy usage in applications today, it inevitably will make its way into databases where it will need to be s …
SQL Local Variables and Performance Issues
The post SQL Local Variables and Performance Issues appeared first on SQLServerCentral.
[Video] Office Hours: Professional Development Q&A
I was supposed to be on a flight to Mexico, but had to cancel at the last minute. While waiting for my favorite bagel shop to open, I went through your professional development questions from https://pollgab.com/room/brento. Here’s what we covere …
Query Exercise: Solving The 201 Buckets Problem
When you run a query, SQL Server needs to estimate the number of matching rows it’ll find – so that it can decide which indexes to use, whether to go parallel, how much memory to grant, and more. For example, take any Stack Overflow databas …
Introducing Schema Validation in MongoDB
This article is part of Robert Sheldon’s continuing series on Mongo DB. To see all of the items in the series, click here. Similar to other NoSQL database systems, MongoDB is known for its flexible and variable schema models, unlike relational database …
Auditing SQL Server – Part 3 – SQL Server Configuration Audit
The post Auditing SQL Server – Part 3 – SQL Server Configuration Audit appeared first on SQLServerCentral.