Ted Krueger (onpnt)

About the Author

Ted Krueger is a SQL Server MVP and has been working in development and database administration for 13+ years. 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. @onpnt Personal Blog over at http://onpnt.wordpress.com/

Social Sitings

• Total posts: 252
• Total views: 913782
• Average views per post: 3,626.12
• Total comments: 715
• Average comments per post: 2.84

• SQL Server Baseline Collection (Views: 12106, Comments: 2)
• Missing index suggestion – Duplicate Index (Views: 11224, Comments: 4)
• SQL Azure Log Space Errors 40552 (Views: 9593, Comments: 1)
• Buffer Latch Error Restoring SQL Server Database (Views: 11989, Comments: 1)
• Loading Large Volumes of Data into SQL Azure with SSIS (Views: 7398, Comments: 3)
• SQL Sentry - Providing Performance and Knowledge (Views: 2299, Comments: 0)
• Setting up Mirroring to SQL 2012 Availability Groups Encryption Error (Views: 2151, Comments: 0)
• Red Gate Releases SQL Backup Pro 7.3 (Views: 1178, Comments: 0)
• Windows and SQL Server 2012 Test Setup (Views: 1067, Comments: 0)
• Define Microsoft Business Intelligence for me? (Views: 1795, Comments: 0)
• When do statistics update? (Views: 1622, Comments: 2)
• A Glance of Plan Explorer Pro’s Deadlock Analysis (Views: 2171, Comments: 1)
• Driving Predictive Analytics (Views: 2288, Comments: 0)
• Do not disable foreign keys (Views: 2452, Comments: 7)
• Database Designing With Performance In Mind (Views: 2027, Comments: 4)
• Import Wizard - Microsoft.ACE.OLEDB 12.0 provider is not registered (Views: 1597, Comments: 1)
• Creating statistics manually – Duplicate Statistics (Views: 1271, Comments: 0)
• SHOW_STATISTICS Density showing key column - Why? (Views: 2090, Comments: 0)
• Update Table Based on a JOIN (Views: 1797, Comments: 0)
• SQL Server Query Tuning – Back to Basics (Views: 4696, Comments: 2)
• Utilizing SQL Server Reports from SSMS (Views: 2326, Comments: 1)
• Expert Performance Indexing for SQL Server 2012 for $15 (Views: 2733, Comments: 1)
• Cardinality Estimate and Computed Columns (Views: 2678, Comments: 0)
• Short-Throw-Away T-SQL (Views: 2995, Comments: 6)
• SELECT 1 - Column Level Security (Views: 2526, Comments: 0)
• SELECT * vs SELECT 1 with EXISTS (Views: 3756, Comments: 2)
• Removed Replication – rowguid added back (Views: 2448, Comments: 1)
• SSMS Add-in for Plan Explorer Update (Views: 2842, Comments: 0)
• Plan Explorer Pro – First Glance (Views: 2949, Comments: 2)
• Why does sys.dm_exec_requests not show my SPID? (Views: 2469, Comments: 1)
• Adding nonclustered index on primary keys (Views: 3291, Comments: 6)
• Plan Cache effects when dropping columns (Views: 4808, Comments: 0)
• LOB Logical Reads twice the row count (Views: 3123, Comments: 1)
• Migrating Replication Subscribing Databases (Views: 4615, Comments: 0)
• Index Seek on LOB Columns (Views: 4588, Comments: 0)
• SQL Saturday Indy - Invasion of SSIS (Views: 2846, Comments: 0)
• Merge Replication Baseline Collector (Views: 2982, Comments: 3)
• Row Overflow Pages - Index Tuning (Views: 3016, Comments: 0)
• Balanced Data Distributor for SSIS 2012 Released (Views: 3306, Comments: 0)
• Does updating a column to itself get logged? #TSQL2sday 31 (Views: 3182, Comments: 0)
• Using EXECUTE AS OWNER (Views: 3077, Comments: 0)
• Columnstore Index – Index Statistics (Views: 3253, Comments: 0)
• Columnstore Index Basics (Views: 4323, Comments: 7)
• Another reason to show off your Tech - Happy Pi() (Views: 1412, Comments: 2)
• Database Mirroring Deprecated in 2012 (Views: 2541, Comments: 9)
• Merge Replication – COM Based Resolver throws Buffer too small Error (Views: 1209, Comments: 0)
• CozyRoc Releases SSIS+ 1.6 Beta (Views: 862, Comments: 0)
• SQL Server Installation Error – Consistency validation for SQL Server Registry keys (Views: 3383, Comments: 0)
• Merge Replication – Filtered Data Publication Setup (Views: 1132, Comments: 0)
• Row-Level and Column-Level tracking in Merge Replication (Views: 1368, Comments: 0)
• SQL Server and xp_cmdshell - The good, the bad and more ugly (Views: 2058, Comments: 2)
• Automating Index Statistics Collection with SSIS – The fast one (Views: 1074, Comments: 0)
• Madison SQL Server User Group (Views: 700, Comments: 1)
• Automating Index Statistics Collection (Views: 1408, Comments: 8)
• Take advantage of Database Mirroring in your applications (Views: 1326, Comments: 0)
• Estimating Mean Uptime for Team-based uptime measurements (Views: 1013, Comments: 0)
• Could not find stored procedure 'sp_ExecuteSQL' (Views: 2396, Comments: 4)
• January #Meme15 Assignment – Twitter, the Blog, taking over the universe (Views: 713, Comments: 0)
• SQL Server Integration Services tools to have – Configuration File Editor (Views: 590, Comments: 0)
• Troubleshooting Merge Replication Performance – Indexing Publications (Views: 815, Comments: 0)
• Fixing orphaned database users in 2005 to 2012 - T-SQL Tuesday #025 (Views: 3251, Comments: 0)
• Troubleshooting Merge Replication – Logging (Views: 1013, Comments: 0)
• Merge Replication – Parameterized Filters (Views: 905, Comments: 0)
• Red Gate’s new SQL Index Manager (Views: 1158, Comments: 3)
• SQL Server Integration Services tools to have – Expression Editor & Tester (Views: 998, Comments: 0)
• Dynamic Connections in SSIS – Extract, Transform and Load (Views: 1378, Comments: 0)
• Shared Connections – New level of efficiency in SSIS 2012 (Views: 1062, Comments: 4)
• SQL Server 2012 RC0 is here! (Views: 1138, Comments: 1)
• SSIS Interview questions - Answers (Views: 4058, Comments: 0)
• SSIS Test yourself with these interview questions (Views: 4693, Comments: 6)
• SSMS Assembly Error - Microsoft.SqlServer.Sqm.dll (Views: 1459, Comments: 0)
• SQL Saturday #99 Minnesota - #SQLAwesome (Views: 762, Comments: 0)
• Fix Execution Plan showing Parallelism (Views: 888, Comments: 2)
• SQL Server Views and Metadata (Views: 1146, Comments: 2)
• SQL Saturday Iowa another success! (Views: 532, Comments: 0)
• SQL Server Deep Dives Volume 2 (Views: 1106, Comments: 1)
• Troubleshooting SQL Server: A guide for the Accidental DBA (Views: 1571, Comments: 0)
• T-SQL Tuesday #21 - A trigger can do that! (Views: 2267, Comments: 6)
• SQL Saturday Pensacola - Measure of success (Views: 711, Comments: 3)
• SQL Server 2008 R2 Setup starts and then disappears (Views: 3206, Comments: 7)
• SQL Server DBA Tip 16 – Working with Files and Folders (Views: 1204, Comments: 2)
• SQL Server DBA Tip 15 – SQL Server Agent – Job ownership (Views: 4101, Comments: 1)
• SQL Server DBA Tip 14 – SQL Server General – Updating Production Data (Views: 1281, Comments: 1)
• SQL Server DBA Tip 13 – SQL Server built in DR/HA Solutions (Views: 1205, Comments: 0)
• SQL Server DBA Tip 12 – SQL Server Tuning – Missing Index DMV (Views: 1279, Comments: 3)
• SQL Server DBA Tip 11 – SQL Server Configuration – MIN Memory (Views: 1144, Comments: 1)
• SQL Server DBA Tip 10 – SQL Server Reporting – Offload the reporting factor (Views: 1983, Comments: 1)
• SQL Server Database Administration Tip a Day Series (Views: 1156, Comments: 8)
• Presenting for PASSMN May 17th (Views: 447, Comments: 1)
• SQL Server DBA Tip 9 – SQL Server Monitoring – Default Trace (Views: 1856, Comments: 2)
• SQL Server DBA Tip 8 - Server Monitoring - Baseline (Views: 3772, Comments: 5)
• SQL Server DBA Tip 7 - Server Security and grouping – Schema Control (Views: 1405, Comments: 1)
• Compressing Data with Uniqueidentifier columns (Views: 1081, Comments: 2)
• SQL Server DBA Tip 6 - Server Security – Windows Authentication / SQL Authentication (Views: 1275, Comments: 1)
• SQL Server DBA Tip 5 - Server Considerations - Installing Features (SSIS, SSRS, Engine, SSAS) (Views: 1119, Comments: 1)
• SQL Server DBA Tip 4 - Server Considerations – 32 bit / 64 bit (Views: 1123, Comments: 5)
• SQL Server DBA Tip 3 - Server Configuration – Model Database (Views: 1092, Comments: 4)
• SQL Server DBA Tip 2 - Server Configuration – Data/Log Files (Views: 1666, Comments: 8)
• SQL Server DBA Tip 1 - Server Configuration – MAX Memory (Views: 2029, Comments: 5)
• Difference between a Cumulative Update and Service Pack for SQL Server (Views: 3626, Comments: 1)
• Should SQL Server Professionals Learn Oracle? (Views: 2266, Comments: 11)
• Bulk loading data into a merge replicated table (Views: 4092, Comments: 0)
• Compress Data Partition Snapshots with SSIS - SQL University (Views: 2160, Comments: 0)
• Think about your presentation and who reviews it (Views: 960, Comments: 5)
• SQL University – Performance Week (Views: 1584, Comments: 0)
• Meme Monday: Eleven Words or Less (Views: 937, Comments: 3)
• Automate Database Restore to Remote Instance with SSIS (Views: 7060, Comments: 7)
• SQL Saturday in Chicago 2011 Eval (Views: 1189, Comments: 8)
• T-SQL Tuesday #016 - COUNT and DELETE duplicates (Views: 1867, Comments: 1)
• Renaming Physical Database Files (Views: 1868, Comments: 0)
• T-SQL Tuesday#15 – Automation with PowerShell (Replace with RegEx) (Views: 2436, Comments: 8)
• Backup file contents with SSIS – INSERT/UPDATE Decisions (Views: 2005, Comments: 0)
• Backup file contents with SSIS - Supporting tables and procedures (Views: 862, Comments: 0)
• Backup file contents with SSIS - Foreach Loop Container and file handling (Views: 1902, Comments: 2)
• Backup file contents with SSIS - Defining the Design (Views: 1249, Comments: 0)
• First glance at the new Red Gate SQL Monitor (Views: 3030, Comments: 3)
• Using RMO to run replication tasks (Views: 893, Comments: 0)
• Policy-Based Management for SQL Agent History (Views: 1528, Comments: 0)
• Running older compatibility levels in newer versions (Views: 2710, Comments: 1)
• Procedure expects parameter error from SqlCommand (Views: 2186, Comments: 6)
• T-SQL Tuesday #13: What the Business Says Is Not What the Business Wants (Views: 1268, Comments: 1)
• Mirroring and Transactional Replication setup – Auto Failover (Views: 4424, Comments: 4)
• Run SSIS Package from Stored Procedure (Views: 9746, Comments: 5)
• Using SSIS to import a directory of images (Views: 4441, Comments: 4)
• Execution Plans - Indexing to achieve optimal query plans (Views: 3591, Comments: 4)
• Who shrunk the files? (DBCC SHRINKFILE Audit) (Views: 1600, Comments: 0)
• PASS Summit is upon us (Views: 799, Comments: 2)
• SQLCop behind a Proxy (Views: 1911, Comments: 3)
• Wisconsin SQL Server User Group (Views: 1452, Comments: 4)
• The History of SQL Server Integration Services (Views: 2988, Comments: 2)
• SSIS runs in BIDS but not with SQL Agent (Views: 6932, Comments: 8)
• Have SQL, will travel – East Iowa SQL Saturday (Views: 5217, Comments: 3)
• SQL Saturday Iowa (Views: 1172, Comments: 2)
• The Lazy DBA Series: Wizards! (Views: 2535, Comments: 4)
• The Lazy DBA Series: High Availability (Views: 1833, Comments: 2)
• The Lazy DBA Series: Email me, I’m broke! (Views: 2577, Comments: 0)
• The Lazy DBA Series: Monitoring (Views: 1945, Comments: 0)
• The Lazy DBA Series: SQL Trace / Profiler (Views: 2250, Comments: 5)
• Making SSIS Dynamic: Passing variables between packages (Views: 9565, Comments: 1)
• Making SSIS Dynamic: Configuration Management (Views: 5421, Comments: 3)
• Creating a baseline for SQL Server (Views: 5922, Comments: 10)
• Baseline, Performance Reporting and being a proactive DBA (Views: 3911, Comments: 2)
• RID Lookup take me down (Views: 3999, Comments: 5)
• Change Data Capture rundown 100 (setup) (Views: 4006, Comments: 4)
• SQL Server and the Auto Close Setting (Views: 5721, Comments: 7)
• SQL Server and High Availability (Views: 4365, Comments: 0)
• SQL University - Recess time! (Views: 2200, Comments: 0)
• Log Shipping for cheap DR (Views: 6003, Comments: 6)
• T-SQL Tuesday - Give me my cores SSIS 2008! (Views: 2658, Comments: 0)
• The SQL Server backup - foundation of any Disaster / Recovery (Views: 4328, Comments: 1)
• Welcome to HA and DR week! (Views: 2098, Comments: 5)
• Removing old files with SSIS (Views: 6654, Comments: 13)
• Report Manager / Report Server Loading Slow Initially (Views: 6346, Comments: 1)
• Transaction Log expanding on restore after shrink (Views: 2499, Comments: 4)
• 12 ways to break your database server before the first transaction (Views: 2395, Comments: 8)
• Five things wouldn’t miss in SQL Server (Views: 1344, Comments: 6)
• Trusting Database Engine Tuning Advisor for Query Tuning (Views: 3625, Comments: 6)
• Mirroring Hands On with Developer Edition (Views: 2668, Comments: 2)
• SQL Connections Suburban Chicago Wrap Up (Views: 1251, Comments: 2)
• Planning your hardware for SQL Server Mirroring (Views: 2204, Comments: 1)
• SQL Connections Suburban Chicago May 2010 Meeting (SSIS Basics) (Views: 1175, Comments: 4)
• Planning your SQL Server mirroring landscape (Views: 2198, Comments: 0)
• Stripping rows out of file imports (Views: 2431, Comments: 6)
• Delay Validation with SSIS Tasks (Views: 9456, Comments: 0)
• Index DMV usage considerations (Views: 4045, Comments: 1)
• Finding meaningful error details to report execution failures (Views: 2248, Comments: 2)
• Choosing operating modes for mirroring over a WAN (Views: 3118, Comments: 0)
• Using schemas to maintain order as a DBA (Views: 1819, Comments: 3)
• Mirroring: Witness misconceptions in High-Performance (Views: 3069, Comments: 0)
• SQL Saturday in Chicago - Schedule is up! (Views: 1100, Comments: 5)
• Read from your mirror in SQL Server (Views: 3894, Comments: 3)
• Backup and copy warm-standby (log shipped) databases in SQL Server (Views: 5673, Comments: 6)
• Activity Monitor to gather statistics and health of SQL Server 2008 (Views: 3592, Comments: 3)
• Mirroring SQL Server 2005 to SQL Server 2008 (part 2) (Views: 8517, Comments: 2)
• Mirroring SQL Server 2005 to SQL Server 2008 (Part 1) (Views: 10890, Comments: 4)
• Using Variables in SSIS: Purpose review and functional examples (Views: 5370, Comments: 3)
• Script Task vs Flat File Connection Management (Views: 3224, Comments: 2)
• The Good, the Bad and the Ugly of Database Design (Views: 6368, Comments: 14)
• Dynamic SQL Server connections in Reporting Services (Views: 3968, Comments: 4)
• Introducing SQL Server to Oracle (Views: 2267, Comments: 8)
• To BUILTIN\Admin or not to BUILTIN\Admin (Views: 4034, Comments: 4)
• Beginning stages of a DR plan for SQL Server (Views: 2814, Comments: 7)
• Back to business for the SQL Server community (Views: 1057, Comments: 0)
• Test your Full Recovery model by restoring backups (Views: 1467, Comments: 3)
• Series of "Bad habits to kick" by Aaron Bertrand (Views: 5299, Comments: 4)
• SQL University and why you should be attending (Views: 3258, Comments: 1)
• Derived Column and the Data Flow Task (Views: 4994, Comments: 1)
• To SA or not to SA (Views: 5771, Comments: 9)
• Suffer to succeed. Another SQL Server Import Story (Views: 1820, Comments: 0)
• Keep your DBA guard up at all times (Views: 5249, Comments: 0)
• 6 ways to import data into SQL Server (Views: 46991, Comments: 19)
• Using Mirroring to Reduce DB Migration Downtime (Part 2) (Views: 4363, Comments: 3)
• Using Mirroring to Reduce DB Migration Downtime (Part 1) (Views: 5319, Comments: 1)
• East Iowa SQL Saturday Oct. 17th (Views: 1079, Comments: 0)
• How I got started with SQL Server (Views: 1534, Comments: 4)
• Death by a thousand tools (Views: 2903, Comments: 2)
• Recover a database without the ldf file (Views: 13490, Comments: 21)
• Working with Excel to match data 101 (Views: 3014, Comments: 3)
• Instance design; Where to do your work as a DBA and DB Developer (Views: 2993, Comments: 2)
• Dynamic Data Sources in SSRS (Views: 8220, Comments: 1)
• Restoring multiple transaction log backups (Views: 3064, Comments: 1)
• Go ahead and click it! I triple dog dare you!!! (Views: 2462, Comments: 7)
• Push your DBA skills over the edge by becoming a better developer (Views: 1846, Comments: 4)
• Dynamic column names and fields in SSRS (Custom Matrix) (Views: 29134, Comments: 13)
• DBA SQLCLR Procedures (Views: 2064, Comments: 0)
• Not a fan of the Report Manager in SSRS? Using SSRS procedures to get the job done (Views: 4633, Comments: 4)
• Why does my variable always have NULL in it? (Views: 2092, Comments: 2)
• Writing reports off third party databases the easy way (Views: 1224, Comments: 2)
• Removing replication and handling tables with identity seeds (Views: 2895, Comments: 0)
• Log Shipping for DR and failing back in case of disaster. The cheap way! (Views: 2145, Comments: 1)
• Get local lab and instances going. Replication / SQL Agent (Views: 2039, Comments: 0)
• Compression tools are a must for any DBA (Views: 3480, Comments: 7)
• SMO Script Index and FK's on a database (Views: 3657, Comments: 1)
• Stop mirroring for server reboot (Views: 2653, Comments: 1)
• SSIS Import all text files. Use RegEx parse out strings (Views: 9093, Comments: 2)
• Read data on Mirror to prevent production database stress (Views: 3404, Comments: 1)
• Using one Parameter for Multiple Datasets in Reporting Services (Views: 6959, Comments: 5)
• Disaster/Recovery for Reporting Services objects (rdl, rds etc..) (Views: 5818, Comments: 1)
• Handling long running queries with a stop sign (Views: 5283, Comments: 1)
• Comparing the Chicago Highway System to your Disaster/Recovery Plans (Views: 2617, Comments: 3)
• Quick Data Model creation off SSAS Data Source in SSRS (Views: 3425, Comments: 3)
• Import directory of XML files into SQL Server 2005 (Views: 4340, Comments: 2)
• Blocking due to fragmented HEAP Tables (Views: 1929, Comments: 1)
• Please Mr. DBA, Change default passwords and use strong passwords (Views: 1304, Comments: 4)
• Split string in SQL Server 2005+ CLR vs. T-SQL (Views: 22350, Comments: 24)
• What makes a successful SQL Server Reporting Services implementation? (Views: 1858, Comments: 2)
• The DBA.. their role, expectations and future? (Views: 2609, Comments: 6)
• Add Report Wizard Layout Style (Standard Company Style) (Views: 2721, Comments: 2)
• Rebuild master and restore system databases from complete disk failure (Views: 9459, Comments: 4)
• Copy SQL Server Database (Views: 7746, Comments: 5)
• Send Excel formatted query results on schedules (Views: 2502, Comments: 1)
• SQL Server Agent Job history purging (Views: 4946, Comments: 0)
• Show message for SSRS reports that do not return data (Views: 7903, Comments: 8)
• ExecutionLog Table in SSRS 2008 Gone (Views: 4877, Comments: 0)
• Using VS.NET 2005 SP1 with SQL Server 2008 connectivity (Views: 1267, Comments: 7)
• Disable SQL Agent Jobs with TSQL based on events (Views: 3752, Comments: 2)
• Client Statistics in SSMS. Check execution times (Views: 3309, Comments: 1)
• Optimizing with indexing where commonly overlooked (Views: 1014, Comments: 3)
• Backups are for sissies!!! (Views: 2381, Comments: 2)
• Scan network for SQL Server instances (Views: 13843, Comments: 9)
• Overlooking system databases and fragmentation (Views: 3103, Comments: 3)
• Quest LiteSpeed update 5.0.2.1030 Released (Views: 1657, Comments: 0)
• Impersonating a SQL Server DBA (Views: 2101, Comments: 3)
• Index and Statistic creation with SQL Server DTA (Views: 2960, Comments: 7)
• Securing your password for SQL Server 2005 and 2008 and more (Views: 5790, Comments: 4)
• ReportViewer and the RSPrintClient Control Problems (Views: 3658, Comments: 4)
• SQL Agent Job Notifications (Views: 6339, Comments: 3)
• Do not truncate your ldf files! (Views: 20007, Comments: 11)
• Performance (How is my SQL Server running?) (Views: 3001, Comments: 2)
• Proactive Deadlock Notifications (Views: 7898, Comments: 7)
• Troubleshooting Blocking 101 on SQL Server (Views: 7988, Comments: 4)
• User to Schema to Roles for controlling security (Views: 2355, Comments: 2)