Posts

SQL PASS Detroit – September Meeting 2016

UpSearch at SQL PASS Detroit - September Meeting

UpSearch at SQL PASS Detroit

UpSearch’s David Maxwell proudly supported SQL PASS Detroit – September Meeting. The event was held September 15, 2016 at Microsoft Heartland District Office, 1000 Town Center Dr., Suite 1930, Southfield, MI 48075.

Presentation

DBA 911 – Database Corruption by David Maxwell.

SQL PASS Detroit - September Meeting

 

Thank you to SQL PASS Detroit for hosting their September meeting. If you live in the Greater Detroit, MI area, consider getting involved with SQL PASS Detroit.

 

About SQL PASS Detroit

SQL PASS Detroit - September MeetingSQL PASS Detroit is affiliated with the Professional Association for SQL Server and has meetings on the second Thursday of every month.

About UpSearch

up-social-round

UpSearch is a company of data management and analytics experts who enable digital maturity with Microsoft’s technologies. Its mission is to enable every leader to unlock data’s full potential. UpSearch provides full lifecycle support for SQL Server, SQL Server in Azure (IaaS), Azure SQL DB (PaaS), Azure SQL DW (PaaS), Analytics Platform System (APS), and Power BI.


SQLStarter – Intro to DBA

 

About the Presentation

Session in the SQLStarter beginner track to introduce the database administrator career. Will discuss aspects of what this job entails and what day to day could look like in this career path. We’ll go over important skills and where to find training information.

Session Level: Beginner

Download the Presentation

SQLStarter - Intro to DBA

Presentations (Upcoming & Past)

 

About the Author

Data Platform Consultant

David Maxwell

UpSearch Alum David Maxwell is a database strategist, community evangelist and public speaker. He is passionate about helping community and business leaders get the most out of SQL Server.

Since 2000, David has served to protect, unlock and optimize data's value within such diverse environments as healthcare providers, insurance companies, manufacturers and financial institutions.  David has the unique ability to zero in on a complex challenge quickly, and provide a long-term solution that fits both the business needs and budget.

Since 2012, David has maintained a SQL Server focused blog at https://dmmaxwell.wordpress.com/. He is a frequent presenter at local and regional events for the Professional Association for SQL Server (PASS) and and works with the Columbus, OH based PASS chapter.

In his free time, David is an avid musician who plays several instruments, as well as a lover of puzzle-based games.

Learn more about David Maxwell at https://upsearch.com/david-maxwell/.

About UpSearch

up-social-round

UpSearch is a company of data management and analytics experts who enable digital maturity with Microsoft’s technologies. Its mission is to enable every leader to unlock data’s full potential. UpSearch provides full lifecycle support for SQL Server, SQL Server in Azure (IaaS), Azure SQL DB (PaaS), Azure SQL DW (PaaS), Analytics Platform System (APS), and Power BI.

SQLSaturday #530 – Indianapolis 2016

UpSearch at SQLSaturday #530 - Indianapolis 2016

UpSearch at SQLSaturday #530

UpSearch proudly supported PASS SQLSaturday #530 – Indianapolis 2016. The event was held August 13, 2016 at Indiana Wesleyan University North, 3777 Priority Way South Drive, Indianapolis, Indiana, 46240.

Presentations

The UpSearch team supported SQLSaturday #530 – Indianapolis 2016 by presenting:

Wait Statistics – The Top 5 Waits You Should Know by David Maxwell.

SQLSaturday #530 - Indianapolis 2016

SQLStarter – Intro to DBA by David Maxwell.

SQLSaturday #530 - Indianapolis 2016

Thank you to IndyPASS for hosting SQLSaturday #530 – Indianapolis 2016. If you live in the Greater Indianapolis, IN area, consider getting involved with IndyPASS (t).

 

UpSearch

About PASS SQLSaturday

up-social-round

The PASS SQLSaturday program provides tools and knowledge needed for groups and event leaders to organize and host a free day of training for SQL Server professionals. To learn more about PASS SQL Saturday, visit http://www.sqlsaturday.com/about.aspx.


About UpSearch

up-social-round

UpSearch is a company of data management and analytics experts who enable digital maturity with Microsoft’s technologies. Its mission is to enable every leader to unlock data’s full potential. UpSearch provides full lifecycle support for SQL Server, SQL Server in Azure (IaaS), Azure SQL DB (PaaS), Azure SQL DW (PaaS), Analytics Platform System (APS), and Power BI.


SQL Server Wait Statistics – The Top 5 Waits You Should Know

 

About the Presentation

