The Curious Case of… missing 832 errors during memory corruption
(The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can sometimes be more frequent. It covers something interesting one of us encountered when working with a client, doing some t …
The Black Friday Sale is Here: Save Big on Training & Apps
My Annual Black Friday Sale is On! I’m running a giant Black Friday sale on my training courses! You can choose from Fundamentals, Mastering, or both. The Fundamentals package is best if you’ve never been to a formal SQL Server training cla …
The Real Problem with SQL Server’s Licensing Costs
At least once a month, a client has The Postgres Conversation™ with me. It happens at the end of a consulting engagement, after we’ve talked about the work that the team needs to do in order to meet their performance objectives. A manager who …
Getting Started with MongoDB
MongoDB is a scalable database management system that stores data as documents in a collection, rather than as rows in a table, such as you’d find in a relational database system. A document is an object made up of one or more field and value pai …
It’s Probably Time to Upgrade Your Cloud VMs
The post It’s Probably Time to Upgrade Your Cloud VMs appeared first on SQLServerCentral.
Azure Data Studio – A First Look
Introduction Azure Data Studio is the next iteration in Microsoft’s development of a cross-platform client tool for developing code and managing databases on-premises and in the cloud. Azure Data Studio was originally released in preview mode as SQL Op …
Security in the cloud: Whose responsibility is it?
The post Security in the cloud: Whose responsibility is it? appeared first on SQLServerCentral.
An editor’s biggest headache: Plagiarism
As an editor working with other people’s technical writing for many years, you might guess that either language skills or technical abilities would be the largest issue that you deal with. Both of these provide plenty of challenges, but the bigge …
Office Hours: “Read This” Edition
Sometimes when people post questions at https://pollgab.com/room/brento, the answer is just a link, nothing more, nothing less. It doesn’t make sense for me to rehash something that’s been covered really well online, and I want to link …
Is your organization using MongoDB? Help the Redgate Flyway team understand your pain points
The post Is your organization using MongoDB? Help the Redgate Flyway team understand your pain points appeared first on SQLServerCentral.
The PASS Data Community Summit First Timer Guide
Edwin Sarmiento has been producing a first-timer’s guide for the PASS Data Community Summit since 2016. He has updated this for 2023 and you can see Edward’s announcement of the guide on Twitter here. Download the guide and you’ll find some amazing inf …
Time-Series Data Analysis with Apache Druid
In the era of data-driven decision-making, the ability to efficiently analyze and derive insights from time-series data is of paramount importance. Apache Druid, a cutting-edge open-source data store and analytics platform, has emerged as a compelling …
[Video] Office Hours: Having a Bad Day Edition
The first day back after a long vacation is always rough, and today’s no exception. I took your questions from https://pollgab.com/room/brento in an effort to turn things around and get back in the groove: Here’s what we covered: 00: …
The NTILE Function
The SQL NTILE() is a window function that allows you to break a table into a specified number of approximately equal groups, or <bucket count>. For each row in a grouping, the NTILE() function assigns a bucket number representing the group to whi …
Fabric Data Warehouse News you need to know
Microsoft Fabric, including the Data Warehouse, evolves faster than we can analyze and write about it. Here I’m summarizing the most recent news I looked at. Clone Table We have a specific statement to clone a table. But what exactly does it mean …