SQL server change single user mode or backup or recovery model of all database sql script

Following is the DBA script which generally used...
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

SQL server change single user mode or backup or recovery model of all database sql script

AdvertisementsFollowing is the DBA script which generally used for most cases the action needed for all the databases like migration,...

Watch: The Best of 2018 and Predictions for 2019 (video)

I recently got together with fellow Microsoft Data Platform MVPs Steve Jones, Kathi Kellenberger and Grant Fritchey to discuss the highlights of innovations we’ve seen in 2018 and predictions...

Adding Microsoft MVP Contributions with PowerShell – Lessons Learned using the MVP API

One of the things that brings Microsoft MVPs together each year is complaining about the pains of reporting community contributions to Microsoft. This is a typical first world problem,...

Giving thanks in 2018

It’s the last post of 2018, and in years past I’ve recapped the year that has just been. This is...

Managing Logins and Users Across An Availability Group

What’s the deal with logins and availability groups?
I’m sure that we all, when creating a login that accesses a database...

Move The Location Map Pin in Meetup

Just received an email from Meetup with some news on enhancements and one of them was interesting to me – the...

Some pictures from 2017’s events

The 2018 year is coming to the end. It’s a good time to review the passing year and… check whether...

Tab Order Enhances Power BI Report Accessibility

Like a diamond in the sky.
How I wonder what you are!
Twinkle, twinkle, little star,
Twinkle, twinkle, little star,
Up above the world...

Upgrading From SQL Server Profiler

How to correlate all of your favorite trace/profiler options into the shiny new XE equivalents.

As luck would have it, there is a means to correlate trace/profiler events to Extended...