SQL Server Soldier :: News from the frontlines of the database wars - Blogs

Recent Presentation Session Files

Session Files – A Little Behind

I’ve been a little tardy about getting my session files posted, and I’m a little behind. So I’m going to try to catch up in one blog post. So here are my session files for SQL PASS Summit 2012, various… Read more

0 comments, 307 reads

Posted in SQL Server Soldier :: News from the frontlines of the database wars on 15 November 2012

T-SQL Tuesday #36 – SQL Community

T-SQL Tuesday #36 - SQL Community

This blog entry is participating in T-SQL Tuesday #36, hosted this month by Chris Yates(Blog|@YatesSQL). You are invited to visit his blog to join the blog party. You are welcome to write your… Read more

1 comments, 336 reads

Posted in SQL Server Soldier :: News from the frontlines of the database wars on 13 November 2012

Don’t Be That PASS Summit Guy

PASS Summit 2012 Speaker

The SQL PASS Summit 2012 is just around the corner. Every year there are lots of first-timers attending. So many that PASS started a first-timers program linking new attendees with veterans who can mentor them in the PASS Summit experience.… Read more

3 comments, 532 reads

Posted in SQL Server Soldier :: News from the frontlines of the database wars on 22 October 2012

Man Vs Machine

Are you a fan of the television show Man Vs Food starring foodie Adam Richman? In this show, host and title subject “Man” Adam Richman travels the United States taking on food challenges where he finds them. Sometimes these challenges entail eating more… Read more

0 comments, 433 reads

Posted in SQL Server Soldier :: News from the frontlines of the database wars on 23 August 2012

Why Attending a Monday Pre-con Will Be Awesome

PASS Summit 2012 Speaker

The SQL PASS Summit 2012 is coming up in a few months. It’s time to make your plans to attend. One of the things that many of you may be considering is attending a pre-con. There are two… Read more

0 comments, 399 reads

Posted in SQL Server Soldier :: News from the frontlines of the database wars on 16 July 2012

Performing Fast Searches of Query Plans

XML: Fast as a Turtle

I've made blog posts in the past on using the exist() method to search for query plans with specific attributes (e.g., Find Cached Query Plans By Index Name). Another good aspect of the exist() method is that it… Read more

1 comments, 497 reads

Posted in SQL Server Soldier :: News from the frontlines of the database wars on 12 July 2012

Is SELECT Identity() … INTO Minimally Logged in Simple Recovery?

Extreme Logging

I was having a discussion with Idera (@idera_software) dev lead Vicky Harp (blog|@vickyharp) about minimizing log impact when performing schema changes on really large tables. One option discussed was using SELECT INTO Read more

3 comments, 675 reads

Posted in SQL Server Soldier :: News from the frontlines of the database wars on 30 June 2012

Troubleshooting Database Mirroring Error 1418 Updated

Last night I was helping someone with a database mirroring setup problem via email. It has been a long time since I came across a new cause for the infamous 1418 error for database mirroring. This time the error was accompanied by an error… Read more

0 comments, 1,269 reads

Posted in SQL Server Soldier :: News from the frontlines of the database wars on 28 June 2012

5 Second Rule Doesn’t Apply to Dropped Databases or Does It?

5 Second Rule Doesn't Apply to Dropped Databases or Does It?

Imagine you get a frantic call from someone, we’ll call him George, who just dropped a busy production database, and if he can’t get it back up ASAP,… Read more

1 comments, 3,097 reads

Posted in SQL Server Soldier :: News from the frontlines of the database wars on 22 June 2012

T-SQL Tuesday #31 – Bulk-Logged Recovery Model and Point-in-time Restore

This blog entry is participating in T-SQL Tuesday #31, hosted this month by Aaron Nelson (Blog|@SQLVariant). You are invited to visit his blog to join the blog party. You are welcome to write your own… Read more

0 comments, 879 reads

Posted in SQL Server Soldier :: News from the frontlines of the database wars on 12 June 2012

SQL Rally 2012 Recap and Session Files

Dallas Convention Center

