Azure Data Studio Schema Compare Extension

A coworker recently introduced me to the SQL Server Schema Compare extension in Azure Data Studio. It has come in handy since we don’t have any paid-for tools, so...

Creating a Speaking Failures Support Group

Earlier this week the emails went out to speakers who submitted to the PASS Data Community Summit 2023 conference. These were acceptances and rejections, letting people know the results...

The two hardest concepts of security are Who? and Where?

I was having a conversation with some friends the other day and Jen McCown (blog|twitter) asked about SQL Server security ... Continue reading

A high level view of the most costly queries by CPU

A high level view of the most costly queries by CPU

I want to see at a high level i.e at batch or stored procedure level, not at the individual...

Assigning a Default Schema to a New User–#SQLNewBlogger

I had to test something for a customer, and as a part of this there as a need to have a different default schema for a user. Since this...

Generate SQL Script to Allow or Disallow Access To All Data

I had a requirement to temporarily prevent access, read or write, to a particular database for all users except 2 users. There were hundreds of SQL Logins with access...

T-SQL Tuesday #164: Code that makes you feel

The invitation this month is from Erik Darling, and it’s a neat one. I like this thought, asking us to find code that impressed us or made us feel...

Code that made you feel a certain way : T-SQL Tuesday #164

It’s been a while, but I’m finally participating in T-SQL Tuesday again! This month Erik Darling (blog|twitter) is hosting. Ever ... Continue reading

Microsoft Fabric

What will be much easier with Microsoft Fabric?
Microsoft Fabric is built on a foundation of Software as a Service (SaaS), which takes simplicity and integration to a whole new...

A Barebone Script To Generate SQL Script to Create Synonyms

A Barebone Script To Generate SQL Script to Create Synonyms

This stored procedure can be used to generate a SQL script to create synonyms for all tables in...