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

Live blog: Women in Technology lunch at #PASSSummit #passwit

11:48am This will be starting shortly! We’re stuffing our faces, first. Today’s featured speaker is Lauri Bingham, Director of Technology Engineering Project Management at T-Mobile (LinkedIn). Let’s go! 12:15pm Wendy Pastrick, PASS Executive VP, opens the show. This is the 16th annul WIT luncheon at PASS Summit. And now, Lauri… Read more

2 comments, 111 reads

Posted in SQL Awesomesauce on 8 November 2018

SQL work-vacation, Thursday! (#Workation #PASSSummit)

Hello yet again! I’ve been writing about our time this week in Seattle, for the PASS Summit. Saturday, I wrote that we’re here in Seattle for the PASS Summit, and that it’s my tenth year. AND that I’m doing daily “letters home” to you fine folk, just like I’m away… Read more

0 comments, 98 reads

Posted in SQL Awesomesauce on 8 November 2018

SQL work-vacation, Monday (#Workation #PASSSummit)

Hello again! Sunday, I wrote that we’re here in Seattle for the PASS Summit, and that it’s my tenth year. AND that I’m doing daily “letters home” to you fine folk, just like I’m away at summer camp. We’re still just a day or three away from the start of… Read more

1 comments, 112 reads

Posted in SQL Awesomesauce on 5 November 2018

SQL work-vacation, T-2 days (#Workation #PASSSummit)

We are at PASS Summit 2018 in Seattle, and I will write a bit about each day I'm here, just because it might be useful. Or, in a year or two, nostalgic. Or just to have something like letters from camp: "Hi there, internet friends, today at camp it rained… Read more

3 comments, 108 reads

Posted in SQL Awesomesauce on 4 November 2018

Regular Expressions: tagging expressions

I re-discovered something very cool while using RegEx in SSMS today: tagging expressions and referencing them in the same line! I’ll take a minute to define regular expressions, explain tagged expressions, and then show you how to use it in the same line. But first, XKCD: Regular Expressions defined “A… Read more

0 comments, 141 reads

Posted in SQL Awesomesauce on 15 October 2018

sqlhelp: limit the x-axis of a geometry line graph

I have a #sqlhelp question that requires some code. So hey, blog post time! TL;DR: the geometry::STGeomFromText graph provides too wide a range for the X-axis, for a large variance of Y-axis values. Is there a way to limit the X-axis range? Update: We have an answer! Thanks MJ! Yeah,… Read more

0 comments, 233 reads

Posted in SQL Awesomesauce on 26 September 2018

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, 644 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, 165 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, 185 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, 222 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, 780 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, 619 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, 322 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, 277 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, 256 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, 717 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, 263 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, 275 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,768 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, 311 reads

Posted in SQL Awesomesauce on 6 April 2018

Older posts