Dynamic T-SQL Script Parameterization Using Python
When working with SQL Server, there are times when you need to build SQL scripts dynamically. In many cases, the logic behind your query depends on variables that aren’t known until runtime. Building these scripts in Python gives you flexibility, but y …
Fabric Analytics for SQL folks: Part 1 – Fabric demystified
Summary In a landscape abundant with AI innovations and promises, a crucial question arises: « Is leveraging SQL and structured data genuinely beneficial for your business in today’s environment? » SQL and structured data have been pivotal in shaping con …
MySQL vs PostgreSQL – String Datatypes
A very common task in creating a database is to store string data. For example, words, paragraph(s) or even documents. String data types allow you to do just that and store and represent text. They handle everything from simple names and addresses to c …
[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 …