Swart’s Ten Percent Rule
May 28, 2013
Caption: Success: Ninety percent hard work, ten percent coffee
May 28, 2013
Caption: Success: Ninety percent hard work, ten percent coffee
The Sch-M lock is Evil
Apr 17, 2013
Caption: That guy over there won't share the table with anybody...
Apr 17, 2013
Caption: That guy over there won't share the table with anybody...
Altering Text Columns: Only a Metadata Change?
Apr 03, 2013
Caption: I defined a column as CHAR(MAX) and immediately ran out of space everywhere
Apr 03, 2013
Caption: I defined a column as CHAR(MAX) and immediately ran out of space everywhere
Some Failed Blog Topics
Feb 08, 2013
Caption: Take the clustered scan from the query plan and put it in the tan van
Feb 08, 2013
Caption: Take the clustered scan from the query plan and put it in the tan van
Triggers On Views? What For?
Oct 31, 2012
Caption: Sad Frankenstein's monster is sad. Patchwork creations deserve love too.
Oct 31, 2012
Caption: Sad Frankenstein's monster is sad. Patchwork creations deserve love too.
My Short Struggle With SQL Agent
Sep 27, 2012
Caption: Tell me Mr. Anderson, do you want to run as the SQL Agent Service account?
Sep 27, 2012
Caption: Tell me Mr. Anderson, do you want to run as the SQL Agent Service account?
Sharpshooting Query Plans From The Cache
Aug 28, 2012
Caption: "Only Imperial Stormtroopers are so precise."
Aug 28, 2012
Caption: "Only Imperial Stormtroopers are so precise."
Data Modelling: Composite Relationships
Jul 26, 2012
Caption: I can store your music but I can only guarantee the integrity of the data
Jul 26, 2012
Caption: I can store your music but I can only guarantee the integrity of the data
T-SQL Tuesday #32 – A Day in the Life
Jul 17, 2012
Caption: My databases ran like clockwork once. There were no pages. Inbox zero. Why couldn't I get that day over and over?
Jul 17, 2012
Caption: My databases ran like clockwork once. There were no pages. Inbox zero. Why couldn't I get that day over and over?
Developing on the Right Side of the Brain
Jul 12, 2012
Caption: I'm sometimes guilty of using ten percent of my brain
Jul 12, 2012
Caption: I'm sometimes guilty of using ten percent of my brain
I’m Sharing My Story at SQL Brit’s Site
Jun 13, 2012
Caption: The Last Starfighter: An accidental DBA (Death Blossom Administrator)
Jun 13, 2012
Caption: The Last Starfighter: An accidental DBA (Death Blossom Administrator)
Visualizing Transaction Isolations For SQL Server
Jun 13, 2012
Caption: Locks taken by SQL Server for the standard isolation levels
Jun 13, 2012
Caption: Locks taken by SQL Server for the standard isolation levels
Modifying Tables Online – Part 1: Migration Strategy
Apr 16, 2012
Caption: This is how I feel when I'm running the sp_rename step
Apr 16, 2012
Caption: This is how I feel when I'm running the sp_rename step
I Was Kidding Myself
Feb 27, 2012
Caption: Vizzini: War Starter, Shorty/Meanie, Dizzying Intellect, Not Immune To Iocane Powder
Feb 27, 2012
Caption: Vizzini: War Starter, Shorty/Meanie, Dizzying Intellect, Not Immune To Iocane Powder
Microsoft Model Databases: Some Unconventional Alternatives?
Feb 09, 2012
Caption: Putting your best foot forward
Feb 09, 2012
Caption: Putting your best foot forward
Rebuild Your Indexes Online (When You Can)
Jan 25, 2012
Caption: We can rebuild it online... We have the technology.
Jan 25, 2012
Caption: We can rebuild it online... We have the technology.
CXPACKET? What's That? And What's Next?
Dec 08, 2011
Caption: "Many hands make light work?" or "Too many cooks spoil the brothe?"
Dec 08, 2011
Caption: "Many hands make light work?" or "Too many cooks spoil the brothe?"
Be Quick About Reading The Data You Asked For
Nov 16, 2011
Caption: These two don't yield; They're on a mission.
Nov 16, 2011
Caption: These two don't yield; They're on a mission.
Insights into "Timeout Expired"
Nov 06, 2011
Caption: A timeout always represents server unresponsiveness from the client's point of view
Nov 06, 2011
Caption: A timeout always represents server unresponsiveness from the client's point of view
Secret Santa as a Puzzle
Oct 19, 2011
Caption: Fun tip: The MVP Deep Dives (Vol 2.) is under the spending limit!
Oct 19, 2011
Caption: Fun tip: The MVP Deep Dives (Vol 2.) is under the spending limit!
Power View Demo Good, Not Great
Oct 13, 2011
Caption: "No data was harmed in the preparation of this demo" ~Amir Netz
Oct 13, 2011
Caption: "No data was harmed in the preparation of this demo" ~Amir Netz
Artificial Intelligence versus SQL Server Help
Sep 21, 2011
Caption: "I am putting myself to the fullest possible use, ..."
Sep 21, 2011
Caption: "I am putting myself to the fullest possible use, ..."
Mythbusting: Concurrent Update/Insert Solutions
Sep 08, 2011
Caption: Don't try this at home! We're what you call experts!
Sep 08, 2011
Caption: Don't try this at home! We're what you call experts!
ACID Properties By Example (And Counterexample) Part Four: Durable
Aug 23, 2011
Caption: Recently, I learned that Richard Harris sang 'MacArthur Park'...
Aug 23, 2011
Caption: Recently, I learned that Richard Harris sang 'MacArthur Park'...
ACID Properties By Example (And Counterexample) Part Three: Consistent
Aug 10, 2011
Caption: Never show them your work in progress
Aug 10, 2011
Caption: Never show them your work in progress
ACID Properties By Example (And Counterexample) Part Two: Consistent
Aug 03, 2011
Caption: "'C' is for cookie. That's good enough for me." ~Cookie Monster
Aug 03, 2011
Caption: "'C' is for cookie. That's good enough for me." ~Cookie Monster
ACID Properties By Example (And Counterexample) Part One: Atomic
Jul 27, 2011
Caption: It's interesting: For most people, the word atomic only refers to a process where atoms are split.
Jul 27, 2011
Caption: It's interesting: For most people, the word atomic only refers to a process where atoms are split.
ACID Properties By Example (And Counterexample) Part Zero
Jul 20, 2011
Caption: It's interesting: Some ACID properties are basic!
Jul 20, 2011
Caption: It's interesting: Some ACID properties are basic!
Poking Around Inside Management Studio
Jun 29, 2011
Caption: Paying attention to the man behind the curtain!
Jun 29, 2011
Caption: Paying attention to the man behind the curtain!
Enforcing Business Rules Vs. Avoiding Triggers: Which Is Better?
Jun 15, 2011
Caption: Ladies! Please! One at a time!
Jun 15, 2011
Caption: Ladies! Please! One at a time!
Forget About PIVOT, You Don’t Need It
Jun 08, 2011
Caption: Be Honest, you can't remember the syntax either!
Jun 08, 2011
Caption: Be Honest, you can't remember the syntax either!
Another Advantage of Consultants
May 25, 2011
Caption: When we built Jurassic Park we spared no expense!
May 25, 2011
Caption: When we built Jurassic Park we spared no expense!
Okay, You’ve Found Blocking, Now What?
May 18, 2011
Caption: Aaaawww yeaaah! Michael's BPR Viewer is the only way I find lead blockers!
May 18, 2011
Caption: Aaaawww yeaaah! Michael's BPR Viewer is the only way I find lead blockers!
When To Use Blocked Processes Reports
May 04, 2011
Caption: When am I supposed to use the Blocked Process Report Viewer?!
May 04, 2011
Caption: When am I supposed to use the Blocked Process Report Viewer?!
Woo Hoo... Microsoft Certification Exam 70-451
Apr 27, 2011
Caption: I have my moments... I recognize them when I can
Apr 27, 2011
Caption: I have my moments... I recognize them when I can
A New Way to Examine Blocked Process Reports
Apr 20, 2011
Caption: There's a new way to look at blocked processes!
Apr 20, 2011
Caption: There's a new way to look at blocked processes!
Whew… Microsoft Certification Exam 70-433
Apr 13, 2011
Caption: There's good odds that this guy does better than me on section 5!
Apr 13, 2011
Caption: There's good odds that this guy does better than me on section 5!
Something Light-hearted.
Mar 30, 2011
Caption: I get that a lot, I'm not the Resource Governor, I'm a Colonel, I don't throttle run-away queries... just chickens
Mar 30, 2011
Caption: I get that a lot, I'm not the Resource Governor, I'm a Colonel, I don't throttle run-away queries... just chickens
Something Light-hearted.
Mar 30, 2011
Caption: PASS has lined up a new performer for the 2011 summit.
Mar 30, 2011
Caption: PASS has lined up a new performer for the 2011 summit.
Something Light-hearted.
Mar 30, 2011
Caption: That day she was amazed to discover that when he was saying "It depends" what he meant was "I love you"
Mar 30, 2011
Caption: That day she was amazed to discover that when he was saying "It depends" what he meant was "I love you"
Searching Inside Strings: CPU is Eight Times Worse For Unicode Strings
Feb 16, 2011
Caption: One more trick for my mental utility belt!
Feb 16, 2011
Caption: One more trick for my mental utility belt!
Pinal Dave: Blogger, MVP and now Interviewee
Feb 09, 2011
Caption: "These blog entries are truly my journey ... This journey is truly remarkable, that's why I continue to walk on it ~Pinal Dave
Feb 09, 2011
Caption: "These blog entries are truly my journey ... This journey is truly remarkable, that's why I continue to walk on it ~Pinal Dave
Ridiculously Unnormalized Database Schemas – Part Three
Feb 02, 2011
Caption: This is the cow ... that jack built
Feb 02, 2011
Caption: This is the cow ... that jack built
Ridiculously Unnormalized Database Schemas – Part Two
Jan 26, 2011
Caption: Get rid of redundant Data!
Jan 26, 2011
Caption: Get rid of redundant Data!
Ridiculously Unnormalized Database Schemas – Part One
Jan 19, 2011
Caption: Ted Codd hates that thing you just did!
Jan 19, 2011
Caption: Ted Codd hates that thing you just did!
Ridiculously Unnormalized Database Schemas – Part Zero
Jan 12, 2011
Caption: The brain: Full of information, but normal ones are extremely rare!
Jan 12, 2011
Caption: The brain: Full of information, but normal ones are extremely rare!
Why Michael J Swart won’t be at the PASS Summit this year.
Nov 07, 2010
Caption: Huh! I expected more people here.
Nov 07, 2010
Caption: Huh! I expected more people here.

