[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.
Don’t Use SQL Server to Send Emails.
I would like to unsubscribe from this idea.I’m not talking about Agent alerts when jobs fail. That’s fine when you can’t get the business to spring for a monitoring system. I’m talking about using SQL Server to send emails to co …
Raw Data Ingestion into Delta Lake Bronze tables using Azure Synapse Mapping Data Flow
The post Raw Data Ingestion into Delta Lake Bronze tables using Azure Synapse Mapping Data Flow appeared first on SQLServerCentral.
A Flyway Teams Callback Script for Auditing SQL Migrations
The post A Flyway Teams Callback Script for Auditing SQL Migrations appeared first on SQLServerCentral.
Introduction to SQL Jobs in Azure Data Studio
By default, Azure Data Studio (ADS) does not allow creating jobs, scheduling them, and creating alerts. However, there is a plugin, named SQL Server Agent, that can be installed. You can also use the Admin Pack for SQL Server that includes the SQL Serv …
Creating 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 …
Introduction to DAX for paginated reports
The post Introduction to DAX for paginated reports appeared first on SQLServerCentral.
SQL Server Data Classification Comes Alive
Overview Microsoft SQL Server 2012 introduced a feature called data classification, which allows you to mark certain columns with labels, indicating that these columns contain sensitive or special-handling data. For instance, you may want to mark a col …
Flyway Teams and the Problem of Database Variants
The post Flyway Teams and the Problem of Database Variants appeared first on SQLServerCentral.
[Video] Office Hours: SQL Server 2008 R2 Edition, I Guess
I went through your highest-voted questions from Pollgab and talked through ’em, and strangely, there was a bit of a 2008R2 theme! https://youtu.be/3-B5L3Komq4 Here’s what we covered: 00:00 Introductions 02:00 Pete Donnelly: Hi Brent, I hav …
How Do You Test IOPs, Latency, and Throughput?
You’ve heard these terms thrown around about storage, and you’re not sure what they mean, and how they relate to each other. Let’s make it simpler by using an analogy. Say you want to measure a shipping company. You’re trying to …
Create a SQL Server PolyBase Scale-out Group Using Amazon Web Services
The post Create a SQL Server PolyBase Scale-out Group Using Amazon Web Services appeared first on SQLServerCentral.