Query Exercise: Looking for Email Addresses
“They put their password WHERE?!?” Personally identifiable information (PII) is freakin’ everywhere. When companies first start looking to identify and lock down their data, they think it’s going to be as easy as identifying com …
MySQL vs. PostgreSQL: Character Sets and Collations
This is part of a series of posts from Aisha Bukar comparing MySQL and PostgreSQL. You can see the entire series here. When working with strings in a database system, you need to ensure that the data is stored, sorted, and compared accurately. That’s w …
Free Webcast Tomorrow: Fundamentals of Query Tuning
It’s time for SQL Server Spring Training! I’m teaching 60-90 minutes of my most popular classes for free over the next few months. Tomorrow I’m doing Fundamentals of Query Tuning. It’s for folks who are comfortable writing queri …
Distractions
The second I wrote down the idea for a blog posts on Distractions, I knew there had to be two examples I would be using. A McCartney song, and another from the movie UP. In this movie there is a dog who can talk to people using a device he wears around …
Pitfalls to avoid while feeding events into CrowdStrike
Because it’s important to know when adversaries are scanning the network searching for vulnerabilities, misconfigurations, unpatched systems or default passwords; but it’s more important to know when adversaries have already compromised a system. Aggre …
Using SQL Server Stored Procedures with the Django ORM
There comes a time when the built-in ORM just isn’t enough. You might have complex queries or performance-critical operations that benefit from the power and efficiency of stored procedures. Stored procedures are precompiled SQL code that lives on your …
Data Streaming Databricks in Azure
The post Data Streaming Databricks in Azure appeared first on SQLServerCentral.
What’s Coming in SQL Server 2025, DMV Edition
As we approach the first public releases of SQL Server 2025, it’s fun to start spelunking through things Azure SQL DB has today – announced and unannounced – that aren’t yet present in the boxed product version of SQL Server. Mi …
Announcing Fundamentals Week 2025!
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 …
How I Achieved Scalability in a. Amazon RDS Shared DB Connection Environment
Overview Amazon RDS allows users to create multiple databases within a single database instance. And connections to each of these databases are shared across the DB instance. This setup can become a bottleneck when the number of connections per DB inst …
Free Webcast Tomorrow: Fundamentals of Index Tuning
It’s time for SQL Server Spring Training! I’m teaching 60-90 minutes of my most popular classes for free over the next few months. Tomorrow I’m doing Fundamentals of Index Tuning. It’s targeted at folks who don’t know how …
Deploy DACPAC to Azure SQL Database using Visual Studio
Deploying a DACPAC to an Azure SQL Database is a critical step in ensuring your database changes are effectively moved from development to production. This guide will walk you through the process of deploy DACPAC to Azure SQL database directly from Vis …
INFO.VIEW DAX Functions Usage and Examples
The post INFO.VIEW DAX Functions Usage and Examples appeared first on SQLServerCentral.
The State of the Database Landscape in 2025: Insights and trends
The post The State of the Database Landscape in 2025: Insights and trends appeared first on SQLServerCentral.
Scales & Measurements
if you’re going to work with databases, you probably ought to know something about data. In particular, we don’t put data directly into a database; we have to encode it and represent it in a format which a machine can handle. Encoding data existed long …