DevOps Collaboration and Process Visibility in Flyway Developments
The post DevOps Collaboration and Process Visibility in Flyway Developments appeared first on SQLServerCentral.
Updated First Responder Kit and Consultant Toolkit for July 2022
Summer has turned the corner. Sure, right now the First Responder Kit is wearing its swimsuit, basking in the sun, but already as we speak, the days are getting shorter. It’s only going to be a matter of time before the Pumpkin Spice release of t …
SQL Server Pop Quiz: A Key Lookup Without the Index
How do we get this to show up in an execution plan: Without having an index seek or index scan operation on the same table? Take any copy of the Stack Overflow database and write a query that will produce a key lookup on the Users, table, but it’ …
How to Connect to an Analysis Services Database in Power BI
In this article, we will learn how to connect an Analysis Services database in Power BI. This article is oriented toward people who are learning SSAS and want to create some reports using Power BI. Multidimensional projects Analysis Services is an OLAP …
Taming Database Documentation with Flyway and MySQL
The post Taming Database Documentation with Flyway and MySQL appeared first on SQLServerCentral.
T-SQL Comment Best Practices for SQL Server
The post T-SQL Comment Best Practices for SQL Server appeared first on SQLServerCentral.
Linked Servers: a Peek Behind the Curtain
We recently received a support call from a Gallium Data user. He was executing queries on his instance of SQL Server, but these queries were getting mysteriously changed, which caused his logic in Gallium Data to not run as expected. What was going on? …
SQL Server 2022: Backup Database Options to AWS S3 Bucket – Part 2
The post SQL Server 2022: Backup Database Options to AWS S3 Bucket – Part 2 appeared first on SQLServerCentral.
[From the archives] Your guide to choosing the right monitoring tool [Video]
The post [From the archives] Your guide to choosing the right monitoring tool [Video] appeared first on SQLServerCentral.
[Video] Office Hours in the Valley of Fire State Park
I drove the Ferrari out through the Valley of Fire State Park and stopped out in the middle of nowhere to take the questions you’d upvoted at https://pollgab.com/room/brento. Here’s what we covered: 00:00 Introductions 00:39 Saket Mittal: H …
SQL Server 2022: Backup and Restore database to AWS S3 bucket – Part 1
The post SQL Server 2022: Backup and Restore database to AWS S3 bucket – Part 1 appeared first on SQLServerCentral.
Cross-RDBMS Version Checks in Flyway
The post Cross-RDBMS Version Checks in Flyway appeared first on SQLServerCentral.
How to Find the Start and End Dates for the Current Week (and more)
tl:dr See the attached dbo.WeekDates function. You don’t know what you’re missing, though. Prologue Thanks to some really clever temporal functions that are built into SQL Server, working with dates and times in SQL Server is pretty easy. The exception …
This Is Your Last Chance to Attend My Mastering Classes Live This Year.
You’ve conquered my Fundamentals classes, and you’re ready to take it up a notch. You know you can get the recordings of my Mastering classes, but you prefer the interaction of live classes – the ability to ask questions live, have me …
DevOps 101: Unlock the value of frequent deployments with Database DevOps
The post DevOps 101: Unlock the value of frequent deployments with Database DevOps appeared first on SQLServerCentral.