SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: February 2018

How to make a Database Request

You need something from the database admin. Maybe it’s permissions, maybe it’s code troubleshooting, or maybe it’s  just that the database is slow. I’m going to let you in on the secret of the best method to get what you want out of your DBA. Ready? Here’s the secret… Ask… Read more

1 comments, 459 reads

Posted in SQL Awesomesauce on 27 February 2018

CROSS JOIN for fun

My son, who wishes to be known as “Pigeon” for the duration of this blog, was mixing the names of Hogwarts houses over a game of chess* with his brother: “ONE MILLION POINTS TO GRYFFINPUFF!” So I said, “Hey guys, I’m going to do a nerdy thing with my database… Read more

6 comments, 1,090 reads

Posted in SQL Awesomesauce on 17 February 2018

Where on Earth is the SQL Server Reporting Services Config Manager?

While we’re on the topic of SQL Server Reporting Services: WHYYYYYY is the Reporting Service Configuration Manager so hard to find from one server to the next? For one thing, it doesn’t help that I’m used to hitting the Windows key and typing “SQL Server” for a list of, oh,… Read more

1 comments, 419 reads

Posted in SQL Awesomesauce on 7 February 2018

Scale-out SSRS (a brain dump)

So, I just got finished with a SQL Server Reporting Services (SSRS) scale-out deployment, based largely on this step-by-step guide. Things mostly went well, but there were a couple of hiccups I’d like to record before they fly out of my head again. Note, too, that I am NOT an… Read more

6 comments, 376 reads

Posted in SQL Awesomesauce on 6 February 2018