Archives: November 2009
PASS Update #20
On the Friday at the end of the Summit we had a 4 hour Board meeting, welcoming new board members Brian Moran and Jeremiah Peschka (and newly elected Tom Larock too). Perhaps out of order, one key thing we discussed was when to have our first in person Board meeting… Read more
10 comments, 432 reads
Posted in SQLAndy on 30 November 2009
Linear Gauge Control: A Practical Use
SQL Server Reporting Services 2008 introduced several new features. One key feature was the inclusion of the Gauge Controls. I was recently asked to provide a real-world example of the Linear Gauge Control. After doing a little reading and testing of the linear control I chose my path. I started… Read more
0 comments, 609 reads
Posted in SQLDownSouth on 30 November 2009
SQL Saturday #34/New England Data Camp v2.0
It’s official sports fans. Well, it’s been official since last week since Adam Machanic set up the web site. The New England SQL Server Users Group and the Southern New England SQL Server Users Group are again jointly hosting a full day of SQL Server goodness on January 30th.…
0 comments, 409 reads
Posted in The Scary DBA on 30 November 2009
Are You a Giver or a Taker?
I have been involved in the SQL Server community since 2000, and during the past nine years I have seen hundreds of volunteers donate large amounts of their time to the community. For example:
- DBAs who answer tens of thousands of questions on SQL Server news groups and forums.
- DBAs…
0 comments, 417 reads
Posted in SQL Aloha on 30 November 2009
What’s Using Space in Tempdb?
It happens, not often, but I do regularly see people talking about their tempdb growing too large. Often that means that people have not properly sized tempdb to me, but there could be legitimate reasons why it’s grown large.
This is one reason that I’d like to see a separate… Read more
1 comments, 5,416 reads
Posted in The Voice of the DBA on 30 November 2009
When it rains…
It pours.
I come back from 4 days unwired, a bunch of writing done, to a laptop that’s head, a site that won’t take posts, and a ton of email and articles.
At least my external HDD reader is reading the drive. I’m copying stuff off now, but it’s not… Read more
2 comments, 414 reads
Posted in The Voice of the DBA on 30 November 2009
XQuery For Idiots
I’m still struggling with learning XQuery. My latest little revelation was small, but vital.
The difference between:
@inXML.nodes('/rss/channel/item')
and
@inXML.nodes('/rss[1]/channel[1]/item')
Is the difference between a 10 minute query and a 4 second query. Kind of shocking really. My understanding is that XQuery assumes there are multiple possible paths that look…
0 comments, 546 reads
Posted in The Scary DBA on 30 November 2009
SQL Server XQuery For Idiots
I’m still struggling with learning XQuery. My latest little revelation was small, but vital.
The difference between:
@inXML.nodes('/rss/channel/item')
and
@inXML.nodes('/rss[1]/channel[1]/item')
Is the difference between a 10 minute query and a 4 second query. Kind of shocking really. My understanding is that XQuery assumes there are multiple possible paths that look…
0 comments, 438 reads
Posted in The Scary DBA on 30 November 2009
TechNet WebCast: SQL Server Locking & Blocking
Next Monday, I’m presenting a TechNet WebCast for Microsoft Thrive Live! The subject: SQL Server Locking & Blocking Made Simple. Here are the details:
Event Overview
A good working knowledge of how Microsoft SQL Server makes use of locking and transaction isolation levels can help you greatly improve an application’s…
0 comments, 412 reads
Posted in Joe Webb on 30 November 2009
My first useful powershell script – capturing performance counters
After playing around with powershell a bit, I managed to do something quite useful. There are a multitude of ways to capture performance counters but I think this will have the advantage of being able to be fired by SqlAgent (or another timer process) every X many seconds. All you… Read more
0 comments, 534 reads
Posted in Dave Ballantynes blog on 30 November 2009
Unwired
I didn’t have Internet access for 4 days while we were in the mountains. Actually I could have purchased it, but for uploading blogs it didn’t seem like a great idea. Plus I’d be tempted to work if I did that.
So I did some offline blogging, but for the… Read more
1 comments, 427 reads
Posted in The Voice of the DBA on 30 November 2009
Maintaining Security and Performance Using Stored Procedures Part II – Signing
0 comments, 498 reads
Posted in Wise Man or Wise Guy on 30 November 2009
SQL Saturday Dallas – Registration and Call for Speakers is Open!
I’m happy to announce that SQL Saturday Dallas is officially scheduled, and the registration and call for speakers is open. This event will be held on Saturday, May 22, 2010, at the Region 10 Education Service Center in Richardson.
We’ll be accepting session abstracts until the middle of February,… Read more
1 comments, 418 reads
Posted in Tim Mitchell on 30 November 2009
OT: Maximizing My Time, Using Technology
Well I've taken the plunge. I have finally broken down and decided to dictate blog post, articles, and other documents. Speech recognition has come a long way over the years, and it's time I make use of it. Does that mean I'm getting typing altogether? Not exactly. One of the… Read more
3 comments, 418 reads
Posted in SQL Man of Mystery on 30 November 2009
More News About AMD’s 2010/2011 Server Roadmap
AnandTech IT has an interesting post up that looks at the roadmap for AMD in the server arena for 2010/2011. The gist of it is that AMD may be competitive with Intel in some parts of the market (two-socket servers), which is very good news for the industry. If Intel… Read more
2 comments, 506 reads
Posted in Glenn Berry's SQL Server Performance on 30 November 2009
Columbia Code Camp!
The Midlands of South Carolina will be hosting a Code Camp on January 30, 2009. You can register as an attendee, submit a session, or sign-up to volunteer here:
The Code Camp is being run by the Columbia Enterprise Developers Guild, our .NET sister guild… Read more
0 comments, 543 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 30 November 2009
Teaching SQL Server 2008 Class at University of Denver – University College
I will be teaching ICT 4461 SQL Server with Lab starting Tuesday, January 5, 2010. This will be an on-campus class, held in the Josephine Computer Lab. The textbook is Beginning SQL Server 2008 for Developers by Robin Dewson. The ten week class is worth four units in the Master’s… Read more
1 comments, 485 reads
Posted in Glenn Berry's SQL Server Performance on 30 November 2009
Featured Blogger: Rob Garrison
I met Rob via email early this year as a volunteer helping with content for PASS, and I’ve been following his blog since then – always interested to see what people that are willing to volunteer are working on. He’s averaging 2-3 posts a month, and almost all of them… Read more
0 comments, 372 reads
Posted in SQLAndy on 29 November 2009
Link: Top 200 Developer Blogs
Ran across this list a while back, Jurgen posted his Top 200 Developer Blogs list and an OPML file of the results. Some I recognize, a lot I don’t, but I’m going to add them all to my reader for a couple months and see which one I want to… Read more
0 comments, 397 reads
Posted in SQLAndy on 29 November 2009
Kevin Kline on PASS
Brian Moran (incoming Board member) did a nice interview with Kevin, worth reading, and some good stuff about areas where PASS could do better. I’m hoping that as he gets through the adjustment of not being on the Board that Kevin will continue to think and comment on areas where… Read more
0 comments, 397 reads
Posted in SQLAndy on 29 November 2009



Subscribe to latest posts