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

Minion Backup: Restore to another server

Minion Backup makes your SQL Server backups effortless, of course.  And even better, it makes your restores effortless! Oh, yes….yes indeed. Today we’ll look at configuring a common, repeatable scenario: take the latest backup of MyDB from ProdServer1 and restore it to DevServer1. There are four basic steps to the… Read more

1 comments, 149 reads

Posted in SQL Awesomesauce on 28 June 2018

The transaction log for database ‘MyDB’ is full due to ‘LOG_BACKUP’

Your transaction log is full. Both Microsoft, and about 100 articles and blogs have covered this topic, but let's take a quick look anyway. Because, you know, it comes up all the time.

The post The transaction log for database ‘MyDB’ is full due to ‘LOG_BACKUP’ appeared first on The… Read more

1 comments, 171 reads

Posted in SQL Awesomesauce on 14 June 2018

Generate RESTORE LOG statements

Today, we're going to take a specific, simple example of generating RESTORE LOG statements from a directory list of files, using Powershell and find-and-replace.

The post Generate RESTORE LOG statements appeared first on The MidnightDBA Star-Times.

Read more

0 comments, 627 reads

Posted in SQL Awesomesauce on 6 June 2018

Tea with Kalen! An interview with Kalen Delaney (#DBAsAtMidnight)

We had an AMAZING talk with Kalen Delaney – wait, you do know who Kalen is, don’t you? Rightfully, @SQLQueen on Twitter. Over 30 years in SQL Server. Independent trainer and consultant. Author of the SQL Server Internals series of books, among others. Runs https://www.sqlserverinternals.com/ Trekkie. All-around awesome person. In… Read more

0 comments, 172 reads

Posted in SQL Awesomesauce on 16 May 2018

SQL Saturday Dallas half-day precon: “Beginning Programming with Powershell”

On May 18 we will be presenting a half-day of PowerShell learnin', right before SQL Saturday Dallas! Read up and register now.

The post SQL Saturday Dallas half-day precon: “Beginning Programming with Powershell” appeared first on The MidnightDBA Star-Times.

Read more

0 comments, 194 reads

Posted in SQL Awesomesauce on 24 April 2018

Fix WHERE clause AND/OR/NOT confusion with truth tables

The ANDs, ORs, and NOTs in a T-SQL query's WHERE clause can get confusing, especially if you're thinking of it like plain-Jane algebra. Here I show you how to figure out exactly what a query is doing, using truth tables!

The post Fix WHERE clause AND/OR/NOT confusion with truth tables Read more

5 comments, 1,520 reads

Posted in SQL Awesomesauce on 17 April 2018

When was my last backup / CheckDB / index maintenance?

Keep a good eye on your backup and maintenance; they’re kind of important to the health and well-being of your job wait I mean SQL Server instances. So how do we go about this? Well, there’s the easiest way – you knew I’d be mentioning Minion Enterprise, right? – and… Read more

1 comments, 228 reads

Posted in SQL Awesomesauce on 6 April 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, 278 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, 268 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, 257 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, 228 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, 279 reads

Posted in SQL Awesomesauce on 7 March 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, 260 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, 967 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, 306 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, 286 reads

Posted in SQL Awesomesauce on 6 February 2018

Absolute computer fundamentals: the command line!

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… Read more

0 comments, 285 reads

Posted in SQL Awesomesauce on 2 January 2018

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… Read more

6 comments, 482 reads

Posted in SQL Awesomesauce on 28 December 2017

PowerShell for fun (and profit?)

Let's have a liltle fun with PowerShell. Along with, I suppose, a couple of useful things and links.

The post PowerShell for fun (and profit?) appeared first on The MidnightDBA Star-Times.

Read more

3 comments, 314 reads

Posted in SQL Awesomesauce on 15 November 2017

Session: T-SQL’s Hidden Support Feature

Today I presented one of my favorite sessions - T-SQL's Hidden Support Feature - for the DBA Fundamentals group! They'll put up the recording shortly, but in the meantime I thought I'd post the slide deck, header template, and more.

The post Session: T-SQL’s Hidden Support Feature appeared first on… Read more

0 comments, 271 reads

Posted in SQL Awesomesauce on 14 November 2017

Older posts