SSMS Tip: Management Studio Script Projects

Did you know that SQL Server Management Studio can help you arrange your SQL scripts into logical groupings? SSMS includes the ability to associate multiple code files together into...

Understanding Azure Geo-Redundant Storage

While at PASS Summit 2019, I gave a session on designing Azure Disaster Recovery Strategies for the Data Platform.  In that session, I talked about Azure storage and the...

Understanding Azure Geo-Redundant Storage

While at PASS Summit 2019, I gave a session on designing Azure Disaster Recovery Strategies for the Data Platform.  In that session, I talked about Azure storage and the...

Prompt in ADS

Ever since VS Code and Azure Data Studio came out, people have been asking for SQL Prompt to port over. I’ve been right there with you, though unsure of...

When Too Much is Not a Good Thing

Explore how to avoid unwanted results that oft occur due to lack of attention to detail, use of internet examples, misunderstanding of the requirements; and always from granting way...

When Too Much is Not a Good Thing

Explore how to avoid unwanted results that oft occur due to lack of attention to detail, use of internet examples, misunderstanding of the requirements; and always from granting way...

SSMS Tip: Vertical Text Selection

Occasionally, I’ll stumble across one of those neat tricks that makes me ask myself, “Why didn’t I know about this years ago?”. This next tip was one such discovery,...

Who needs data access? Not You!

With a little planning and care, we can find various ways to fulfill user requests without compromising the environment.
Related Posts:

When Too Much is Not a Good Thing December 13,...

Who needs data access? Not You!

With a little planning and care, we can find various ways to fulfill user requests without compromising the environment.
Related Posts:

When Too Much is Not a Good Thing December 13,...

Azure Synapse Analytics & Power BI performance

With two new relational database features (Result-set caching and Materialized Views) just GA’d in Azure Synapse Analytics (formally called Azure SQL Data Warehouse), it makes for some very compelling reporting...