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

Archives: March 2018

Code that writes code

Code that writes code it one of the best productivity tips I can give you.  And no, I’m not talking about ORMs. I’m specifically talking about YOU writing a query, which writes one or more queries. The example I’ll give today is changing database file growth rates. If I want… Read more

1 comments, 505 reads

Posted in SQL Awesomesauce on 30 March 2018

“The report server Web Portal URLs and Web Service URLs don’t match”

A client recently upgraded a server, and then started receiving this error when they tried to access the SSRS Reports page at http://MyServerName\Reports: The service is not available. The report server isn’t configured properly. Contact your system administrator to resolve the issue. System administrators: The report server Web Portal URLs… Read more

4 comments, 801 reads

Posted in SQL Awesomesauce on 19 March 2018

Management Studio Shortcut – Change Connection

Update: Now with Object Explorer shortcuts! One of the most common things I do within SSMS is to change connection for the current query editor window, from one SQL Server instance to another: I’m a huge fan of keyboard shortcuts (see exhibit 1, exhibit 2, and exhibit 3). So let’s… Read more

6 comments, 388 reads

Posted in SQL Awesomesauce on 14 March 2018

SQL Saturday Colorado Springs, and a full-day class with the MidnightDBAs!

Edit: Now with discount code! We’ll be speaking at SQL Saturday Colorado Springs on Saturday March 24. The day before that, we bring you a full day class about the most important job a DBA has: managing and maintaining the SQL Server enterprise. Yes, this applies to you even if… Read more

1 comments, 336 reads

Posted in SQL Awesomesauce on 13 March 2018

SQL Server logins, users, SIDs, and orphaned users – a quick primer

Here’s a good starter article on SQL Server logins, users, and SIDs: SQL Server Logins, Users and Security Identifiers (SIDs) Some major points to absorb from this: A login is created at the SQL Server instance level. We say it’s an instance-level object. A user is created at the database… Read more

2 comments, 458 reads

Posted in SQL Awesomesauce on 7 March 2018