SQL Rally 2012 was hosted by the North Texas SQL Server User Group. More tha anything, it was nice to be back in the area where I grew up. I was born in Houston, but I grew up in… Read more

0 comments, 370 reads

Posted in SQL Server Soldier :: News from the frontlines of the database wars on 15 May 2012

Session Files from SQL Saturday #107 Houston

Houston Skyline

SQL Saturday Houston was a great event hosted by the Houston Area SQL Server Users Group. The event did not have a very large attendence, but those who traded in a beautiful Saturday for some free training were very engaged… Read more

0 comments, 481 reads

Posted in SQL Server Soldier :: News from the frontlines of the database wars on 15 May 2012

SQL Saturday #107 in Houston, TX

Houston Skyline

SQL Saturday #107 in Houston, TX is almost here. I will be leaving for Houston on Friday, April 13, and I’ll be spending the entire week preceeding SQL Saturday #107 in Houston visiting the headquarters of my new employer, Idera. One… Read more

0 comments, 373 reads

Posted in SQL Server Soldier :: News from the frontlines of the database wars on 9 April 2012

Reflections on Leaving Microsoft

Reflections of Microsoft By Jeff Sandquist (http://www.flickr.com/photos/jeffsand/)

Several members of my SQLFamily have made adjustments to their career path recently. Several of us got together for #SQLNomz yesterday to celebrate our job changes, though granted, we don’t generally require an excuse to get together. Yesterday (Friday,… Read more

0 comments, 736 reads

Posted in SQL Server Soldier :: News from the frontlines of the database wars on 31 March 2012

Whitepaper: Demystify Tempdb Performance & Management

Demystify Tempdb Performance & Management

There are many misconceptions and myths about tempdb and purported best practices are inconsistent at best. It’s hard to know which advice to follow when one resource says to always do it one way and another tells you to… Read more

1 comments, 596 reads

Posted in SQL Server Soldier :: News from the frontlines of the database wars on 21 March 2012

Goodbye Microsoft, Hello World

The cowboy’s job is done here, and it’s time for him to move on to the next adventrue. The lonely prairie wanderer moves onward, always moving forward. Never looks back, never catches one last fleeting glance. This adventure is over. and it’s… Read more

0 comments, 776 reads

Posted in SQL Server Soldier :: News from the frontlines of the database wars on 3 March 2012

Why We Follow Best Practices

Best Practices

There are many reasons why we follow best practices. My own reasons have changed over the course of my career. Early in my career as a database developer and then later as a new DBA, I followed best practices because people who claimed… Read more

2 comments, 1,557 reads

Posted in SQL Server Soldier :: News from the frontlines of the database wars on 26 February 2012

SQL Saturday 108 (Redmond, WA) Session Files

SQL Saturday 108 Replication Magic

Session files are now available for download. The zip file contains the PowerPoint slide deck and demo code.

Zip file: ReplicationMagic.zip (5.2 KB)

Demo: Initializing replication from a log backup
- InitializeFromLogPub.sql
- InitializeFromLogSub.sql
Demo: Initializing replication from…

[Shameless Plug] Can We Have Your Vote?

SQL PASS SQLRally

Argenis Fernandez (|@DBArgenis ) and yours truly have submitted a Pre-Conference for SQL Rally 2012 in Dallas, TX called “Demystifying Database Administration Best Practices”. We think it’s going to be an epic session with just loads and loads… Read more

0 comments, 419 reads

Posted in SQL Server Soldier :: News from the frontlines of the database wars on 8 February 2012

Breaking Down TempDB Contention (part 2)

Tempdb Contention via Idera Diagnostic Manager

I wrote a somewhat popular script and blog post a while back called Breaking Down TempDB Contention. This post explains how to identify tempdb contention. This past Friday, Jonathan Kehayias (blog|@SQLPoolboy) contacted me… Read more

4 comments, 920 reads

Posted in SQL Server Soldier :: News from the frontlines of the database wars on 30 January 2012

Get Your Own Blog

Contact the author

All Blogs

Feeds

Archives for this blog