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.
Jes Borland
About Jes Borland
Jes Borland is a Premier Field Engineer - SQL Server for Microsoft, where she is a trusted technical adviser, deep technical support, and teacher for her customers. Her experience as a DBA, consultant, and 5-time Data Platform MVP allow her to help the business and the IT teams reach their goals. She has worked with SQL Server as a developer, report writer, DBA, and consultant. Her favorite topics are administration, automation, and performance. She frequently presents at user groups, SQL Saturdays, and other community events. She is also an avid runner and chef.
Social Sitings
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