Posts

SQLSaturday #527 – Columbus 2016

UpSearch at SQLSaturday #527 - Columbus 2016

UpSearch at SQLSaturday #527

UpSearch proudly supported PASS SQLSaturday #527 – Columbus 2016. The event was held July 16, 2016 at Quest Conference Center, 8405 Pulsar Place, Columbus, Ohio, 43082.

Presentations

The UpSearch team supported SQLSaturday #527 – Columbus 2016 by presenting:

Inside the Black Box – Making Sense of Service Broker by Colleen Morrow.

SQLSaturday #527 - Columbus 2016

Intro to Azure SQL Databases by Michael Fal.

SQLSaturday #527 - Columbus 2016

Honorable Mention

In her speaking debut at SQLSaturday Cleveland, Evelyn Maxwell presented Improving Your PowerPoint Skills. If you missed this popular session, you were in luck, because Evelyn presented at SQLSaturday Columbus.

Evelyn Maxwell at SQLSaturday #527 - Columbus 2016

Thank you to Columbus SQL Server Users Group for hosting SQLSaturday #527 – Columbus 2016. If you live in the Greater Columbus, OH area, consider getting involved with Columbus 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.


SQLSaturday #526 – Rochester 2016

UpSearch at SQLSaturday #526 - Rochester 2016

UpSearch at SQLSaturday #526

UpSearch proudly supported PASS SQLSaturday #526 – Rochester 2016. The event was held May 14, 2016 at Rochester Institute of Technology, 1 Lomb Memorial Drive, Rochester, New York, 14623.

Presentations

The UpSearch team supported SQLSaturday #526 – Rochester 2016 by presenting:

Inside the Black Box – Making Sense of Service Broker by Colleen Morrow.

SQLSaturday #526 - Rochester 2016

 

Thank you to Rochester PASS for hosting SQLSaturday #526 – Rochester 2016. If you live in the Greater Rochester, NY area, consider getting involved with Rochester PASS.

 

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.


SQLSaturday #473 – Cleveland 2016

UpSearch at SQLSaturday #473

UpSearch proudly sponsored PASS SQLSaturday #473 – Cleveland 2016. The event was held February 6, 2016 at Hyland Software, 28500 Clemens Rd., Cleveland, Ohio, 44145. UpSearch’s Colleen Morrow and David Maxwell volunteered to make 2 presentations.

Lunch Session with SQL Sentry

SQL Sentry’s Justin Randall and UpSearch’s Colleen Morrow demonstrated how SQL Sentry tools help UpSearch and their customers monitor and tune SQL Servers.

Sentry

 

Presentations

The UpSearch team supported SQLSaturday #473 – Cleveland 2016 by making two presentations:

Colleen Morrow presented Inside the Black Box – Making Sense of Service Broker.

David Maxwell presented Turbo-Charged Transaction Logs.

Honorable Mention

Sometimes, moments unexpectedly transcend all expectations. Evelyn Maxwell’s presentation was one of those moments for many of us.

If you don’t know about Evelyn Maxwell, you ought to. In her SQLSaturday speaking debut, Evelyn presented Improving Your PowerPoint Skills. Everyone learned something new about PowerPoint. She made us laugh, kept the audience engaged, under control and navigated technical difficulties like a seasoned professional.

Keep your eye on Evelyn Maxwell. It won’t be long before she challenges for PASS Summit Speaker Idol.

4558-0501237d

Special Mentions

Thank you to the Ohio North SQL Server User Group’s effort for hosting SQLSaturday #473 – Cleveland 2016. If you live in the Greater Cleveland, OH area, consider getting involved with the Ohio North SQL Server User Group, or find them on Twitter at @ONSSUG.

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.

Inside the Black Box – Making Sense of SQL Server Service Broker

 

About the Presentation


SQL Server Service Broker is often seen as a black box. Messages go in, and hopefully they come out on the other side. But when they don’t, DBAs typically don’t know where to look. Trying to figure out what’s wrong quickly turns into a guessing game.

