Some of my friends know I am a huge fan of the song “Havana” by Camila Cabello. They also know I like to remix songs and if I was to remix the song I would just change the word “Havana” to “Wheeling, WV” because half of my heart is in the Ohio Valley.

Why?

Wheeling is where I grew up as an adult and to this day it is one of the special happy places I like to visit. On April 28th Wheeling will host their the third SQL Saturday. Anyone can attend for FREE! l look forward to sharing my favorite city with the SQL Community and my SQL Family.

Free SQL Server Training in Wheeling, WV

Free SQL Server Training on April 29th in Wheeling, WV

Procure SQL will be teaming up with the Wheeling Chapter of AITP (only IT group in Ohio Valley) to bring some expert SQL Server training from MVPs, MCTs, and community experts to the Ohio Valley. I hope Data Platform professionals in nearby cities like Columbus, Pittsburgh, Harrisburg, Cleveland and Washington DC join is un the fun as well.

Things to Do?

Check out this quick five-minute video to find out some of the great things you can do in Wheeling, WV and why I fell in love with Wheeling!

Food

Colemans Fish Market – It is #1 on TripAdvisor for a reason. Best-fried fish sandwiches.
Ye Old Alpha – The Bridgeport brownie is legendary good.
DeCarlos Pizza – Wheeling’s special version of Pizza. If you get it make sure to eat it quick. Locals typically will eat it on the hood of their cars.
Undos – My personal favorite Italian food restaurant.

Places to See:

Good Mansion Wine – If you like wine, the selection here is fantastic. They will also have an open wine tasting event April 27th at 6 pm. If you are looking for something fun to do the night before the event I would recommend this.
Suspension BridgeIf you like history. You have to check out one of the oldest suspension bridges in the USA. You can still walk and drive across it.
Wheeling Artisan CenterGreat small tour of the history of Wheeling, WV.
Center Market
– Historic part of town with a lot of shops and places to eat. Its an easy walk from the SQL Saturday venue.
Oglebay Resort – Depending on the weather the driving range or ski lift will be open. Seriously, a great five-star resort with epic holiday events including Christmas lights, ogalbayfest, and 4th of July.
Wheeling Island Casino – If you like to play cards and win money its a great location. Used to do it a lot on lunch breaks.

The post Why We’re Organizing SQL Saturday in Wheeling, WV on April 28th appeared first on SQL Server Consulting & Remote DBA Service.

What is the best way to learn?

     The best way to learn is directly from industry professionals!  We are thrilled to be helping the SQLSaturday Wheeling organizers put together a great SQLSaturday, April 28, 2018.  The schedule is packed full of knowledgeable SQL professionals waiting to share their unique experiences and knowledge with you!

What is SQLSaturday?

     SQLSaturday is a free training event for Microsoft Data Platform professionals and those wanting to learn about SQL Server, Business Intelligence and Analytics. Admittance to this event is free, and most costs are covered by donations and sponsorships.  This event will be held on Apr 28 2018 at West Virginia Northern Community College, 1704 Market Street, Wheeling, West Virginia, 26003, United States.  You can register here: SQLSatWheeling

* To register for a SQLSaturday, you must first become a PASS member. A PASS account is free and makes it convenient to manage your SQLSaturday user profile, update preferences, and keep track of your SQLSaturday registrations.

What topics will be discussed?

     SQLSaturdays offer a wide variety of sessions from beginner to advanced.  There truly is something for every data professional at every level of his or her career.

  •  The topics covered are:
    • Analytics and Visualization
    • Application and Database Development
    • BI Information (Delivery, Architecture, Development, and Administration)
    • Cloud Development and Implementation
    • Enterprise Database Administration and Deployment
    • Professional Development

     The full schedule for SQLSaturday Wheeling can be found here.

What else does a SQLSaturday offer?

     Education is a very important element in growing your career.  Another often over-looked important element to growing a successful career is networking!  SQLSaturdays provide an excellent opportunity to meet new people, reconnect with old, and have a great time networking.  There will be a networking event Saturday after the event, so you will have a chance to unwind, grab a bite to eat, and chat with your newfound SQL friends!

     We will be there, and we hope to see you as well! Networking

 Procure SQL is proud to announce that Jay Falck has joined our team!  Jay brings a wealth of knowledge, wisdom, experience, and levity to our group.

How it all started.

