Indexing for Delete – SQL in Sixty Seconds #197
In Comprehensive Database Performance Health Check, I often discuss that indexes can reduce the performance of your system big time. Many still think that indexes are good for a SELECT statement but that is not true and I have previously created a vide …
The ins and outs of joining tables in SQL Server
The post The ins and outs of joining tables in SQL Server appeared first on SQLServerCentral.
The Script Activity in Azure Data Factory
Introduction Azure Data Factory recently introduced a new activity, called the Script activity. We can use the Script activity to execute DML (Data Manipulation Language) statements like SELECT, INSERT, UPDATE, as well as DDL (Data Definition Language) …
Summit Learning Pathways Announced
The post Summit Learning Pathways Announced appeared first on SQLServerCentral.
Creating unique datasets with managed code
Figuring out uniqueness in large datasets is somewhat trivial in SQL via the DISTINCT statement. This DISTINCT technique, however, puts a load on the SQL box to where it is more beneficial to scale out horizontally in managed code instead. Typically, i …
The 6-Year-Old T-SQL Book That Never Goes Out of Style
You’ve been working with Microsoft SQL Server for yeeears, and you’re pretty confident that you know how to write a query. So when I tell you about a book called T-SQL Fundamentals, you’re all, “nah, man, I got this covered. …
Office Hours Speed Round: Text Edition
I recorded an Office Hours stream answering a bunch of your questions quickly, but…I forgot to turn on my microphone, so the video only had the sound effects: Oops. So here are the questions in text form instead: Q: 22DBA: what performance recom …
Your First Repo in Azure Data Studio or VS Code
I wrote an article recently on Azure Data Studio and Version Control. Someone commented that their co-workers didn’t want to use the command line at all, but they didn’t have a Git repo. In this case, how would one get started with version control? Thi …
DevOps 101: Introducing Database DevOps
The post DevOps 101: Introducing Database DevOps appeared first on SQLServerCentral.
A MySQL story: Can system engineers solve database issues using system tools?
The post A MySQL story: Can system engineers solve database issues using system tools? appeared first on SQLServerCentral.
Don’t Treat SQL Like a Programming or Scripting Language.
In a programming language like C# or Java, you tell the computer what to do, in order. Get the customers from California, then get their invoices, then sum the total. SQL, on the other hand, is a declarative language where you declare the shape of your …
Working with Firebase Version 9 Modular SDK and React Typescript
The post Working with Firebase Version 9 Modular SDK and React Typescript appeared first on SQLServerCentral.
Who is the Best Batman in Power BI
Who is the best Batman? – A Power BI Analysis of data Introduction Who is the best Batman? We were drinking some cold beers with some friends when someone said that Pattinson was the best Batman. People started to discuss and after 2 hours, the p …
Flyway How-tos: a User’s Perspective
The post Flyway How-tos: a User’s Perspective appeared first on SQLServerCentral.
How to automate table level refresh in Power BI
The post How to automate table level refresh in Power BI appeared first on SQLServerCentral.