Nr: 354
SQLSaturday #354 - Charleston 2014
SessionID: 11201
"I Know What You Did Last Query" --SQL Server
Event Date: 13-12-2014 - Session time: 00:00:00 - Track: Track 1
Speaker: Carlos L Chacon
Title: "I Know What You Did Last Query" --SQL Server
Abstract:
SessionID: 11525
Becoming Certified In Microsoft SQL Server
Event Date: 13-12-2014 - Session time: 00:00:00 - Track: Track 2
Speaker: Chris Hyde
Title: Becoming Certified In Microsoft SQL Server
Abstract:
Chris Hyde has been working with the Microsoft SQL Server stack for over thirteen years and has completed certification exams in SQL versions 2012, 2008, 2005, and 2000. He is a Senior Consultant with Leidos Health specializing in the healthcare market, which he particularly enjoys as he gets to tackle different types of data problems at each client. He is currently on the board of the Albuquerque chapter of SQL PASS.
SessionID: 13257
SQL Window functions in SQL Server 2008 and later
Event Date: 13-12-2014 - Session time: 00:00:00 - Track: Track 2
Speaker: Donald Wert
Title: SQL Window functions in SQL Server 2008 and later
Abstract:
"Just what the heck is a window function and why should I care?" Have you ever needed to provide a running subtotal or average in your dataset? Need to provide a total by customer or a grand total on each row? Need to assign row numbers or counts that change when a certain value in your data changes! Window functions to the rescue! That's why you should care.
SessionID: 13995
ETL Frameworks Using SSIS Programming
Event Date: 13-12-2014 - Session time: 00:00:00 - Track: Track 3
Speaker: Jorge Novo
Title: ETL Frameworks Using SSIS Programming
Abstract:
SessionID: 14443
Learn How To Build A Golden Record for Any Subject Over Lunch!
Event Date: 13-12-2014 - Session time: 00:00:00 - Track: Track 1
Speaker: Gene Webb
Title: Learn How To Build A Golden Record for Any Subject Over Lunch!
Abstract:
Attend the lunch demo and see how you can use Master Data Services and Maestro to:
• Create a golden record for any subject area in a matter of minutes
Leverage your Microsoft licenses, skills and infrastructure to lower license costs and FTE costs, and reduce the complexity of an MDM environment?
• Understand how to implement workflow and business process solutions around the management of MDM, without having to write complex custom coding for everything?
• Tackle data quality, consistency and control by empowering business and subject matter experts, without needing heavy IT resources and writing complex code or scripting
• Improve data quality, data stewardship, workflow, and data sharing with any of your enterprise
SessionID: 15746
Don't Panic, DBAs! Databases on VMware made easy.
Event Date: 13-12-2014 - Session time: 00:00:00 - Track: Track 3
Speaker: Janis Griffin
Title: Don't Panic, DBAs! Databases on VMware made easy.
Abstract:
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.
SessionID: 16281
Sliding Window Table Partition Intro
Event Date: 13-12-2014 - Session time: 00:00:00 - Track: Track 2
Speaker: Jeff Reinhard
Title: Sliding Window Table Partition Intro
Abstract:
A walk-through of creating a sliding window table partition on an AdventureWorks table.
SessionID: 18030
What You Absolutely Must Know about SQL Server Security
Event Date: 13-12-2014 - Session time: 00:00:00 - Track: Track 1
Speaker: Brian Kelley
Title: What You Absolutely Must Know about SQL Server Security
Abstract:
There are so many security tips out there for SQL Server. Almost all of them are rated as a best practice.What do you listen to? What do you focus on? In this session we'll break down what you absolutely must know about securing SQL Server. We'll look at the things to look for within SQL Server, including some of the nooks and crannies an attacker might use but what are rarely audited. You'll leave with a checklist of what to investigate and a set of scripts to run on your own systems.
SessionID: 18224
Top 10 Admininistrator Mistakes on SQL Server
Event Date: 13-12-2014 - Session time: 00:00:00 - Track: Track 3
Speaker: Kevin Kline
Title: Top 10 Admininistrator Mistakes on SQL Server
Abstract:
SessionID: 21262
PowerShell Basics for SQLServer
Event Date: 13-12-2014 - Session time: 00:00:00 - Track: Track 1
Speaker: Michael Wharton
Title: PowerShell Basics for SQLServer
Abstract:
SessionID: 23339
Revenge: The SQL! - Director's Cut
Event Date: 13-12-2014 - Session time: 00:00:00 - Track: Track 3
Speaker: Rob Volk
Title: Revenge: The SQL! - Director's Cut
Abstract:
Pop quiz DBA: Your developers are running rampant in production. Logic, reason, and threats have all failed. You're on the edge. What do you do? WHAT DO YOU DO?
Hint: You attend Revenge: The SQL!
This session will show you how to "correct" all those bad practices. Everyone logging in as sa? Running huge cursors? Using SELECT * and ad-hoc SQL? Stop them dead, without actually killing them. Ever dropped a table, or database, or WHERE clause? You can prevent that! And if you’re tired of folks ignoring your naming conventions, make them behave with Unicode…and take your revenge!
Revenge: The SQL! is fun and educational and may even have some practical use, but you’ll want to attend simply to indulge your Dark Side. Revenge: The SQL! assumes no liability and is not available in all 50 states. Do not taunt Revenge: The SQL! or Happy Fun Ball.
SessionID: 24942
Administering Managing the Power BI Environment
Event Date: 13-12-2014 - Session time: 00:00:00 - Track: Track 2
Speaker: Melissa Coates
Title: Administering Managing the Power BI Environment
Abstract:
Power BI for Office 365 is Microsoft's new self-service BI offering. Just because it emphasizes self-service doesn't mean a system administrator isn't an important role! In this session we will discuss the overall system components and how a Power BI site in SharePoint Online differs from an on-premises SharePoint BI site. We will walk through how to best handle setting up connectivity to data sources, when a gateway is needed, and what data refresh capabilities exist. We will also consider how and when to create OData feeds from your corporate on-premises data sources, and how those OData feeds affect Enterprise Data Search functionality.
SessionID: 27044
Data center migrations – a focus on the ‘Data’
Event Date: 13-12-2014 - Session time: 00:00:00 - Track: Track 2
Speaker: Tony Scotto di Carlo
Title: Data center migrations – a focus on the ‘Data’
Abstract:
Data center migrations are all the rage these days and the SQL Server DBA is one of the most important accessories to success. I find that approximately 10-20% of all Windows Servers in the business enterprise are SQL Servers. When an organization makes the decision to move from one data center to another, of all the very important servers that will be migrated, the ones with the company data will be the most watched. Just like any other project, a good plan followed by good execution is required. In this session you’ll learn about the research, design, planning, process, and execution that go into migrating SQL Servers from one data center to another. I’ll go over some lessons learned and discuss whether you go it alone or brings in some help. I’ll discuss the big options and decisions on migration techniques and methodologies and the pros and cons. You’ll also hear about the big decisions like keeping the same server names, production downtime, data synchronization more.
SessionID: 27744
SSMS Tips Tricks
Event Date: 13-12-2014 - Session time: 00:00:00 - Track: Track 1
Speaker: Wayne Sheffield
Title: SSMS Tips Tricks
Abstract:
Almost everyone uses SSMS to write queries and to browse around on the server - but do you use all of the features that SSMS offers to increase your productivity? Come to this session, consisting mostly of demos, to see features built-in to SSMS that will improve your experience and productivity. Time permitting, we'll also go into some 3rd party products that also increase your productivity in SSMS.
SessionID: 34770
Push your career to new heights: A Panel Discussion on Career Planning and Professional Development
Event Date: 13-12-2014 - Session time: 00:00:00 - Track: Track 3
Speaker: Kevin Klein, Melissa Coates, Chris Hyde, Ryan McKnight
Title: Push your career to new heights: A Panel Discussion on Career Planning and Professional Development
Abstract:
Research has proven that professionals who spend time deliberately planning their career achieve greater successes and accomplishments. Have you thought much about your career as an IT pro? Or have you drifted from one opportunity to the next without much forethought? Now is the time to change your approach. Join our panel discussion with noted bloggers, MVPs, and IT pros who can answer your questions and help you get onto a better career trajectory. These sessions are always fun and packed with wisdom. So don't miss out!