Unzipping Word Documents in T-SQL
In the databases I am currently working with, there are some tables containing Word documents stored as binaries and I was wondering if it would be possible to perform some server-side processing on these documents. Modern Word documents (.docx) are no …
Join Me in San Diego for SQL Saturday!
I’m coming to San Diego on Sept 13-14 for SQL Saturday San Diego! I’m teaching a one-day pre-conference workshop on Friday, September 13th. Tuning Databases In One Day – You’ve got production databases in SQL Server or Azure SQL …
Working with SQL Server in Visual Studio Code
Introduction Visual Studio Code (VSCode) is a free and light source code editor created by Microsoft. It can be installed in Windows, macOS, or Linux. Note that Visual Studio is not the same as Visual Studio Code. Visual Studio Code is a light software …
Fine-grained Access Control for Stored Procedures
Synopsis Modern relational databases have comprehensive security mechanisms to enforce fine-grained access control for tables and views. But when it comes to stored procedures, access control is rudimentary: either you can execute a stored procedure, o …
Power BI Treemap Chart Step-by-Step Tutorial
The post Power BI Treemap Chart Step-by-Step Tutorial appeared first on SQLServerCentral.
[Video] Creepy Office Hours in Vancouver
While in a hotel room in Vancouver for PGconf.dev, I strapped on my Apple Vision Pro headset to take your top-voted questions from https://pollgab.com/room/brento. Somehow, the latest Vision OS update gave me a 1980s 3rd Bass haircut. Here’s what …
Query Exercise: Beat ChatGPT at Finding Good Question Times
What are the best days of the week and times of the day to post a question at StackOverflow.com? It seems like a simple question, but it’s surprisingly nuanced. I asked ChatGPT’s latest version, 4o, and its answer made me laugh out loud. Fi …
Memory Grant Feedback Persistence in SQL Server 2022
As a SQL Server DBA, effectively controlling memory allocations is essential to guaranteeing optimal query performance. In SQL Server 2022, Microsoft enhanced a powerful feature called Memory Grant Feedback Persistence, which allows SQL Server to bette …
PostgreSQL is Now Faster than Pinecone, 75% Cheaper, with New Open Source Extensions
NEW YORK – June 11, 2024 – Timescale, the PostgreSQL cloud database company, has unveiled two groundbreaking open-source extensions, pgvectorscale and pgai, which significantly enhance PostgreSQL’s scalability and ease of use for AI applications. Licen …
There’s a 6-Month Statute of Limitations on “The Last Person.”
“The last person must have set it up that way.” “The last person wrote that code.” “The last person just didn’t configure it right.” You can use that excuse for 6 months. For six months, you’re allowed to …
Choosing Between the Lakehouse and Warehouse in Microsoft Fabric
Microsoft Fabric is a new centralized, AI-powered cloud data platform hosted by Microsoft. It combines several services of the existing Azure Data Platform – such as Azure Data Factory – with Power BI, while also introducing new services. I …
Concepts and Issues in Test Data Generation
Data generation is the science and art of providing data for database development work that is as realistic and controllable as possible. The skills of generating realistic data are an essential part of being a database developer. It is important: you …
How to Sort String Date Values on a Power BI Slicer Visual
The post How to Sort String Date Values on a Power BI Slicer Visual appeared first on SQLServerCentral.
How to Set Up Microsoft Fabric Database Mirroring for Azure Cosmos DB
Microsoft Fabric is a new centralized, SaaS data analytics platform which has been generally available since November 2023. It offers different types of analytical workloads, such as batch processing with Spark (in either a lakehouse or a warehouse) or …
Identify Tables With Dropped Columns
In my last article – What happens when we drop a column on a SQL Server table? Where’s my space? – I have shown what happens when we drop a column from a table. Today, we are going to check if we have a way to find tables with dropped columns. Why? As …