Fabric: Query a SQL Endpoint from a Notebook
Let’s analyse why we would like to query an SQL Endpoint. Once we understand why, we can dig into how to make a query to a SQL Endpoint. We use notebooks to connect directly to lakehouse. Except by the T-SQL notebook, the notebooks have a default …
Query Exercise Answer: Finding Email Addresses
For this week’s Query Exercise, your mission had two parts: Do a first pass search through the Users table looking for columns where people had snuck in email addresses where they didn’t belong Write a more high-quality query to identify ex …
Improving the Performance of UPDATE Statements in SQL Server
Introduction Performing bulk updates in SQL Server can be a resource-intensive operation, particularly when dealing with large datasets. The efficiency of such operations is influenced by various factors, including batch size, disk I/O, memory usage, C …
The Wide World of GiST Indexes
In Parts I (Solving the Overlap Query Problem in PostgreSQL) and II (Overlapping Ranges in Subsets in PostgreSQL) of this series, we used the GiST index type – and its lesser known cousin: SP-GiST – to turbocharge the performance of overlap queries. …
Why Your Azure SQL DB Hyperscale Bill is Higher Than You’d Expect
tl;dr: if you use Azure SQL DB Hyperscale’s auto-scaling, it’s probably not cutting your bill down because like SQL Server, Hyperscale doesn’t automatically relinquish memory, and it’ll be up to you to manually manage your own m …
SQL Server JSON Functions JSON_OBJECTAGG and JSON_ARRAYAGG
The post SQL Server JSON Functions JSON_OBJECTAGG and JSON_ARRAYAGG appeared first on SQLServerCentral.
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 …