Ohio North SQL Server User Group

Choose a meeting below to view its details


Meeting Archive

Tuesday,

July

07

ONSSUG July Meeting

  • In-Person @ 6050 Oak Tree Blvd. Independence, Ohio, United States (map)
  • 17:00 - 19:30 Eastern Daylight Time
  • Language: English

RSVP: https://www.eventbrite.com/e/onssug-july-meeting-tickets-17458549993

5:00 - 6:00 - Pre-Session Video:  Are Your Indexes Hurting You or Helping You? (Jes Borland)

Queries need your help! Your mission, should you choose to accept it, is to make great decisions about what indexes are best for your workload. In this session, we'll review the difference between clustered and nonclustered indexes, show when to use included columns, understand what sargability means, and introduce statistics. You'll leave this session with the ability to confidently determine why, or why not, SQL Server uses your indexes when executing queries.

6:00 - 6:15 - Opening & Announcements

6:15 - 7:30 - Feature Presentation

Meeting Sponsor:  Bennett Adelson

Bennett Adelson is a technology solution consulting firm and a recent winner of the 2015 CIO Review "100 Most Promising Microsoft Solution Providers". Our mission is to help our clients realize their goals through user-centric technology solutions. Led by experts in their field, our 8 core practice areas help us solve the complex business challenges that face every enterprise.

Any inquiries can be sent to ddougherty@bennettadelson.com or we can be contacted through our website www.bennettadelson.com

Please take a minute to check our their site and see what they have to offer and don't hesitate to contact them if you have any questions.

Featured Presentation:

Automating “Excel Hell” with T-SQL

Jeff Moden, Senior Database Administrator and SQL Mentor Proctor Financial, Inc.

One of the most used computer tools in the world is some form of a spreadsheet yet nothing will send people into a panic more quickly than telling them that you want to import spreadsheet data into SQL Server. Spreadsheets are usually not in any format that would come close to being easily importable. There are tools like SSIS that can do some of the basic parts of importing complex spreadsheets but the complex parts, such as departitioning groups of monthly columns, requires a script of some sort. Without such a script, the import package would need to be modified each and every month to accommodate the additional month’s columns. Then, there’s the problem of people adding new “categories” to the monthly partitions in the form of yet more columns causing the monthly partitions to have a different number of columns along with new column header names. There are also the problems associated with merged cells and having the dates of each monthly partition spread across at least 2 rows for year and month because to do otherwise would make an ugly spreadsheet. There is a way to make a lot of these spreadsheets in a self-correcting “set it and forget it” mode and you don’t need to know how to program in C#, Java, Perl, VB Script, PowerShell, or any of the other languages to solve these problems. In fact, you don’t need SSIS to do this, either, although the methods explained in this session could be used in conjunction with SSIS. This “Black Arts” session will show you how to do it all in T-SQL with some initial help of a now old friend, the ACE drivers.

About Jeff:
With more than 47,000 posts and 3 dozen mostly 5 star articles, Jeff Moden is a strong contributor on SQLServerCentral.com where he coined the term “RBAR” (Row By Agonizing Row). Jeff has more than 2 decades of experience with SQL Server and is mostly self-trained in what he calls the “Black Arts” of T-SQL. He’s known worldwide for his informative articles, high performance T-SQL coding methods, and methods of mentoring. His dedication to helping others earned him the MS SQL Server MVP award for nine years and the RedGate Exceptional DBA Award in 2011. His mantra is "Performance is in the code".

Supplementary Materials

The following event attachments are available to you:

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids