| description |
Jeff Maaks
Introduction to HammerDB
Do you have a fresh, new SQL Server installation that you’d like to benchmark against the system you’re replacing? Or perhaps you’d like to run a workload against a test SQL Server instance to validate your monitoring & troubleshooting tools. If so, this session is for you!
HammerDB is a free, open source tool that allows you to run “quasi” TPC-C and TPC-H benchmarks against SQL Server, as well as Oracle, MySQL, and PostgreSQL. In this talk, Jeff Maaks from Fuchsia Innovation Advisors will introduce HammerDB and demonstrate its use via a SQL Server instance in the cloud. Jeff will also share some interesting lessons-learned from a recent customer engagement with a large-scale hyper-converged infrastructure vendor.
For a primer on Jeff’s talk, check out Kendra Little’s article: https://www.brentozar.com/archive/2012/06/load-test-sqlserver/
Jeff MaaksJeff is an experienced leader with a mind for business, collaboration, and delivering growth through technological innovation. In his former role as CTO for Hitachi Oil and Gas, Jeff led global and cross-cultural initiatives in market assessment and commercialization of new technologies. His expertise in enterprise architecture, cloud computing, and business integration is informed by a passion for data and for bringing people together. Currently, Jeff is a Partner with Fuchsia Innovation Advisors, where his technical mastery helps deliver start-up agility to large enterprises through technical innovation.
Alberto Santaballa
JSON In and Out “Ins and Outs”
Even if you’re not planning to use JSON in the database yourself, you may come up against JSON in the SQL environment at some time. Let’s review some simple techniques to parse elements from a JSON formatted field and to generate JSON from SQL queries.
Alberto SantaballaAl is a lifelong software developer but with a strong data gene. Always curious about how to bend SQL to do interesting things and totally drawn in when someone says “I don’t think you can do that with SQL”. Happy transplant from the very muggy Southeast and member of OregonSQL for the five years here in Portland.
Refreshments graciously provided by ServerLogic.
We wish to acknowledge the OSHU Information Technology Group for supporting Oregon SQL by generously providing the meeting venue.
|
→ |
Michael Wall
PoSh for SSRS: Essential Skills to Manage Your Report Server with PowerShell
Whether you are a casual report designer or a DBA who has the responsibility of managing the SSRS installs at your company, you will find the new PoSH tools for SSRS to be very useful. This demo heavy presentation will do a deep dive on a number of the new PoSh tools for SSRS. From deploying new SSRS installations to easily and *QUICKLY* backing up and restoring your reports, everyone will come away from this presentation ready to go to work with PowerShell!
Michael Wall has been a Database Administrator since he was asked if he wanted to be one after successfully managing the Y2K upgrade project on over fifty UNIX servers. Immediately thrust into a major Oracle upgrade project, he has since then managed multiple challenges and now is the sole DBA for a global food processing company responsible for both SQL Server and Ingres databases.
He was honored to speak at PASS Summit in 2018 and hopes to have the experience again!
He is currently very active in his SQL Server community (PACNW) both as a presenter and assisting with multiple SQL Saturdays. Having experienced the Power BI community, he has now gone back to basics and is working with his VAXen at work again.
Alberto Santaballa
JSON In and Out “Ins and Outs”
Even if you’re not planning to use JSON in the database yourself, you may come up against JSON in the SQL environment at some time. Let’s review some simple techniques to parse elements from a JSON formatted field and to generate JSON from SQL queries.
Alberto SantaballaAl is a lifelong software developer but with a strong data gene. Always curious about how to bend SQL to do interesting things and totally drawn in when someone says “I don’t think you can do that with SQL”. Happy transplant from the very muggy Southeast and member of OregonSQL for the five years here in Portland.
Refreshments graciously provided by ServerLogic.
We wish to acknowledge the OSHU Information Technology Group for supporting Oregon SQL by generously providing the meeting venue.
|