SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: March 2008

Schedule Announced for SQLSaturday#3 in Jacksonville

Brian has just posted the schedule of sessions for SQLSaturday #3. I haven't gone through to see how many are SSC regulars, but I noticed Brandie Tarvin, Brian Kelley, and Tim Mitchell. Registration still climbing, over 170 registered so far. If you're planning to attend, tell your co-workers! One… Read more

0 comments, 1,304 reads

Posted in SQLAndy on 31 March 2008

T-SQL Course

I am here in sunny Orlando at End to End Training. I am very impressed with the new training facility. Andy has reported on all the work that went into get this new facility going and it has been well worth it. I am working with a group of 8 very… Read more

0 comments, 1,343 reads

Posted in Advice from Aunt Kathi on 31 March 2008

Practices Does Make a Difference When Speaking

As I've mentioned a couple times previously I teach a free 'how to be a speaker' course, mainly to encourage those that want to speak at our local user group to take that next step. We focus on a lot of the mechanics and less on true public speaking items,… Read more

0 comments, 1,350 reads

Posted in SQLAndy on 30 March 2008

SQL Saturday

I've just received notice that I will be a presenter at the upcoming SQL Saturday event in Jacksonville, Florida. I'll be speaking about the SQL SMO object namespace and how this powerful set of classes can be used to administer SQL Server instances programmatically.

I'm looking forward to this opportunity.… Read more

0 comments, 1,490 reads

Posted in Tim Mitchell on 30 March 2008

How Should It Work?

I was following a debate on the new Merge syntax in SQL Server 2008 with interest. It was somewhat of a debate about hot things should work, what happens with NULLs, etc. Now I don't want to recreate it here, but one thing was interesting to me. What would you… Read more

0 comments, 1,474 reads

Posted in The Voice of the DBA on 28 March 2008

Shhhh!! Be vewy, vewy quiet. I'm hunting Select *!!

"Select *" is bad. Everyone knows it, but everyone still uses it. I use it. Most of the time it is fairly innocuous. No harm, no foul, right?

Updating your procedures to not use Select * can be a daunting task. Here's a tip to help you work smarter, not… Read more

Shhhh!! Be vewy, vewy quiet. I'm hunting Select *!!

Who's bad?

"Select *" is bad. Everyone knows it, but everyone still uses it. I use it. Most of the time it is fairly innocuous. No harm, no foul, right?

But what about those precious milliseconds lost sending data across the network to client applications? That's where you start to… Read more

More Code Per Module = More Bugs, But More Complex Code <> More Bugs?

SDTimes has an article up about Debunking Cyclomatic Complexity that talks about the results of some research that supports what I suspect most of agree with - more lines of code per module/method leads to more bugs. Object oriented program has done a great job in leading away from procedures… Read more

0 comments, 1,469 reads

Posted in SQLAndy on 28 March 2008

The Shadow Knows What Procedures Lurk in the SQL Plan Cache

How do you know what procedures are cached in SQL Server? Simple, just ask, and SQL Server will tell you.You can query the SQL Server dynamic management views to get a list of procedures in cache. In this example, I query sys.dm_exec_cached_plans and sys.dm_exec_sql_text:

Select object_name(st.objectid, st.dbid) As ProcedureName
From Read more

More Thoughts on LINQ to SQL

At the recent Orlando Code Camp I had the opportunity to spend a good bit of time discussing LINQ to SQL with Jim Wooley, author of Linq In Action. It was really an interesting conversation. Clearly Jim likes LINQ and sees some opportunities there for developers. As we… Read more

0 comments, 1,639 reads

Posted in SQLAndy on 26 March 2008

Getting Reporting Services to work on Vista

I recently ordered a new laptop and this one came with Windows Vista Ultimate. I knew about having to install SP2 as well as the Vista Provisioning tool, which should be run after the SP2 install. Yes, it can be run after the fact, like if you have the SQL… Read more

Notes About our Raffle of the One Laptop Per Child Laptop at Orlando Code Camp

I've blogged about the OLPC project a couple times already, not as a political statement but just as a fascinating idea based on some interesting technology and a vision - which if bold - could have a long lasting impact on some of the poorest countries in the world. We… Read more

0 comments, 1,339 reads

Posted in SQLAndy on 24 March 2008

Orlando Code Code Follow Up

Although attendance was down this year (around 280 attendees) due to it being held Easter weekend, I thought this was easily the best of the Orlando Code Camps so far. More volunteers, better logistics, and definitely a great site (same as we used for SQLSaturday#1 in Orlando) all combined to… Read more

0 comments, 1,397 reads

Posted in SQLAndy on 23 March 2008

Writing a course

Over the last three years, since that first article I submitted to SQLServerCentral, I find myself getting involved in more and more projects. Recently, I agreed to teach a two day T-SQL course for End to End Training. I have to admit, Steve, Brian and Andy have really helped me… Read more

0 comments, 1,257 reads

Posted in Advice from Aunt Kathi on 21 March 2008

Orlando Code Camp Reminder & A Special Raffle - One Laptop Per Child

Reminder that if you're registered the Orlando Code Camp is tomorrow. If you're registered and plans have changed, please cancel your registration. There's a ton of people on the wait list hoping for a seat at this free event.

I'll be at the Code Camp speaking and representing End to… Read more

0 comments, 1,569 reads

Posted in SQLAndy on 21 March 2008

Denver Heros Happen {Here} Launch

 I went down to the  Denver stop on the Heros Happen Here launch events and as you can tell by this post, I left early. The IT Pro section was in the am and the developer section in the afternoon, but I grew a little tired of the developer keynote… Read more

0 comments, 1,705 reads

Posted in The Voice of the DBA on 20 March 2008

A Minor Rant About Statistics

If you've ever taken a look at the auto generated statistics that SQL builds (typically on non indexed columns when you reference the column in a where clause) you'll see that they are named _WA_Sys...blahblah. But why? A quick search didn't reveal any good answer (though perhaps I just didn't… Read more

0 comments, 1,307 reads

Posted in SQLAndy on 19 March 2008

Another Take on SP3 & Service Packs In General

Had lunch with a friend in the business yesterday that is involved with vulnerability scans for a large company and one of the things he discussed was that service packs are hard for them. On many of their servers they apply fixes of any type only if critical or fix… Read more

1 comments, 1,557 reads

Posted in SQLAndy on 18 March 2008

Utah Code Camp is April 26, 2008

Tjay Belt forwarded me the information about the Utah Code Camp this year. Still early in the process, no schedule posted yet, and the call for speakers is open if you live near by. Read more

0 comments, 1,488 reads

Posted in SQLAndy on 18 March 2008

Reminder - Orlando Code Camp is Mar 22, 2008

Just a reminder that the event is this Saturday. The tentative schedule has been posted and it looks like I'll be doing my presentation as the last one of the day (hopefully that's good). Overall not a lot of SQL content - if you don't count LINQ that is -… Read more

0 comments, 1,459 reads

Posted in SQLAndy on 17 March 2008

Older posts