SQL Server Execution Plan Issues when using TOP Clause and Various Parameters
The post SQL Server Execution Plan Issues when using TOP Clause and Various Parameters appeared first on SQLServerCentral.
SQL Server Row Level Security Deep Dive. Part 4 – Integration, Anti-patterns, and Alternatives
One of the primary reasons to implement RLS is to facilitate reporting and ease the administrative burden. This section covers some considerations for using RLS with the primary Microsoft reporting engines and gives you an idea of things to look for in …
How To Filter SQL Server Data in Windows PowerShell
Explore techniques for filtering SQL Server data using both PowerShell and SQL queries.
Backup and Restore SQL Database to Azure Blob Storage
SQL databases are crucial for businesses, so it’s critical to back them up. A dependable and affordable option is offered by Azure Blob Storage. Let’s examine the advantages, the steps involved in backing up to and restoring from a device, recommended …
Generate Test Data Sets for Testing SQL Server Database Applications
The post Generate Test Data Sets for Testing SQL Server Database Applications appeared first on SQLServerCentral.
Announcing SQLBits 2024: 19-23 March, Near London
I hate picking favorites, but I gotta be honest: SQLBits is my favorite conference. Sure, like any conference, it has workshops, training days, and even a free community day, but the icing on the crumpet is the attendee party. Every year, Bits goes all …
Microsoft Fabric: Using notebooks and table partitioning to convert files to tables
When Microsoft Fabric was born, the only method to convert files to tables was using notebooks. Nowadays we have an easy-to-use UI feature for the conversion. As I explained on the article about lakehouse and ETL, there are some scenarios where we stil …
[Video] Office Hours at Breiðamerkursandur, Diamond Beach
Post your Azure SQL DB and SQL Server questions at https://pollgab.com/room/brento and upvote the ones you’d like to see me discuss. In this episode, I’m overlooking Breiðamerkursandur, Diamond Beach, one of the most Instagrammed places in …
“Oops, I Lost My Indexes in Azure SQL DB.”
I got an interesting request for consulting, and I’m going to paraphrase it: We were using Azure SQL DB with automatic index tuning enabled for months. Things were going great, but… we just deployed a new version of our code. Our deployment …
How To Visualize SQL Server Data in PowerShell (With Sample Script)
Learn how to use data from a SQL Server database to create graphs and charts in PowerShell. A sample script is provided.
What’s Faster: IN or OR? Columnstore Edition
Pinal Dave recently ignited a storm of controversy when he quizzed readers about which one of these would be faster on AdventureWorks2019:SELECT * FROM Sales.SalesOrderHeader WHERE CustomerID IN (1, 2, 3); SELECT * FROM Sales.SalesOrderHeader WHERE Cus …
Webinar: The Impact of the Cloud on Databases
The post Webinar: The Impact of the Cloud on Databases appeared first on SQLServerCentral.
How to create a SQL Server presentation in 5 minutes using AI
Introduction This SQLServerCentral article shows how to create a SQL Server presentation in 5 minutes using AI. AI is revolutionizing the world as it continues to evolve. In this article, we aim to answer the question: Is it truly possible to create a …
Working with NULL Values in SQL
The post Working with NULL Values in SQL appeared first on SQLServerCentral.
SQL Server Row Level Security Deep Dive. Part 3 – Performance and Troubleshooting
Previous sections gave a brief introduction to RLS, including some common use cases. They also showed how to implement RLS using a few different methods. This section focuses on performance and potential issues you may encounter. There are two main are …