Bob Pusateri
open-menu closeme
About
Community
Contact
twitter mastodon linkedin github rss
  • UPDATEs That Really Aren’t

    calendar Oct 20, 2010 · SQL Server  ·
    Share on: twitter facebook linkedin copy

    A long time ago I can remember wondering what happens when you try to update a value by setting it equal to itself – whether the database engine will actually carry out the update or just ignore it. At the time I didn't think much of it, but it popped into my head again last week and I decided to find out. I'm sure I'm …


    Read More
  • Book Review: Dr. Deming

    calendar Oct 15, 2010 · Book Review  ·
    Share on: twitter facebook linkedin copy

    This was the first non-database related book that I've read in a long time, and its full title is actually "Dr. Deming: The American Who Taught the Japanese About Quality". I was expecting to read about the life of W. Edwards Deming, but instead the book was more of a summary of his teachings and management …


    Read More
  • Two Myths About ‘Lock Pages in Memory’

    calendar Oct 12, 2010 · Configuration SQL Server TSQL Tuesday  ·
    Share on: twitter facebook linkedin copy

    This Month’s T-SQL Tuesday topic comes from Sankar Reddy (twitter) and he’s asking for SQL Server myths and misconceptions to be de-bunked. I’ve got 2 myths I’d like to set the record straight about. They’re rather closely related, and concern the "Lock Pages in Memory" setting. What’s it do? Without getting into an …


    Read More
  • Review: The Social Network

    calendar Oct 6, 2010 · Thoughts  ·
    Share on: twitter facebook linkedin copy

    When I started this blog I had zero intention of reviewing movies. I wanted to stick to technical topics with perhaps a few book reviews in-between. That goal hasn’t changed, but after seeing “The Social Network” this past weekend I decided an exception would be appropriate. In my opinion, the SQL Server community gets …


    Read More
  • Savepoints: The Other Other White Meat

    calendar Sep 29, 2010 · SQL Server T-SQL  ·
    Share on: twitter facebook linkedin copy

    Most T-SQL guides and tutorials I've seen concentrate on the following transaction commands: BEGIN, COMMIT, and ROLLBACK, which I'll henceforth refer to as the "big three". While they're certainly very important, there's also a fourth command, SAVE, which is typically treated like a distant cousin who's only …


    Read More
  • SQL Saturday #50 Wrap-up

    calendar Sep 21, 2010 · Speaking SQL Saturday SQL Server  ·
    Share on: twitter facebook linkedin copy

    I had the immense pleasure of speaking at SQL Saturday #50 in Iowa City this past weekend. To say it was an awesome time would be quite the understatement. Special thanks to Michelle Ufford (blog | twitter), Ed Leighton-Dick (twitter) and Jeff Belina (twitter) for all you did to make this event possible. Also a giant …


    Read More
  • Potty Chairs and Duplicate Indexes

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

    This post is my contribution to T-SQL Tuesday #10, which is being hosted by Michael J. Swart (blog | twitter) Each year my Boy Scout troop has a rummage sale as a fundraiser. All the scouts and their families gather up their old clothes, books, toys, electronics, and any other treasures they no longer need and donate …


    Read More
  • A Look at the SQL Server Browser Service

    calendar Sep 1, 2010 · SQL Server  ·
    Share on: twitter facebook linkedin copy

    Let's say you're starting off in a new environment (new job, department, client, whatever) and after being shown your workspace and meeting with your supervisor, you sit down to start figuring out their databases. You send an email requesting the name of the development database, and the reply you get is as follows: …


    Read More
  • Speaking at SQLSaturday #50: East Iowa 2010

    calendar Aug 25, 2010 · Presentations SQL Saturday SQL Server  ·
    Share on: twitter facebook linkedin copy

    I feel extremely honored to have the chance to speak at SQLSaturday #50, which is taking place in Iowa City on September 18th. The organizers have put together a great schedule consisting of some amazing speakers and somehow I got on the list too! I'll be giving a talk called "Application Coding Sins." As …


    Read More
  • Four Reasons Not To Learn The Dvorak Keyboard

    calendar Aug 19, 2010 · Hardware Thoughts  ·
    Share on: twitter facebook linkedin copy

    In my previous post I looked at 4 reasons to learn the Dvorak Simplified Keyboard (DSK). I'll now take a look at the other side and give you 4 reasons why you might not want to.

    1. You're Already A Good Typist If you're reading this, chances are pretty good you're a DBA, developer, consultant, or someone else who makes …


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

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