Find Text in Stored Procedure, Function, View, or Trigger
The post Find Text in Stored Procedure, Function, View, or Trigger appeared first on SQLServerCentral.
Fun with PowerShell Asynchronous
The post Fun with PowerShell Asynchronous appeared first on SQLServerCentral.
Implementing Vector Datatype with Azure SQL Server
Overview Searching for relevant information in vast repositories of unstructured text can be a challenge. This article demonstrates how to implement a vector database using Azure SQL Server. Azure SQL Server recently introduced vector data type support …
MySQL Index Overviews: Descending B-Tree Indexes
Most anyone who works with indexes should be familiar with B-tree indexes. These are the most commonly used data structures to facilitate faster access to data when we search for exact matches of data using the WHERE clause (or partial matches that can …
[Video] Office Hours: Hawaiian Edition
I took your top-voted questions from https://pollgab.com/room/brento and answered ’em from my balcony at Disney’s Aulani Resort in Hawaii. I’m not really a Disney guy – we were there for a friend’s birthday celebration …
I’m coming to Jacksonville and Raleigh for SQL Saturday! Register now.
I’m coming to Jacksonville, FL on May 2-3 and Raleigh, NC on May 16-17 for SQL Saturdays! In each city, I’m teaching a one-day pre-conference workshop on Friday. Jacksonville Pre-Conference Workshop: Mastering Query Tuning You’ve been worki …
Exploring Scalar Solutions to Complex Data Math
There are many functions and tools available to database professionals that can solve data math challenges, regardless of complexity. A recent problem came across my desk that called for not only a valid solution, but one that performs as optimally as …
Using Group Managed Service Accounts with SQL Server
The post Using Group Managed Service Accounts with SQL Server appeared first on SQLServerCentral.
How to Develop Solutions with Fabric Data Warehouse: Data Engineering with Fabric
The SQL endpoint of the Fabric Data Warehouse allows programs to read from and write to tables. The flexibility of the warehouse can lead to a big debate within your company on “How to develop with this new service?”. Older programmers might want to …
The 8 Worst Things Microsoft Ever Did to SQL Server
Last week I wrote about the 6 best things Microsoft ever did to SQL Server, but now we gotta pull up a chair and discuss the stinkers. To be fair, I excluded anything that’s basically ANSI standard. I’m sorry that you don’t like funct …
SQL Database Project in Azure Data Studio
Introduction This article teaches how to use the Azure Data Studio extension to handle SQL Database projects. It is a good practice to handle code as a Database project. Keeping the version history in Visual Studio is easier, and you can easily publish …
SQL Server BIT_COUNT and an Alternative
I was editing an article the other day that uses the BIT_COUNT function that was added to SQL Server 2022. The solution presented is excellent, and I will try to come back and link to it here when I remember. (It will be linked the other way. Reading t …
Understanding Data Type Conversion Functions in SQL Server with PARSE, TRY_PARSE, and TRY_CONVERT
Introduction SQL Server provides robust tools for data type conversion, such as PARSE, TRY_PARSE, and TRY_CONVERT. These functions are designed to simplify the process of converting data types while handling potential errors effectively. Data type conv …
How to use @@ROWCOUNT in SQL Server
The post How to use @@ROWCOUNT in SQL Server appeared first on SQLServerCentral.
SQL ConstantCare® Population Report: Winter 2025
Every quarter, we publish adoption rate data showing how quickly people are adopting new versions of SQL Server. Today it’s time for the winter 2025 version of our SQL ConstantCare® population report. SQL Server 2022 is finally seeing some good a …