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.
A New and Improved Data Warehouse: Data Engineering with Fabric
Microsoft Fabric is their fourth version of a Data Warehouse. Back in September of 2008, Microsoft bought DATAllegro for its intellectual property. The first product was called SQL Server Parallel Data Warehouse which came with a purchase of both har …
Make Money Referring Folks to My Training!
YOU! Wanna make easy money? Black Friday is coming. Every November, we run a big sale on our training & apps. It’s a really big deal for us – and for you. I like to think of it as a reward for my long-term readers who can hold out, make …
Auditing SQL Server – Part 4 – Database Configuration Audit
This continues my series on auditing SQL Server. The fist parts covered discovery and documentation, server level hardware audits and SQL Server engine level audits. This section examines database configuration audits. As with the previous audit sectio …
LIKE Constraints
In this article, I will cover a bit about the LIKE operator, including how it works, and a bit of history about why it is like it is. After establishing this, I will discuss a bit about how you can (and should) use the LIKE operator in your CHECK const …
Reduce SQL Server Blocking with READ_COMMITTED_SNAPSHOT
The post Reduce SQL Server Blocking with READ_COMMITTED_SNAPSHOT appeared first on SQLServerCentral.
Data Prediction with SQL Server Machine Learning Services, Python, and Linear Regression
AI is increasingly becoming part of everyday life across various domains. For the uninitiated, AI which stands for Artificial Intelligence, is a branch of computer science that explores the process of building intelligent machines that can perform cogn …
PostgreSQL Partitioning: The Most Useful Feature You May Never Have Used
Partitioning in PostgreSQL was for many years a feature almost entirely ignored, and even today is often thought of only as a means to increase performance on large tables. While it’s certainly useful for this, it’s also an invaluable tool …