Upgrade SQL Server on your workstation
Lately, I’ve seen many people struggling to upgrade their workstation to the latest version of SQL Server. The main source of the problem is usually the web installer/wrapper, which can fail for a variety of reasons that aren’t always made …
[Video] Office Hours: Hot Tub Edition
Today’s Office Hours comes from a very different office! I climbed into the hot tub to review your top-voted questions from https://pollgab.com/room/brento. Don’t worry, the webcast is completely safe for work. Here’s what we covered: …
What Every DBA Should Know about Always On Readable Secondaries
This article aims to demonstrate the lesser-known impact of Always On Readable secondaries. In this article, we will not be going into how readable secondaries are configured and how read-only connections are directed to readable secondaries. Instead, …
Redgate Summit: The Database Landscape
The post Redgate Summit: The Database Landscape appeared first on SQLServerCentral.
Query Exercise: Find Recent Superstars
For this week’s Query Exercise, we’re working with the Stack Overflow database, and our business users have asked us to find the new superstars. They’re looking for the top 1000 users who were created in the last 90 days, who have a r …
Finding Long Values Faster: Answers & Discussion
In last week’s Query Exercise, our developers had a query that wasn’t going as fast as they’d like:CREATE INDEX DisplayName ON dbo.Users(DisplayName); GO SELECT * FROM dbo.Users WHERE LEN(DisplayName) > 35; The query had an index, …
Dynamically Create Tables in Power BI with DAX Functions
The post Dynamically Create Tables in Power BI with DAX Functions appeared first on SQLServerCentral.
Forget the Models, Your Data is the Secret Sauce for Generative AI
Credit: Image generated by Google Bard Generative AI (GenAI) models like GPT, Gemini, PaLM, DALL-E, and others offer businesses powerful text generation, image creation, and language translation capabilities. These models have the potential to automate …
#TSQL2sday Roundup: The Most Recent Issues You Closed.
For this month’s TSQLTuesday, I asked y’all to describe the most recent issues you closed. If you ask someone in IT, “What do you do for a living?” they struggle with job titles. They say things like: “Well, my job title i …
Database Feature Toggles
In software development the concept of feature toggles are used to selectively turn on and off features. They are, for example, used to restrict some newly introduced features to a select group to see how these features work. While this concept has bee …
Tutorial: Using the hierarchyid Data Type
The post Tutorial: Using the hierarchyid Data Type appeared first on SQLServerCentral.
[Video] Office Hours: Ask Me Anything About Microsoft Databases
Post your database questions at https://pollgab.com/room/brento and upvote the ones you’d like to see me discuss on the stream. If you’d like to be alerted when I live stream these, follow me on Twitch. Here’s what we discussed today: …
JQ – Tool for Querying JSON documents using the CLI
In my role as a Data Engineer, I have an ever-increasing need for Querying JSON documents using the CLI (command line interface) in these ways: Filtering the output from a cloud CLI to just the useful information Extracting the output from an API Evalu …
Functions and Procedures: Learning PostgreSQL with Grant
One of the most useful constructs in SQL Server is the stored procedure. It gives you a way to do several things. First up, you can store code within the database. Next, you can parameterize queries so that you’re not hard coding or generating ad …
Query Exercise: Finding Long Values Faster
Our developers have come to us with a problem query that isn’t as fast as they’d like. Using any Stack Overflow database:CREATE INDEX DisplayName ON dbo.Users(DisplayName); GO SELECT * FROM dbo.Users WHERE LEN(DisplayName) > 35; It has a …