SQL Server Wait Statistics - The Top 5 Waits You Should KnowWait statistics are a great tool for troubleshooting performance tuning problems in SQL Server. However, there are so many different wait types in SQL Server, it can be challenging to determine what to focus on and what can be ignored. Even after discovering that SQL Server is waiting for something, most DBAs don’t know where to look next. In this session, we’ll examine 5 of the most frequently seen SQL Server wait statistics and how to troubleshoot each of them. You’ll learn how to determine the root cause of a particular wait type, and how to avoid common mistakes made when troubleshooting with SQL Server wait statistics.

Session Level: Beginner

View Webinar & Download Presentation

Download contains:

  • Webinar Recording – 60 Minutes
  • PowerPoint Presentation
  • Scripts

SQL Server Wait Statistics - The Top 5 Waits You Should Know

Presentations (Upcoming & Past)

 

Want to Learn More About SQL Server Performance Tuning?

If you'd like to learn more about how UpSearch can support your SQL Server performance tuning initiative, visit SQL Server Performance Tuning or contact us today.

About the Author

Data Platform Consultant

David Maxwell

UpSearch Alum David Maxwell is a database strategist, community evangelist and public speaker. He is passionate about helping community and business leaders get the most out of SQL Server.

Since 2000, David has served to protect, unlock and optimize data's value within such diverse environments as healthcare providers, insurance companies, manufacturers and financial institutions.  David has the unique ability to zero in on a complex challenge quickly, and provide a long-term solution that fits both the business needs and budget.

Since 2012, David has maintained a SQL Server focused blog at https://dmmaxwell.wordpress.com/. He is a frequent presenter at local and regional events for the Professional Association for SQL Server (PASS) and and works with the Columbus, OH based PASS chapter.

In his free time, David is an avid musician who plays several instruments, as well as a lover of puzzle-based games.

Learn more about David Maxwell at https://upsearch.com/david-maxwell/.

About UpSearch

up-social-round

UpSearch is a company of data management and analytics experts who enable digital maturity with Microsoft’s technologies. Its mission is to enable every leader to unlock data’s full potential. UpSearch provides full lifecycle support for SQL Server, SQL Server in Azure (IaaS), Azure SQL DB (PaaS), Azure SQL DW (PaaS), Analytics Platform System (APS), and Power BI.

SQLSaturday #531 – Louisville 2016

UpSearch at SQLSaturday #531 - Louisville 2016

UpSearch at SQLSaturday #531

UpSearch proudly supported PASS SQLSaturday #531 – Louisville 2016. The event was held August 6, 2016 at Indiana Wesleyan University, 1500 Alliant Avenue, Louisville, Kentucky, 40299.

Pre-Con

Mike Fal presented a pre-con, Introduction to Powershell for SQL Server DBAs. This full day session helped build a foundation for learning and using Powershell. You can find more details here.

 

Presentations

The UpSearch team supported SQLSaturday #531 – Louisville 2016 by presenting:

Wait Statistics – The Top 5 Waits You Should Know by David Maxwell.

SQLSaturday #531 - Louisville 2016

Exploring SQLPS, the SQL Server Powershell Module by Michael Fal.

SQLSaturday #531 - Louisville 2016

Thank you to Louisville SQL Server Users Group for hosting SQLSaturday #531 – Louisville 2016. If you live in the Greater Louisville, KY area, consider getting involved with Louisville SQL Server Users Group (t).

 

UpSearch

About PASS SQLSaturday

up-social-round

The PASS SQLSaturday program provides tools and knowledge needed for groups and event leaders to organize and host a free day of training for SQL Server professionals. To learn more about PASS SQL Saturday, visit http://www.sqlsaturday.com/about.aspx.


About UpSearch

up-social-round

UpSearch is a company of data management and analytics experts who enable digital maturity with Microsoft’s technologies. Its mission is to enable every leader to unlock data’s full potential. UpSearch provides full lifecycle support for SQL Server, SQL Server in Azure (IaaS), Azure SQL DB (PaaS), Azure SQL DW (PaaS), Analytics Platform System (APS), and Power BI.


Understanding and Handling Database Corruption

 

About the Presentation

This presentation was formerly titled “DBA 911 – Database Corruption.”

Database CorruptionDatabase corruption is simply a fact of a DBA’s life – if you haven’t seen it yet, you will. Success or failure depends on having a solid plan to deal with different types of corruption. In this session, we will discuss usage of related DBCC commands such as DBINFO, CHECKDB and PAGE. You’ll learn how to monitor for corruption with SQL Server Agent Alerts and Jobs, and when it’s time to restore instead of repair. After attending this session, you will be able to check for issues such as page corruption or data purity problems, and take the appropriate measures to deal with them.

