SQL RNNR

Free workshop on SQL Server leading up to Summit 2017 that will provide attendees an alternate means to increase affordable learning opportunities during the week.

A linked server is a fabulous feature in SQL Server to help accomplish various data tasks between local and remote servers. There is a time and a place for the use of linked servers.

Building your brand is not an overnight sensation. It does take a while and possibly a bit of luck here or there along the way. The one thing it always starts with is your name.

Some Text here to seed the syndication. Related Posts:Database In Recovery Update May 18, 2015 T-SQL Tuesday #081: Sharpen Something July 27, 2016 SSRS Subscription Schedules May 23, 2017 Last Execution of a Proc February 17, 2015 T-SQL Tuesday #081: Sharpen Something – Reminder August 2, 2016

“What the heck is an endpoint?” Well, that is a good question. An endpoint in the simplest form is a connection or point of entry into SQL server.

With the ability to create content delivery schedules, or to subscribe to report content delivery, it becomes very important to also know when the various reports are scheduled to be delivered.

With the ability to create content delivery schedules, or to subscribe to report content delivery, this imposes a requirement to also know when the various reports are scheduled to be delivered.

Reporting Services is a pretty feature rich tool for delivering reports to various consumers. Unfortunately, the scheduling capability within SSRS is fairly weak.

Do you fear the coming turbulence of the Cloud uprising? I think the cloud is a good thing for the data professional, when done right.

It is very important to understand who has what level of access within the server and databases on that server. Sometimes we see users being granted server or database access through the fixed roles available in SQL Server. How exactly do you know what permissions those individuals have via role membership? This article will help to reveal the permissions granted to the various roles and maybe a gotcha or two.

That is fantastic. Should Erik be Ernie now then? For a bit I was sure he was trying to pull…

Nice post Terry. Have lost track of how many times I’ve got Craig, etc Regards…

Great point, Chuck. True story: my nickname is Bert because ~15 years ago, the company I worked…

Hi Did you ever get around to(time) to update this script?

I found your post coincidentally, nice solution :-) And have a simple way to format the output…

TheTARDIS should be blue not red. :) https://goo.gl/2Fh7EU

Actually, this method relies explicitly on a buggy cursor. SP_MSFOREACHDB comes with inconsistencies and a few bugs. The heart of…

Michael, Thanks for the excellent feedback. I am glad somebody took this and adapted it to posh. I will have…

Thanks for the feedback.

Hi, I've tried the version provided for schema support, but it never worked in my environment.…