Bellingham SQL Server Users Group

Next Meeting

Tuesday,

March

15

Monthly Chapter Meeting

  • In-Person @ 709 West Orchard Drive #4 Bellingham, Washington, United States (map)
  • 18:00 - 20:00 Pacific Daylight Time
  • Language: English

This months technical presentation will be "TempDB, Do This and Don't Do That" presented by Steve Stedman.

The agenda for the meeting will be:
- Welcome and Pizza
- Chapter news and announcements
- Technical presentation 
- Socialize and networking

We are still looking for a pizza sponsor for this meeting. Please contact Steve if your business would like to sponsor the meeting.

 

The chapter meeting will be at the following address. Thanks to Derrick Bovenkamp for providing the location for this meeting.

709 West Orchard Drive #4
Bellingham, WA 98225



For any questions, please contact Steve Stedman, Steve@Stedman.us. (360)610-7833

Featured Presentation:

TempDB, do this and don’t do that.

Steve Stedman, Managing Technology Partner SQL Data Partners

There are many rules and tips that tell you to do this or don’t do that with TempDB. In this session we will explore the reasons behind many of the recommendations or best practices for TempDB. Find out how TempDB it is used, and why it is important to your SQL Server. Explore why TempDB usually needs more than one data file and how many files are needed for TempDB? Find out why disk speed has such an impact on TempDB? Explore the reasons TempDB should be on a different logical drive, even with a SAN, or VHDs. Explore why you should run DBCC CheckDB on TempDB. Find out about VLFs and how they impact performance? Learn about Windows settings that impact TempDB. With the exploration of these topics and more, you can take away the knowledge that you need to properly manage TempDB on all your SQL Servers.

About Steve:
Steve Stedman is the Leader of a PASS Chapter in Bellingham WA USA. Steve runs his own SQL consulting firm Stedman Solutions, LLC. He has 26 years of programming and SQL experience. He has written the book on SQL Common Table Expressions. He teaches, speaks at conferences, writes, and has taught SQL server classes at Western Washington University. Steve has previously spoken at PASS Summit, TechEd, DevTeach Vancouver, many SQL Saturdays, and more.