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

Archives: November 2007

The DBA Routine Posted on SSC

This was fun to write, though it's hard to boil everything down to 10 big steps. I thnk as an industry we tend to forget that there are a LOT of us wearing multiple hats, working solo, just trying to get things done - and while we want to do… Read more

0 comments, 1,431 reads

Posted in SQLAndy on 30 November 2007

MS, kill Begin/End!

It's funny - sorta - how you become used to the quirks of the tools you. I try not to rant too often here on the blog, but seriously, it's time for TSQL to lose the BEGIN/END syntax. It's clunky syntax that I think adds more bugs than it prevents.… Read more

0 comments, 1,397 reads

Posted in SQLAndy on 29 November 2007

Another use of OpenRowSet()

From time to time, I need to dump out the result from a SP, such as sp_lock or sp_who.

Traditionally, I will use

sp_helptext sp_lock

to get the source code and retrieve the column metadata of the result set, and then build a table based on the retrieve column information,…

Read more

0 comments, 1,385 reads

Posted in DBA Philosophy on 29 November 2007

Why Don't People Go to Free Training?

I was having this discussion recently with Shawn Weisfeld, President of ONETUG and it's definitely a frustrating topic. As a former IT manager my team was always pushing to go to a class or a conference to "maintain their skills" but surprisingly few would make time to attend a Code… Read more

1 comments, 1,415 reads

Posted in SQLAndy on 28 November 2007

Google CIO and IT Strategy

CIO Magazine has a interesting article about Douglas Merrill, the CIO of Google. One of the things he dicusses in the article is that if someone can be 10% more efficient by using a Mac, he let's them use the Mac. He goes on to talk about rather than… Read more

0 comments, 1,666 reads

Posted in SQLAndy on 26 November 2007

Community Search vs Brute Force Algorithms

I was reading an interview with Jimmy Wales (the Wikipedia guy) in Selling Power magazine (I have ecletic reading preferences I know) and aside from the stuff about Wikipedia he talked a little about moving into search and how he hoped that by leveraging the lessons learned so far he… Read more

0 comments, 1,345 reads

Posted in SQLAndy on 26 November 2007

Passed 70-431

After putting it off for six months, I finally took - and passed - 70-431 yesterday. I know, I'm probably one of the last ones on board, but I'm kind of a geek and I don't want to sit for an exam until I'm really ready. I've failed two MS…

Read more

2 comments, 1,427 reads

Posted in Tim Mitchell on 25 November 2007

Honeypots in the Database

As a follow up to my post about Cesar Cerrudo's new whitepaper, earlier this month David Litchfield talked about putting honeypots in the database in his blog post, Database tripwires..., to catch someone snooping around. The basic idea for non-Oracle databases is to create some sort of alerting…

Read more

2 comments, 2,136 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 23 November 2007

Whitepaper on Malware to Attack Databases

Cesar Cerrudo of Argeniss Information Security has put out a new whitepaper (.pdf format), Data0: Next generation malware for stealing databases, describing how malware could be crafted to steal information out of databases. For the most part, it stays at a high-level, however, Cesar does give a few example…

Read more

5 comments, 1,948 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 23 November 2007

Buying a New Cell Phone

For the page 10 months or so I've been using a Samsung Blackjack, before that I used various Blackberries for perhaps 5 years. I changed phones because the BB I had didn't offer the ability to tether and working mostly solo it's pretty handy to be be able to connect… Read more

1 comments, 1,414 reads

Posted in SQLAndy on 21 November 2007

Logging Server Reboots - What the Heck MS?

Maybe someone at MS can explain this; they have that nice dialog that comes up after a reboot where you select planned/unplanned, enter a code and a reason. Why don't they auto populate that when a Windows update triggers the reboot without user intervention? A list of the changes applied… Read more

1 comments, 1,388 reads

Posted in SQLAndy on 21 November 2007

SQLSaturday Article Posted on SSC

I wrote up some more notes (in addition to what's available here on the blog) to try to raise the awareness level of what might be possible for a SQL Server event. Article is at http://www.sqlservercentral.com/articles/User+Groups/61534/. Read more

0 comments, 1,364 reads

Posted in SQLAndy on 21 November 2007

Distributed Transaction Issue Msg 7391

I solved an "interesting" issue today. It is about distributed transaction. When I set up transactional replication with immediate updating subscription between two SQL Server 2K5, using

EXEC sp_link_publication @publisher = 'Server1', @publication = 'PubUpdate1',@publisher_db = 'Pub_DB',@security_mode = 0,@login = 'sa',@password = 'sa_pwd'

on Server2, where the updatable subscribtion is…

Read more

1 comments, 3,360 reads

Posted in DBA Philosophy on 21 November 2007


I recently wrote an article on owners vs schemas for SQLTeam thinking that I had this all figured out. So now I am studying for 70-431 and ran across an item on broken ownership chains. This is the problem when a view has a different owner than a table or…

Read more

1 comments, 1,689 reads

Posted in Advice from Aunt Kathi on 20 November 2007

SQLSaturday #2 aka SQLSaturday Tampa 2007

I had dinner with Wes Dumey and Pam Shaw from Tampa last night to share some lessons learned and hear what they had in mind for their implementation. They made the decision to rent space at a hotel, partly out of lack of free venues and partly because the hotel… Read more

0 comments, 1,373 reads

Posted in SQLAndy on 20 November 2007

Physical Fitness

Real life events continue to interfere with my regular posting. However, I would rather deal with them and neglect posting than the other way around. My mother-in-law had full knee replacement surgery last week and we've been helping her out. I've been tending to the children and cooking while my…

Read more

0 comments, 1,553 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 19 November 2007

Giving PASS Chapters Access to Summit Content

I've got a request in to PASS asking them to release 2 of the many sessions that were presented at the most recent Summit to the chapters to be made available for download to their members. Chapters are always looking for content and PASS always needs to market the event,… Read more

0 comments, 1,326 reads

Posted in SQLAndy on 19 November 2007

Pics of SQLSaturday

Visit the blog of Joe Healy, my favorite MS Developer Evangelist to see some pics from SQLSaturday. Joe is amazingly good at fostering interactions between groups all over Florida and he actually managed to take a few decent photos too! Read more

0 comments, 1,342 reads

Posted in SQLAndy on 15 November 2007

Dr Dobbs & Databases

You may not think of DDJ for database info and I'll admit that what they do cover is often a bit off the path most of us SQL Server people follow, but they do have some interesting content that I like because it does take me past my normal SQL… Read more

0 comments, 1,404 reads

Posted in SQLAndy on 15 November 2007

Generate RPC:Completed Event

I was doing a research on SQL trace regarding RPC:Completed event. So I need to generate a RPC:Completed event first for test, but it seems I cannot(or I do not know how to) do it within SSMS quickly.

So I create a quick VBScript to do this for me:

dim… Read more

0 comments, 1,652 reads

Posted in DBA Philosophy on 14 November 2007

Older posts