This is an archive of the posts published to LessThanDot from 2008 to 2018, over a decade of useful content. While we're no longer adding new content, we still receive a lot of visitors and wanted to make sure the content didn't disappear forever.
Ted Krueger (onpnt)
About Ted Krueger (onpnt)
Ted Krueger is a SQL Server MVP and Author that has been working in development and database administration and the owner of a successful consulting business, DataMetrics Consulting. Specialties range from High Availability and Disaster / Recovery setup and testing methods down to custom assembly development for SQL Server Reporting Services. Ted blogs and is also one of the founders of LessThanDot.com technology community. Some of the articles focused on are Backup / Recovery, Security, SSIS and working on SQL Server and using all of the SQL Server features available to create stable and scalable database services.
Social Sitings
Summary
- Active from November 2008 to February 2015
- 355 posts published
Table of Contents
Posts
2015 (1 posts)
- DataMetrics – New Success in the Making on February 24, 2015
2014 (6 posts)
- Who I am voting for – PASS Board on September 24, 2014
- Setup IaaS in Azure for SQL Server on September 19, 2014
- LobsterPot Solutions US on August 18, 2014
- Merge Replication for SQL Server Auditing on July 24, 2014
- Availability Groups Setup and Configuration from A to Z on June 4, 2014
- 2013 – Review of Writing on January 2, 2014
2013 (39 posts)
- ACL added security for Availability Group Listener in Azure on December 19, 2013
- Can I recover from a secondary replica COPY_ONLY full backup? on December 11, 2013
- Mentoring, Ambition, and Your Career on December 10, 2013
- Async replica loss causes transactional replication to fail on November 29, 2013
- Automated Job Activation with Mirroring and Availability Groups on November 5, 2013
- What makes a successful SQL Server Pro? on October 23, 2013
- SQL Server Services fail to start – FAIL_PAGE_ALLOCATION on October 21, 2013
- Enable TDE when Replication is in use on October 10, 2013
- Replication requires the actual server name – Incorrect server name on October 9, 2013
- SQL Agent Job High Availability – Availability Groups on October 5, 2013
- SQL Server Configuration Manager – Remote Procedure Call Failed on September 11, 2013
- Microsoft Isn't the Devil on August 19, 2013
- Success in Your Career on July 18, 2013
- Managing Transaction Log Growth on June 27, 2013
- Which loads faster – 2008, 2008 R2 or 2012 on June 27, 2013
- BlueMetal Architects Chicago and the Data Practice on June 26, 2013
- A big loss to our community on May 15, 2013
- SQL Server Baseline Collection on May 7, 2013
- Missing index suggestion – Duplicate Index on April 20, 2013
- SQL Azure Log Space Errors 40552 on April 15, 2013
- Buffer Latch Error Restoring SQL Server Database on April 10, 2013
- Windows 8 for the Enterprise Event – Tuesday, April 16th on April 9, 2013
- T-SQL Tuesday #41 – Presenting on April 9, 2013
- A Week of SQL Server on April 2, 2013
- Loading Large Volumes of Data into SQL Azure with SSIS on March 22, 2013
- SQL Sentry – Providing Performance and Knowledge on March 21, 2013
- Setting up Mirroring to SQL 2012 Availability Groups Encryption Error on March 20, 2013
- Red Gate Releases SQL Backup Pro 7.3 on March 20, 2013
- Direction of Intelligent Computing on March 8, 2013
- Windows and SQL Server 2012 Test Setup on February 15, 2013
- Define Microsoft Business Intelligence for me? on January 29, 2013
- When do statistics update? on January 28, 2013
- So you want a Windows 8 Phone? on January 28, 2013
- A Glance of Plan Explorer Pro's Deadlock Analysis on January 28, 2013
- Driving Predictive Analytics on January 23, 2013
- Do not disable foreign keys on January 23, 2013
- Database Designing With Performance In Mind on January 22, 2013
- Import Wizard – Microsoft.ACE.OLEDB 12.0 provider is not registered on January 19, 2013
- Creating statistics manually – Duplicate Statistics on January 19, 2013
2012 (73 posts)
- Blogging isn't easy unless you have support on December 31, 2012
- SHOW_STATISTICS Density showing key column – Why? on December 31, 2012
- Successful Consulting Series – Interviewing for a Consulting Position on December 21, 2012
- Successful Consulting Series – Work Ethics as a Consultant on December 20, 2012
- Successful Consulting Series – Career Paths on December 18, 2012
- Successful Consulting Series – Difficult Clients on December 14, 2012
- Update Table Based on a JOIN on December 11, 2012
- Successful Consulting Series – Time Management on December 10, 2012
- Successful Consulting Series – Estimating Work on December 10, 2012
- SQL Server Query Tuning – Back to Basics on December 9, 2012
- A Month with BlueMetal on December 7, 2012
- Successful Consulting Series – Overcomplicating, Stress...Freaking Out! on December 4, 2012
- Successful Consulting Series – Travel, Expenses, Pain on December 4, 2012
- Successful Consulting Series – Technical Aptitude on November 30, 2012
- Presenting Yourself – Visually and Respectfully on November 29, 2012
- Successful Consulting Series on November 28, 2012
- Utilizing SQL Server Reports from SSMS on November 28, 2012
- Expert Performance Indexing for SQL Server 2012 for $15 on November 20, 2012
- Cardinality Estimate and Computed Columns on November 16, 2012
- Short-Throw-Away T-SQL on November 15, 2012
- The lost art of an IT Professional on November 13, 2012
- SELECT 1 – Column Level Security on October 30, 2012
- SELECT * vs SELECT 1 with EXISTS on October 18, 2012
- Future, Career and Success – BlueMetal Architects on October 18, 2012
- Removed Replication – rowguid added back on October 18, 2012
- SSMS Add-in for Plan Explorer Update on October 17, 2012
- Plan Explorer Pro – First Glance on October 15, 2012
- Why does sys.dm_exec_requests not show my SPID? on October 12, 2012
- Adding nonclustered index on primary keys on October 11, 2012
- T-SQL Tuesday #35 – Horrify Me! on October 9, 2012
- SQL Saturday #149 on September 30, 2012
- SQL Server Training Bonanza on September 21, 2012
- Plan Cache effects when dropping columns on September 4, 2012
- Bad Code is like the birds on August 31, 2012
- LOB Logical Reads twice the row count on August 28, 2012
- Chicago Events – SQL and .NET on August 15, 2012
- Migrating Replication Subscribing Databases on August 9, 2012
- Index Seek on LOB Columns on August 8, 2012
- SQL Saturday Indy – Invasion of SSIS on July 26, 2012
- Merge Replication Baseline Collector on July 18, 2012
- T-SQL Tuesday #32: A Day in the Life on July 17, 2012
- Consulting – The best part? on July 3, 2012
- Row Overflow Pages – Index Tuning on June 28, 2012
- Balanced Data Distributor for SSIS 2012 Released on June 20, 2012
- Does updating a column to itself get logged? #TSQL2sday 31 on June 12, 2012
- SQL Saturday Speakers – Your submissions on May 22, 2012
- SQL Saturday in Madison – The First on April 26, 2012
- SQL Saturday Speakers – Thoughts when scheduling on April 24, 2012
- Mentoring – As I see it on April 20, 2012
- Using EXECUTE AS OWNER on April 19, 2012
- SQLFriends May 18th – What questions do you have for me? on April 12, 2012
- Columnstore Index – Index Statistics on April 10, 2012
- Columnstore Index Basics on April 9, 2012
- Another reason to show off your Tech – Happy Pi() on March 14, 2012
- Knowing SQL Server and where it lives – T-SQL Tuesday #028 on March 13, 2012
- Forgotten art of using what you know on March 12, 2012
- Database Mirroring Deprecated in 2012 on March 8, 2012
- Merge Replication – COM Based Resolver throws Buffer too small Error on March 6, 2012
- CozyRoc Releases SSIS+ 1.6 Beta on March 2, 2012
- SQL Server Installation Error – Consistency validation for SQL Server Registry keys on February 16, 2012
- onpnt on Linkedin – Feb #meme15 on February 15, 2012
- SQL Saturday in Atlanta – Oh my, the pre-cons on February 15, 2012
- Merge Replication – Filtered Data Publication Setup on February 14, 2012
- Row-Level and Column-Level tracking in Merge Replication on February 14, 2012
- SQL Server and xp_cmdshell – The good, the bad and more ugly on February 7, 2012
- Automating Index Statistics Collection with SSIS – The fast one on January 27, 2012
- Madison SQL Server User Group on January 27, 2012
- Automating Index Statistics Collection on January 25, 2012
- Take advantage of Database Mirroring in your applications on January 24, 2012
- Estimating Mean Uptime for Team-based uptime measurements on January 23, 2012
- Could not find stored procedure 'sp_ExecuteSQL' on January 19, 2012
- January #Meme15 Assignment – Twitter, the Blog, taking over the universe on January 16, 2012
- Friday SQL Nugget #1 on January 13, 2012
2011 (74 posts)
- LessThanDot Bloggers Weekly 12/11 on December 16, 2011
- Why I started and continue to blog – #Meme15 on Blogging on December 15, 2011
- SQL Server Integration Services tools to have – Configuration File Editor on December 15, 2011
- Troubleshooting Merge Replication Performance – Indexing Publications on December 14, 2011
- Fixing orphaned database users in 2005 to 2012 – T-SQL Tuesday #025 on December 13, 2011
- Troubleshooting Merge Replication – Logging on December 12, 2011
- Merge Replication – Parameterized Filters on December 9, 2011
- SQL Saturday in Chicago – Third year! on December 9, 2011
- Red Gate's new SQL Index Manager on December 8, 2011
- SQL Server Integration Services tools to have – Expression Editor & Tester on December 8, 2011
- SQL Saturday in Wisconsin is a reality! on December 7, 2011
- Dynamic Connections in SSIS – Extract, Transform and Load on December 7, 2011
- Shared Connections – New level of efficiency in SSIS 2012 on December 6, 2011
- Meme Monday for December on December 5, 2011
- SQL Server 2012 RC0 is here! on November 17, 2011
- SQL Saturday in Minnesota down to a few days! on November 8, 2011
- Blogging Tip – Removing Sensitive Information from Images on November 4, 2011
- SSIS Interview questions – Answers on November 3, 2011
- SSIS Test yourself with these interview questions on November 1, 2011
- SSMS Assembly Error – Microsoft.SqlServer.Sqm.dll on October 31, 2011
- SQL Saturday #99 Minnesota – #SQLAwesome on October 26, 2011
- Fix Execution Plan showing Parallelism on October 6, 2011
- SQL Server Views and Metadata on October 6, 2011
- SQL Saturday Iowa another success! on October 6, 2011
- SQL Server Deep Dives Volume 2 on October 2, 2011
- Troubleshooting SQL Server: A guide for the Accidental DBA on October 2, 2011
- T-SQL Tuesday on August 10, 2011
- Desktop Computing is Dead on August 8, 2011
- SQL Saturday Pensacola – Measure of success on June 6, 2011
- SQL Server 2008 R2 Setup starts and then disappears on June 6, 2011
- SQL Server DBA Tip 16 – Working with Files and Folders on May 17, 2011
- SQL Server DBA Tip 15 – SQL Server Agent – Job ownership on May 16, 2011
- SQL Server DBA Tip 14 – SQL Server General – Updating Production Data on May 13, 2011
- SQL Server DBA Tip 13 – SQL Server built in DR/HA Solutions on May 12, 2011
- SQL Server DBA Tip 12 – SQL Server Tuning – Missing Index DMV on May 11, 2011
- SQL Server DBA Tip 11 – SQL Server Configuration – MIN Memory on May 10, 2011
- SQL Server DBA Tip 10 – SQL Server Reporting – Offload the reporting factor on May 9, 2011
- SQL Server Database Administration Tip a Day Series on May 6, 2011
- Presenting for PASSMN May 17th on May 6, 2011
- SQL Server DBA Tip 9 – SQL Server Monitoring – Default Trace on May 6, 2011
- SQL Server DBA Tip 8 – Server Monitoring – Baseline on May 5, 2011
- SQL Server DBA Tip 7 – Server Security and grouping – Schema Control on May 4, 2011
- Compressing Data with Uniqueidentifier columns on May 3, 2011
- SQL Server DBA Tip 6 – Server Security – Windows Authentication / SQL Authentication on May 3, 2011
- SQL Server DBA Tip 5 – Server Considerations – Installing Features (SSIS, SSRS, Engine, SSAS) on May 2, 2011
- SQL Server DBA Tip 4 – Server Considerations – 32 bit / 64 bit on April 29, 2011
- SQL Server DBA Tip 3 – Server Configuration – Model Database on April 28, 2011
- SQL Server DBA Tip 2 – Server Configuration – Data/Log Files on April 27, 2011
- SQL Server DBA Tip 1 – Server Configuration – MAX Memory on April 26, 2011
- Difference between a Cumulative Update and Service Pack for SQL Server on April 23, 2011
- Should SQL Server Professionals Learn Oracle? on April 21, 2011
- SQL Saturday on April 20, 2011
- Bulk loading data into a merge replicated table on April 8, 2011
- Compress Data Partition Snapshots with SSIS – SQL University on April 7, 2011
- Think about your presentation and who reviews it on April 6, 2011
- SQL University – Performance Week on April 5, 2011
- Meme Monday: Eleven Words or Less on April 4, 2011
- Automate Database Restore to Remote Instance with SSIS on March 30, 2011
- Thanks, LessThanDot on March 29, 2011
- SQL Saturday in Chicago 2011 Eval on March 27, 2011
- Twitter and the SQL Help hash tag – Questions only! on March 15, 2011
- T-SQL Tuesday #016 – COUNT and DELETE duplicates on March 8, 2011
- SQL Saturday in Chicago the second on March 6, 2011
- Professional Development –Building Relationships on February 25, 2011
- Professional Development Week, Comfort Zone on February 22, 2011
- Professional Development Week, An introduction to this week on SQL University on February 21, 2011
- Twitter – I do want to follow you but... on February 10, 2011
- Renaming Physical Database Files on February 9, 2011
- T-SQL Tuesday#15 – Automation with PowerShell (Replace with RegEx) on February 8, 2011
- Reflector to cost us now on February 8, 2011
- Backup file contents with SSIS – INSERT/UPDATE Decisions on January 31, 2011
- Backup file contents with SSIS – Supporting tables and procedures on January 28, 2011
- Backup file contents with SSIS – Foreach Loop Container and file handling on January 25, 2011
- Backup file contents with SSIS – Defining the Design on January 24, 2011
2010 (78 posts)
- First glance at the new Red Gate SQL Monitor on December 30, 2010
- Using RMO to run replication tasks on December 30, 2010
- Policy-Based Management for SQL Agent History on December 28, 2010
- Running older compatibility levels in newer versions on December 28, 2010
- Procedure expects parameter error from SqlCommand on December 27, 2010
- T-SQL Tuesday #13: What the Business Says Is Not What the Business Wants on December 14, 2010
- Build your resume for the position on December 9, 2010
- Mirroring and Transactional Replication setup – Auto Failover on November 30, 2010
- Run SSIS Package from Stored Procedure on November 29, 2010
- What am I thankful for? on November 25, 2010
- Using SSIS to import a directory of images on November 24, 2010
- Moving on on November 15, 2010
- My first PASS attendance on November 15, 2010
- Execution Plans – Indexing to achieve optimal query plans on October 25, 2010
- Who shrunk the files? (DBCC SHRINKFILE Audit) on October 22, 2010
- PASS Summit is upon us on October 19, 2010
- SQLCop behind a Proxy on October 18, 2010
- Wisconsin SQL Server User Group on October 11, 2010
- The History of SQL Server Integration Services on October 11, 2010
- SSIS runs in BIDS but not with SQL Agent on October 6, 2010
- Doing this for the SQL Community on September 21, 2010
- Have SQL, will travel – East Iowa SQL Saturday on September 20, 2010
- SQL Saturday Iowa on September 11, 2010
- The Lazy DBA Series: Wizards! on August 25, 2010
- The Lazy DBA Series: High Availability on August 24, 2010
- The Lazy DBA Series: Email me, I'm broke! on August 24, 2010
- The Lazy DBA Series: Monitoring on August 22, 2010
- The Lazy DBA Series: SQL Trace / Profiler on August 20, 2010
- Making SSIS Dynamic: Passing variables between packages on August 19, 2010
- Making SSIS Dynamic: Configuration Management on August 18, 2010
- Creating a baseline for SQL Server on August 9, 2010
- Baseline, Performance Reporting and being a proactive DBA on August 5, 2010
- RID Lookup take me down on July 18, 2010
- T-SQL Tuesday on July 13, 2010
- Change Data Capture rundown 100 (setup) on July 12, 2010
- MSDN Ultimate Subscription giveaway +1 on July 6, 2010
- Being a finalist for the Exceptional DBA of the Year on June 25, 2010
- SQL Community Services – Resources everywhere! on June 18, 2010
- SQL University – Let's blog on June 17, 2010
- SQL Server Forums – Helping to build a knowledge base on June 15, 2010
- SQL Server and the Auto Close Setting on June 12, 2010
- SQL Server and High Availability on June 11, 2010
- SQL University – Recess time! on June 10, 2010
- Log Shipping for cheap DR on June 10, 2010
- T-SQL Tuesday – Give me my cores SSIS 2008! on June 8, 2010
- The SQL Server backup – foundation of any Disaster / Recovery on June 8, 2010
- Welcome to HA and DR week! on June 7, 2010
- Removing old files with SSIS on June 4, 2010
- Report Manager / Report Server Loading Slow Initially on May 28, 2010
- Transaction Log expanding on restore after shrink on May 27, 2010
- 12 ways to break your database server before the first transaction on May 19, 2010
- Five things wouldn't miss in SQL Server on May 11, 2010
- Trusting Database Engine Tuning Advisor for Query Tuning on May 11, 2010
- Mirroring Hands On with Developer Edition on May 9, 2010
- SQL Connections Suburban Chicago Wrap Up on May 6, 2010
- Planning your hardware for SQL Server Mirroring on May 4, 2010
- SQL Connections Suburban Chicago May 2010 Meeting (SSIS Basics) on May 3, 2010
- Planning your SQL Server mirroring landscape on May 3, 2010
- Stripping rows out of file imports on April 22, 2010
- The Measurement of Success – SQL Saturday Chicago on April 20, 2010
- LessThanDot Sponsors SQL Saturday in Chicago on April 14, 2010
- Delay Validation with SSIS Tasks on April 5, 2010
- Index DMV usage considerations on March 31, 2010
- Finding meaningful error details to report execution failures on March 30, 2010
- Working with vendor-provided databases on March 29, 2010
- Approach the SQL Community without hesitation! on March 25, 2010
- Finding SQL Server Support – Become an expert yourself on March 8, 2010
- Choosing operating modes for mirroring over a WAN on March 2, 2010
- Using schemas to maintain order as a DBA on February 26, 2010
- Mirroring: Witness misconceptions in High-Performance on February 16, 2010
- SQL Saturday in Chicago – Schedule is up! on February 11, 2010
- Read from your mirror in SQL Server on February 3, 2010
- Backup and copy warm-standby (log shipped) databases in SQL Server on January 27, 2010
- Three Events that Brought Me Here on January 19, 2010
- Activity Monitor to gather statistics and health of SQL Server 2008 on January 18, 2010
- Mirroring SQL Server 2005 to SQL Server 2008 (part 2) on January 12, 2010
- Mirroring SQL Server 2005 to SQL Server 2008 (Part 1) on January 11, 2010
- Goals for 2010 on January 6, 2010
2009 (71 posts)
- Using Variables in SSIS: Purpose review and functional examples on December 31, 2009
- Script Task vs Flat File Connection Management on December 16, 2009
- The Good, the Bad and the Ugly of Database Design on December 14, 2009
- Dynamic SQL Server connections in Reporting Services on December 12, 2009
- Introducing SQL Server to Oracle on December 11, 2009
- To BUILTINAdmin or not to BUILTINAdmin on November 19, 2009
- Beginning stages of a DR plan for SQL Server on November 13, 2009
- Back to business for the SQL Server community on November 13, 2009
- Test your Full Recovery model by restoring backups on November 5, 2009
- Series of "Bad habits to kick" by Aaron Bertrand on October 18, 2009
- SQL University and why you should be attending on October 14, 2009
- Derived Column and the Data Flow Task on October 8, 2009
- To SA or not to SA on October 7, 2009
- Suffer to succeed. Another SQL Server Import Story on September 30, 2009
- Keep your DBA guard up at all times on September 25, 2009
- 6 ways to import data into SQL Server on September 14, 2009
- Using Mirroring to Reduce DB Migration Downtime (Part 2) on September 10, 2009
- Using Mirroring to Reduce DB Migration Downtime (Part 1) on September 10, 2009
- East Iowa SQL Saturday Oct. 17th on September 9, 2009
- How I got started with SQL Server on September 8, 2009
- Death by a thousand tools on August 19, 2009
- Recover a database without the ldf file on August 13, 2009
- Working with Excel to match data 101 on August 5, 2009
- Instance design; Where to do your work as a DBA and DB Developer on July 28, 2009
- Dynamic Data Sources in SSRS on July 24, 2009
- Restoring multiple transaction log backups on July 22, 2009
- Bringing your thoughts back into line on July 21, 2009
- Go ahead and click it! I triple dog dare you!!! on July 10, 2009
- Push your DBA skills over the edge by becoming a better developer on July 9, 2009
- Dynamic column names and fields in SSRS (Custom Matrix) on July 1, 2009
- DBA SQLCLR Procedures on June 26, 2009
- Not a fan of the Report Manager in SSRS? Using SSRS procedures to get the job done on June 25, 2009
- Finding motivation after a smack in the face on June 8, 2009
- Why does my variable always have NULL in it? on June 5, 2009
- Writing reports off third party databases the easy way on June 5, 2009
- Removing replication and handling tables with identity seeds on June 4, 2009
- Log Shipping for DR and failing back in case of disaster. The cheap way! on June 1, 2009
- Get local lab and instances going. Replication / SQL Agent on May 29, 2009
- Compression tools are a must for any DBA on May 27, 2009
- SMO Script Index and FK's on a database on May 18, 2009
- Stop mirroring for server reboot on May 17, 2009
- SSIS Import all text files. Use RegEx parse out strings on May 17, 2009
- Read data on Mirror to prevent production database stress on May 13, 2009
- Using one Parameter for Multiple Datasets in Reporting Services on May 11, 2009
- Disaster/Recovery for Reporting Services objects (rdl, rds etc..) on May 8, 2009
- Handling long running queries with a stop sign on May 5, 2009
- Comparing the Chicago Highway System to your Disaster/Recovery Plans on April 28, 2009
- Quick Data Model creation off SSAS Data Source in SSRS on April 27, 2009
- Import directory of XML files into SQL Server 2005 on April 27, 2009
- Blocking due to fragmented HEAP Tables on April 24, 2009
- Please Mr. DBA, Change default passwords and use strong passwords on April 23, 2009
- Split string in SQL Server 2005+ CLR vs. T-SQL on April 21, 2009
- What makes a successful SQL Server Reporting Services implementation? on April 20, 2009
- The DBA.. their role, expectations and future? on April 15, 2009
- Add Report Wizard Layout Style (Standard Company Style) on April 14, 2009
- Rebuild master and restore system databases from complete disk failure on April 14, 2009
- Copy SQL Server Database on April 13, 2009
- Send Excel formatted query results on schedules on April 10, 2009
- SQL Server Agent Job history purging on April 10, 2009
- cidaemon.exe process CPU usage on Windows Server 2003 R2 on April 8, 2009
- Show message for SSRS reports that do not return data on April 2, 2009
- ExecutionLog Table in SSRS 2008 Gone on March 27, 2009
- Using VS.NET 2005 SP1 with SQL Server 2008 connectivity on March 27, 2009
- Disable SQL Agent Jobs with TSQL based on events on March 26, 2009
- Space heater * power strip = support disaster on March 25, 2009
- Search the Internet Archive with the Wayback Machine on March 24, 2009
- Client Statistics in SSMS. Check execution times on March 22, 2009
- Optimizing with indexing where commonly overlooked on March 22, 2009
- Backups are for sissies!!! on March 11, 2009
- Scan network for SQL Server instances on March 9, 2009
- Todo in 2009 on January 6, 2009
2008 (13 posts)
- Overlooking system databases and fragmentation on December 18, 2008
- Quest LiteSpeed update 5.0.2.1030 Released on December 17, 2008
- Impersonating a SQL Server DBA on December 16, 2008
- An ego will only hurt you: Toughest Challenges on December 10, 2008
- Index and Statistic creation with SQL Server DTA on December 3, 2008
- Securing your password for SQL Server 2005 and 2008 and more on December 2, 2008
- ReportViewer and the RSPrintClient Control Problems on December 1, 2008
- SQL Agent Job Notifications on December 1, 2008
- Do not truncate your ldf files! on November 20, 2008
- Performance (How is my SQL Server running?) on November 18, 2008
- Proactive Deadlock Notifications on November 17, 2008
- Troubleshooting Blocking 101 on SQL Server on November 14, 2008
- User to Schema to Roles for controlling security on November 7, 2008