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

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

3 comments, 163 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, 156 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

0 comments, 184 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

0 comments, 162 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

9 comments, 188 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, 162 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, 204 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, 181 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, 881 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, 249 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, 213 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, 220 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, 345 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, 257 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, 214 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, 227 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, 267 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, 264 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, 450 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, 259 reads

Posted in SQL Awesomesauce on 18 July 2017

Older posts