SQL PASS Detroit

March 2013

Indexing for Performance

Kimberly Tripp of SQLSkills chats about indexes and performance tuning.

Speaker Bio
Kim's bio is incredible, from her beginnings with SQL Server as a trainer at Microsoft University, to technical writing on the SQL Server Development Team, to starting her own consulting company. She's a top-rated author of SQL Server Magazine (http://www.sqlmag.com) articles, white papers, and books on SQL Server and with her husband Paul Randal and the rest of the SQLSkills crew delivers SQL Immersion events on SQL Server topics. Her full bio can be found at http://www.sqlskills.com/aboutkimberlyltripp.asp.

This month's meeting is sponsored by SQL Sentry.

PDF Presentation (.pdf) 1 MB
Windows Media Player (.wmv) 22 MB

April 2013

Hacking SQL Server

The best defense is a good offense. Learn how to practice hacking without going to jail or getting fired. In this presentation we'll be going over how to exploit weak SQL servers with actual tools of the penetration testing trade. You will learn why the SQL Service is a popular target on your network and how to defend against basic attacks. We will also attempt to snag some credentials from the SAM cache so we can go galavanting across the rest of the network.

Speaker Bio
Dustin has worked for a large insurance company since graduating from Western Michigan University in 2006. He is a MCITP SQL 2008 Database Administration but enjoys a large array of server infrastructure and automation topics. He blogs about these topics at http://nujakcities.wordpress.com.

This month's meeting is sponsored by Microsoft.

Powerpoint Presentation (.pptx) 2 MB
Windows Media Player (.wmv) 24 MB

June 2013

Disabling xp_CmdShell… Is it Really a 'Best Practice'?

XP_CmdShell is a powerful tool that can greatly simplify the life of DBAs. You can quickly and easily write full ETL systems, up/down-load FTP files, call PowerShell scripts to interrogate the status of hard-disks across the enterprise with nary a 3rd party tool in sight, and much more. And it’s all done under the control a scheduled job system that you already know and that keeps its own logs.Yet, you'll find millions of people that agree that disabling xp_CmdShell is a best practice. Some even say that it should never be used. Why? Disabling it supposedly decreases the system "surface area" of possible attack and never using it supposedly solves the problem of someone elevating their privileges with it. Well, surprise! Disabling xp_CmdShell doesn't actually solve any of those problems. In fact, disabling it may actually hurt security.

Speaker Bio
Jeff Moden has been working almost exclusively with SQL Server and T-SQL for 17 years, has been an SQL Server MVP since 2008, won the RedGate Exceptional DBA award for 2011, and has been a member of SPID (that's US!) since most of us can remember. He coined the term "RBAR" (Row By Agonizing Row) and, with 30 articles on the ""Black Arts"" of T-SQL and more than 32,000 posts (as he says, "some are actually useful") on SQLServerCentral.com, has made previously advanced subjects, like the Tally Table, nearly household words. As well as presenting at the PASS Summit and many SQL Saturdays, Jeff has presented his unique "Developer to Developer" sessions many times here for SPID. This time, he takes on the world of configuration and security by demonstrating that turning xp_CmdShell off might NOT be a "Best Practice" after all as well as how to set it up and use it properly and securely. He also provides a demonstration and explanation of how to call PowerShell from SQL Server to report on the disk status of all the SQL Servers in the enterprise.

This month's meeting is sponsored by Microsoft.

Powerpoint Presentation (.pptx) 830 KB
Windows Media Player (.wmv) 44 MB

August 2013

A World Where All Data Has a Place to Live:  Centralizing Distributed Reference Data

"Have you ever started work on a project only to find that one of your key reference datasets is only available in a spreadsheet on somebody's desktop? Even worse, you've probably run into situations where key data elements are 'common knowledge' amongst the business users, but don't even exist in a spreadsheet. Take heart. Using Master Data Services (MDS) we now have an effective solution to this problem that has plagued IT for years, without having to create a custom solution. In this session you will learn the basics of MDS, and how it can be used to easily create a home for the homeless data on your latest project. Don't get hung up trying to build a custom solution to house homeless reference data during your next project. Join this session and learn how to use MDS so you can deliver your project on time and on budget.

Speaker Bio
Lead Consultant - BlueGranite, Inc. - Shane is a veteran business intelligence consultant specializing in the Microsoft BI stack. Over the past 6 years he has helped numerous companies implement industry leading business intelligence solutions to empower individuals at all levels of the organization. Shane has worked in numerous industries including automotive, health care, consumer packaged goods, software development, and manufacturing to name a few. Shane's passion is to help clients use their data to gain a competitive advantage in an information driven world.

This month's meeting is sponsored by SQL PASS in Detroit (SPID).

Powerpoint Presentation (.pptx 1.6 MB)
Livemeeting (.wmv 23 MB)

October 2013

Automate Your ETL Infrastructure with SSIS and PowerShell

Speaker Bio
Allen White is the Practice Leader for UpSearch in Northeast Ohio. He's spent over 35 years in IT and has been using SQL Server since 1992. He is a certified MCITP in SQL Server and an MCT and has been awarded Microsoft’s MVP Award for the past 7 years. Allen is president of the Ohio North SQL Server User's Group. You can read his blog at http://sqlblog.com/blogs/allen_white/default.aspx.

This month's meeting is sponsored by SQL Pass in Detroit (SPID), and Microsoft.

Livemeeting (.wmv 27 MB)

December 2013

SQL Server 2014, In-Memory OLTP “Project Hekaton”

SQL Server 2014 delivers new in-memory capabilities built into the core database for OLTP.  Now tables and stored procedures can be selectively transformed into “in-memory or memory-optimized” database objects within your existing SQL Server database on your existing hardware.  Applications can run with minimal changes and realize tremendous performance improvements.

Speaker Bio
Brian Davis has over 14 years in the IT field in multiple areas including software development, support, user training, and as a DBA. He has been working with SQL Server since 2003 and has hands on experience with SQL Server 2000/2005/2008/2008R2/2012. Brian is also an active member and leader of the Ohio North SQL Server User Group.

This month's meeting is sponsored by SQL Pass in Detroit (SPID), Plex, ApexSQL, and Microsoft.

Powerpoint Presentation and Code (.zip 187 KB)
Livemeeting (.wmv 29 MB)

Back to Top