The Southeast Michigan SQL Server User Group
Topic: SQL Server Data Tools 2012
Speaker: Randy Pagels
Tired of the same old routine of hand-coding scripts to maintain, develop, deploy, upgrade, and migrate your databases? In recent years, Microsoft has revisited the tools available to database developers known as “DataDude”. These tools are really powerful and can have a dramatic impact on the productivity and quality of your work at the data layer and your collaboration with other team members. This demonstration-heavy session will focus on the features available to database developers in Visual Studio 2010 & Visual Studio 11 Beta. Features covered in this session include connected development, getting your database code into source control, refactoring, and most importantly deployment. This session will preview the radical new direction Microsoft is taking in the next version of Visual Studio. Learn about the benefits of developing in SQL Server Data Tools (SSDT), and how to best use SSDT to build, debug, maintain and refactor databases on premise or in the cloud(SQL Azure). SQL Server Data Tools (SSDT) is a toolset that allows professional database and application developers to carry out all their database design work for SQL Server and SQL Azure within Visual Studio.
Speaker BIO
Randy is a Sr. Developer Technology Specialist and a Developer Platform and Evangelism tools team member covering the Heartland District (MI, OH, KY, TN) for Microsoft. His expertise includes Visual Studio, Team Foundation Server, Test Professional, and Lab Management products. He educates the customer to maximize their ALM tools by explaining best practices, installation, and configuration through presentations, workshops, or quick starts. Prior to Microsoft he worked for 16 years as a developer in the IT area and has designed and developed many .Net web applications using agile methodologies. Randy is a Microsoft Certified Technology Specialist (MCTS) on Team Foundation Server. For further resource information, please refer to his website http://www.teamsystemcafe.net.
This month our meeting is sponsored by Microsoft. Please visit them at www.microsoft.com
|
|
|
Topic: Don't Panic DBAs! Databases on VMWare made Easy
Speaker: Janis Griffin, Sr. DBA at Confio Software
Tired of the same old routine of hand-coding scripts to maintain, develop, deploy, upgrade, and migrate your
More and more companies are virtualizing with VMWare, and databases are the next logical step. This presentation will explore the fundamentals of monitoring databases running in a VMWare environment because it can be much different than when running on a physical machine. You will learn business and technical benefits of virtualization, master new terms and concepts, pick up useful planning tips and tricks, and cover best practices for maintaining optimum performance in a VMWare environment.
Speaker BIO
Over 20 years experience in Oracle Database Administration and Development. Additional experience as DBA for Sybase, Informix, Progres, Progress, MySql and Sql Server databases. In addition, 8 years experience as a System administrator for VMS / DOS / Unix operating systems. Also, I've have over 5 years of managing/mentoring other DBAs.
|
|
|
Topic: Baseline Basics: Where to Start, What You Need
Speaker: Erin Stellato
|
|
|
Topic: Storing Powershell
Speaker: Chad Miller
Code
|
|
|
Topic: Creating Dashboards with PerformancePoint Services
Speaker: Devin Knight
Powerpoint
|
|
|
Topic: Gather SQL Server Performance Data with PowerShell
Speaker: Allen White
Allen is a Practice Manager for Upsearch Technology Services in Northeast Ohio. He's spent over 35 years in IT and has been using SQL Server since 1992 and is certified MCITP in SQL Server and MCT. Allen has been awarded Microsoft’s MVP Award for the last five years. He's President of the Ohio North SQL Server User's Group and contributes in the MSDN Forums, answering questions about SMO and PowerShell, and maintains a blog at http://sqlblog.com/blogs/allen_white/default.aspx. The slide deck for this meeting is not available. The free book that was mentioned can be found at this link. The book is among the free downloads along the right side of the page.
http://powershell.com/cs/
|
|
|
Topic: Visual Studio to manage/deploy SQL Server Objects
Speaker: David Giard
Visual Studio provides a set of integrated tools that assist developers in managing and deploying SQL Server database objects.
In this session, you will learn about the following tools:
· Database projects
· Schema Compare tool
· Data Compare tool
· Database Unit Tests
Live Meeting
Media Player
Powerpoint
|
|
|
Topic: SQL Azure -- Relational Database Built for the Cloud
Speaker: Jeff Nuckolls Windows Azure Platform Solution Specialist
Live Meeting
Media Player
|
|
|
|
Topic:
|
Lightening Talks
|
|
Date:
|
Thursday, February 10, 2011 6:00pm
|
|
Speakers:
|
Joseph Fleming, Jeffrey Moden, Andrew Flint, Tomy George, Rick Brewis, Tom Groszko
|
Presentations
|
|
|
Topic: SQL Server Virtualization on Hyper - V
Speaker: Jeff Leigh, Microsoft
May LiveMeeting
|
|
|
Topic: SQL Server Analysis Services
Speaker: Christopher Campbell, Principal Consultant, Blue Granite
Unfortunately, due to some technical issues, the video for this presentation was captured, but no audio.
|
|
|
Topic: SQL Server Virtualization
Speaker: Rick Westrate, Senior Systems Engineer, VMware
Apologies, but due to technical difficulties, this LiveMeeting Recording was lost.
|
|
|
Topic: Converting Rows to Columns: Cross Tabls, Pivots, and "Nasty Fast" Reports
Speaker: Jeffrey Moden, SQL MVP
January LiveMeeting
|
|
|
Topic: Business Intelligence - Starting from Scratch
Speaker: Michael Edwards, Solution Architect, New World systems
November LiveMeeting
|
|
|
|
Topic:
|
Deploying, Managing, and Using SSIS
|
|
Date:
|
Thursday, Oct 8th, 2009
|
|
Speakers:
|
Christopher Campbell, Principal Consultant, Blue Granite
|
|
Location:
|
Microsoft Heartland District Offices, 1000 Town Center, Southfield, MI
|
|
Overview:
|
SQL Server Integration Services is Microsoft’s premier technology for developing Extract-Transform-Load processes for SQL Server. It provides developers and administrators with all of the tools they need to develop high-performing, production-ready applications for integrating data from disparate systems and technologies. This session will cover built-in features of SSIS that make it easier for organizations to deploy SSIS packages across the enterprise, log package execution and errors and manage ETL processes through multiple environments.
|
|
|
|
|
Topic:
|
Reducing Storage Costs through De-Duplication
|
|
Date:
|
Thursday, Sep 17th 6:00pm
|
|
Speakers:
|
Greg Simmons, Sr. Storage Engineer, Adexis.
|
|
Speakers:
|
Break through some of the confusnig terminology surrounding technology related to de-duplication. Learn how it can save storage space, and what targets are prime for de-duplication and which are not. Greg will also discuss some different de-duplication strategies, such as inline or post-processing de-duplication.
|
|
|
|
|
Topic:
|
SQL Server Replication
|
|
Date:
|
Thursday, August 13, 2009 6:00pm
|
|
Speakers:
|
Tommy Brickle, DBA, Plex Systems
|
|
Speakers:
|
Overview: We will be covering the complete life cycle around merge replication and how it can be used in your shop. This will include many of the day to day task needed to manage merge replication, creating publications with static and dynamic filters, publishing and republishing subscriptions disaster best practices for recovery of published databases and many tricks for getting the most out of merge replication.
|
|
|
|
Topic(s): The Running Total Problem and Other "Previous Row" Calculations and Groupings
Creating the Million Row Test Table
Overview: The ROW_NUMBER() and RANK() "windowing functions" work great but what if you are still using SQL Server 2000? What if you need to number groups of rows in a particular order or sequence that even ROW_NUMBER() won't handle? What if you need to "copy data down" to the next row or do something to the next row based on the previous row like a Running Total, Grouped Running Total, or a 5 day average sliding window? Even SQL Server 2008 doesn't have functions like that! So what do you do? Use a RBAR Cursor or While Loop? Not on your life. It's too slow! This Developer-to-Developer session demonstrates a unique technique to solve all those problems in a super fast set-based fashion. Some of the "bad" techniques will also be demonstrated so you know what to watch out for.
"A Developer must not guess… a Developer must KNOW!" There are many myths and legends about what makes high performance code. The problem is that most folks demonstrate their "speed" on only 10 or 20 rows. As the number of rows in a table go up, the Execution Plan changes and maybe that code that someone is so proud of doesn't work in the face of scalability. How can you test for such a thing? Easy… build a million row test table to test against. This Developer-to-Developer session demonstrates how to create and control the content of a million row table without buying any 3rd party tools. It's all done in T-SQL and it works in less than 30 seconds. Better than that, the code is only 4 lines long plus 1 line for each desired column and two of those are duplicates which makes this method easy to remember
Speaker: SQL Server MVP Jeff Moden is back with more T-SQL tricks up his sleeve in two more "Developer-to-Developer" presentations. As you may recall, Jeff gave the first ever "Developer-to-Developer" presentation for SEMSSUG last February on the Tally table and how to use it to replace loops. Jeff has several articles and more than 15,000 posts (as he says, "Some are actually useful!" ) on SQLServerCentral.com. This double header session is actually a preview of part of what's to come in the book he's currently for RedGate/Simple Talk publishing and two of the presentation abstracts that he submitted for this year's PASS conference.
|
|
|
Topic: Improving SQL database storage efficiency and performance
Overview: What SQL Server performance counters to monitor when reviewing disk throughput and utilization
How to reduce storage costs significantly with space-efficient backup capabilities
How to eliminate storage overhead for SQL Testing and Development
Streamline data management and automate routine tasks to increase DBA productivity
Increase backup frequency to protect more data automatically without impacting performance
Streamline management of SQL Server data across multiple storage resources with automated backup and recovery processes
Speaker: John W. Jones is a Solution Architect at NetApp. He joined NetApp in 2006 as a Microsoft specialist to better understand application level storage requirements when architecting storage solutions for SQL, SharePoint, and Exchange. Before joining NetApp, he spent about ten years working for Microsoft gold system integrators doing system administration, design and implementations. He holds a current MCTS certification and was awarded a Microsoft MVP in 2006.
|
|
|
Date: April 9, 2009
Topic: Table Partitioning
Overview: During this presentation we will explore the performance benefits of partitioning, how to identify a table as a potential candidate for partitioning, identifying the ideal fields for partitioning, and maintaining the partition once it is created.
Speaker: Tommy Brickle is a Database Administrator with Plex Systems
|
|
|
Topic: What happens in SQL Server Plan Cache?
Overview: What DMVs are used to examine the plan cache.
What information can we learn about our system from the plan cache.
How to implement a monitoring system that captures plan cache information real-time.
NOTE: Due to technical difficulties with recording equipemt, the livemeeting is not available. We are attempting to acquire the slides from the presenter and will post them once we do.
Speaker: Jerry Foster is one of the founders and Chief Scientist of Plex Systems, where he has been the development and technical lead for over 18 years. Plex's premier product, Plex Online, is the first and only fully integrated, on-demand manufacturing software hosted completely over the internet. Plex Online is accessed via a simple web browser
|
|
|
|
Topic:
|
Double Feature! Using RSS for system Administration + Replacing Loops with Tally Tables
|
|
Date:
|
Thursday, February 12, 2009 6:00pm
|
|
Speakers:
|
Chad Miller is a SQL Server DBA and Manager of Database Administration at Raymond James Financial. He has 9 years experience as DBA, working with SQL Server 6.5 through SQL Server 2008. He is the author of various technical articles published in SQL Server Central and SQL Server Magazine and has presented at the Tampabay SQL Server User Group and SQL Saturday. In his spare time Chad is the Project Coordinator/Developer of Codeplex projects SQL Server PowerShell Extensions (SQLPSX) and PoshRSS and blogs at http://chadwickmiller.spaces.live.com/.
Jeff Moden is a SQLServerCentral.com author and coiner of the term “RBAR” (pronounced ree-bar) for statements that process data “Row By Agonizing Row.”
|
|
|
|
|
Overview:
|
RSS: Provide an overview using simple tools that generate standard RSS feeds containing information regarding SQL Server jobs; ad-hoc queries and database size and space allocation information. This session will demonstrate using RSS to automate a daily DBA morning checklist by aggregating error logs, backup and additional information across multiple servers/databases.
Tally Table: Explore what a Tally table is and how it works to replace loops. We'll start out simple and build to the classic example of "splitting" a parameter. We'll throw in the added bonus of how to normalize an entire table worth of a CSVColumn... all with no cursors, no loops, no functions, and no performance problems.
|
|
|
|
|
|