T-SQL Tuesday #008: Gettin' Schooled

13 July 2010 by Bob Pusateri in SQLServerPedia Syndication , TSQL Tuesday with 3 comments

AIN’T YOU GOT NO BOOKLEARNIN’?  This, the eighth T-SQL Tuesday is hosted by the SQL Soldier, Robert Davis (Blog | Twitter) and he’s asking how we learn and how we teach.

How I Learned

Throughout my school years I seem to have been assigned a disproportionate number of “old-school” teachers who could be extremely harsh, often utilizing [...]

3 comments

Elevator Etiquette

9 July 2010 by Bob Pusateri in Thoughts with 3 comments

And now for something completely different.  I realize there’s probably been countless thoughts, blog posts and jokes on the subject of elevator etiquette, but I think mine’s a little different as it concerns whether or not using the elevator is polite in certain situations.  Allow me to explain:

In college I spent the better part of [...]

3 comments

Review: MozyHome Remote Backup

8 July 2010 by Bob Pusateri in Redundancy , Software with 4 comments

In a previous post, I talked about disaster recovery strategies for the home and promised reviews on the services I use. Today I’ll take a look at Mozy.

I’ve been a satisfied Mozy customer since March of 2007.  I’ve yet to have a bad experience with it, and as I write this I currently have [...]

4 comments

Optimizing for Ad hoc Workloads

6 July 2010 by Bob Pusateri in SQL Server , SQLServerPedia Syndication with 2 comments

One of the nifty features available in SQL Server 2008 is the “Optimize for Ad hoc Workloads” option, which is at the instance level.  If your workload involves a high number of ad hoc queries that are used only once, your plan cache (also known as the “procedure cache”) may benefit from enabling this feature. [...]

2 comments

Disaster Recovery Strategies for the Home

1 July 2010 by Bob Pusateri in Redundancy with 5 comments

A key function of a DBA is to plan, test, and implement disaster recovery policies for the databases they maintain.  DBAs lacking these skills may also find themselves lacking a job if they are unable to recover data when necessary.  For all these skills we apply in the workplace, I have still heard via Twitter [...]

5 comments
« Newer Entries