Tag Archives: SQL

Distributed Transaction Coordinator (DTC) in a SQL Failover Cluster

At my company, we have recently refreshed some of our physical hardware for our SQL failover clusters.  During our building of these new servers (Windows 2012 R2 and SQL Server 2012), we decided to change the setup of the distributed … Continue reading

Posted in DBA | Tagged , , | Leave a comment

Database Administrators or Developers … Who is Responsible for Indexing?

To answer that question, I am going with “it depends” and “both”! The reason I answer that way, is that anyone designing, building, querying, or maintaining database objects needs to have a grasp of indexing and how it will affect … Continue reading

Posted in DBA, Developer, TSQL | Tagged , , , | Leave a comment

“Do It All at Once” Philosophy … A Set Based Approach Using a Tally or Numbers Table

When it comes to database programming, two of the key principles are that the code should run quickly and be scalable.  And this is really where a lot of people coming from traditional programming backgrounds get into the most trouble … Continue reading

Posted in Developer, TSQL | Tagged , , | Leave a comment

Find Data Quickly … By Using Indexes

Frequently, when a person is interviewing for a database job (i.e. developer or administrator), someone asks them … What is an index?  Or they may ask, what is the difference between a clustered and non-clustered index?  Now, while I do … Continue reading

Posted in DBA, Developer | Tagged , , | 2 Comments

Attack It in Small Bits or Chunks

A friend of mine, with an interesting sense of humor, once asked me, “Do you know how you can eat a whole cow?”  I knew there was going to be some “smart” type of answer, but I didn’t come up … Continue reading

Posted in DBA, Developer, TSQL | Tagged , | 1 Comment

Don’t Re-Invent the Wheel

When I first started working with SQL Server early in the year 2000, the SQL Server community was not like it is today.  There were not all the conferences, blogs, monitoring solutions, and training.  Compared to how things are now, … Continue reading

Posted in DBA | Tagged , , | 1 Comment

Storage Space … Check It and Plan for Growth!

When I moved into my current 3 bedroom home, from my 1 bedroom apartment, I marveled at the amount of space and storage.  I had extra rooms and closets with nothing to put in them.  However, 5 years and 1 … Continue reading

Posted in DBA | Tagged , , | 2 Comments

Red Gate SQL in the City

Free training … free food … I’m there!  That’s what I thought when I first heard about Red Gate’s SQL in the City coming to Chicago (http://sqlinthecity.red-gate.com/).  To me, it felt like a “no brainer” of a decision to make, … Continue reading

Posted in Developer, Training | Tagged , , | Leave a comment

What Should I Be Doing as a DBA?

From time to time, some friends or colleagues I have worked with in the past, either become a database administrator (DBA) or assume some DBA responsibilities.  And they always ask me the same question … what should I be doing … Continue reading

Posted in DBA | Tagged , | 2 Comments