“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 …
How to Use SQL to Analyze the Bitcoin Blockchain
Background The Bitcoin blockchain is a vast and complex database. It contains over 100 million blocks, each of which contains thousands of transactions. This makes it a challenge to analyze the blockchain using traditional methods. SQL is a powerful la …
Decision Tree – Credit Card Fraud Detection
Credit card fraud detection is an important application of machine learning techniques, including Decision Trees. The goal is to identify and detect fraudulent transactions and separate them from valid transactions to prevent financial loss and protect …
SQL Unit Testing reference guide for beginners
The post SQL Unit Testing reference guide for beginners appeared first on SQLServerCentral.
Working with MySQL constraints
MySQL provides a set of constraints that you can include in your table definitions to help ensure the integrity of the data. The constraints let you better control the types of data that can be added to the database. For example, you can use constraint …
[Video] Office Hours at Jökulsárlón Glacial Lagoon
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 at Jökulsárlón Glacial Lagoon, a wonder of nature, watching the icebergs pile up, stuc …
How To Connect to SQL Server Database From PowerShell
PowerShell can be a valuable tool for data analytics and data orchestration, especially when dealing with SQL Server data.
Microsoft Fabric: Lakehouse and Data Factory in Power BI environment
Microsoft is merging Data Factory and Power BI Dataflows in one single ETL solution. It’s not a simple merging, but still these ETL tools are easier to use then ever. In this article, I will demonstrate how to create a lakehouse and ingest data u …
[Video] Office Hours at the Blue Lagoon
Road trip time! I’m recovering from jet lag after flying over to Iceland, so I went through your top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 00:55 Shehroz Sabzwari: What are your pros / cons …