Category: sqlserverpedia-syndication

Restore a SQL Server Backup (WITH MOVE)

This is a basic skill can get overlooked, so let’s talk about a common DBA task: backing a database up and restoring it to another server. First let’s dispel a couple of common misconceptions: You cannot restore a backup from a later version of SQL Server, to an earlier version. For example, a 2016 backup will […]

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 skillz and then show you, okay? […]

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