The difference between BIN2 and Case-Sensitive collations in SQL
A common question that arises in SQL Server collation discussions is whether a binary collation (BIN2) is functionally equivalent to a case-sensitive collation that is sensitive to all aspects of sensitivity (for instance, Latin1_General_100_CS_AS). In …
The Benefits of Volunteering at SQL Saturdays
Editor note: The call for volunteer and speakers is open at on the Pass Data Community Summit 2024 site for this year’s Summit coming up in Seattle November 4-8! Volunteering for local data events large and small is a great way to get into …
[Video] Office Hours: Speed Round
Not all of the questions y’all post at https://pollgab.com/room/brento require long-winded answers. Let’s conquer 22 questions in 15 minutes! Here’s what we discussed: 00:00 Start 01:05 JoseDBA: We just started monitoring our AlwaysOn …
SQL Server to PostgreSQL Database Schema Conversion
The post SQL Server to PostgreSQL Database Schema Conversion appeared first on SQLServerCentral.
Option Recompile is a Magic Turbo Button That Actually Works.
I didn’t say that – Guy Glantser did. Guy Glantser is an Israeli SQL Server guru with a ton of great presentations on YouTube. I’ve had the privilege of hanging out with him in person a bunch of times over the year, and I’ll alw …
Transforming and Analyzing Data in PostgreSQL
In our data hungry world, knowing how to effectively load and transform data from various sources is a highly valued skill. Over the last couple of years, I’ve learned how useful many of the data manipulation functions in PostgreSQL can superchar …
Get the most out of SQL Server Agent logs
If you haven’t migrated your workloads to a managed database platform yet, you’re probably still relying on SQL Server Agent for various maintenance and other scheduled tasks. Most of the time, these processes just work. But when it’s …
Will AI end with SQL, Is this the end of SQL?
Introduction to the End of SQL Will the AI end with SQL? That is the question. The AI is replacing many job positions, like content writers, designers, programmers, and more. For example, Buzzfeed laid off 15 % of its staff and replaced them with AI to …
Why Test-Driven Development? (Part 2)
The post Why Test-Driven Development? (Part 2) appeared first on SQLServerCentral.
SSRS 2022 Install, Setup and Configuration
The post SSRS 2022 Install, Setup and Configuration appeared first on SQLServerCentral.
Power BI Auto Detect Relationship Failure
In this article, we will talk about how to manually create a relationship by identifying the primary and foreign keys if Power BI is unable to identify the correct auto-relationship between the tables after we import a dataset Sample Sales Data. Prepar …
What Happens When Multiple Queries Compile at Once?
An interesting question came in on PollGab. DBAmusing asked: If a query takes 5-7s to calculate the execution plan (then executes <500ms) if multiple SPIDS all submit that query (different param values) when there’s no plan at start, does each …
Reverse Creating the PBIP file from Source Control
On my article about Source Control with GIT, Power BI and Microsoft Fabric, I illustrate how to use the PBIP file format to include Power BI reports and semantic models in a source control process and stablish a SDLC (Software Development Lifecycl …
Finding Sister Locations to Help Each Other: Answers & Discussion
This week’s query exercise asked you to find two kinds of locations in the Stack Overflow database: Locations populated with users who seem to be really helpful, meaning, they write really good answers Locations where people seem to need the most …
Writing your 2024 PASS Data Community Summit Submission
It is time again for the PASS Data Community Summit Call For Speakers. Some of you are very ready. You have a presentation idea that has percolated since at least last October. You have asked friends and coworkers if it is a good idea. You may have pre …