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.
Authors
- All (2380)
- Alex Ullrich (55)
- Axel Achten (axel8s) (28)
- Bert Michielsen (1)
- Brian Davis (7)
- Mark (ca8msm) (10)
- chaospandion (10)
- Howard (chopstik) (20)
- Christiaan Baes (chrissie1) (568)
- damber (9)
- David Forck (thirster42) (24)
- Eli Weinstock-Herman (191)
- Erik (8)
- George Mastros (gmmastros) (45)
- Hope Foley (3)
- Jes Borland (202)
- Joshua Fennessy (7)
- Kaht (3)
- Kevin Conan (18)
- Koen Verbeeck (100)
- Naomi Nosonovsky (27)
- Niikola (3)
- Paul Timmerman (9)
- pmch22 (3)
- Paul (ptheriault) (6)
- Ramireddy (4)
- Remou (4)
- riverguy (2)
- Rob Earl (14)
- Rose Waters (3)
- Sam Vanga (4)
- Stephen (sqlarcher) (11)
- SQLDenis (597)
- SQLology ~ Kim Tessereau (6)
- Steve Hughes (DataOnWheels) (5)
- Tahir Khalid (vurso) (5)
- Ted Krueger (onpnt) (355)
- Rick (ThatRickGuy) (12)
Top Categories
- All (2380)
- Microsoft SQL server (664)
- Microsoft SQL server admin (541)
- Data modelling and design (453)
- Database programming (453)
- Database administration (366)
- Microsoft technologies (354)
- Vb.net (223)
- Professional development (193)
- C# (137)
- Business intelligence (134)
- Ethics and it (113)
- Web design, graphics and styling (86)
- Asp.net (83)
- Ssrs (81)
- Uncategorized (77)
Jes Borland
About Jes Borland

