Uniqueness, Keys, and Identity
If you’ve ever had a traditional logic course, you’ll have run into “The Law of Identity” as […]
Archives de l’année : 2024
What Did AI Ever Do for Me?
Let me start with a simple confession, and I hope it’s not too shocking for anyone; I’m […]
GitHub Desktop Tutorial
Introduction Previously, we created a tutorial to connect Visual Studio Code with GitHub. Now, we will show another […]
PostgreSQL Backups to Support Point In Time Recovery: Learning PostgreSQL ...
The focus of your backup strategy should not be backups. Instead, you should be focused on restoring […]
Using Containers to Avoid Installing SQL Server
I got a new laptop recently and instead of installing SQL Server, I decided to try and use […]
SQL ROUND Function vs. Bankers Rounding with T-SQL
The post SQL ROUND Function vs. Bankers Rounding with T-SQL appeared first on SQLServerCentral.
Storing and Retrieving the Initialization and Configuration Data for Applications
All developers hit the problem of how and where to store and set their configuration, profile, or […]
[Video] Office Hours Q&A: Abrupt Exit Edition
Last week, we had an abrupt intro, and this week, we have an abrupt ending when my camera […]
Microsoft Fabric and PySpark: Coding tricks to improve your solutions
PySpark has some unconventional syntaxes which provide power to the development process, making it easier. We talked […]
Continued feedback for SSMS 21
Hello SSMS users! A short post today to remind folks to check out the feedback site regularly. As […]
Geographic Sharding is Usually a Pretty Bad Idea.
Let’s say you built a web app and it became globally popular. You’ve got users scattered across North […]
I Must Be an Idiot: Automatic Tuning Never Works for ...
The post I Must Be an Idiot: Automatic Tuning Never Works for Me. appeared first on SQLServerCentral.
Hotfix: JDBC Driver 12.6.4 for SQL Server Released
We recently released an update to Microsoft JDBC Driver for SQL Server, version 12.6.4. The update addresses a […]
Who’s Hiring in the Microsoft Data Platform Community? September 2024 ...
Is your company hiring for a database position as of September 2024? Do you wanna work with the […]
Solving the Overlap Query Problem in PostgreSQL
Range queries are a very common task in SQL: selecting dates, numbers, or even text values that […]
How to Slice Data by Fiscal Month using DAX for ...
The post How to Slice Data by Fiscal Month using DAX for Power BI Reports appeared first on […]
Choosing Data Types and Column Options
An entire post on choosing the correct data types either seems like overkill or much needed and […]
Debugging T-SQL using Visual Studio
Hey folks – I’ve seen some comments and replies stating that folks cannot use the debugger with SSDT […]
MySQL Index Overviews: Composite B-Tree Indexes
Indexes in MySQL are one of the primary ways to enhance query performance and they are especially […]
Microsoft Fabric: Using Lakehouse data in Real Time Dashboards
The post Microsoft Fabric: Using Lakehouse data in Real Time Dashboards appeared first on SQLServerCentral.
Is it still worth it to sponsor PASS Summit?
The post Is it still worth it to sponsor PASS Summit? appeared first on SQLServerCentral.
[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 […]
Released: Microsoft.Data.SqlClient 4.0.6, 5.1.6, 5.2.2
We have released updates to multiple supported versions of Microsoft.Data.SqlClient. The updates address several issues. Microsoft.Data.SqlClient 4.0 […]
Released: Microsoft.Data.SqlClient 6.0 Preview 1
Microsoft.Data.SqlClient 6.0 Preview 1 has been released. This release contains improvements and updates to the Microsoft.Data.SqlClient data provider […]
Hotfix: JDBC Driver 12.8.1 for SQL Server Released
We recently released an update to Microsoft JDBC Driver for SQL Server, version 12.8.1. The update addresses a few […]
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 […]
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 […]
Bad Data and Dirty Databases
Many years ago, my wife and I wrote an article for Datamation, a major trade publication at […]
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 […]
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 […]
Big Northwind with AI
As part of my work with Redgate, I wanted to do some testing on our subsetting and masking […]
Announcement: System.Data.SqlClient package is now deprecated
We announced Microsoft.Data.SqlClient in the first half of 2019 and shipped the first stable package later that year. That release coincided with .NET […]
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 […]
SQL Local Variables and Performance Issues
The post SQL Local Variables and Performance Issues appeared first on SQLServerCentral.
Released: Microsoft.Data.SqlClient 3.1.7
We have released an update to Microsoft.Data.SqlClient, version 3.1.7. The update addresses several issues. Microsoft.Data.SqlClient 3.1 is […]
[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. […]
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 – […]
Introducing Schema Validation in MongoDB
This article is part of Robert Sheldon’s continuing series on Mongo DB. To see all of the […]
Auditing SQL Server – Part 3 – SQL Server Configuration ...
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 […]
Released: Microsoft.Data.SqlClient 3.1.6
We have released an update to Microsoft.Data.SqlClient, version 3.1.6. The update addresses several issues. Microsoft.Data.SqlClient 3.1 is […]
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 […]
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 […]
LIKE Constraints
In this article, I will cover a bit about the LIKE operator, including how it works, and […]
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 ...
AI is increasingly becoming part of everyday life across various domains. For the uninitiated, AI which stands for […]
PostgreSQL Partitioning: The Most Useful Feature You May Never Have ...
Partitioning in PostgreSQL was for many years a feature almost entirely ignored, and even today is often […]
10 tips for Test Data Management success
The post 10 tips for Test Data Management success appeared first on SQLServerCentral.