Inside the Black Box - Making Sense of SQL Server Service BrokerIt’s not that complicated once you understand how it all works.

Service Broker is an asynchronous messaging technology built into SQL Server that allows you to scale out your application, replicate data or perform ETL, all while guaranteeing messages are delivered and processed in the right order. In this session, we’ll discuss the basics of the Service Broker architecture, its components, and deployment options. We will discuss troubleshooting tips and performance best practices to help you deploy a SQL Service Broker solution in your own environment.

Session Level: Beginner

Download the Presentation

Inside the Black Box - Making Sense of SQL Server Service Broker

Presentations (Upcoming & Past)

 

Want to Learn More About SQL Server Service Broker?

If you'd like to learn more about how UpSearch can support your SQL Server service broker initiative, visit SQL Server Service Broker or contact us today.

About the Author

SQL Server Consultant

Colleen Morrow

UpSearch Alum Colleen Morrow is a database strategist, community advocate, author, blogger and public speaker. She is passionate about helping technology leaders use Microsoft's SQL Server to protect, optimize and unlock data's value.

Colleen has been working with relational databases for almost 20 years. Since 2000, Colleen has specialized in SQL Server and Oracle database management solutions. She excels at performance tuning, troubleshooting mission critical SQL Server environments, and training technology professionals and business users of all levels.

Since 2011, Colleen has maintained a SQL Server focused blog at http://colleenmorrow.com. She is an active member of the Ohio North SQL Server User Group, as well as a volunteer for the Professional Association for SQL Server (PASS). Colleen earned a Bachelor of Science in Computer and Information Systems from Cleveland State University.

Learn more about Colleen Morrow at https://upsearch.com/colleen-morrow/.

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.

Colleen Morrow Promoted to Principal Consultant

We are pleased to announce Colleen Morrow has been promoted to Principal Consultant.  Congratulations Colleen!

 

About Colleen Morrow

colleen_large

Colleen joined UpSearch in October 2014 as a SQL Server Consultant. She quickly proved to be a natural at consulting services. Colleen’s sharp intuition and keen sense of urgency was immediately noticed by clients and team members alike. One year later, clients continue to rave about her combination of technical know-how, productivity and professionalism.

In this new position, Colleen will be responsible for the delivery of UpSearch’s Microsoft Practice professional and managed services. She will work directly with me to evolve the Practice’s delivery maturity. Learn more about Colleen Morrow here.

Please help me wish Colleen continued success.

Shawn Upchurch,
Founder & CEO

Congratulations Colleen!

Fun Fact

Colleen presented Enterprise Auditing with SQL Server Audit at PASS Summit 2015.

 

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 #446 – Oregon 2015

SQLSaturday #446 - Oregon 2015

UpSearch at SQLSaturday #446

UpSearch proudly participated at PASS SQLSaturday #446 – Oregon 2015. The event was held October 24, 2015 at Mittleman Community Center, 6651 SW Capitol Highway, Portland, Oregon, 97219. UpSearch’s Colleen Morrow made one presentation.

Presentations

The UpSearch team supported SQLSaturday #446 – Oregon 2015 by volunteering time to make one presentation:

Colleen Morrow presented Enterprise Auditing with SQL Server Audit.
SQLSaturday #446 - Oregon 2015

Special Mentions

Thank you to the Oregon SQL Server User Group for hosting SQLSaturday #446 – Oregon 2015. If you live in Oregon, consider getting involved with the Oregon SQL Server User Group.

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 #442 – Orlando 2015

UpSearch at SQLSaturday #442

UpSearch proudly sponsored PASS SQLSaturday #442 – Orlando 2015. The event was held October 10, 2015 at Seminole State College of Florida, 100 Weldon Blvd Building UP, Sanford, FL 32773. UpSearch’s Brian Davis, Colleen Morrow and Kendal Van Dyke volunteered to make 3 presentations.

Co-Sponsored Lunch Session

Kendal Van Dyke led a co-sponsored presentation between SIOS & UpSearch titled Implementing a SANLess Cluster in Under an Hour.

Presentations

