[Video] Office Hours: I Don’t Have All the Answers
When I went through the top-voted questions at https://pollgab.com/room/brento, I didn’t have all the answers today: Here’s what we covered: 00:00 Start 00:48 MyTeaGotCold: I increased my RAM from 16 GB to 32 GB and my buffer pool has grown …
Join Me in Seattle for Watch Brent Tune a Query in SQL Server 2022
The PASS Data Community Summit session lineup for Nov 4-8 in Seattle was just announced, and I’ve been selected for a general session! Watch Brent Tune a Query in SQL Server 2022: Ever wonder how somebody else does it? In this all-demo session, w …
Control OneLake with Storage Explorer – Data Engineering with Fabric
OneLake Storage What is a Lakehouse in Azure Fabric? Borrowing a quote from MS Learn – « Microsoft Fabric Lakehouse is a data architecture platform for storing, managing, and analyzing structured and unstructured data in a single location ». I think of i …
The SQL Language is Just a Hurdle You Gotta Overcome.
I’m not talking just about Microsoft SQL Server specifically here, nor T-SQL. Let’s zoom out a little and think bigger picture for a second: is the SQL language itself a problem? Sometimes when I talk to client developers, they gripe about …
Deleting Documents from a MongoDB Collection
This article is part of Robert Sheldon’s continuing series on Mongo DB. To see all of the items in the series, click here. So far in this series, we’ve looked at different ways that you can add, retrieve, and update documents in a MongoDB collect …
How to Rename a Column in SQL Server
Recently, I was working on a project to analyze the schema of a third-party vendor. In our organization, we had an internal support ticket management tool. The tool used an SQL database, and after considering the cost of the tool, we decided not to ren …
XML Performance Tuning and Added Options
SQL Server provides a variety of ways to tune XML so that it provides consistent performance, consumes less space, all while ensuring efficient access to critical data. At its core, the metadata-styled XML format runs counter to the data that SQL Serve …
How I Used PostgreSQL RLS To Avoid Code Changes During a Migration
Overview Our application is a microservice that stores metadata for actual data and is backed by Amazon Postgres RDS. It is deployed in a multi-tenant/multi-region/multi-cell environment. The Gateway handles the multi-region aspect of the system. That …
[Video] Office Hours: Database Answers from a Hotel Room
I went through your top-voted questions from https://pollgab.com/room/brento before heading out to PGConf.dev in Vancouver. Here’s what we covered: 00:00 Start 01:43 Poul J: Hi Brent. Can you give some examples of how a CHECK() constraint is used …
Query Exercise Answer: Beating ChatGPT at Finding Good Question Times
For this week’s Query Exercise, I asked you to write a better query than ChatGPT wrote. Your goal was to find the best days and times to post questions on Stack Overflow. I found it interesting that a lot of the initial answers focused on the tim …
SQL Server TRY CATCH, RAISERROR and THROW for Error Handling
The post SQL Server TRY CATCH, RAISERROR and THROW for Error Handling appeared first on SQLServerCentral.
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 …