Category: Level

How to make a Database Request

Post author By Jen McCown
Post date February 27, 2018
Categories In Admin, sql server, sqlserverpedia-syndication, SSC, Tips
1 Comment on 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 clearly. Include all details. In the sections below, […]

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

Post author By Jen McCown
Post date February 7, 2018
Categories In sqlserverpedia-syndication, SSC, SSRS, Tech and Learning, Tips
1 Comment on 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, say, SQL SERVER RELATED PROGRAMS AND OPTIONS. But […]

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 […]