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: 332
• Total views: 1054862
• Average views per post: 3,177.30
• Total comments: 965
• Average comments per post: 2.91

• A big loss to our community (Views: 1353, Comments: 2)
• SQL Server Baseline Collection (Views: 11240, Comments: 2)
• Missing index suggestion – Duplicate Index (Views: 11190, Comments: 4)
• SQL Azure Log Space Errors 40552 (Views: 9582, Comments: 1)
• Buffer Latch Error Restoring SQL Server Database (Views: 11981, Comments: 1)
• Windows 8 for the Enterprise Event - Tuesday, April 16th (Views: 1217, Comments: 0)
• T-SQL Tuesday #41 - Presenting (Views: 1227, Comments: 0)
• A Week of SQL Server (Views: 1343, Comments: 1)
• Loading Large Volumes of Data into SQL Azure with SSIS (Views: 7379, Comments: 3)
• SQL Sentry - Providing Performance and Knowledge (Views: 2280, Comments: 0)
• Setting up Mirroring to SQL 2012 Availability Groups Encryption Error (Views: 2140, Comments: 0)
• Red Gate Releases SQL Backup Pro 7.3 (Views: 1171, Comments: 0)
• Direction of Intelligent Computing (Views: 1182, Comments: 0)
• Windows and SQL Server 2012 Test Setup (Views: 1058, Comments: 0)
• Define Microsoft Business Intelligence for me? (Views: 1785, Comments: 0)
• When do statistics update? (Views: 1616, Comments: 2)
• So you want a Windows 8 Phone? (Views: 1749, Comments: 2)
• A Glance of Plan Explorer Pro’s Deadlock Analysis (Views: 2160, Comments: 1)
• Driving Predictive Analytics (Views: 2281, Comments: 0)
• Do not disable foreign keys (Views: 2443, Comments: 7)
• Database Designing With Performance In Mind (Views: 2019, Comments: 4)
• Import Wizard - Microsoft.ACE.OLEDB 12.0 provider is not registered (Views: 1579, Comments: 1)
• Creating statistics manually – Duplicate Statistics (Views: 1265, Comments: 0)
• Blogging isn’t easy unless you have support (Views: 1470, Comments: 2)
• SHOW_STATISTICS Density showing key column - Why? (Views: 2083, Comments: 0)
• Successful Consulting Series - Interviewing for a Consulting Position (Views: 1949, Comments: 0)
• Successful Consulting Series - Work Ethics as a Consultant (Views: 1800, Comments: 0)
• Successful Consulting Series – Career Paths (Views: 2098, Comments: 0)
• Successful Consulting Series - Difficult Clients (Views: 1740, Comments: 0)
• Update Table Based on a JOIN (Views: 1788, Comments: 0)
• Successful Consulting Series - Time Management (Views: 1916, Comments: 1)
• Successful Consulting Series - Estimating Work (Views: 1833, Comments: 3)
• SQL Server Query Tuning – Back to Basics (Views: 4677, Comments: 2)
• A Month with BlueMetal (Views: 1248, Comments: 0)
• Successful Consulting Series - Overcomplicating, Stress...Freaking Out! (Views: 2065, Comments: 2)
• Successful Consulting Series - Travel, Expenses, Pain (Views: 1939, Comments: 0)
• Successful Consulting Series – Technical Aptitude (Views: 1829, Comments: 0)
• Presenting Yourself – Visually and Respectfully (Views: 2431, Comments: 3)
• Successful Consulting Series (Views: 2509, Comments: 3)
• Utilizing SQL Server Reports from SSMS (Views: 2321, Comments: 1)
• Expert Performance Indexing for SQL Server 2012 for $15 (Views: 2724, Comments: 1)
• Cardinality Estimate and Computed Columns (Views: 2671, Comments: 0)
• Short-Throw-Away T-SQL (Views: 2989, Comments: 6)
• The lost art of an IT Professional (Views: 1472, Comments: 6)
• SELECT 1 - Column Level Security (Views: 2524, Comments: 0)
• SELECT * vs SELECT 1 with EXISTS (Views: 3750, Comments: 2)
• Future, Career and Success – BlueMetal Architects (Views: 1838, Comments: 6)
• Removed Replication – rowguid added back (Views: 2443, Comments: 1)
• SSMS Add-in for Plan Explorer Update (Views: 2838, Comments: 0)
• Plan Explorer Pro – First Glance (Views: 2947, Comments: 2)
• Why does sys.dm_exec_requests not show my SPID? (Views: 2460, Comments: 1)
• Adding nonclustered index on primary keys (Views: 3284, Comments: 6)
• T-SQL Tuesday #35 - Horrify Me! (Views: 1313, Comments: 2)
• SQL Saturday #149 (Views: 1209, Comments: 1)
• SQL Server Training Bonanza (Views: 5014, Comments: 0)
• Plan Cache effects when dropping columns (Views: 4802, Comments: 0)
• Bad Code is like the birds (Views: 1103, Comments: 0)
• LOB Logical Reads twice the row count (Views: 3116, Comments: 1)
• Chicago Events - SQL and .NET (Views: 1759, Comments: 0)
• Migrating Replication Subscribing Databases (Views: 4606, Comments: 0)
• Index Seek on LOB Columns (Views: 4584, Comments: 0)
• SQL Saturday Indy - Invasion of SSIS (Views: 2846, Comments: 0)
• Merge Replication Baseline Collector (Views: 2980, Comments: 3)
• T-SQL Tuesday #32: A Day in the Life (Views: 2001, Comments: 0)
• Consulting – The best part? (Views: 2952, Comments: 5)
• Row Overflow Pages - Index Tuning (Views: 3011, Comments: 0)
• Balanced Data Distributor for SSIS 2012 Released (Views: 3305, Comments: 0)
• Does updating a column to itself get logged? #TSQL2sday 31 (Views: 3176, Comments: 0)
• SQL Saturday Speakers – Your submissions (Views: 1196, Comments: 3)
• SQL Saturday in Madison – The First (Views: 1002, Comments: 1)
• SQL Saturday Speakers – Thoughts when scheduling (Views: 1949, Comments: 8)
• Mentoring - As I see it (Views: 1813, Comments: 11)
• Using EXECUTE AS OWNER (Views: 3064, Comments: 0)
• SQLFriends May 18th – What questions do you have for me? (Views: 1446, Comments: 1)
• Columnstore Index – Index Statistics (Views: 3249, Comments: 0)
• Columnstore Index Basics (Views: 4316, Comments: 7)
• Another reason to show off your Tech - Happy Pi() (Views: 1412, Comments: 2)
• Knowing SQL Server and where it lives – T-SQL Tuesday #028 (Views: 2045, Comments: 3)
• Forgotten art of using what you know (Views: 1701, Comments: 1)
• Database Mirroring Deprecated in 2012 (Views: 2535, Comments: 9)
• Merge Replication – COM Based Resolver throws Buffer too small Error (Views: 1203, Comments: 0)
• CozyRoc Releases SSIS+ 1.6 Beta (Views: 860, Comments: 0)
• SQL Server Installation Error – Consistency validation for SQL Server Registry keys (Views: 3361, Comments: 0)
• onpnt on Linkedin - Feb #meme15 (Views: 783, Comments: 0)
• SQL Saturday in Atlanta – Oh my, the pre-cons (Views: 849, Comments: 0)
• Merge Replication – Filtered Data Publication Setup (Views: 1126, Comments: 0)
• Row-Level and Column-Level tracking in Merge Replication (Views: 1361, Comments: 0)
• SQL Server and xp_cmdshell - The good, the bad and more ugly (Views: 2051, Comments: 2)
• Automating Index Statistics Collection with SSIS – The fast one (Views: 1067, Comments: 0)
• Madison SQL Server User Group (Views: 699, Comments: 1)
• Automating Index Statistics Collection (Views: 1405, Comments: 8)
• Take advantage of Database Mirroring in your applications (Views: 1325, Comments: 0)
• Estimating Mean Uptime for Team-based uptime measurements (Views: 1007, Comments: 0)
• Could not find stored procedure 'sp_ExecuteSQL' (Views: 2380, Comments: 4)
• January #Meme15 Assignment – Twitter, the Blog, taking over the universe (Views: 713, Comments: 0)
• Friday SQL Nugget #1 (Views: 750, Comments: 0)
• LessThanDot Bloggers Weekly 12/11 (Views: 505, Comments: 2)
• Why I started and continue to blog - #Meme15 on Blogging (Views: 664, Comments: 3)
• SQL Server Integration Services tools to have – Configuration File Editor (Views: 589, Comments: 0)
• Troubleshooting Merge Replication Performance – Indexing Publications (Views: 811, Comments: 0)
• Fixing orphaned database users in 2005 to 2012 - T-SQL Tuesday #025 (Views: 3218, Comments: 0)
• Troubleshooting Merge Replication – Logging (Views: 1010, Comments: 0)
• Merge Replication – Parameterized Filters (Views: 903, Comments: 0)
• SQL Saturday in Chicago - Third year! (Views: 546, Comments: 0)
• Red Gate’s new SQL Index Manager (Views: 1153, Comments: 3)
• SQL Server Integration Services tools to have – Expression Editor & Tester (Views: 994, Comments: 0)
• SQL Saturday in Wisconsin is a reality! (Views: 2314, Comments: 7)
• Dynamic Connections in SSIS – Extract, Transform and Load (Views: 1376, Comments: 0)
• Shared Connections – New level of efficiency in SSIS 2012 (Views: 1058, Comments: 4)
• Meme Monday for December (Views: 557, Comments: 3)
• SQL Server 2012 RC0 is here! (Views: 1135, Comments: 1)
• SQL Saturday in Minnesota down to a few days! (Views: 699, Comments: 0)
• Blogging Tip - Removing Sensitive Information from Images (Views: 1609, Comments: 4)
• SSIS Interview questions - Answers (Views: 4049, Comments: 0)
• SSIS Test yourself with these interview questions (Views: 4683, Comments: 6)
• SSMS Assembly Error - Microsoft.SqlServer.Sqm.dll (Views: 1453, Comments: 0)
• SQL Saturday #99 Minnesota - #SQLAwesome (Views: 762, Comments: 0)
• Fix Execution Plan showing Parallelism (Views: 884, Comments: 2)
• SQL Server Views and Metadata (Views: 1142, Comments: 2)
• SQL Saturday Iowa another success! (Views: 531, Comments: 0)
• SQL Server Deep Dives Volume 2 (Views: 1103, Comments: 1)
• Troubleshooting SQL Server: A guide for the Accidental DBA (Views: 1567, Comments: 0)
• T-SQL Tuesday #21 - A trigger can do that! (Views: 2263, Comments: 6)
• Desktop Computing is Dead (Views: 2999, Comments: 9)
• SQL Saturday Pensacola - Measure of success (Views: 709, Comments: 3)
• SQL Server 2008 R2 Setup starts and then disappears (Views: 3200, Comments: 7)
• SQL Server DBA Tip 16 – Working with Files and Folders (Views: 1196, Comments: 2)
• SQL Server DBA Tip 15 – SQL Server Agent – Job ownership (Views: 4083, Comments: 1)
• SQL Server DBA Tip 14 – SQL Server General – Updating Production Data (Views: 1275, Comments: 1)
• SQL Server DBA Tip 13 – SQL Server built in DR/HA Solutions (Views: 1199, Comments: 0)
• SQL Server DBA Tip 12 – SQL Server Tuning – Missing Index DMV (Views: 1273, Comments: 3)
• SQL Server DBA Tip 11 – SQL Server Configuration – MIN Memory (Views: 1137, Comments: 1)
• SQL Server DBA Tip 10 – SQL Server Reporting – Offload the reporting factor (Views: 1972, 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: 1852, Comments: 2)
• SQL Server DBA Tip 8 - Server Monitoring - Baseline (Views: 3754, Comments: 5)
• SQL Server DBA Tip 7 - Server Security and grouping – Schema Control (Views: 1400, Comments: 1)
• Compressing Data with Uniqueidentifier columns (Views: 1079, Comments: 2)
• SQL Server DBA Tip 6 - Server Security – Windows Authentication / SQL Authentication (Views: 1271, Comments: 1)
• SQL Server DBA Tip 5 - Server Considerations - Installing Features (SSIS, SSRS, Engine, SSAS) (Views: 1113, Comments: 1)
• SQL Server DBA Tip 4 - Server Considerations – 32 bit / 64 bit (Views: 1118, Comments: 5)
• SQL Server DBA Tip 3 - Server Configuration – Model Database (Views: 1088, Comments: 4)
• SQL Server DBA Tip 2 - Server Configuration – Data/Log Files (Views: 1656, Comments: 8)
• SQL Server DBA Tip 1 - Server Configuration – MAX Memory (Views: 2014, Comments: 5)
• Difference between a Cumulative Update and Service Pack for SQL Server (Views: 3613, Comments: 1)
• Should SQL Server Professionals Learn Oracle? (Views: 2259, Comments: 11)
• SQL Saturday #77 - Pensacola, FL (Views: 632, Comments: 1)
• Bulk loading data into a merge replicated table (Views: 4074, Comments: 0)
• Compress Data Partition Snapshots with SSIS - SQL University (Views: 2156, Comments: 0)
• Think about your presentation and who reviews it (Views: 958, Comments: 5)
• SQL University – Performance Week (Views: 1579, Comments: 0)
• Meme Monday: Eleven Words or Less (Views: 936, Comments: 3)
• Automate Database Restore to Remote Instance with SSIS (Views: 7034, Comments: 7)
• Thanks, LessThanDot (Views: 562, Comments: 5)
• SQL Saturday in Chicago 2011 Eval (Views: 1186, Comments: 8)
• Twitter and the SQL Help hash tag - Questions only! (Views: 1330, Comments: 2)
• T-SQL Tuesday #016 - COUNT and DELETE duplicates (Views: 1864, Comments: 1)
• SQL Saturday in Chicago the second (Views: 519, Comments: 3)
• Professional Development –Building Relationships (Views: 1416, Comments: 0)
• Professional Development Week, Comfort Zone (Views: 1653, Comments: 6)
• Professional Development Week, An introduction to this week on SQL University (Views: 1245, Comments: 3)
• Twitter – I do want to follow you but… (Views: 1011, Comments: 2)
• Renaming Physical Database Files (Views: 1865, Comments: 0)
• T-SQL Tuesday#15 – Automation with PowerShell (Replace with RegEx) (Views: 2434, Comments: 8)
• Reflector to cost us now (Views: 1225, Comments: 9)
• Backup file contents with SSIS – INSERT/UPDATE Decisions (Views: 2000, 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: 1899, Comments: 2)
• Backup file contents with SSIS - Defining the Design (Views: 1247, Comments: 0)
• First glance at the new Red Gate SQL Monitor (Views: 3023, Comments: 3)
• Using RMO to run replication tasks (Views: 890, Comments: 0)
• Policy-Based Management for SQL Agent History (Views: 1527, Comments: 0)
• Running older compatibility levels in newer versions (Views: 2706, Comments: 1)
• Procedure expects parameter error from SqlCommand (Views: 2180, Comments: 6)
• T-SQL Tuesday #13: What the Business Says Is Not What the Business Wants (Views: 1266, Comments: 1)
• Build your resume for the position (Views: 2088, Comments: 3)
• Mirroring and Transactional Replication setup – Auto Failover (Views: 4409, Comments: 4)
• Run SSIS Package from Stored Procedure (Views: 9722, Comments: 5)
• What am I thankful for? (Views: 1014, Comments: 4)
• Using SSIS to import a directory of images (Views: 4407, Comments: 4)
• Moving on (Views: 1259, Comments: 11)
• My first PASS attendance (Views: 1644, Comments: 2)
• Execution Plans - Indexing to achieve optimal query plans (Views: 3581, Comments: 4)
• Who shrunk the files? (DBCC SHRINKFILE Audit) (Views: 1594, Comments: 0)
• PASS Summit is upon us (Views: 799, Comments: 2)
• SQLCop behind a Proxy (Views: 1910, Comments: 3)
• Wisconsin SQL Server User Group (Views: 1450, Comments: 4)
• The History of SQL Server Integration Services (Views: 2985, Comments: 2)
• SSIS runs in BIDS but not with SQL Agent (Views: 6911, Comments: 8)
• Doing this for the SQL Community (Views: 957, Comments: 3)
• Have SQL, will travel – East Iowa SQL Saturday (Views: 5216, Comments: 3)
• SQL Saturday Iowa (Views: 1170, Comments: 2)
• The Lazy DBA Series: Wizards! (Views: 2532, Comments: 4)
• The Lazy DBA Series: High Availability (Views: 1828, Comments: 2)
• The Lazy DBA Series: Email me, I’m broke! (Views: 2575, Comments: 0)
• The Lazy DBA Series: Monitoring (Views: 1938, Comments: 0)
• The Lazy DBA Series: SQL Trace / Profiler (Views: 2245, Comments: 5)
• Making SSIS Dynamic: Passing variables between packages (Views: 9541, Comments: 1)
• Making SSIS Dynamic: Configuration Management (Views: 5412, Comments: 3)
• Creating a baseline for SQL Server (Views: 5900, Comments: 10)
• Baseline, Performance Reporting and being a proactive DBA (Views: 3898, Comments: 2)
• RID Lookup take me down (Views: 3996, Comments: 5)
• T-SQL Tuesday #008: Gettin' Schooled "Pushing others into learning and teaching" (Views: 1681, Comments: 2)
• Change Data Capture rundown 100 (setup) (Views: 3997, Comments: 4)
• MSDN Ultimate Subscription giveaway +1 (Views: 1836, Comments: 0)
• Being a finalist for the Exceptional DBA of the Year (Views: 2003, Comments: 11)
• SQL Community Services - Resources everywhere! (Views: 1780, Comments: 0)
• SQL University - Let's blog (Views: 1659, Comments: 3)
• SQL Server Forums – Helping to build a knowledge base (Views: 8184, Comments: 7)
• SQL Server and the Auto Close Setting (Views: 5710, Comments: 7)
• SQL Server and High Availability (Views: 4356, Comments: 0)
• SQL University - Recess time! (Views: 2199, Comments: 0)
• Log Shipping for cheap DR (Views: 5997, Comments: 6)
• T-SQL Tuesday - Give me my cores SSIS 2008! (Views: 2654, Comments: 0)
• The SQL Server backup - foundation of any Disaster / Recovery (Views: 4325, Comments: 1)
• Welcome to HA and DR week! (Views: 2091, Comments: 5)
• Removing old files with SSIS (Views: 6643, Comments: 13)
• Report Manager / Report Server Loading Slow Initially (Views: 6340, Comments: 1)
• Transaction Log expanding on restore after shrink (Views: 2494, Comments: 4)
• 12 ways to break your database server before the first transaction (Views: 2389, Comments: 8)
• Five things wouldn’t miss in SQL Server (Views: 1344, Comments: 6)
• Trusting Database Engine Tuning Advisor for Query Tuning (Views: 3623, Comments: 6)
• Mirroring Hands On with Developer Edition (Views: 2663, Comments: 2)
• SQL Connections Suburban Chicago Wrap Up (Views: 1249, Comments: 2)
• Planning your hardware for SQL Server Mirroring (Views: 2201, Comments: 1)
• SQL Connections Suburban Chicago May 2010 Meeting (SSIS Basics) (Views: 1170, Comments: 4)
• Planning your SQL Server mirroring landscape (Views: 2191, Comments: 0)
• Stripping rows out of file imports (Views: 2427, Comments: 6)
• The Measurement of Success – SQL Saturday Chicago (Views: 2689, Comments: 8)
• LessThanDot Sponsors SQL Saturday in Chicago (Views: 1062, Comments: 8)
• Delay Validation with SSIS Tasks (Views: 9440, Comments: 0)
• Index DMV usage considerations (Views: 4040, Comments: 1)
• Finding meaningful error details to report execution failures (Views: 2244, Comments: 2)
• Working with vendor-provided databases (Views: 1324, Comments: 4)
• Approach the SQL Community without hesitation! (Views: 2279, Comments: 13)
• Finding SQL Server Support - Become an expert yourself (Views: 7409, Comments: 5)
• Choosing operating modes for mirroring over a WAN (Views: 3112, Comments: 0)
• Using schemas to maintain order as a DBA (Views: 1810, Comments: 3)
• Mirroring: Witness misconceptions in High-Performance (Views: 3064, Comments: 0)
• SQL Saturday in Chicago - Schedule is up! (Views: 1099, Comments: 5)
• Read from your mirror in SQL Server (Views: 3890, Comments: 3)
• Backup and copy warm-standby (log shipped) databases in SQL Server (Views: 5655, Comments: 6)
• Three Events that Brought Me Here (Views: 1699, Comments: 12)
• Activity Monitor to gather statistics and health of SQL Server 2008 (Views: 3586, Comments: 3)
• Mirroring SQL Server 2005 to SQL Server 2008 (part 2) (Views: 8505, Comments: 2)
• Mirroring SQL Server 2005 to SQL Server 2008 (Part 1) (Views: 10876, Comments: 4)
• Goals for 2010 (Views: 1546, Comments: 3)
• Using Variables in SSIS: Purpose review and functional examples (Views: 5358, Comments: 3)
• Script Task vs Flat File Connection Management (Views: 3216, Comments: 2)
• The Good, the Bad and the Ugly of Database Design (Views: 6362, Comments: 14)
• Dynamic SQL Server connections in Reporting Services (Views: 3965, Comments: 4)
• Introducing SQL Server to Oracle (Views: 2261, Comments: 8)
• To BUILTIN\Admin or not to BUILTIN\Admin (Views: 4028, Comments: 4)
• Beginning stages of a DR plan for SQL Server (Views: 2811, Comments: 7)
• Back to business for the SQL Server community (Views: 1055, Comments: 0)
• Test your Full Recovery model by restoring backups (Views: 1467, Comments: 3)
• Series of "Bad habits to kick" by Aaron Bertrand (Views: 5294, Comments: 4)
• SQL University and why you should be attending (Views: 3257, Comments: 1)
• Derived Column and the Data Flow Task (Views: 4993, Comments: 1)
• To SA or not to SA (Views: 5766, Comments: 9)
• Suffer to succeed. Another SQL Server Import Story (Views: 1818, Comments: 0)
• Keep your DBA guard up at all times (Views: 5244, Comments: 0)
• 6 ways to import data into SQL Server (Views: 46936, Comments: 19)
• Using Mirroring to Reduce DB Migration Downtime (Part 2) (Views: 4355, Comments: 3)
• Using Mirroring to Reduce DB Migration Downtime (Part 1) (Views: 5311, Comments: 1)
• East Iowa SQL Saturday Oct. 17th (Views: 1078, Comments: 0)
• How I got started with SQL Server (Views: 1532, Comments: 4)
• Death by a thousand tools (Views: 2898, Comments: 2)
• Recover a database without the ldf file (Views: 13477, Comments: 21)
• Working with Excel to match data 101 (Views: 3012, Comments: 3)
• Instance design; Where to do your work as a DBA and DB Developer (Views: 2988, Comments: 2)
• Dynamic Data Sources in SSRS (Views: 8217, Comments: 1)
• Restoring multiple transaction log backups (Views: 3061, Comments: 1)
• Bringing your thoughts back into line (Views: 1558, Comments: 4)
• Go ahead and click it! I triple dog dare you!!! (Views: 2460, 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: 29103, Comments: 13)
• DBA SQLCLR Procedures (Views: 2063, Comments: 0)
• Not a fan of the Report Manager in SSRS? Using SSRS procedures to get the job done (Views: 4628, Comments: 4)
• Finding motivation after a smack in the face (Views: 1966, Comments: 8)
• Why does my variable always have NULL in it? (Views: 2092, Comments: 2)
• Writing reports off third party databases the easy way (Views: 1223, Comments: 2)
• Removing replication and handling tables with identity seeds (Views: 2893, Comments: 0)
• Log Shipping for DR and failing back in case of disaster. The cheap way! (Views: 2142, Comments: 1)
• Get local lab and instances going. Replication / SQL Agent (Views: 2036, Comments: 0)
• Compression tools are a must for any DBA (Views: 3474, Comments: 7)
• SMO Script Index and FK's on a database (Views: 3648, Comments: 1)
• Stop mirroring for server reboot (Views: 2649, Comments: 1)
• SSIS Import all text files. Use RegEx parse out strings (Views: 9082, Comments: 2)
• Read data on Mirror to prevent production database stress (Views: 3393, Comments: 1)
• Using one Parameter for Multiple Datasets in Reporting Services (Views: 6939, Comments: 5)
• Disaster/Recovery for Reporting Services objects (rdl, rds etc..) (Views: 5806, Comments: 1)
• Handling long running queries with a stop sign (Views: 5276, Comments: 1)
• Comparing the Chicago Highway System to your Disaster/Recovery Plans (Views: 2606, Comments: 3)
• Quick Data Model creation off SSAS Data Source in SSRS (Views: 3422, Comments: 3)
• Import directory of XML files into SQL Server 2005 (Views: 4334, Comments: 2)
• Blocking due to fragmented HEAP Tables (Views: 1927, 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: 22336, Comments: 24)
• What makes a successful SQL Server Reporting Services implementation? (Views: 1856, Comments: 2)
• The DBA.. their role, expectations and future? (Views: 2606, Comments: 6)
• Add Report Wizard Layout Style (Standard Company Style) (Views: 2720, Comments: 2)
• Rebuild master and restore system databases from complete disk failure (Views: 9446, Comments: 4)
• Copy SQL Server Database (Views: 7745, Comments: 5)
• Send Excel formatted query results on schedules (Views: 2498, Comments: 1)
• SQL Server Agent Job history purging (Views: 4939, Comments: 0)
• cidaemon.exe process CPU usage on Windows Server 2003 R2 (Views: 5764, Comments: 1)
• Show message for SSRS reports that do not return data (Views: 7890, Comments: 8)
• ExecutionLog Table in SSRS 2008 Gone (Views: 4873, 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: 3750, Comments: 2)
• Space heater * power strip = support disaster (Views: 2102, Comments: 3)
• Search the Internet Archive with the Wayback Machine (Views: 1318, Comments: 2)
• Client Statistics in SSMS. Check execution times (Views: 3306, Comments: 1)
• Optimizing with indexing where commonly overlooked (Views: 1010, Comments: 3)
• Backups are for sissies!!! (Views: 2377, Comments: 2)
• Scan network for SQL Server instances (Views: 13837, Comments: 9)
• Todo in 2009 (Views: 2934, Comments: 3)
• Overlooking system databases and fragmentation (Views: 3101, Comments: 3)
• Quest LiteSpeed update 5.0.2.1030 Released (Views: 1656, Comments: 0)
• Impersonating a SQL Server DBA (Views: 2099, Comments: 3)
• An ego will only hurt you: Toughest Challenges (Views: 1312, Comments: 4)
• Index and Statistic creation with SQL Server DTA (Views: 2959, Comments: 7)
• Securing your password for SQL Server 2005 and 2008 and more (Views: 5783, Comments: 4)
• ReportViewer and the RSPrintClient Control Problems (Views: 3653, Comments: 4)
• SQL Agent Job Notifications (Views: 6337, Comments: 3)
• Do not truncate your ldf files! (Views: 19971, Comments: 11)
• Performance (How is my SQL Server running?) (Views: 2998, Comments: 2)
• Proactive Deadlock Notifications (Views: 7892, Comments: 7)
• Troubleshooting Blocking 101 on SQL Server (Views: 7985, Comments: 4)
• User to Schema to Roles for controlling security (Views: 2355, Comments: 2)