Click here to check if anything new just came in.
November 19 2008
Voting for the PASS Board
I got the email with a Zoomerang survey to vote for the PASS board. All are excellent candidates, but ultimately, I could only vote for 3. My choices look like I'm stealing from Steve Jones, but I'm not. I voted for 3, but the 3rd choice were really hard. Two were not. Here are those easy ones:
Andy Warren - I know Andy. Every time we see each other I spend a lot of time picking his brain...
November 18 2008
Checkout the PASS Web Site
Have you seen the PASS web site lately? I'll have to admit that before today I had not looked at it in a long time. To be honest, I was not all that impressed with it in the past. But NOW.... WOW! MUCH Improved!
As of this writing, it is still in "Beta" which I guess is the new, hip way to say "under construction". I've noticed that the official Dilbert web site has been in Beta for...
SQLPass 2008: The PASS Summit - Day Two
SQLblog.com - The SQL Server blog spot on the web
Introduction
"Hey Andy? What happened to your Day One post?" Excellent question. I was going to post a Day One post - really I was - but I got side-tracked. I won't mention any names, but I will blame the major offenders by their Twitter handles: @BrentO, @sqlagentman, and @SqlBatman.
These gentlemen forced me - through coercion and peer pressure (you teenagers take note) - into joining them...
My reasons for upgrading to SQL Server 2008
SQLblog.com - The SQL Server blog spot on the web
I gave a presentation this morning to my bosses and co-workers explaining some of the benefits of upgrading to SQL Server 2008. I thought it might be useful to some of you if I shared my reasons for recommending this upgrade even if the cost is daunting.
(Of course, it would be much easier to always stay on the newest version if there were some kind of rolling upgrade licensing in effect; for o...
PASS Volunteer Session
If I’ve missed anything, my apologies, I’m writing this as fast as people are talking.
Chapter News
Greg Low
- DVDs of past conferences
- Four physical mailings a year of PASS related news
- Part of a huge group of professionals:
62 US chapters, 70+ chapters outside of the US
Program
Lynda Rab
- Speaker and abstract management system
- Program to develop new speakers for PASS
- Upcoming speaker resource...
Performance (How is my SQL Server running?)
In a previous entry I talked about how you should pressure management to purchase SQL Server monitoring tools. This in my eyes is important for more than just the fact you can see quickly when you have problems on your instances but also because we as any associate working for the company that was kind enough to employ us is a business entity. That means we need the business to run with...
How many mirrored databases can I have on a server?
Theo gegen den Rest der Welt
So langsam kommt in der Sache Zwanziger ./. Weinreich doch was von der klassischen Presse:
- Frankfurter Rundschau - “Zwanzigers verbissener Kampf”
Zwanziger, der skrupellos genug war, zur Begründung seiner Reaktion in einem Interview mit Oliver Fritsch auf einen Besuch in Yad Vashem zu verweisen, blieb eigentlich nur der Notausgang.
Das muss ihn mächtig gewurmt haben. Jedenfalls unternahm der DFB nun eine letzte Kraftanstrengung, um die Niederlage in einen Sieg umzudeuten.
…
Damit ist amtlich, dass der DFB Rabulisten beschäftigt - Wortverdreher. - Frankfurter Rundschau, Kommentar - Wahrheiten
Kritische Geister wie Weinreich gibt es im Sportjournalismus eine Handvoll. Sie sind unter Funktionären nicht wohlgelitten, klar. Neu ist der Versuch, sie als Hetzer zu brandmarken und so ihre Geschäftsgrundlage zu zerstören. Die Blogger, deren gewachsene Bedeutung der DFB sträflich unterschätzte, haben das erkannt und üben Solidarität. Sportjournalisten sollten ihrem Beispiel folgen. - n-tv.de - Der DFB blamiert sich
Bewusst falsch dargestellt wurde hingegen, dass Weinreich die Aussage grundlos getroffen habe.
…
Und dies ist beileibe nicht die einzige Falschaussage in der Pressemitteilung, in der der DFB seinem Präsidenten öffentlich beispringen wollte. Genau das macht die ganze Angelegenheit so unfassbar … Damit kann jedermann jederzeit jeden einzelnen der vielen sachlichen Fehler, die der Medienjournalist Stefan Niggemeier wie auch Weinreich schlicht Lügen nennt, bei Bedarf mit Fakten widerlegen. - Stuttgarter Zeitung - DFB-Präsident Theo Zwanziger und der Demagogenstreit
Es ist ein geradezu dreister Versuch, wieder die von Zwanziger so oft erwähnte “Kommunikationsherrschaft” zu erlangen. Es ist ein Schreiben aus der DFB-Welt, offensichtlich einem Paralleluniversum außerhalb des Rechtsraums. - Die Zeit - Ach, Theo
Weil der Theo viele wichtige Leute im DFB und andere Journalisten kennt, hat er den Text mit der Geschichte von der Entschuldigung auch an die geschickt. Theo will nämlich, dass der DFB die “Kommunikationsherrschaft“ erlangt. Weil der DFB immer bestimmt, welcher Journalist eine Karte für ein Länderspiel bekommt und wer nicht, mögen ihn viele Journalisten. Ob Jens noch mal so eine Karte bekommt? - Süddeutsche Zeitung - Was ist ein Demagoge?
Im September und im Oktober versuchte Zwanziger, vor dem Landgericht und dem Kammergericht Berlin das Unterlassungsbegehren durchzusetzen - ohne Erfolg. Mehrere Blogs begleiteten die Auseinandersetzung ausführlich. Die DFB-Pressemitteilung erwähnt die beiden verlorenen Gerichtsentscheide pikanterweise nicht.
Nur das Leitmedium Spiegel Online, sonst gerne auf jedem Trittbrett dabei, lässt seltsamerweise auf sich warten und erwähnt die Angelegenheit mit keinem Wort.
PASS Summit 2008 Monday Recap
Amazing Presentation by Itzik Ben-Gan
I registered for the Advanced T-SQL Querying & Programming in Microsoft SQL Server 2005 & 2008 at the last minute this morning and I was a little worried that I wasn’t going to be able to get in. Turns out that I had every reason to worry - the presentation room was packed, and with good reason.
Itzik is an amazing presenter. He’s obviously passionate about h...
PASS Summit 2008 Monday Recap (#sqlpass)
Great SSIS Boot Camp by Brian Knight
Brian’s a fantastic presenter - really funny, really engaging, and can answer questions on his feet. The one-day presentation was a great way to get started, and I ordered his Professional SSIS 2008 book to answer my questions as I start digging into SSIS.
One indicator of a good presentation style: people follow along and ask questions, and the presenter’s a...
Now on Twitter
A comment recently asked if I am on Twitter. Well I wasn't but I am now. Not sure what exactly I plan to do with it, but I can post short blurbs on what I am doing at the moment throughout the day I guess.
http://www.twitter.com/jmkehayias
I try to keep my online information business oriented and professional, so don't expect a whole lot of random rambling on there, but we'll see where it g...
The first day of PASS
The conference started with a bang with a full day workshop with Itzik Ben-Gan on advanced T-SQL querying and programming. The advanced adjective wasn’t a joke, if anything it was an understatement.
The workshop started with a look at the OVER clause, new in 2005 and unfortunatly not enhanced in 2008. Itzik covered the OVER clause as it applies to aggregates and also how it works with the...
November 17 2008
More Thoughts on SSIS Twitter Integration at #sqlpass
Yesterday, Andy Leonard and Jessica Moss announced that their Wednesday 3pm class on SSIS scripting will cover Twitter integration. In today’s SSIS Boot Camp by Brian Knight, I spoke with some DBAs about the Twitter idea. The initial reaction has been, “Why would you want to do that? Twitter is so unreliable.”
True: us database administrators are conditioned to working with extremely reliable ...
SQL 2008 : CDC - Change Data Capture
CDC has excellent potential in load systems e.g. for data warehousing etc.
It can be used to capture changes on tables or just columns.
exec sys.sp_cdc_enable_table
[ @source_schema = ] 'source_schema',
[ @source_name = ] 'source_name' ,
[ @role_name = ] 'role_name'
[,[ @capture_instance = ...
Should You Redesign Your Website to 800x600 – Or Wait For Netbook Makers to Wake Up and Give Us Decent Screens?
Oh, size issues again… Size Matters – said yours truly back in April, before returning the very first eee PC after only a day:
I could get used to the screen size, my fingers would learn to deal with the keyboard, but it’s impossible to browse the Net with this thing. The problem is that most websites are designed for larger resolution, and the eee can only display part of a page. Vertical...
Updated Index Defrag Script (2005, 2008)
Thanks to everyone who left a comment or sent me an e-mail regarding the Index Defrag Script. I’ve received some great feedback and requests for features. I’ve also had some questions regarding how to use it, which I will answer at the end of this post.
Changes include:
- separate version for both Enterprise and Standard editions
- Standard edition removes partitioning and online...

