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

Archives: April 2008

Review of Pro SQL Server 2005 High Availability

I grabbed Pro SQL Server 2005 High Availability by Allan Hirt recently to add to the library and I've been pleased with it even though it's expensive as books go, close to $60. Really good coverage of everything you need to know to figure our your HA strategy, with lots… Read more

0 comments, 1,352 reads

Posted in SQLAndy on 30 April 2008

Building Raffle Tickets for SQLSaturday

Raffle tickets have become a mainstay of our events, making it easy to handle the large volume of items donated by our sponsors. Back in SQLSaturday #1 they looked more like business cards due to time constraints, but as we've learned and had time to reflect we've been upgrading here… Read more

0 comments, 1,603 reads

Posted in SQLAndy on 29 April 2008


I've never been much of a mentor to people, partially not having the chance, partially focusing too much on myself, and partially, well, I haven't thought aobut it enough.

However I've had some discussions with Andy Warren lately about mentoring and I always find them interesting and intriguing. He's actively… Read more

0 comments, 2,020 reads

Posted in The Voice of the DBA on 29 April 2008

More on Mentoring

Two weeks ago I did five posts on mentoring, and based on that I received a couple interesting notes, here is one, posted with the permission of the sender:

"I have been in the position of having a mentor.  A good mentor is the best friend and guide… Read more

0 comments, 1,364 reads

Posted in SQLAndy on 28 April 2008

SQLSaturday #3 Jacksonville - Final Reminder!

Just checked the registrations and we're at 354, with plenty of room for more! Brian has been busy tweaking the schedule and getting his crew of volunteers ready to go, Friday they'll be buying all the stuff needed to make the event happen. There are some really great sessions on… Read more

0 comments, 1,345 reads

Posted in SQLAndy on 28 April 2008

Visiting the Space Coast .Net Users Group in June

My friend Ken Tucker invited me to speak on June 11, I'll be doing a short presentation on SQL performance and then trying to answer as many questions as I can with the goal of showing developers how and why the DBA's make such harsh demands of developers:-) It'll be… Read more

0 comments, 1,560 reads

Posted in SQLAndy on 28 April 2008

Orlando Heroes Launch Event

I attended this on Friday along with fellow oPASS members Mike Antonovich and Ulysses Vasquez to represent PASS, and we were joined at the community table along with Shawn Weisfeld of The Orlando .Net Users Group and Ken Tucker of The Space Coast .Net Users Group. We saw… Read more

0 comments, 1,504 reads

Posted in SQLAndy on 27 April 2008

SQL Server in the Cloud

The April 15, 2008 edition of SDTimes (PDF download here) has some information about SSDS, the SQL Server in the cloud that was announced not long ago (and still in private beta). I'll mention a couple points here, but worth reading the article!

  • Says that it doesn't use…

Read more

0 comments, 1,481 reads

Posted in SQLAndy on 27 April 2008

Gotta love the Information Age

First it was CNN 24x7.  Next the Internet brought us live information from around the globe.

Now this...  real-time pizza tracking...

Read more

1 comments, 1,428 reads

Posted in Tim Mitchell on 27 April 2008

Recent slate of IIS attacks - more info

The recent slate of attacks on IIS servers don't seem to be an attack directly against IIS or against SQL Server itself. In other words, they aren't going after vulnerabilities in the server product (either one). Rather, the attacks are targeting weaknesses in the web application which permit SQL Injection… Read more

I've got a date with an Error Log -- Error Logs Part II

Error Logs Part II -- Enumerating the error logs

In my first post on SQL Server Error Logs, I briefly mentioned using xp_enumerrorlogs to list the archived error logs. Here I want to demonstrate how to use the procedure to find and output all error logs since a specific… Read more

Cursors and high gas prices

Using cursors is a controversal topic. As a former developer, that is the way I thought about processing data at one time. I gave a talk to a VB group a couple of years ago where I compared using cursors, correlated subqueries, etc., to other techniques to show the performance differences. A lively… Read more

0 comments, 1,379 reads

Posted in Advice from Aunt Kathi on 25 April 2008

More LINQ Discussion

Steve Jones recently posted an editorial about LINQ and the resulting discussion encapsulates most of the points of view on the topic. The biggest problem "we" have is we just don't have a good picture of the time savings for developers using LINQ (and I really mean LINQ to SQL)… Read more

0 comments, 1,768 reads

Posted in SQLAndy on 24 April 2008

Tribute to Jim Gray

Ran across this in the Mar/Apr ACM Queue, http://www.eecs.berkeley.edu/IPRO/JimGrayTribute/ will be held at UC Berkeley on May 31st, 2008. Jim Gray was a Microsoft researcher that focused on databases and was lost at sea some time ago. Read more

0 comments, 1,352 reads

Posted in SQLAndy on 24 April 2008

Desktop or Laptop

Most of that do any time of training or consulting typically use laptops, and they are even reasonably common in the corporate world - even for those that have 'desk' jobs. I have a couple desktops at home, but I've used a laptop for work for close to 9 years… Read more

0 comments, 1,605 reads

Posted in SQLAndy on 23 April 2008

Interesting Web Hosting Option

Ran across this from Mosso, a spin off from Rackspace. Pricing looks very attractive, and there are some interesting twists. One is that you can run PHP/ASP.Net on the same server, no problem. You can get SQL Server for another $5 a month (hosting starts at $100 and includes… Read more

0 comments, 1,704 reads

Posted in SQLAndy on 22 April 2008

Difference between truncate and delete

This is an old topic and well documented, just google it and I believe you will get a lot,

However, there is one difference that seems not being mentioned and actually I find it out myself only two hours ago. So here is the point

If a table is published… Read more

0 comments, 2,103 reads

Posted in DBA Philosophy on 22 April 2008

SQL Saturday - Jacksonville

I am fairly new to the IT profession, so I think my blog will be great for others trying to get their break.  I have always used blogs as a great source to find answers to my numerous questions.  So, I hope my blog can be used similarly. Read more

0 comments, 1,533 reads

Posted in Devin Knight on 22 April 2008

SQLSaturday #4 in Orlando - With a Twist!

As you may know MS Teched is two weeks this year and is being held in Orlando. Turns out that they have it leased for two full weeks, but nothing planned for the middle weekend. That presented an opportunity for the local MS communities to do something with the space.… Read more

0 comments, 1,324 reads

Posted in SQLAndy on 22 April 2008

Where are Profiler User Defined Templates Stored?

Someone asked me this recently and I really had no idea. Quick look in BOL didn't yield any results, so curiousity won out. First step was to use Profiler to monitor while I created a new template (with the standard like '%profiler% filter removed!) and didn't see anything. Loaded FileMon Read more

0 comments, 1,753 reads

Posted in SQLAndy on 21 April 2008

Older posts