Should Apps Use a Dedicated Port?

Most applications connect on whatever the default port is, typically 1433 for SQL, though it’s common to change that to...

Scrum what are story points

In this blog post I discuss Scrum (agile development methodology) and method to accurately estimate effort to complete sprint which...

SSRS does not require IIS

Starting with SQL Server Reporting 2008 Reporting Services (SSRS) was the removal of the Internet Information Services (IIS) dependency, so you do...

#TSQL2Day – A Day in the Life of A Service DBA

Today I am excited to join in with my #sqlfamily and participate in this months #tsql2day throw down. This month Erin...

Where in the World is…

You may or may not have noticed that over the past several months I have been somewhat absent from my blog.  Very few articles if any have been produced....

Where in the World is…

You may or may not have noticed that over the past several months I have been somewhat absent from my...

What’s been happening in Wayne’s World

Late last year, my life got strange. Well, it’s always been strange, so let’s just say it became stranger than...

Enabling "Open Project Folder" for project types that don't support it

One annoying thing about SSIS (2008) and some of the other project types in Visual Studio is the lack of...

The Hollywood DBA

I’m delighted to welcome a fellow Brit to the blog to share their story in today’s guest post. Many of you will...

SQL Saturday #171 Pittsburgh!

It's official, there's going to be a SQL Saturday in Pittsburgh this year!

The date is October 6th, and the...