[Video] Office Hours: SQL Server at Sunset
Let’s kick back with a tasty beverage and go through your highest-upvoted questions from https://pollgab.com/room/brento on the beach: https://youtu.be/hwRAwhcgCGU Here’s what we covered: 00:00 Introductions 00:49 Alexander Speshilov: How t …
Unity state machine behaviours
The post Unity state machine behaviours appeared first on SQLServerCentral.
Adding Test Data to Databases During Flyway Migrations
The post Adding Test Data to Databases During Flyway Migrations appeared first on SQLServerCentral.
Check Your SQL Server Backup Performance & Safety with sp_BlitzBackups
Out of all of the scripts in our free First Responder Kit, sp_BlitzBackups is probably the one you’ve used the least. Let’s talk about what comes out of it, and why you should use it more often. First, let’s define two terms: Recovery …
Why cloud and hybrid estates are important – but bring complexity
The post Why cloud and hybrid estates are important – but bring complexity appeared first on SQLServerCentral.
Is SQL Server Profiler in Azure Data Studio?
Introduction Do we have the SQL Profiler in Azure Data Studio? In a previous article, we compared SSMS and Azure Data Studio. Now we will compare the new SQL Profiler against the old one. If you check the SQL Server Profiler documentation, you will fin …
Working with PowerShell strings
The post Working with PowerShell strings appeared first on SQLServerCentral.
Performance Tuning Using Free Tools
Do you frequently upgrade your on-premises hardware in order to keep a certain level of performance? Are your Azure SQL bills bigger than you expected? Are your databases wasting money through inefficiency? You can keep expenses under control by improv …
Did you know SQL Monitor supports Azure databases, too?
The post Did you know SQL Monitor supports Azure databases, too? appeared first on SQLServerCentral.
Editing API Driver API Profiles
RESTful APIs offer a straightforward way for businesses to work with external data and offer access to their own data. With more than 24,000 public APIs providing access to limitless data and the typical enterprise leveraging more than 200 applications …
Connecting to PostgreSQL: Learning PostgreSQL with Grant
The post Connecting to PostgreSQL: Learning PostgreSQL with Grant appeared first on SQLServerCentral.
[Video] Office Hours: SQL Server Q&A in Cabo at Sunrise
Let’s watch the sun rise at Land’s End and cover your top-voted questions from https://pollgab.com/room/brento/. Here’s what we covered: 00:00 Introductions 01:04 Jr Wannabe DBA: Hi Brent, a colleague wants to upgrade from Standard to …
[Video] Office Hours: First Post From Cabo
Join me on my balcony in Cabo as I review your top-rated questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Introductions 00:48 md: Hi Brent, as SQL Server works with 8K pages why is the recommended NTFS Unit Allocation …
BETWEEN the two of us
The post BETWEEN the two of us appeared first on SQLServerCentral.
DBAs at work #2: The airline DBA
The post DBAs at work #2: The airline DBA appeared first on SQLServerCentral.