Summary
- Active from December 2010 to April 2018
- 202 posts published
Table of Contents
Posts
2018 (2 posts)
- Replacing Trace Flags 1204 and 1222 with the Extended Events system_health Session on April 24, 2018
- \"North to Alaska\" on March 1, 2018
2017 (3 posts)
- Use ostress to load test a SQL database on October 26, 2017
- Catch my keynote at Chicago Code Camp 2017! on March 28, 2017
- You Are Responsible for Telling Your Story on January 27, 2017
2016 (16 posts)
- Transactional Replication from Availability Groups to Azure SQL Database: Part 5 – Testing on December 30, 2016
- Transactional Replication from Availability Groups to Azure SQL Database: Part 4 – The Subscriber on December 29, 2016
- Transactional Replication from Availability Groups to Azure SQL Database: Part 3 – The Publisher on December 28, 2016
- Transactional Replication from Availability Groups to Azure SQL Database: Part 2 – The Distributor on December 27, 2016
- Transactional Replication from Availability Groups to Azure SQL Database: Part 1 – Planning on December 26, 2016
- T-SQL Tuesday #84: Growing New Speakers – Dealing with Failure on November 8, 2016
- I'm talking SQL Server, Azure, and Extended Events at SQLintersection on August 18, 2016
- Learn more about Azure + SQL Server at SQLSaturday Minnesota on August 15, 2016
- Help me kick off Wausau PASS! on July 20, 2016
- The Standing Desk on July 11, 2016
- Help, my company won't pay for training! on June 23, 2016
- Testing SQL Server with an Application on June 21, 2016
- Time to pack your tent for That Conference 2016! on June 13, 2016
- Never drag and drop files between servers again! on February 19, 2016
- What I Learned on SQL Cruise 2016 on February 15, 2016
- Learn about SQL Server in Azure in Madison, WI on January 27, 2016
2015 (23 posts)
- 5 Questions with Derik Hammer on December 9, 2015
- Training in Boston: How to Get Started Using SQL Server in Azure on December 2, 2015
- Prepare to Set Sail on SQL Cruise Caribbean 2016 on November 23, 2015
- 5 Questions with Amanda Crisp on November 18, 2015
- 5 Questions With Meagan Longoria on October 21, 2015
- 5 Questions with Mike Fal on October 14, 2015
- Turning a Notepad outline into a PowerPoint presentation on October 8, 2015
- Get the Most Out of Your Upcoming Conference on September 11, 2015
- 5 Questions with Chris Yates on August 26, 2015
- Being Better on August 13, 2015
- 5 Questions with Russ Thomas on July 29, 2015
- 5 Questions with Mala Mahadevan on July 15, 2015
- 5 Questions with Josh Fennessy on July 1, 2015
- T-SQL Tuesday #67 Extended Events Wrap-up on June 17, 2015
- Level Up Your SQL Server Index Knowledge on June 12, 2015
- T-SQL Tuesday #67 – What Extended Events is Missing on June 9, 2015
- You're Invited to T-SQL Tuesday #67: Extended Events on June 2, 2015
- User Group Survey on March 30, 2015
- Viewing Execution Plans in Visual Studio on March 28, 2015
- Slides from Execution Plans: The Secret to Query Tuning Success at NEW Code Camp on March 28, 2015
- Writing another chapter in my career book on March 3, 2015
- SQL Cruise Caribbean 2015: More Than A Cruise With Classes. Much More. on February 19, 2015
- SQL Server on the High Seas on January 7, 2015
2014 (8 posts)
- PASS Summit 2014 WIT Luncheon Recap on November 12, 2014
- Book Review: Fundamentals of SQL Server 2012 Replication on October 1, 2014
- October Presentations on September 30, 2014
- PASS elections are here, and this is who I'm supporting on September 24, 2014
- Split a Query Window in SSMS on September 10, 2014
- September presentations on August 28, 2014
- T-SQL Tuesday #052 – Why Back Up System Databases? on March 11, 2014
- SQL Saturday Madison Pre-Con: Make Me a Tuning Believer on February 17, 2014
2013 (39 posts)
- A New Solution for Monitoring SQL Server on December 30, 2013
- Book Review: Inside the SQL Server Query Optimizer on December 23, 2013
- T-SQL Tuesday #49: SQL Server, Waits, and You on December 10, 2013
- Advice for Aspiring Data Professionals on December 10, 2013
- Document Your SQL Server Databases with Extended Properties on November 6, 2013
- Take the First Step on October 28, 2013
- PASS Summit 2013 on September 11, 2013
- Creating Custom Color Palettes in SSRS Charts on July 24, 2013
- T-SQL Tuesday #44 – The Second Chance on July 9, 2013
- Book Review: Pro SQL Server 2008 Failover Clustering on June 25, 2013
- Stepping Outside the Comfort Zone on June 17, 2013
- Another Smashing Success: SQL Saturday Madison 2013 on April 11, 2013
- T-SQL Tuesday #41 – Presenting: Be Prepared on April 9, 2013
- A User Group Experiment – Open Mic Night on April 4, 2013
- SSRS Properties – Chart Series Label Visibility on February 26, 2013
- SSRS Properties – Chart Series Tooltip on February 25, 2013
- SSRS Properties – Chart Axis Minimum, Maximum, and Interval on February 22, 2013
- SSRS Properties – Image Source on February 21, 2013
- SSRS Properties – CanGrow and CanShrink on February 20, 2013
- SSRS Properties – InnerPlotPosition on February 19, 2013
- SSRS Properties – VerticalAlign on February 18, 2013
- SSRS Properties – RepeatWith on February 15, 2013
- SSRS Properties – WritingMode on February 14, 2013
- SSRS Properties – Document Map on February 13, 2013
- SSRS Properties – NoRowsMessage on February 12, 2013
- SSRS Properties – FixedRowHeaders on February 11, 2013
- SSRS Properties – FixedColumnHeaders on February 8, 2013
- SSRS Properties – Interactive Sort on February 7, 2013
- SSRS Properties – Tablix Sorting on February 6, 2013
- SSRS Properties – Tablix Filters on February 5, 2013
- SSRS Properties – Hidden & ToggleItem on February 4, 2013
- SSRS Properties – Description on February 1, 2013
- SSRS Properties – Columns on January 31, 2013
- SSRS Properties – Background Image on January 30, 2013
- Making Data Tell a Story With SSRS Properties on January 30, 2013
- Join Me At SQL Saturday #175 Fargo, ND on January 23, 2013
- SQL Saturday #206 Madison 2013 on January 23, 2013
- Book Review: Pro SQL Server 2012 Practices – Indexing Outside the Bubble on January 14, 2013
- Book Review: Expert Performance Indexing for SQL Server 2012 on January 3, 2013
2012 (54 posts)
- Successful Consulting Series – Consulting vs. Fulltime Employment – Making a Decision on December 21, 2012
- A Look Inside SQL Server Row and Page Compression on December 19, 2012
- \"The What, Why, and How of Filegroups\" – I-380 PASS Materials on December 12, 2012
- Book Review: On Writing Well on November 28, 2012
- Is being a DBA still sexy? on November 14, 2012
- A Few Notes About Creating Custom SSMS Reports on October 31, 2012
- Hex Editoring on October 30, 2012
- I'm An Author! "Pro SQL Server 2012 Practices" Releases October 31 on October 25, 2012
- Cheers to Tech on Tap v1.3 PowerShell! on October 24, 2012
- My PASS Summit Packing List on October 23, 2012
- Book Review: SQL Server Hardware on October 22, 2012
- T-SQL Tuesday #35: Soylent Green SQL Server on October 9, 2012
- Free SQL Server Tools on August 31, 2012
- Presenting at Red Gate's SQL in the City Chicago 2012 on August 28, 2012
- Road Trip Time! Presenting at SQL Saturday #149 Minnesota on August 27, 2012
- Join me at SQL Friends Lunch #4 Chicago! on August 23, 2012
- Presenting "What is Report Builder 3.0?" for OKPASS on August 22, 2012
- Saying Farewell to MADPASS and Hello to FoxPASS on August 21, 2012
- Book Review: Troubleshooting SQL Server – A Guide for the Accidental DBA on August 1, 2012
- T-SQL Tuesday 32: A Day in the Life a Grrl Geek on July 17, 2012
- Quad Cities PASS "Make Your Voice Heard" Presentation Materials on July 12, 2012
- Thoughts on User Groups, Speaking, and Paying It Forward on June 28, 2012
- Presenting "The What, Why, and How of Filegroups" for PASSMN on June 14, 2012
- T-SQL Tuesday #31 – Reporting Services Logs on June 12, 2012
- The Tech on Tap v1.2 SharePoint Top 10 on June 11, 2012
- Book Review: SQL Server MVP Deep Dives on May 23, 2012
- Brewing Up Tech on Tap v1.2 SharePoint on May 22, 2012
- SQL Saturday #119 Chicago 2012: They Did It. Again. on May 21, 2012
- Report Builder 3.0 – Report Parts on May 11, 2012
- Windy City, Here I Come! SQL Saturday #119 Chicago 2012 on May 8, 2012
- SQL Saturday #118 Wisconsin: They Came, They Saw...Did They Tip Cows? on April 23, 2012
- I'm a Radio Star! I'm Talking SSRS on RunAs Radio on April 18, 2012
- Will I See You At SQL Saturday #118 Wisconsin? on April 9, 2012
- Report Builder 3.0 – Map Wizard on March 28, 2012
- Presenting "Filegroups: Putting the Pieces Together" for Chicago SQL Connections on March 26, 2012
- Why You Should Volunteer for the PASS Summit Program Committee on March 25, 2012
- T-SQL Tuesday #028 – Jack of All Trades, Master of None? on March 13, 2012
- Chicago SQL Server User Group – Filegroups Presentation Material on March 12, 2012
- Report Builder 3.0 – Chart Types, Visualizations, and Properties on March 8, 2012
- Report Builder 3.0 – Chart Wizard on February 29, 2012
- MADPASS's First Birthday: They Grow Up So Fast! on February 23, 2012
- Report Builder 3.0 – Table or Matrix Wizard on February 22, 2012
- Report Builder 3.0 – The Introduction on February 15, 2012
- #meme15 February 2012 – LinkedIn on February 15, 2012
- February 2012 Presentations on February 10, 2012
- It's Hard To Be "Average": Mean, Median, and Mode in SQL Server on February 8, 2012
- Tech on Tap v1.1 – Post-Event High-Fives on January 30, 2012
- Cheatsheet: Relational Database Management Systems Comparison on January 24, 2012
- Five Days and Counting: Tech On Tap v1.1 on January 23, 2012
- Friday SQL Nugget #1 on January 13, 2012
- WiSSUG "Filegroups: Putting the Pieces Together" Materials on January 11, 2012
- MySQL MyISAM and InnoDB Engine Differences on January 10, 2012
- Book Review: Microsoft SQL Server 2008 Internals on January 4, 2012
- Presenting "Filegroups: Putting The Pieces Together" for WiSSUG on January 3, 2012
2011 (53 posts)
- 2011: That Time I Packed A Lifetime Into A Single Year on December 30, 2011
- Replacing sysfiles With sys.database_files on December 21, 2011
- On Being A Consultant: Lessons Learned, Month One on December 16, 2011
- #meme15: I'm A Blogger. Why? on December 15, 2011
- T-SQL Tuesday #25: T-SQL Tricks – Checking Transaction Log Space Used on December 13, 2011
- Presentation Files: EDMPASS and ABQ SQL on December 9, 2011
- T-SQL Tuesday #024: Reporting Services, Stored Procedures, and Multiple Result Sets on November 8, 2011
- What #sqlfamily Means To Me (Or, A Case of the Warm Fuzzies) on November 7, 2011
- My Favorite PowerShell Script: Reading Log Files on October 28, 2011
- A New Door Opens on October 24, 2011
- PASS Summit 2011: Reporting Services 201 Wrap-Up on October 21, 2011
- PASS Summit 2011: A Picture Book on October 18, 2011
- SQL Saturday #92 Portland, OR: Wrap-Ups, High-Fives, and Doughnuts on October 17, 2011
- A New Adventure: Tech On Tap on October 5, 2011
- SQL Saturday #92 – Portland, OR on October 3, 2011
- 2011 Quarter 3 Goals: Kicking [beep], Taking Names on September 30, 2011
- Tips and Tricks to Make SQL Server Management Studio Awesome on September 22, 2011
- Attending PASS Summit 2011? Want Lunch? And Free Career Advice? I Have Just The Event... on September 15, 2011
- Watch Me (and 23 Others!) During 24 Hours of PASS: Summit Preview on August 31, 2011
- Reporting Services Error: "The tablix has a detail member with inner members" (And How To Fix It) on August 19, 2011
- T-SQL Wednesday #21 – T-SQL That Should Have Been Flushed Down the Toilet on August 10, 2011
- Chicago SQL Connections – Reporting Services 201 Slides & Code on August 4, 2011
- A Cheat Sheet for All the *{_(%#$] PowerShell Punctuation on July 22, 2011
- T-SQL Tuesday #20 – T-SQL Best Practices on July 12, 2011
- 2011 Quarter 2 Goal Review on July 1, 2011
- Excel 2010 Data Source "From Microsoft Query" Missing DSNs on June 30, 2011
- User Groups? Those Still Exist? They Do, and You Should Be Going To One on June 24, 2011
- I'm Speaking! PASS Summit 2011 on June 17, 2011
- Energizing the Next Generation: A Women In Tech Discussion at SQL Saturday #75 on June 15, 2011
- SQL Saturday #75, Columbus OH: I Came, I Saw, I Ran on June 14, 2011
- I'll See You At SQL Saturday #75 Columbus, OH on June 6, 2011
- SQL Server Filegroup Piecemeal Restores on May 24, 2011
- T-SQL Tuesday #18: A Recursive CTE Is: A Recursive CTE Is on May 10, 2011
- Windows Server 2008 R2 Failover Clustering - It's Cool on May 2, 2011
- SQL Server Filegroups: The What, The Why and The How on April 26, 2011
- 2011 Quarter 1 Goal Review on April 6, 2011
- Using STOPAT in the RESTORE DATABASE Statement on April 4, 2011
- My Experience Attending a Free-Con on March 31, 2011
- SQL Saturday #67 Chicago 2011 Wrap-Up on March 28, 2011
- SQL Saturday #67 Chicago 2011: Have Fun Storming the Castle! on March 21, 2011
- 24 Hours of PASS: Wrap-Up, Slides, Demos and High-Fives on March 17, 2011
- SUM (T-SQL Tuesday #016: Aggregate Functions) on March 10, 2011
- SQL University Women In Technology (WIT) Week - My Name Is Jes, and I'm a WIT on March 7, 2011
- Creating Mailing Labels in SQL Server Reporting Services on February 28, 2011
- Come One, Come All to T-SQL Tuesday #016 : Aggregate Functions on February 26, 2011
- MADPASS Meeting Wrap-Up on February 24, 2011
- Changing a SQL Server Database Owner on February 15, 2011
- 24 Hours of PASS, WIT Edition: Register! Learn! Listen to Me! on February 14, 2011
- Presenting at the February WI SSUG Meeting on February 7, 2011
- SQL University – SQL Server Reporting Services: Exploring the RSReportServer.config File on February 3, 2011
- SQL University – SQL Server Reporting Services Configuration Files Overview on February 1, 2011
- Lessons Learned from Failing the MCTS 70-432 on January 24, 2011
- 24 Hours of PASS - WIT Edition – Awesome Women I'd Love to Hear Talk SQL on January 7, 2011
2010 (4 posts)
- 2011 Goals: Bring It On on December 29, 2010
- 2010 Goals: 4th Quarter/Year-End Review on December 27, 2010
- T-SQL Tuesday #013: What Does the Business Want? on December 14, 2010
- SQL Server: Starting a Server-Side Trace on December 10, 2010