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

Fun with PowerShell: I made a game

So we got to playing around with PowerShell last week – one son is making a game hack, and the other is making a game, both with PowerShell.  So I decided to get in on the fun. I wasn’t feeling particularly creative, so I stole the idea of (ahem) that… Read more

1 comments, 171 reads

Posted in SQL Awesomesauce on 19 November 2018

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, 188 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, 173 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, 176 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, 172 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, 277 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, 306 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, 716 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, 235 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, 251 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, 290 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, 860 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, 687 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, 392 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, 406 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, 335 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, 795 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, 334 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, 347 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, 2,005 reads

Posted in SQL Awesomesauce on 17 April 2018

Older posts