Session Level: Beginner

View Webinar & Download Presentation

Download contains:

  • Webinar Recording – 60 Minutes
  • PowerPoint Presentation
  • Scripts

Understanding and Handling Database Corruption

Presentations (Upcoming & Past)

 

Want to Learn More About SQL Server Disaster Recovery?

If you'd like to learn more about how UpSearch can support your SQL Server disaster recovery initiative, visit SQL Server Disaster Recovery or contact us today.

About the Author

Data Platform Consultant

David Maxwell

UpSearch Alum David Maxwell is a database strategist, community evangelist and public speaker. He is passionate about helping community and business leaders get the most out of SQL Server.

Since 2000, David has served to protect, unlock and optimize data's value within such diverse environments as healthcare providers, insurance companies, manufacturers and financial institutions.  David has the unique ability to zero in on a complex challenge quickly, and provide a long-term solution that fits both the business needs and budget.

Since 2012, David has maintained a SQL Server focused blog at https://dmmaxwell.wordpress.com/. He is a frequent presenter at local and regional events for the Professional Association for SQL Server (PASS) and and works with the Columbus, OH based PASS chapter.

In his free time, David is an avid musician who plays several instruments, as well as a lover of puzzle-based games.

Learn more about David Maxwell at https://upsearch.com/david-maxwell/.

About UpSearch

up-social-round

UpSearch is a company of data management and analytics experts who enable digital maturity with Microsoft’s technologies. Its mission is to enable every leader to unlock data’s full potential. UpSearch provides full lifecycle support for SQL Server, SQL Server in Azure (IaaS), Azure SQL DB (PaaS), Azure SQL DW (PaaS), Analytics Platform System (APS), and Power BI.

SQLSaturday #521 – Atlanta 2016

UpSearch at SQLSaturday #521 - Atlanta 2016

UpSearch at SQLSaturday #521

UpSearch proudly supported PASS SQLSaturday #521 – Atlanta 2016. The event was held May 21, 2016 at Georgia State University – Alpharetta location, 3775 Brookside Pkwy, Alpharetta, Georgia, 30022.

Presentations

The UpSearch team supported SQLSaturday #521 – Atlanta 2016 by presenting:

DBA 911 – Database Corruption by David Maxwell.

SQLSaturday #521 - Atlanta 2016

Managing Availability Groups (What happens after the build!) by Michael Fal.

SQLSaturday #521 - Atlanta 2016

 

Thank you to Atlanta MDF (SQL Server User Group) for hosting SQLSaturday #521 – Atlanta 2016. If you live in the Greater Atlanta, GA area, consider getting involved with Atlanta MDF (SQL Server User Group) (t).

 

UpSearch

About PASS SQLSaturday

up-social-round

The PASS SQLSaturday program provides tools and knowledge needed for groups and event leaders to organize and host a free day of training for SQL Server professionals. To learn more about PASS SQL Saturday, visit http://www.sqlsaturday.com/about.aspx.


About UpSearch

up-social-round

UpSearch is a company of data management and analytics experts who enable digital maturity with Microsoft’s technologies. Its mission is to enable every leader to unlock data’s full potential. UpSearch provides full lifecycle support for SQL Server, SQL Server in Azure (IaaS), Azure SQL DB (PaaS), Azure SQL DW (PaaS), Analytics Platform System (APS), and Power BI.


SQLSaturday #499 – Madison 2016

UpSearch at SQLSaturday #499 - Madison 2016

UpSearch at SQLSaturday #499

UpSearch proudly supported PASS SQLSaturday #499 – Madison 2016. The event was held April 9, 2016 at The Pyle Center, 702 Langdon St, Madison, Wisconsin, 53706.

Presentations

The UpSearch team supported SQLSaturday #499 – Madison 2016 by volunteering time to make the following presentation(s):

Colleen Morrow presented Enterprise Auditing with SQL Server Audit.

SQLSaturday #499 - Madison 2016

David Maxwell presented The Usual SUSPECTs: When Good Databases Go Bad.
SQLSaturday #499 - Madison 2016

Michael Fal presented Managing SQL Server Availability Groups (What happens after the build!)
SQLSaturday #499 - Madison 2016

Michael Fal presented Exploring SQLPS, the SQL Server Powershell Module.
SQLSaturday #499 - Madison 2016

Thank you to the five Wisconsin SQL Server User Groups for hosting SQLSaturday #499 – Madison 2016. If you live in Wisconsin, consider getting involved with FoxPASS (t), Madison SQL Server Users Group (t), Microsoft BI Professionals – Wisconsin, Western Wisconsin SQL Server User Group, or Wisconsin SQL Server Users Group.

 