The UpSearch team supported SQLSaturday #442 – Orlando 2015 by making two presentations:

Brian Davis presented DQ What? DQ Who? DQ How?

Colleen Morrow presented Enterprise Auditing with SQL Server Audit.

Special Mentions

Thank you to the two Orlando, FL  SQL Server User Groups team effort for hosting SQLSaturday #442 – Orlando 2015. If you live in Greater Orlando, FL area, consider getting involved with the MagicPASS SQL Server Users Group, or find them on Twitter at @MagicPASS, and the Orlando SQL Server Users Group, or find them on Twitter at @PassOrlando.

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.

Enterprise Audit with SQL Server Audit

 

About the Presentation


Enterprise Audit with SQL Server AuditAudit. The very word strikes fear in the bravest of hearts. But as a DBA, the need to know who is doing what in your production databases is critical. In SQL Server 2008, Microsoft finally gave us a true auditing tool. But how does it work, what exactly can it track, and how can you handle its output?

In Enterprise Audit with SQL Server Audit, we cover SQL Server Audit from the ground up. We go from the basics of which events can be audited to a look at how SQL Server Audit works “under the covers”, and what that means for performance. While implementing server and database audits, we discuss audit granularity and filtering, as well as the pros and cons of Audit’s output options.

Whether it’s through the SQL Server Management Studio (SSMS) interface, via T-SQL, or using PowerShell and Server Management Objects (SMO), at the end of this session you’ll be able to deploy Audit across your SQL Server enterprise and manage its output, fearlessly.

Session Level: Intermediate

 This session was presented at PASS Summit 2015.Enterprise Audit with SQL Server Audit

Download the Presentation

Enterprise Audit with SQL Server Audit

Presentations (Upcoming & Past)

Want to Learn More About SQL Server Audit?

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

About the Author

SQL Server Consultant

Colleen Morrow

UpSearch Alum Colleen Morrow is a database strategist, community advocate, author, blogger and public speaker. She is passionate about helping technology leaders use Microsoft's SQL Server to protect, optimize and unlock data's value.

Colleen has been working with relational databases for almost 20 years. Since 2000, Colleen has specialized in SQL Server and Oracle database management solutions. She excels at performance tuning, troubleshooting mission critical SQL Server environments, and training technology professionals and business users of all levels.

Since 2011, Colleen has maintained a SQL Server focused blog at http://colleenmorrow.com. She is an active member of the Ohio North SQL Server User Group, as well as a volunteer for the Professional Association for SQL Server (PASS). Colleen earned a Bachelor of Science in Computer and Information Systems from Cleveland State University.

Learn more about Colleen Morrow at https://upsearch.com/colleen-morrow/.

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 #421 – Columbus 2015

UpSearch at SQLSaturday #421

UpSearch proudly sponsored PASS SQLSaturday #421 – Columbus 2015. The event was held July 11, 2015 at Mount Vernon Nazerene University – New Albany, 150 E. Dublin-Granville Rd., Columbus, OH 43081. UpSearch’s Allen White, Brian Davis, and Colleen Morrow volunteered to make 5 presentations.

Co-Sponsored Lunch Session

Brian Davis led a co-sponsored presentation between SQL Sentry and UpSearch titled Better Managed Services Through Monitoring with UpSearch & SQL Sentry.

 

Presentations

The UpSearch team also supported SQLSaturday #421 – Columbus 2015 by making five presentations:

Allen White presented on how to use SQL Server Service Broker.

Allen White also presented on how to use PowerShell to maintain SQL Server performance.

Brian Davis presented on how to automate SQL Server installs.

Goodbye Next, Next, Next...Hello Automated Installs!

Brian Davis & Adam Belebczuk presented SISS Grab Bag of Best Practices.

 

Colleen Morrow presented What Changed? Auditing Options in SQL Server 2014.

 

Special Mentions

Thank you to the Columbus SQL Server Users Group for hosting SQLSaturday #421 – Columbus 2015. If you live in the Greater Columbus, OH area, consider getting involved with the Columbus SQL Server Users Group.

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.