Less Than Dot is a community of passionate IT professionals and enthusiasts dedicated to sharing technical knowledge, experience, and assistance. Inside you will find reference materials, interesting technical discussions, and expert tips and commentary. Once you register for an account you will have immediate access to the forums and all past articles and commentaries.
Your profile
Tag cloud - author
backup baseline blogging cdc community configuration files configuration variables database administration deprecated list disaster recovery dmf dmv dr dtsx execution plan forums free ha help high availability index integrated services learn log shipping maintenance mirroring monitoring new features parent child packages pass performance report server reporting resources restore rid lookup sql community sql response sql server sql server 2005 sql server 2008 sql server integration services sql server reporting services sql university sqlpass ssis ssis 2008 ssrs teach tracking data
Authors
- SQLDenis (302)

- chrissie1 (241)

- Ted Krueger (onpnt) (139)

- George Mastros (36)

- tarwn (31)

- Alex Ullrich (30)

- naomi (13)

- thatrickguy (12)

- ca8msm (8)

- chaospandion (8)

- thirster42 (8)

- damber (7)

- More...
Main Categories
Search
Google Ads
Ted Krueger (onpnt) 
List of posts with summary
- The Lazy DBA Series: Wizards! (Views: 432, Comments: 4)
- The Lazy DBA Series: High Availability (Views: 765, Comments: 2)
- The Lazy DBA Series: Email me, I’m broke! (Views: 1154, Comments: 0)
- The Lazy DBA Series: Monitoring (Views: 435, Comments: 0)
- The Lazy DBA Series: SQL Trace / Profiler (Views: 427, Comments: 5)
- Making SSIS Dynamic: Passing variables between packages (Views: 398, Comments: 0)
- Making SSIS Dynamic: Configuration Management (Views: 730, Comments: 2)
- Creating a baseline for SQL Server (Views: 1068, Comments: 5)
- Baseline, Performance Reporting and being a proactive DBA (Views: 1056, Comments: 2)
- RID Lookup take me down (Views: 907, Comments: 5)
- T-SQL Tuesday #008: Gettin' Schooled "Pushing others into learning and teaching" (Views: 464, Comments: 2)
- Change Data Capture rundown 100 (setup) (Views: 843, Comments: 3)
- MSDN Ultimate Subscription giveaway +1 (Views: 345, Comments: 0)
- Being a finalist for the Exceptional DBA of the Year (Views: 651, Comments: 11)
- SQL Community Services - Resources everywhere! (Views: 562, Comments: 0)
- SQL University - Let's blog (Views: 699, Comments: 3)
- SQL Server Forums – Helping to build a knowledge base (Views: 642, Comments: 7)
- SQL Server and the Auto Close Setting (Views: 744, Comments: 5)
- SQL Server and High Availability (Views: 974, Comments: 0)
- SQL University - Recess time! (Views: 341, Comments: 0)
- Log Shipping for cheap DR (Views: 2001, Comments: 2)
- T-SQL Tuesday - Give me my cores SSIS 2008! (Views: 714, Comments: 0)
- The SQL Server backup - foundation of any Disaster / Recovery (Views: 1074, Comments: 0)
- Welcome to HA and DR week! (Views: 590, Comments: 4)
- Removing old files with SSIS (Views: 1023, Comments: 12)
- Report Manager / Report Server Loading Slow Initially (Views: 912, Comments: 0)
- Transaction Log expanding on restore after shrink (Views: 915, Comments: 4)
- 12 ways to break your database server before the first transaction (Views: 883, Comments: 7)
- Five things wouldn’t miss in SQL Server (Views: 605, Comments: 6)
- Trusting Database Engine Tuning Advisor for Query Tuning (Views: 955, Comments: 5)
- Mirroring Hands On with Developer Edition (Views: 620, Comments: 2)
- SQL Connections Suburban Chicago Wrap Up (Views: 358, Comments: 2)
- Planning your hardware for SQL Server Mirroring (Views: 502, Comments: 0)
- SQL Connections Suburban Chicago May 2010 Meeting (SSIS Basics) (Views: 399, Comments: 4)
- Planning your SQL Server mirroring landscape (Views: 503, Comments: 0)
- Stripping rows out of file imports (Views: 575, Comments: 6)
- The Measurement of Success – SQL Saturday Chicago (Views: 1046, Comments: 8)
- LessThanDot Sponsors SQL Saturday in Chicago (Views: 530, Comments: 8)
- Delay Validation with SSIS Tasks (Views: 1118, Comments: 0)
- Index DMV usage considerations (Views: 1200, Comments: 1)
- Finding meaningful error details to report execution failures (Views: 563, Comments: 2)
- Working with vendor-provided databases (Views: 634, Comments: 4)
- Approach the SQL Community without hesitation! (Views: 1476, Comments: 13)
- Finding SQL Server Support - Become an expert yourself (Views: 1296, Comments: 5)
- Choosing operating modes for mirroring over a WAN (Views: 984, Comments: 0)
- Using schemas to maintain order as a DBA (Views: 861, Comments: 3)
- Mirroring: Witness misconceptions in High-Performance (Views: 1142, Comments: 0)
- SQL Saturday in Chicago - Schedule is up! (Views: 525, Comments: 5)
- Read from your mirror in SQL Server (Views: 1381, Comments: 3)
- Backup and copy warm-standby (log shipped) databases in SQL Server (Views: 1360, Comments: 2)
- Three Events that Brought Me Here (Views: 741, Comments: 12)
- Activity Monitor to gather statistics and health of SQL Server 2008 (Views: 970, Comments: 2)
- Mirroring SQL Server 2005 to SQL Server 2008 (part 2) (Views: 1642, Comments: 2)
- Mirroring SQL Server 2005 to SQL Server 2008 (Part 1) (Views: 2368, Comments: 1)
- Goals for 2010 (Views: 610, Comments: 3)
- Using Variables in SSIS: Purpose review and functional examples (Views: 2215, Comments: 2)
- Script Task vs Flat File Connection Management (Views: 1209, Comments: 2)
- The Good, the Bad and the Ugly of Database Design (Views: 4024, Comments: 14)
- Dynamic SQL Server connections in Reporting Services (Views: 1419, Comments: 4)
- Introducing SQL Server to Oracle (Views: 795, Comments: 8)
- To BUILTIN\Admin or not to BUILTIN\Admin (Views: 1384, Comments: 4)
- Beginning stages of a DR plan for SQL Server (Views: 921, Comments: 7)
- Back to business for the SQL Server community (Views: 274, Comments: 0)
- Test your Full Recovery model by restoring backups (Views: 674, Comments: 3)
- Series of "Bad habits to kick" by Aaron Bertrand (Views: 3109, Comments: 4)
- SQL University and why you should be attending (Views: 1415, Comments: 1)
- Derived Column and the Data Flow Task (Views: 2571, Comments: 0)
- To SA or not to SA (Views: 3349, Comments: 9)
- Suffer to succeed. Another SQL Server Import Story (Views: 1018, Comments: 0)
- Keep your DBA guard up at all times (Views: 2840, Comments: 0)
- 6 ways to import data into SQL Server (Views: 15509, Comments: 18)
- Using Mirroring to Reduce DB Migration Downtime (Part 2) (Views: 1950, Comments: 0)
- Using Mirroring to Reduce DB Migration Downtime (Part 1) (Views: 2079, Comments: 1)
- East Iowa SQL Saturday Oct. 17th (Views: 584, Comments: 0)
- How I got started with SQL Server (Views: 823, Comments: 4)
- Death by a thousand tools (Views: 1885, Comments: 2)
- Recover a database without the ldf file (Views: 5789, Comments: 21)
- Working with Excel to match data 101 (Views: 1858, Comments: 3)
- Instance design; Where to do your work as a DBA and DB Developer (Views: 1689, Comments: 2)
- Dynamic Data Sources in SSRS (Views: 3786, Comments: 1)
- Restoring multiple transaction log backups (Views: 913, Comments: 0)
- Bringing your thoughts back into line (Views: 851, Comments: 4)
- Go ahead and click it! I triple dog dare you!!! (Views: 1180, Comments: 7)
- Push your DBA skills over the edge by becoming a better developer (Views: 1149, Comments: 4)
- Dynamic column names and fields in SSRS (Custom Matrix) (Views: 10442, Comments: 11)
- DBA SQLCLR Procedures (Views: 1040, Comments: 0)
- Not a fan of the Report Manager in SSRS? Using SSRS procedures to get the job done (Views: 2039, Comments: 3)
- Finding motivation after a smack in the face (Views: 1452, Comments: 8)
- Why does my variable always have NULL in it? (Views: 1414, Comments: 2)
- Writing reports off third party databases the easy way (Views: 674, Comments: 2)
- Removing replication and handling tables with identity seeds (Views: 1342, Comments: 0)
- Log Shipping for DR and failing back in case of disaster. The cheap way! (Views: 879, Comments: 1)
- Get local lab and instances going. Replication / SQL Agent (Views: 1355, Comments: 0)
- Compression tools are a must for any DBA (Views: 1944, Comments: 7)
- SMO Script Index and FK's on a database (Views: 1337, Comments: 0)
- Stop mirroring for server reboot (Views: 848, Comments: 0)
- SSIS Import all text files. Use RegEx parse out strings (Views: 4074, Comments: 2)
- Read data on Mirror to prevent production database stress (Views: 1183, Comments: 1)
- Using one Parameter for Multiple Datasets in Reporting Services (Views: 2047, Comments: 5)
- Disaster/Recovery for Reporting Services objects (rdl, rds etc..) (Views: 2254, Comments: 1)
- Handling long running queries with a stop sign (Views: 2983, Comments: 1)
- Comparing the Chicago Highway System to your Disaster/Recovery Plans (Views: 1000, Comments: 3)
- Quick Data Model creation off SSAS Data Source in SSRS (Views: 1502, Comments: 3)
- Import directory of XML files into SQL Server 2005 (Views: 1778, Comments: 2)
- Blocking due to fragmented HEAP Tables (Views: 827, Comments: 1)
- Please Mr. DBA, Change default passwords and use strong passwords (Views: 644, Comments: 4)
- Split string in SQL Server 2005+ CLR vs. T-SQL (Views: 10354, Comments: 23)
- What makes a successful SQL Server Reporting Services implementation? (Views: 956, Comments: 1)
- The DBA.. their role, expectations and future? (Views: 1353, Comments: 5)
- Add Report Wizard Layout Style (Standard Company Style) (Views: 1433, Comments: 2)
- Rebuild master and restore system databases from complete disk failure (Views: 3445, Comments: 4)
- Copy SQL Server Database (Views: 3356, Comments: 3)
- Send Excel formatted query results on schedules (Views: 1000, Comments: 1)
- SQL Server Agent Job history purging (Views: 2129, Comments: 0)
- cidaemon.exe process CPU usage on Windows Server 2003 R2 (Views: 1624, Comments: 0)
- Show message for SSRS reports that do not return data (Views: 2804, Comments: 8)
- ExecutionLog Table in SSRS 2008 Gone (Views: 2548, Comments: 0)
- Using VS.NET 2005 SP1 with SQL Server 2008 connectivity (Views: 615, Comments: 7)
- Disable SQL Agent Jobs with TSQL based on events (Views: 1631, Comments: 2)
- Space heater * power strip = support disaster (Views: 1026, Comments: 3)
- Search the Internet Archive with the Wayback Machine (Views: 755, Comments: 2)
- Client Statistics in SSMS. Check execution times (Views: 1377, Comments: 1)
- Optimizing with indexing where commonly overlooked (Views: 353, Comments: 3)
- Backups are for sissies!!! (Views: 1084, Comments: 2)
- Scan network for SQL Server instances (Views: 6742, Comments: 8)
- Todo in 2009 (Views: 2547, Comments: 3)
- Overlooking system databases and fragmentation (Views: 2284, Comments: 3)
- Quest LiteSpeed update 5.0.2.1030 Released (Views: 892, Comments: 0)
- Impersonating a SQL Server DBA (Views: 1407, Comments: 3)
- An ego will only hurt you: Toughest Challenges (Views: 819, Comments: 4)
- Index and Statistic creation with SQL Server DTA (Views: 1794, Comments: 7)
- Securing your password for SQL Server 2005 and 2008 and more (Views: 3657, Comments: 4)
- ReportViewer and the RSPrintClient Control Problems (Views: 2134, Comments: 4)
- SQL Agent Job Notifications (Views: 3568, Comments: 3)
- Do not truncate your ldf files! (Views: 6744, Comments: 9)
- Performance (How is my SQL Server running?) (Views: 1520, Comments: 2)
- Proactive Deadlock Notifications (Views: 3034, Comments: 5)
- Troubleshooting Blocking 101 on SQL Server (Views: 4922, Comments: 4)
- User to Schema to Roles for controlling security (Views: 1311, Comments: 2)
Back to authorslist

LTD Social Sitings
Note: Watch for social icons on posts by your favorite authors to follow their postings on these and other social sites.