SQL ConstantCare® Population Report: Fall 2023
The short story for this quarter: SQL Server 2019 is on fire, dominating the market. For the long story: ever wonder how fast people are adopting new versions of SQL Server, or what’s “normal” out there for SQL Server adoption rates? …
What I Wish Everyone Knew About ETL Processes – Traditional to Modern Cloud Solutions
The post What I Wish Everyone Knew About ETL Processes – Traditional to Modern Cloud Solutions appeared first on SQLServerCentral.
Designing Databases for Distributed Systems
The post Designing Databases for Distributed Systems appeared first on SQLServerCentral.
Who’s Hiring in the Microsoft Data Platform Community? October 2023 Edition
Is your company hiring for a database position as of October 2023? Do you wanna work with the kinds of people who read this blog? Let’s set up some rapid networking here. If your company is hiring, leave a comment. The rules: Your comment must in …
Fundamentals Week is Coming. Every Day, the Price Goes Up.
You’ve attended some of my free online streams, read my blog posts, and you use the First Responder Kit. You enjoy my laid-back, humorous approach to sharing what I’ve learned over the years. You love live classes. You’ve tried watchi …
Don’t use DISTINCT as a “join-fixer”
I’ve quietly resolved performance issues by re-writing slow queries to avoid DISTINCT. Often, the DISTINCT is there only to serve as a “join-fixer,” and I can explain what that means using an example. Let’s say we have the follo …
Explore Natively Compiled SQL Server Stored Procedure Execution Plans
The post Explore Natively Compiled SQL Server Stored Procedure Execution Plans appeared first on SQLServerCentral.
GIT Configuration and Automated Release for Azure Data Factory
Introduction Azure Data Factory resources including pipelines, datasets, linked services, etc. should be maintained in a version control system. Also, the changes implemented in the Data Factory in Development Environment need to be deployed in higher …
What Is Good Database Design?
The post What Is Good Database Design? appeared first on SQLServerCentral.
SQL Server Security Primer
SQL Server security structure, mechanisms and methods are very thoroughly documented in the Microsoft documentation, but it is quite daunting if you don’t already know about the functionality. I recently had a request to explain some security fea …
The SQL Developer Experience: Beyond RDBMS
SQL Server has always empowered developers through a wide variety of drivers, the robust T-SQL language, and an industry proven database engine with security, performance, and availability. Some developers though are not aware of the SQL Server and Azu …
Integrating Python with MongoDB
Introduction MongoDB has gained significant popularity as a NoSQL database solution due to its flexibility, scalability, and document-oriented nature. Python, on the other hand, is a versatile programming language known for its ease of use and rich eco …
New Microsoft Sandbox Uses Natural Language LLMs for SQL Queries
The post New Microsoft Sandbox Uses Natural Language LLMs for SQL Queries appeared first on SQLServerCentral.
A Beginners Guide To MySQL Replication Part 6: Security Considerations in MySQL Replication
This article is part of Aisha Bukar’s 6 part series: A Beginners Guide to MySQL Replication. The entries include: Part 1: Introduction to MySQL Replication Part 2: Configuring Source and Replicas Part 3: Multi-Source Replication Part 4: Using GTID Base …
[Video] Office Hours with a Surprise Special Guest
I have a special guest star on today’s episode: Pinal Dave dropped by the house! We went through a few of the top-voted questions from https://pollgab.com/room/brento. 00:00 Start 00:15 What happened to you? Did you spend too much time in the sun …