Nr: 204
SQLSaturday #204 - Detroit 2013
SessionID: 10033
Manage SQLServer Efficiently w/PowerShell Remoting
Event Date: 16-03-2013 - Session time: 00:00:00 - Track: Wild Card
Speaker: Allen White
Title: Manage SQLServer Efficiently w/PowerShell Remoting
Abstract:
You have more and more servers to manage and less time to accomplish everything. You're writing scripts to automate those tasks but they still take time to run. PowerShell remoting allows you to manage servers without the overhead of Remote Desktop, and allows you to run processes on all your servers simultaneously. In this session we'll walk through how PowerShell remoting works, how to set it up, and how you can save time getting things done more quickly.
SessionID: 11510
Becoming Certified In Microsoft SQL Server
Event Date: 16-03-2013 - Session time: 00:00:00 - Track: Prof Dev
Speaker: Chris Hyde
Title: Becoming Certified In Microsoft SQL Server
Abstract:
Chris Hyde has been working with the Microsoft SQL Server stack for over twelve years and has completed certification exams in SQL versions 2012, 2008, 2005, and 2000. He is a Senior Consultant with maxIT-VCS, a subsidiary of SAIC that specializes in healthcare IT consulting for the healthcare market, which he particularly enjoys as he gets to tackle different types of SQL problems at each client. He has been previously employed at ABQ Health Partners, Thornburg Mortgage, and Presbyterian Health Services.
SessionID: 11761
So I started this blog... now what?
Event Date: 16-03-2013 - Session time: 00:00:00 - Track: Prof Dev
Speaker: Colleen Morrow
Title: So I started this blog... now what?
Abstract:
Ever thought about trying your hand at blogging? Or maybe you've started a blog but struggle with what to write about. We'll take a beginner's look at blogging and examine common roadblocks, finding topics, building readership, and setting you on the road to blogging stardom.
SessionID: 11763
SQL Audit - auditing doesn't have to be boring
Event Date: 16-03-2013 - Session time: 00:00:00 - Track: Wild Card
Speaker: Colleen Morrow
Title: SQL Audit - auditing doesn't have to be boring
Abstract:
Let's face it, auditing isn't sexy. But if you're a DBA, you need to know what's going on in your SQL Server instance. Fortunately, SQL Audit makes it easy. In this session, we'll cover what you can and can't audit using SQL Audit, enhancements in 2012, configuring database and server audits, ways to process output, and ideas for how to implement SQL Audit on a larger scale. Auditing doesn't have to be hard. And with the help of a little custom coding, it can even be sexy.
SessionID: 12004
Upgrade Roadmap: Let’s delve into SQL Server 2012
Event Date: 16-03-2013 - Session time: 00:00:00 - Track: DBA
Speaker: Craig Purnell
Title: Upgrade Roadmap: Let’s delve into SQL Server 2012
Abstract:
We will review the upgrade process to SQL Server 2012. An upgrade is 75% project planning and 25% execution. Everyone knows that, right? Actually, no. A checklist of considerations a company would likely encounter coming from SQL Server 2005/2008 or R2. The pros and cons of in place upgrade vs. the build out new approach. There will be many real world lessons learned sprinkled in as the presenter has led many upgrades and migrations of SQL Server. Key takeaways include: when to upgrade in place compared to build new, usage of and how to gauge the usefulness of Upgrade Advisor, deprecated features and how to test for them
SessionID: 12005
LinkedIn for SQL Server Professionals
Event Date: 16-03-2013 - Session time: 00:00:00 - Track: Prof Dev
Speaker: Craig Purnell
Title: LinkedIn for SQL Server Professionals
Abstract:
SessionID: 12557
Event Date: 16-03-2013 - Session time: 00:00:00 - Track: DBA
Speaker: David Klee
Abstract:
SessionID: 13312
DBA Basics: The Four Tasks Every DBA Should Know.
Event Date: 16-03-2013 - Session time: 00:00:00 - Track: DBA
Speaker: David Maxwell
Title: DBA Basics: The Four Tasks Every DBA Should Know.
Abstract:
There are four basic tasks every DBA should know how to do. They are, in this order: Restore, Backup, Index and Stats maintenance, and Consistency Checking. After this session, beginning and "involuntary" DBAs will know the basic ins and outs of each of these four critical tasks, as well as how to set up recurring maintenance on their servers, and handle some of the common issues these tasks present
SessionID: 13653
How PowerShell helps me as a DBA (2013 Edition)
Event Date: 16-03-2013 - Session time: 00:00:00 - Track: Wild Card
Speaker: Carlton Ramsey
Title: How PowerShell helps me as a DBA (2013 Edition)
Abstract:
In this session we will review some example code of ways I use PowerShell to help me as a DBA. Bring your questions and we will work together see how PowerShell can be the "Super Glue" that can be used to solve some of your problems.
SessionID: 14102
Join Us! Getting Started as a Technical Speaker
Event Date: 16-03-2013 - Session time: 00:00:00 - Track: Prof Dev
Speaker: Eddie Wuerch
Title: Join Us! Getting Started as a Technical Speaker
Abstract:
SessionID: 14103
Partitioning for Perf and Management of Large Tabl
Event Date: 16-03-2013 - Session time: 00:00:00 - Track: DBA
Speaker: Eddie Wuerch
Title: Partitioning for Perf and Management of Large Tabl
Abstract:
Managing data in ever-growing transaction and history tables can be challenging. Activities with large chunks of data such as moving data to archive tables, batch-importing many rows, or defragging an entire table when only the active portion changes introduces heavy I/O and blocking. Table partitioning seamlessly solves a host of headaches with minimal effort. Ever wanted to truncate or defrag part of a table, or insert an entire staging table of data into another table in milliseconds instead of hours? Come see what partitioning can provide for you.
SessionID: 14302
I'm Spatial
Event Date: 16-03-2013 - Session time: 00:00:00 - Track: BI
Speaker: Frank Murphy
Title: I'm Spatial
Abstract:
Introduction to spatial features in SQL Server: how to create, procure, integrate and leverage spatial data.
Demo using SQL Server 2008 R2.
SessionID: 14468
Making SSIS 2008 Packages More Dynamic
Event Date: 16-03-2013 - Session time: 00:00:00 - Track: BI
Speaker: George Squillace
Title: Making SSIS 2008 Packages More Dynamic
Abstract:
SessionID: 16045
Hierarchies... on Steroids the No RBAR Way
Event Date: 16-03-2013 - Session time: 00:00:00 - Track: Developer
Speaker: Jeff Moden
Title: Hierarchies... on Steroids the No RBAR Way
Abstract:
Hierarchical data sets are everywhere. If you haven't worked with one yet, you will. If you're already working with them, you know they can be horribly complex, slow performing, difficult to maintain resource hogs that can really take the steam out of any GUI or batch process. This simple but code intensive "black arts" session shows you how to quickly and easily get around all of that using all 3 common hierarchical structures and a new structure that just might make Nested Sets obsolete. For stalwarts, it also includes a very high performance method (100,000 nodes in 6 seconds) for converting Adjacency Lists to Nested Sets that even a beginner can understand. You just have to know that a Tally Table is involved somewhere in this. ;-)
SessionID: 17352
Data Modeling for Large Scale Cube systems
Event Date: 16-03-2013 - Session time: 00:00:00 - Track: BI
Speaker: Jordan Martz
Title: Data Modeling for Large Scale Cube systems
Abstract:
This is just the start because I'll be interjecting how to Model Data Warehouses for major companies and how your company needs to do it. You don't get hired for knowing Kimball and Inmon anymore.
SessionID: 17516
Demystifying BISM and Tabular Mode SSAS
Event Date: 16-03-2013 - Session time: 00:00:00 - Track: BI
Speaker: Josh Fennessy
Title: Demystifying BISM and Tabular Mode SSAS
Abstract:
In this session, attendees will gain understanding of what Multidimensional and Tabular modelling IS, as well as how the BISM layer helps to translate user requests to ensure no confusion is made. Attendees will also learn how to BUILD a Tabular model, and will help design a solution live during the presentation.
SessionID: 17882
$*! Your Database Says About Me
Event Date: 16-03-2013 - Session time: 00:00:00 - Track: Wild Card
Speaker: Karen Lopez
Title: $*! Your Database Says About Me
Abstract:
Does your data sit around mocking your best attempts to support good data practices? Databases are also bound by the GIGO rule: Garbage In is Garbage Out. In this presentation, Karen shows you examples of the types of mistakes, misunderstandings and outright cheats that lead to poor data quality, mistrust in IT systems and overall smelliness in our IT solutions. Using real-life evidence of her own data in your systems.
SessionID: 22297
Hacking SQL Server
Event Date: 16-03-2013 - Session time: 00:00:00 - Track: Wild Card
Speaker: Dustin Prescott
Title: Hacking SQL Server
Abstract:
SessionID: 22662
Goodbye Next Next Next, Hello Automated Installs
Event Date: 16-03-2013 - Session time: 00:00:00 - Track: DBA
Speaker: Brian Davis
Title: Goodbye Next Next Next, Hello Automated Installs
Abstract:
SessionID: 23083
Incorporating Hadoop into your DW/BI Strategy
Event Date: 16-03-2013 - Session time: 00:00:00 - Track: BI
Speaker: Rob Kerr
Title: Incorporating Hadoop into your DW/BI Strategy
Abstract:
This session provides a technical overview of Hadoop and HD Insight targeted for Microsoft DW/BI professionals. Emphasis will be on how Map/Reduce paradigms complement and extend BI architectures. Specifically highlighted will be the Hadoop ecosystem, HDFS, Cloud vs. On-Premise, and various strategies to integrate SQL and NoSQL technologies into cohesive solutions.
SessionID: 23843
Using Filetables
Event Date: 16-03-2013 - Session time: 00:00:00 - Track: Developer
Speaker: Sam Nasr
Title: Using Filetables
Abstract:
The FileStream feature was introduced with SQL Server 2008 allowing BLOBs to be managed by the DB. In 2012, FileTable expands on this feature by using specific tables for storing these BLOBs. This allows Windows apps to access these items as if there were stored on the file system.
SessionID: 25094
Event Date: 16-03-2013 - Session time: 00:00:00 - Track: Prof Dev
Speaker: Kevin Bullen
Abstract:
SessionID: 26169
Windowing Functions: THE Reason to Upgrade to 2012
Event Date: 16-03-2013 - Session time: 00:00:00 - Track: Developer
Speaker: Kevin Boles
Title: Windowing Functions: THE Reason to Upgrade to 2012
Abstract:
SessionID: 26170
Common TSQL Mistakes
Event Date: 16-03-2013 - Session time: 00:00:00 - Track: Developer
Speaker: Kevin Boles
Title: Common TSQL Mistakes
Abstract:
SessionID: 26984
Writting DML Triggers
Event Date: 16-03-2013 - Session time: 00:00:00 - Track: Developer
Speaker: Tom Groszko
Title: Writting DML Triggers
Abstract:
I will present INSERT, UPDATE, DELETE and INSTEAD OF triggers using T-SQL. I will not be talking about CLR triggers. I will compare triggers to constraints, discuss security, demonstrate what each kind of trigger does, explain T-SQL trigger specific statements, enabling and disabling, ordering the sequence of trigger execution, demonstrate how to use the INSERTED and DELETED tables available in a trigger.