Export SQL User Permissions to T-SQL script using PowerShell and dbatools

There are times when DBA’s are required to export database user permissions to a file. This may be for a...

Margaritas and TexMex at VS Live

takes place in a few weeks and I’m excited. Austin is one of those cities I enjoy visiting, with a...

Reviewing the 2016 PASS Audited Financials

Notes on items I found interesting in the financial statement, recommend you download and read the entire document.
Global Alliance Partner...

SQL Server Free eBooks, Softwares, Tutorials and Websites

When we start working as developer or learning, we often
face this issue. Where is the best tutorials, books and other...

Why SQLSaturday? A SQLSat Career Case Study

We all know that SQLSaturday events are good for career networking, professional development, and technical education. Sometimes the perfect story...

Working with Data in Always Encrypted

In this post we’re going to create some encrypted columns in a table in a test database and look at some of the practicalities and limitations of working with...

Gethyn Ellis:My SQL Server You Tube Channel

Its been an interesting weekend at gethynellis.com I have been attempting to put together a SQL Server YouTubechannel. I’m planning...

Monday Coffee 2017-04-10

So SQLBits is over and I have to say that I really enjoyed attending on the Saturday, hopefully next year...

Monday Coffee 2017-04-10

So SQLBits is over and I have to say that I really enjoyed attending on the Saturday, hopefully next year...

Missing index with create statements

Missing index :- Scripts will help you to get all the missing index and prepare script for new index.

/*
Description:- This Query...