Bob Pusateri
open-menu closeme
About
Community
Contact
twitter mastodon linkedin github rss
  • T-SQL Tuesday #008: Gettin’ Schooled

    calendar Jul 13, 2010 · TSQL Tuesday  ·
    Share on: twitter facebook linkedin copy

    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 …


    Read More
  • Elevator Etiquette

    calendar Jul 9, 2010 · Thoughts  ·
    Share on: twitter facebook linkedin copy

    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 …


    Read More
  • Review: MozyHome Remote Backup

    calendar Jul 8, 2010 · Cloud Storage Software  ·
    Share on: twitter facebook linkedin copy

    Note MozyHome no longer exists. I'm leaving this post up for posterity and to show what it was like, as well as my opinion of it at that time. 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 …


    Read More
  • Optimizing for Ad hoc Workloads

    calendar Jul 6, 2010 · Configuration SQL Server  ·
    Share on: twitter facebook linkedin copy

    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 …


    Read More
  • Disaster Recovery Strategies for the Home

    calendar Jul 1, 2010 · Cloud Storage  ·
    Share on: twitter facebook linkedin copy

    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 a few …


    Read More
  • Transactions: Taking The Plunge

    calendar Jun 24, 2010 · SQL Server  ·
    Share on: twitter facebook linkedin copy

    A few days ago Tim Ford (blog | twitter) put forth a challenge to describe a transaction in a non-technical fashion. I could have replied to the post directly, but I figured it would be rather wordy. Instead I decided to follow the lead of Janice Lee (blog | twitter) and write a post about it, providing Tim with a neat …


    Read More
  • More Than An Output

    calendar Jun 22, 2010 · SQL Server T-SQL  ·
    Share on: twitter facebook linkedin copy

    No more than an output to me, but it sure was to SQL Server! This issue kept me busy over the weekend, and most definitely gave me a case of Saturday Night SQL Fever (as opposed to "SQL Saturday Night Fever", for which the only cure is more karaoke). When executing a stored procedure with an OUTPUT parameter, …


    Read More
  • Why My Newest Laptop Is A Mac

    calendar Jun 10, 2010 · Hardware Thoughts  ·
    Share on: twitter facebook linkedin copy

    I've never been a fan of Apple. Despite making a living off SQL Server, I don't consider myself to be a Windows fanboy by any stretch of the imagination either, but I never imagined that I would buy a Mac. One of the easiest arguing points back in the day was the availability of software. Games on a mac? There was that …


    Read More
  • T-SQL Tuesday #007: My Favorite 2008 Feature

    calendar Jun 8, 2010 · Indexing SQL Server TSQL Tuesday  ·
    Share on: twitter facebook linkedin copy

    This post is my contribution to T-SQL Tuesday #007, hosted this month by the SQLChicken himself, Jorge Segarra (Blog | Twitter). Since I'm a bad DBA and have yet to get my hands on a copy of R2, I'll make use of the rule that we can discuss any feature from 2008. My favorite is filtered indexes, as they were the …


    Read More
  • Tips for Upgrading SQL Server Versions

    calendar Jun 4, 2010 · SQL Server  ·
    Share on: twitter facebook linkedin copy

    At my previous employer I took part in several projects that involved migrating databases not only to new hardware but also to new versions of SQL Server. We upgraded machines running the 2000 and 2005 versions of SQL Server to 2008. Here's how we went about doing it, and some helpful hints we figured out along the …


    Read More
    • ««
    • «
    • 25
    • 26
    • 27
    • 28
    • 29
    • »
    • »»

Bob Pusateri

Data and Kindred Subjects
Microsoft MVP
Friend of Redgate
Microsoft Certified Master

Newsletter

Subscribe Here

Recent Posts

  • Finding Install Media on an Azure SQL Virtual Machine
  • How To Remember SQL Clause Ordering
  • Building A Redirect Service with Cosmos DB and Azure Functions
  • New and Improved - Now With Static!
  • Presenting at PASS Data Community Summit 2021!

Tags

SQL-SERVER 82 SPEAKING 37 SQL-SATURDAY 37 TSQL-TUESDAY 37 THOUGHTS 36 PASS-SUMMIT 34 COMMUNITY 33 EVENTS 27 PRESENTATIONS 17 T-SQL 12 PERSONAL 10 SOFTWARE 10 TOOLS 10 PROFESSIONAL-DEVELOPMENT 9
All Tags
24-HOURS-OF-PASS1 ARTIFICIAL-INTELLIGENCE1 AUDITING1 AZURE-DATA-STUDIO4 AZURE-FUNCTIONS1 AZURE-SQL-DATABASE1 AZURE-VMS2 BACKUP2 BACON8 BIG-DATA-CLUSTERS1 BLOGGING3 BOOK-REVIEW3 CERTIFICATION2 CHICAGO-SQL-ASSOCIATION2 CLOUD-STORAGE8 COMMUNITY33 COMPRESSION2 COMPUTING2 CONFIGURATION3 COSMOS-DB3 DATA-SETS1 DATA-TYPES2 DESIGN3 EIGHTKB1 EVENTS27 FILEGROUPS1 HARDWARE4 HIGH-AVAILABILITY1 HUGO1 INDEXING3 INTERVIEWING3 LINUX1 LITERATURE2 MICROSOFT-CERTIFIED-TRAINER1 MVP1 OFF-TOPIC1 PASS4 PASS-SUMMIT34 PERSONAL10 POWERSHELL7 PRESENTATIONS17 PROFESSIONAL-DEVELOPMENT9 RECOVERY-MODELS1 SECURITY1 SNAPSHOTS1 SOFTWARE10 SPEAKING37 SQL-SATURDAY37 SQL-SERVER82 SQLBITS3 SSMS6 SSRS1 T-SQL12 THOUGHTS36 TIPS-TRICKS3 TOOLS10 TRAINING1 TSQL-TUESDAY37 USER-GROUPS4 VIDEO-CONVERSION2 WINDOWS1 XML2
[A~Z][0~9]
Bob Pusateri

Copyright 2010 -  Bob Pusateri. All Rights Reserved

to-top