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...

Microsoft Fabric Overview

First, thank you to Guy in a Cube for a great licensing/cost video. My company is exploring what data warehousing technology to use in Azure. I needed to learn...

Query the fully qualified connection string for the AlwaysOn Connection

While we do maintain an exact inventory of sql servers and their configuration, its too numerous and I often find myself in a need to look up AG connection...