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

More PowerShell for fun (and profit) – filter files by date

PowerShell provides an easy way to search for and/or delete just the files you want. Let's look at navigating in the PowerShell window, and filtering by name, and by date last modified.

The post More PowerShell for fun (and profit) – filter files by date appeared first on The MidnightDBA… Read more

0 comments, 8 reads

Posted in SQL Awesomesauce on 24 September 2018

All about PASS Summit 2018

Here are the things you must/should probably know about PASS Summit 2018, as told by me. First Timers Read this blog, of course. Register for Denny Cherry’s attendee orientation. Sign up for the PASS Buddy Program. And their advice about travel. Get on Twitter and meet people. Check out the… Read more

0 comments, 107 reads

Posted in SQL Awesomesauce on 19 September 2018

Be in the SQL Yearbook

I’ve been thinking about this for years, and I’m finally doing it. I’m making a SQL Yearbook, and I want you to be in it. Since first writing this, I have realized that a “yearbook” is primarily an American phenomenon. M-W defines yearbook as “school publication that is compiled usually… Read more

0 comments, 142 reads

Posted in SQL Awesomesauce on 6 September 2018

T-SQL: How many bananas tall are you?

So today, this happened: Now I suddenly want to know how many bananas tall I am… https://t.co/7geupBzXDj — MidnightDBA (@MidnightDBA) September 6, 2018 And I realized it would be really easy to find that out, via a calculator, or – more amusingly – with SQL: DECLARE @feet FLOAT = 5.0,… Read more

4 comments, 135 reads

Posted in SQL Awesomesauce on 6 September 2018

Fix: When an Availability Group listener’s IP is stolen

When you can connect to the individual nodes of a SQL Server Availability Group (AG), but not the AG listener, you may have a duplicate IP situation. Resolving this isn't QUITE as straightforward as I'd hope, so here's our solution.

The post Fix: When an Availability Group listener’s IP is… Read more

1 comments, 717 reads

Posted in SQL Awesomesauce on 5 September 2018

Learn PowerShell in Oklahoma, August 24!

SQL Saturday Oklahoma City is coming up RIGHT SOON, on August 25. The day before SQL Saturday OKC - August 24 - we're teaching our one day Beginning PowerShell class! Buy your tickets TODAY.

The post Learn PowerShell in Oklahoma, August 24! appeared first on The MidnightDBA Star-Times.

Read more

0 comments, 576 reads

Posted in SQL Awesomesauce on 14 August 2018

Vote for a new SSMS feature: Pin files in SQL Server Management Studio

So, this just happened: That's a p good idea. I'll upvote it if you put it in User Voice. Or we just pull rank and nag @vickyharp ?? — Kerry Tyler (@AirborneGeek) August 3, 2018 And so, I did. Post the idea, I mean…I didn’t nag Vicky. Vote here.    Read more

0 comments, 278 reads

Posted in SQL Awesomesauce on 3 August 2018

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, 215 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, 212 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, 679 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, 217 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, 231 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,671 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, 268 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, 333 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, 438 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, 309 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, 268 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, 347 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, 314 reads

Posted in SQL Awesomesauce on 27 February 2018

Older posts