SQL Connectivity issues: A guided walk through

The SQL Tiger Team (t) has recently put out a guided walkthrough for SQL Connectivity issues.
Announcement
Walk Through
If you look...

My SQL logins don’t work. Again.

My recent post on why SQL logins aren’t working has generated a couple of follow up posts. The first one...

Changing what SSMS opens on startup

When you open SSMS a connection window automatically comes up. Then once you pick your server, connection type, username and...

Azure quick start

In case you hadn’t noticed, I love built in help. DBCC HELP, the script button in SSMS, even BOL. Well...

Creating a connect entry.

I recently wrote a blog about how to tell why your SQL login isn’t working. There were a lot of...

What is COPY_ONLY?

You’ll frequently hear that you should add the COPY_ONLY clause when taking an ad-hoc full backup to avoid messing up...

Lead Blocker

Blocking is just part of life I’m afraid. Because we have locks (and yes we have to have them, and...

A detailed view into your Azure resources

I’ve been studying Azure recently and came across a really interesting Azure site.
resources.azure.com

To give you an idea why I find...

Why won’t my SQL Logins work?

I recently had an interesting time getting the SQL Auth logins on a new instance working. I was doing a...

Connect suggestion to add included columns to sp_helpindex

I’m a big fan of the sp_help system stored procedures, which is why I’ve been a bit disappointed that the...