Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: June 2008

RC0 and HierarchyID

I gave a presentation Tuesday to my local SQL user group on 2008 T-SQL and data types. One of the items covered was HierarchyID. I had a simple but thorough code sample that demonstrated most of the functions. I guess I have been out of the loop lately, because at some point… Read more

1 comments, 372 reads

Posted in Advice from Aunt Kathi on 13 June 2008

TechEd - Execution Plans

Randy Dyess of Solid Quality Mentors had a session and since I'd just gotten a copy of Grant Fritchey's book with the same name, I wanted to check it out.

There are 3 types of plans: graphical, text, and XML.

Graphical is cool, looks good, but it doesn't have enough… Read more

0 comments, 287 reads

Posted in The Voice of the DBA on 13 June 2008

Notes on My Visit To The Space Coast Users Group

I visited the Space Coast group last night, hosted by Ken Tucker, and did about 90 minute of SQL Q&A with a nice group of developers who were all interested in data access (perhaps those not interested didn't attend!). We talked about partitioning, indexing, concurrency, blocking, deadlocks, stored procedure… Read more

0 comments, 232 reads

Posted in SQLAndy on 12 June 2008

Avoid Domain Admin level accounts for SQL Server

Every so often I see a post in the forums where someone has stated they've used a Domain Admin level account to run the SQL Server service. The implications are that anyone who is a member of the sysadmin fixed server role is effectively a domain admin. That means if a developer is a… Read more

TechEd - Day 3

I left my laptop at the Red Gate booth, and then managed to wander up to a Data Compression talk from Sunil A. from Microsoft. It was a great presentation, and despite some extensive reading and researching earlier this year, I learned quite a bit about how it works. There… Read more

0 comments, 259 reads

Posted in The Voice of the DBA on 12 June 2008

SQLSaturday #6 in Cleveland - Registration Open

Long time acquaintance Allen White is hosting SQLSaturday #6 in Cleveland on August 9th. Registration and call for speakers is open, and once he gets back from Tech Ed will start to communicate with sponsors too. One note on the registration; if you're registering just to see what is going… Read more

0 comments, 162 reads

Posted in SQLAndy on 12 June 2008

TechEd - Query Performance

A program manager asked the question at the start:  Who's had a query performance issue where a query "went bad" on the server?

Lots of hands up, and that was one of the things I wanted from this session.

What's reliability? MS sees this as two things

 - Quality: Given… Read more

0 comments, 439 reads

Posted in The Voice of the DBA on 12 June 2008

Presentations using a Panel Format

At the recent SQLSaturday #4 we had a session end up finishing much earlier than expected, so we gave the attendees the option of moving to other sessions or staying for a Q&A session done with a panel up front. I've only done the panel format a couple times and… Read more

0 comments, 228 reads

Posted in SQLAndy on 11 June 2008

TechEd - Data Corruption

I went to this one, mostly because I don't understand coruption that well and Paul Randal is a great speaker. Worth going to see him if you get the chance. 

Run CheckDB. It's important.

You need to know how long checkdb takes to run. Checkdb is optimized to run for… Read more

0 comments, 614 reads

Posted in The Voice of the DBA on 11 June 2008

TechEd - IO and Wait Stats

Andrew Kelley, SQL Server MVP, is a good speaker, so I'd recommend his sessions if you want good technical information.

IO Stats are a snapshot in time since the instance was restarted, so you must have at least two reads to compare the data. Stats are a snapshot. They are… Read more

0 comments, 1,538 reads

Posted in The Voice of the DBA on 11 June 2008

IndyTechFest Update

Just received this from my friend John Magnabosco about the SQL portion of the event:

Business Intelligence Track        - TBD (Arie Jones, Perpetual Technologies)
        - Performance Point Server (Craig Utley, Solid Quality Mentors)
        - Troubleshooting MDX Queries (Craig Utley, Solid Quality Mentors)
        - TBD (Arie Jones,…

Read more

0 comments, 158 reads

Posted in SQLAndy on 10 June 2008

TechED - Building an SOA Data Center

Talking about heterogenous systems, usually legacy systems. How do you move to a new architecture?

You must start with the old systems, often you cannot throw it away and need to mitigate the risks of migration to newer systems. One way of doing this is to rip out the presentation… Read more

0 comments, 248 reads

Posted in The Voice of the DBA on 10 June 2008

How to Do and Not Do Customer Support

I recently purchased a Dell XPS M1530 laptop for use both for professional work (consulting & presentations) and ministry (mostly presentations). Yesterday, as I was at home recovering from a back injury, I noticed that some files were closing a little slower than I remembered. So naturally I checked the… Read more

TechEd - Designing a Global Database

I was going to hit a Powershell lab because the Scripting Guys at TechNet write great columns, but it filled up, so I went to my second choice: Building  a Global Database.

 

What does this mean? If you are building a database that handles all types of languages and… Read more

0 comments, 631 reads

Posted in The Voice of the DBA on 10 June 2008

Provisioning Storage

It's a rite of passage in our business that we have to learn the RAID levels, and I still enjoy the arguments about RAID-5 vs RAID-10, and it seems we still have to keep having the conversation about spindles vs space. But the world is changing with SAN's becoming very… Read more

0 comments, 178 reads

Posted in SQLAndy on 9 June 2008

SQLSaturday #4 Wrap Up

Attendance on Saturday about 450 across the communities (SQL, .Net, DNN, etc). Not as big as we'd hoped, but still a win when you get a chance to provide training and network time for the community. Kudos to Joe Healy for organizing the overall event and getting MS to fund… Read more

0 comments, 159 reads

Posted in SQLAndy on 8 June 2008

Change of Leaders at ONETUG - Adios Shawn!

Shawn Weisfeld has been the President of ONETUG (Orlando .Net Users Group) for the past three years and has just turned over control to Jessica Sterner as he gets ready to move to Dallas for a new job. Shawn has been very active in the community and INETA, and he… Read more

0 comments, 152 reads

Posted in SQLAndy on 8 June 2008

Building Software is Like

I still remember hearing an executive in IT at Virginia Power start a sentence like this, and he went on to say it's like a house before chastising the developers for being slow. I was on the ops team and liked the analogy, finding it funny. Course I hadn't done… Read more

0 comments, 251 reads

Posted in The Voice of the DBA on 6 June 2008

Heroes? Probably Not

One of the big themes this year for Microsoft (and I just saw it on the PASS Summit site) is about IT Heroes. Perhaps I'm just hard to live with today, but I don't think there are too many heroes in IT. We work hard, we make a big contribution,… Read more

1 comments, 213 reads

Posted in SQLAndy on 5 June 2008

Know Your Equipment

Today I ran to the co-location facility for FourDeuce and End to End Training, to upgrade our database server to SQL Server 2005. We've been wanting to do it for awhile, but since most of our SQL code is fairly simple and generic, we haven't needed it.  The old SQL… Read more

0 comments, 230 reads

Posted in The Voice of the DBA on 5 June 2008

Newer posts

Older posts