Jay’s love of all things computer started his sophomore year in high school when a friend of his chemistry teacher loaned them a computer for a week. Jay was so taken, he ended up walking home from school around 7:00 PM that night!  Over the next two years, a teacher, using his own money, bought a computer kit and did training before and after school as the school didn’t have a computer science class. For those two years, Jay’s team won first place in a programming contest at Southwest Texas State for schools from Waco to San Antonio.   He decided then he was destined to do something computer related with his life.

A very impressive list of experience!

While in high school, Jay worked as a night shift operator at the textile mill in New Braunfels, Texas, where he got to dabble in FORTRAN and COBOL troubleshooting.  As a freshman at UT, he worked for an Animal Science researcher maintaining and running a huge FORTRAN program that performed radioimmunoassay analysis.  At San Antonio College, Jay worked in the research lab at the Audie Murphy VA Hospital. Here he did everything from computer operator to DG BASIC and FORTRAN programming for the research doctors.  After graduation, he moved to Austin and went to work for a small firm selling account software and hardware.  (This was his first exposure to rudimentary database systems.)

Eventually he moved to state government as an application developer working with VSAM and Model204 database systems. After 2 years he got the opportunity to do what he really wanted to do, Operating Systems programming!  He spent the next 14 years of state employment as a mainframe system programmer. This lead to his two biggest passions in IT: performance and security.

Jay’s passion for healthcare IT.

In 1996, when the Clinton Administration was moving forward with HIPAA, Jay was invited to join a company that was moving into healthcare.  At this time he didn’t know anything about healthcare IT but neither did they, so he went along for the ride. At this point Jay added healthcare IT to his passion list. He spent the next 20 years doing programming, system administration, and database administration for Unix/Linux and Windows based systems. This included Informix, Universe, Oracle and SQL Server databases. During this time he was VP of the CSC Healthcare User Group and the CIO of a small health insurance company in Lexington, KY.

SQL Server experience.

Jay’s two passions in IT are making things go faster and security.  His experience with SQL Server includes years of  improving query performance, indexing, data extraction and transfer, and security.  Through the years, he has had the opportunity to see first-hand how important security is to the data world.  He is looking forward to bringing his understanding of security policy to the database admin role and becoming proficient in applying policy to procedure.

Jay holds many certifications.

Fast forward to today and Jay maintains an impressive list of certifications related to his passion areas: CISSP (Certified Information Systems Security Professional) and HCISPP (Healthcare Information Security and Privacy Practitioner) from ISC2, and CCSA (Certified Cyber Security Architect, a HIPAA centric certification that replaced the CHSS (Certified HIPAA Security Specialist) and CSCS (Certified Security Compliance Specialist).  He is currently studying to add Microsoft Certification for SQL Server and ISC2 CCSP (Certified Cloud Security Professional).

What he brings to the table.

Not only does Jay bring his vast experience and knowledge, he brings a love of movies and the Texas Longhorns.  He’s always armed with a zinger and great story as well!  Jay is always ready to learn new things as well as teach what he knows.  We are very thankful to have Jay and cannot wait to share his knowledge and humor with our clients!  

Last weekend I had a blast speaking at the SQL Saturday in Chicago. It was awesome to share my knowledge and also catch up with some good friends.  My talk was on Automating the Pain Away with Query Store and Automated Tuning.  I hope this session helped people understand Query Store and Automated Tuning as these two new features can help resolve parameter sniffing problems.

John Sterrett Teaching Performance Tuning

John Sterrett teaching Performance Tuning at SQL Saturday Chicago

John Sterrett teaching performance tuning

SQL Saturday Chicago training class

The post SQL Saturday Chicago appeared first on SQL Server Consulting & Remote DBA Service.

This week at MVP Summit I got to talk with a friend who loves profiler. We were talking about capturing workloads and doing analysis on them. T-SQL or other 3rd party tools like ClearTrace, ReadTrace would be used to aggregate the data to get insight into the top offenders. I mentioned that workload analysis could be done with extended events without writing a single line of T-SQL.  This was a lightbulb moment for him.  Quickly, I learned that he is not alone and that there are a lot of people in the community who didn’t know this either.

I am including a quick video below to show you why Extended Events is a great solution for finding top offenders in a workload.

The post Finding Top Offenders with Extended Events appeared first on SQL Server Consulting & Remote DBA Service.