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

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

2 comments, 171 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, 201 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, 166 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, 185 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

7 comments, 288 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, 220 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, 188 reads

Posted in SQL Awesomesauce on 14 November 2017

Five reasons to be a technology speaker

I don’t think everyone should be a technical speaker. But I wouldn’t object if everyone spent a season trying. Why be a technology speaker? Simply put: You learn more about your subject. You will learn more about presenting yourself, which is good in general (and especially good for interviewing). You… Read more

5 comments, 193 reads

Posted in SQL Awesomesauce on 8 November 2017

Attend “T-SQL’s Hidden Support Feature” online September 11!

I’m presenting T-SQL’s Hidden Support Feature for the DBA Fundamentals virtual chapter on Monday, Sep 11 at 9:30 PM CDT! Session description: The most effective T-SQL support feature comes installed with every edition of SQL Server, is enabled by default, and costs no overhead. Yet, the vast majority of database… Read more

0 comments, 235 reads

Posted in SQL Awesomesauce on 6 September 2017

Tech news: Your phone screen is a dirty rotten spy

Great. Now you can't even trust your phone's screen, of all things, to not steal your data… https://t.co/KUyGjwsih2 — Adam Machanic (@AdamMachanic) August 29, 2017 OH GOODY, your phone’s screen could totally be spying on you. Great.

The post Tech news: Your phone screen is a dirty rotten spy appeared… Read more

2 comments, 235 reads

Posted in SQL Awesomesauce on 29 August 2017

That thing you want to do? Do the thing.

You're thinking of starting a blog, or teaching, or training videos. Will it pay off? Will it be worth it? Could he keep up with it? Will you end up embarrassing yourself? Let's talk.

The post That thing you want to do? Do the thing. appeared first on The MidnightDBA… Read more

0 comments, 412 reads

Posted in SQL Awesomesauce on 29 July 2017

Celebrate! Second Anniversay Giveaway (is now over)

Two years ago, we officially became MinionWare and launched the absolutely masterful SQL Server management solution, Minion Enterprise. For a few days, we're giving it away.

The post Celebrate! Second Anniversay Giveaway (is now over) appeared first on The MidnightDBA Star-Times.

Read more

0 comments, 231 reads

Posted in SQL Awesomesauce on 18 July 2017

There’s no substitute for mentoring

There’s no substitute for mentoring. We’ve heard it before, and in various ways, but I think we tend to largely ignore it. Americans, at least, aren’t used to a mentor system, and we’re not in the habit of asking for mentors. But mentors can be great. You can stop them… Read more

0 comments, 233 reads

Posted in SQL Awesomesauce on 18 July 2017

Employees, encourage work from home

The discussion around the last article I wrote on work from home (WFH) has been wonderful, but there is one aspect that drives me nutty-freaking bonkers: “But, I don’t want to work from home!“ Oh, my stars and grasslands. Techies: I don’t want to force work from home.  I’m not… Read more

4 comments, 291 reads

Posted in SQL Awesomesauce on 22 May 2017

Employers, let your people work from home

Work from home is, astoundingly, still not the norm in United States IT offices. This is ludicrous, because employees want it, employers can provide it, and the objections to work from home do not hold up. Let's talk.

The post Employers, let your people work from home appeared first on… Read more

6 comments, 339 reads

Posted in SQL Awesomesauce on 17 May 2017

I’m going to make you love backups

On April 12, I'm going to show you about two dozen ways to make your backups better, easier, faster, and more complete...using Minion Backup, of course.

The post I’m going to make you love backups appeared first on The MidnightDBA Star-Times.

Read more

0 comments, 267 reads

Posted in SQL Awesomesauce on 4 April 2017

The Public Speaking Roadmap

So you look around, and all the cool kids are speaking at SQL Saturdays and PASS Summit and the like. You want to be the cool kids too, so how do you start public speaking? Here in four simple steps, is your roadmap.

The post The Public Speaking Roadmap appeared… Read more

0 comments, 246 reads

Posted in SQL Awesomesauce on 25 March 2017

Compare column names for case sensitivity

I’m reviewing the code for the upcoming Minion CheckDB, and one of the things we’re checking for is case consistency in column names. For example, if Table1 has a column named Col1, and Table2 has COL1, well that’s no good. But, how do we easily find those mismatches on a… Read more

3 comments, 616 reads

Posted in SQL Awesomesauce on 25 January 2017

Webinar: Introducing Minion CheckDB!

Minion CheckDB is available for download as of February 1, 2017! In celebration, we’re having a Minion CheckDB webinar on two different days: Wednesday, February 1 – Done! We will post the video next week. Meanwhile, here is the WebinarDemo script, and the webinar survey. Friday, February 3 at 12pm… Read more

0 comments, 641 reads

Posted in SQL Awesomesauce on 19 January 2017

Database snapshots for everyone!

If you're lucky enough to have SQL Server 2016, go on and upgrade to SP1....you get extra-lucky special database snapshots in any version! Oh what's that? You don't use snapshots? Well let's see a couple of good use cases for them.

The post Database snapshots for everyone! appeared first on… Read more

0 comments, 526 reads

Posted in SQL Awesomesauce on 5 January 2017

Older posts