You must just have the touch

Over the years, I’ve found my professional maturity to be a growing entity. One piece of evidence of this is how I react to being the most knowledgeable person in the room. Now, understand I’m not being arrogant, I mean, “the room,” literally. I…

Windows Server 2012 R2 Product Key Failure

Today I had an odd experience with installing Windows Server 2012 R2. I downloaded the ISO from the MSDN subscriber’s downloads. Then I got the product key from the same line item on the download page, this makes me assume…

Becoming a Senior DBA

My life in the work force began like many others, as a waiter at a Greek restaurant in my home town, Newtown, CT. After graduating from high school I ran off to join the Navy so that I could afford…

Broken ownership chain – Dynamic SQL

Today I had a co-worker come to my desk wondering why his service was getting a permissions error when selecting from a table. His confusion was rooted in the fact that his service has been using this stored procedure for…

SQL Server 2012 SP2 released

Microsoft SQL Server 2012 SP2 is now available Build number: 11.0.5058.0 Microsoft SQL Server 2012 service packs are cumulative updates and upgrade all editions and service levels of SQL Server 2012 to SP2. This service pack contains up to and including…

Information Technology: Minimum requirements

I’ve been asked, several times, what skills a person should work on if they wanted to enter the IT field. The specific question changes depending upon if the question was targeted at DBA, developer, systems administrator, or testing skills. When…

Update zero base column to one base

Problem: A co-worker requested help with a query today… Derik, I have an Email table with a list of email addresses per person record. There is an ordinal column that is base zero but I decided to make the index in the…

What happened to the SQL Hammer?

Two months ago I accepted a new position as a Data Architect / Developer (SQL and .NET). I accepted the position partially due to my passion for database design and partially as a means to expand my knowledge base. I’m attempting…

April SQL Server Updates

SQL Server 2014 Cumulative Update #1 is Available Microsoft has released Cumulative Update #1 for SQL Server 2014. KB Article: KB #2931693 114 fixes listed at time of publication (121 total) Build number is 12.0.2342 Relevant for @@VERSION 12.0.2000 through 12.0.2341…