Archives: June 2008
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
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
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
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
3 comments, 5,721 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 12 June 2008
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
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
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
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
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
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
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,…
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
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
0 comments, 358 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 10 June 2008
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
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
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
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
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
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
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