[Video] Office Hours: Waiting for the Hot Tub to Fill
While waiting for my Husavik hot tub to fill up, I took your top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 01:28 1440×1080: always on with 2 nodes 1db, readable secondary. I’ve optimized …
T-SQL Has Regex. Don’t Get Too Excited.
Regular expressions are a way of doing complex string searches. They can be really useful, but they have a reputation: they’re hard to write, hard to read, and they’re even harder to troubleshoot. Once you master ’em, though, they com …
Understanding SQL Server LEFT_SHIFT and RIGHT_SHIFT Functions
Introduction SQL Server 2022 introduced the LEFT_SHIFT and RIGHT_SHIFT functions, which allow you to manipulate numbers by shifting their binary digits either to the left or right. These functions are part of bitwise operations, which directly operate …
AI Tools for Job Seekers – Salary
The post AI Tools for Job Seekers – Salary appeared first on SQLServerCentral.
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 …