Archives

It's Not Too Late To Sign Up for a Precon

This is just a quick reminder that I and two of my friends are presenting Precons tomorrow for SQL Saturday Dallas. While I am biased and think that you should sign up for mine, any of these sessions are a huge educational value. If you’re in the DFW area, do yourself a favor and attend [...]

Why I Chose to Become a Business Intelligence DBA

Recently I’ve received several emails with the same basic theme. I was sought out because I am a Business Intelligence Consultant and they want to know whether the career would be good for them. Well, it’s hard to read a short synopsis of someone’s experience and recommend a life altering directional change. So, I decided [...]

Stop Writing Visual FoxPro Reports... Today

Last week I saw a discussion on the LinkedIn Made2Manage Group about the Pros and Cons of using SSRS vs. VFP Reporting, and it amazes me that people are still arguing about it. So, I thought I’d reaffirm a stance that I’ve had for many years, which is VFP Reporting Must Die.

I’ve [...]

Opening SSRS Reports Automatically From Other Systems

Users typically love SQL Server Reporting Services Reports (SSRS), especially if they’re accustomed to more primitive tools such as Visual FoxPro. However, One of the biggest complaints I hear about SSRS is that users want to be able to launch it directly from their ERP, accounting, and other systems. A conventional way to do this [...]

Drawing a Blank. Dealing With Blank Values in SQL Server using NullIf and Coalesce

“Melodical Murray is a human musical instrument; he makes music by blowing his…blank” – Match Game

In the previous article I discussed the issues when working with Null-able fields in Joins and Where clauses. This article will deal with the problems of blank values.

What About Blanks?

Many systems forego the use of Null-able fields, but [...]

I Don’t Know! Deal With It! (Nulls)

This topic has been done to death in many places, but I still get frequent questions about Null field issues in T-SQL. My purpose in this article is not to debate the definition of Null. Smarter men than I have already done so.

SQL Server Books Online indicates “A value of NULL indicates that the [...]

Ooh! Ooh! Pick Me!

Pick Me Mr. Kotter!

SQL Rally is a brand new event for this year. It’s kind of a hybrid between the PASS Summit and a SQL Saturday. It’s fairly low cost and being held May 11-13 in Orlando, Florida.

Anyway, the reason for this post is completely self serving. I really want to present at [...]

SQL Saturday Dallas #56 Re-Cap

Ryan, Vic, and yours truly.

SQL Saturday #56 BI Edition went off without a hitch last Saturday. Those who read this blog, probably remember the awesome experience I had at my first SQL Saturday.

Once again, everything went wonderfully. Our event was scaled back this time which translated into fewer hassles. Microsoft and Artis [...]

SQL Server Maintenance Plans for Small/Mid-sized Businesses

I get a ton of questions and calls about SQL Server Maintenance issues from Administrators who just want their server to work and be protected. They’re not interested in the intricate structure of a transaction log, how to use wait stats, etc. While many database administrators who read this article will disagree or perhaps outright [...]

Using User Defined Functions to Pre-Format Fields

Some DBAs would cringe at what I’m about to tell you, but I often use T-SQL to format my data prior to presenting it in a report. Many experts feel that data formatting should always be done in the presentation layer. There are a couple of reasons why I do this.

I re-use as much code [...]

Page 1 of 212