UpSearch

About PASS SQLSaturday

up-social-round

The PASS SQLSaturday program provides tools and knowledge needed for groups and event leaders to organize and host a free day of training for SQL Server professionals. To learn more about PASS SQL Saturday, visit http://www.sqlsaturday.com/about.aspx.


About UpSearch

up-social-round

UpSearch is a company of data management and analytics experts who enable digital maturity with Microsoft’s technologies. Its mission is to enable every leader to unlock data’s full potential. UpSearch provides full lifecycle support for SQL Server, SQL Server in Azure (IaaS), Azure SQL DB (PaaS), Azure SQL DW (PaaS), Analytics Platform System (APS), and Power BI.


The Usual SQL Server SUSPECT: When Good Databases Go Bad

 

About the Presentation

The Usual SQL Server SUSPECT: When Good Databases Go BadYou just finished patching your SQL Server. After rebooting it, though, some of your databases aren’t coming online. What do you do? In this session we’ll cover some of the various states that a SQL Server database can be in. We’ll look at useful states like OFFLINE and STANDBY, as well as damaged states like SQL Server SUSPECT or RECOVERY_PENDING. You’ll learn how databases get into those states, and the proper techniques to bring your data safely back online.

Session Level: Beginner

Download the Presentation

The Usual SQL Server SUSPECT: When Good Databases Go Bad

Presentations (Upcoming & Past)

 

Want to Learn More About SQL Server Disaster Recovery?

If you'd like to learn more about how UpSearch can support your SQL Server disaster recovery initiative, visit SQL Server Disaster Recovery or contact us today.

About the Author

Data Platform Consultant

David Maxwell

UpSearch Alum David Maxwell is a database strategist, community evangelist and public speaker. He is passionate about helping community and business leaders get the most out of SQL Server.

Since 2000, David has served to protect, unlock and optimize data's value within such diverse environments as healthcare providers, insurance companies, manufacturers and financial institutions.  David has the unique ability to zero in on a complex challenge quickly, and provide a long-term solution that fits both the business needs and budget.

Since 2012, David has maintained a SQL Server focused blog at https://dmmaxwell.wordpress.com/. He is a frequent presenter at local and regional events for the Professional Association for SQL Server (PASS) and and works with the Columbus, OH based PASS chapter.

In his free time, David is an avid musician who plays several instruments, as well as a lover of puzzle-based games.

Learn more about David Maxwell at https://upsearch.com/david-maxwell/.

About UpSearch

up-social-round

UpSearch is a company of data management and analytics experts who enable digital maturity with Microsoft’s technologies. Its mission is to enable every leader to unlock data’s full potential. UpSearch provides full lifecycle support for SQL Server, SQL Server in Azure (IaaS), Azure SQL DB (PaaS), Azure SQL DW (PaaS), Analytics Platform System (APS), and Power BI.

SQLSaturday #484 – Chicago 2016

UpSearch at SQLSaturday #484

UpSearch proudly supported PASS SQLSaturday #484 – Chicago 2016. The event was held March 5, 2016 at DeVry University – Addison Campus, 1221 North Swift Road, Addison, Illinois, 60101.

Presentations

The UpSearch team supported SQLSaturday #484 – Chicago 2016 by volunteering time to make the following presentation(s):

David Maxwell presented Turbo-Charged Transaction Logs.

Special Mentions

Thank you to the two Chicago, IL SQL Server User Groups team effort for hosting SQLSaturday #484 – Chicago 2016. If you live in the Greater Chicago, IL area, consider getting involved with the Chicago SQL Server User Group and the Chicago Suburban SQL Server User Group, or find information about both groups on Twitter at @ChiSQL.

A highlight from the event includes David Maxwell rocking a kilt!

SQLSaturday #484 - Chicago 2016

About PASS SQLSaturday

up-social-round

The PASS SQLSaturday program provides tools and knowledge needed for groups and event leaders to organize and host a free day of training for SQL Server professionals. To learn more about PASS SQL Saturday, visit http://www.sqlsaturday.com/about.aspx.

About UpSearch

up-social-round

UpSearch is a company of data management and analytics experts who enable digital maturity with Microsoft’s technologies. Its mission is to enable every leader to unlock data’s full potential. UpSearch provides full lifecycle support for SQL Server, SQL Server in Azure (IaaS), Azure SQL DB (PaaS), Azure SQL DW (PaaS), Analytics Platform System (APS), and Power BI.