Category: sqlserverpedia-syndication

Scale-out SSRS (a brain dump)

Post author By Jen McCown
Post date February 6, 2018
Categories In Admin, Advanced, sqlserverpedia-syndication, SSC, Tech and Learning
6 Comments on 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 SSRS guru. Feel free to ping me in the comments […]

Absolute computer fundamentals: the command line!

Post author By Jen McCown
Post date January 2, 2018
Categories In Beginner, sqlserverpedia-syndication, SSC, Tech and Learning

So I’ve spoken to more than one DBA who is not familiar with using the command prompt (aka command line) – or as we old-schoolers still accidentally call it, “DOS”. It’s not really DOS any more, of course, but it still uses the old commands and has the same basic look: From here, you can move […]

RegEx in SSMS: A gift for quick code

Post author By Jen McCown
Post date December 28, 2017
Categories In Beginner, Dev, Intermediate, sql server, sqlserverpedia-syndication, SSC, Study, Tech and Learning, Tips
7 Comments on RegEx in SSMS: A gift for quick code

I had yet another example of how beautiful Regular Expressions can be in SQL coding today, and so I thought I’d share. What I HAD was a set of DELETE statements that might or might not have been executed recently: DELETE FROM dbo.Table1 WHERE val = 1 DELETE FROM dbo.Table2 WHERE val = 1 DELETE […]