Nr: 222
SQLSaturday #222 - Sacramento 2013
SessionID: 10250
Event Date: 27-07-2013 - Session time: 00:00:00 - Track: Nimble Storage Room
Speaker: Ben Miller
Abstract:
SessionID: 10253
SQL LogShipping with PowerShell
Event Date: 27-07-2013 - Session time: 00:00:00 - Track: Nimble Storage Room
Speaker: Ben Miller
Title: SQL LogShipping with PowerShell
Abstract:
SQL Server LogShipping is an option to keep a copy of a database on another site. It is also a way to have a read-only copy of a database on another server for reporting, etc. This session will cover going outside the box and using PowerShell to backup, ship, and restore the database backups to another server. This has been used to LogShip over the internet and over an FTP infrastructure. This session is intended to show the possibilities of PowerShell and SQL Server together. There will be full end-to-end demos of the pieces that make this possible.
SessionID: 11338
Real-time Data Warehouse and Reporting Solutions
Event Date: 27-07-2013 - Session time: 00:00:00 - Track: SIOS Room
Speaker: Carlos Bossy
Title: Real-time Data Warehouse and Reporting Solutions
Abstract:
SessionID: 11553
RU Ready for the Cloud?
Event Date: 27-07-2013 - Session time: 00:00:00 - Track: Red Gate Room
Speaker: Chris Skorlinski
Title: RU Ready for the Cloud?
Abstract:
Ready to begin your first SQL Database application? Wondering what others have learned as the moved data into the cloud? I'll cover best practices you'll need while planning your move to SQL Database in the cloud.
SessionID: 11556
Read Hunter
Event Date: 27-07-2013 - Session time: 00:00:00 - Track: SIOS Room
Speaker: Chris Skorlinski
Title: Read Hunter
Abstract:
Are you suffering from High CPU, Low Memory, Query Timeouts, Decreasing Page Life Expectancy, CXPACKET Waits, or just a slow running application? I'll show you how to become a "Read Hunter" to track down top logical reads queries bringing down your SQL Server performance.
SessionID: 12126
AlwaysOn Availability Groups in Action
Event Date: 27-07-2013 - Session time: 00:00:00 - Track: Quest/Dell Room
Speaker: DIlip nayak
Title: AlwaysOn Availability Groups in Action
Abstract:
SQL 2012 AlwaysOn Availability Groups is a new unified High availability(HA) and disaster recovery(DR) solution introduced in SQL 2012. This solution is an answer to both HA and DR requirements that is flexible, integrated, and easy to deploy. You'll see a demo that includes: •Setting up the Availability Group •Setting up multiple secondaries •Manual Failover •Automated Failover •AG Listener •and much more... You'll learn: •How to set up, manage, and maintain Availability groups in SQL 2012 •Create availability group failovers between data centers •How to utilize the replicas for backup and other tasks
SessionID: 12547
Event Date: 27-07-2013 - Session time: 00:00:00 - Track: Nimble Storage Room
Speaker: David Klee
Abstract:
SessionID: 12548
Event Date: 27-07-2013 - Session time: 00:00:00 - Track: Track 4
Speaker: David Klee
Abstract:
SessionID: 14743
What to Look for in Execution Plans
Event Date: 27-07-2013 - Session time: 00:00:00 - Track: Red Gate Room
Speaker: Grant Fritchey
Title: What to Look for in Execution Plans
Abstract:
SessionID: 15713
Looney Tuner? No, there IS a method to my madness
Event Date: 27-07-2013 - Session time: 00:00:00 - Track: Nimble Storage Room
Speaker: Janis Griffin
Title: Looney Tuner? No, there IS a method to my madness
Abstract:
SQL Server query tuning is often more art than science and it can quickly eat up a lot of DBA and/or Developer time. This presentation will outline a method for determining the best approach for tuning queries by utilizing response time analysis and SQL diagramming techniques. Regardless of the complexity of the statement, this quick, systematic approach will lead you down the correct tuning path with no guessing. If you are a beginner or expert, this approach will save you countless hours tuning a query.
SessionID: 15882
Event Date: 27-07-2013 - Session time: 00:00:00 - Track: Quest/Dell Room
Speaker: Jason Hall
Abstract:
SessionID: 16212
Event Date: 27-07-2013 - Session time: 00:00:00 - Track: Quest/Dell Room
Speaker: Joseph D'Antoni
Abstract:
Back in the old days, compression and databases was a really bad idea. Now, with powerful CPUs we can use to both improve performance and save disk space. We will cover the basics of how all compression and deduplication works, and then we will learn how SQL Server page and row compression work, and the special compression that is used in SQL 2012 Columnstore Indexes. We will demo performance and space savings in using compression.
SessionID: 16802
AlwaysOn - Finally, A usable 'mirror'!
Event Date: 27-07-2013 - Session time: 00:00:00 - Track: Quest/Dell Room
Speaker: Jim Murphy
Title: AlwaysOn - Finally, A usable 'mirror'!
Abstract:
In the past, High Availability and Disaster Recovery (HADR) had many limitations. Clustering and Mirroring are great, but the mirror/secondary database is not very usable since it is not online. Finally, AlwaysOn solves this limitation by merging both multi-node Clustering and mirroring. AlwaysOn also allows the secondary database to remain ONLINE, so we can use it for reporting purposes without resorting to a Snapshot! Come see this lively session with extensive demos of setting up, configuring and testing AlwaysOn. We'll also test automatic fail-over using a real web app to see how well this feature works.
SessionID: 17486
Data Quality Services Approach to Cleansing
Event Date: 27-07-2013 - Session time: 00:00:00 - Track: Red Gate Room
Speaker: Joseph Verftido
Title: Data Quality Services Approach to Cleansing
Abstract:
Learn about Microsoft’s Data Quality Services (DQS), what it is and how it works. You will discover how DQS sets itself apart from conventional data cleansing routines and go through examples on how to begin your own Data Quality Project which includes data cleansing and deduplication. But what really makes DQS unique and powerful is its ability to access shared knowledge, so we will show you how to access and use this shared knowledge to your benefit
SessionID: 17544
Lunch Session Accelerating SQL in the Datacenter with Hybrid Storage
Event Date: 27-07-2013 - Session time: 00:00:00 - Track: Nimble Storage Room
Speaker: Tom Riggins
Title: Lunch Session Accelerating SQL in the Datacenter with Hybrid Storage
Abstract:
SessionID: 17844
What Happened? Exploring the Plan Cache
Event Date: 27-07-2013 - Session time: 00:00:00 - Track: Quest/Dell Room
Speaker: Kalen Delaney
Title: What Happened? Exploring the Plan Cache
Abstract:
If you haven't been pro-active and set up some sort of tracing, does that mean there is nothing you can do to find out what problematic queries might be running? The answer is no.
In this session, we'll explore SQL Server's plan cache, from the way it is managed in memory, to the tools and techniques for discovering what plans are in cache, how long they've been there, how often they've been run, and whether they contain any suspected sub-optimal operators, such as table scans and hash joins. Knowing what's happened is the first step in knowing what needs to be fixed.
SessionID: 20136
Master Data and Data Quality in SQL Server 2012
Event Date: 27-07-2013 - Session time: 00:00:00 - Track: Nimble Storage Room
Speaker: Mark Gschwind
Title: Master Data and Data Quality in SQL Server 2012
Abstract:
SessionID: 20385
Table Partitioning in the Wild
Event Date: 27-07-2013 - Session time: 00:00:00 - Track: SIOS Room
Speaker: Mickey Stuewe
Title: Table Partitioning in the Wild
Abstract:
In this session we'll talk about the why and how of table partitioning. Expect to leave with real world scripts to help you create, breakdown, and manage your partitioned tables.
SessionID: 20832
Event Date: 27-07-2013 - Session time: 00:00:00 - Track: Nimble Storage Room
Speaker: Mitchell Bottel
Abstract:
SessionID: 21832
Tabular Models: Easier Faster Than Cubes; Really?
Event Date: 27-07-2013 - Session time: 00:00:00 - Track: Red Gate Room
Speaker: Paul Turley
Title: Tabular Models: Easier Faster Than Cubes; Really?
Abstract:
The future of data analysis is the new, in-memory xVelocity Tabular analytic engine but is this new product ready for enterprise solutions? Is it easier to build Tabular models than multidimensional cubes in SQL Server 2012? Maybe… Depends on what you need to do. Is it faster? Heck, yea. Taking off the Microsoft BI marketing hat, let’s take a tabular journey together and learn some lessons from the first generation of real, enterprise-scale solutions: The Good, the Bad, the Ugly and the Beautiful.
SessionID: 21959
Big Data Analytics with PowerPivot and Power View
Event Date: 27-07-2013 - Session time: 00:00:00 - Track: Red Gate Room
Speaker: Peter Myers
Title: Big Data Analytics with PowerPivot and Power View
Abstract:
This presentation will introduce big data analytics for the business analyst with PowerPivot and Power View. It will be of interest to those new to the concept of big data, new to self-service data modelling with PowerPivot, and those interested to understand what is new for PowerPivot and Power View in Excel 2013.
Demonstrations will include creating a big data solution by using HDInsight Server; producing a PowerPivot model based on the big data solution; using PowerPivot to integrate big data with local data; and, analyzing the PowerPivot model data by using Power View.
SessionID: 22276
Event Date: 27-07-2013 - Session time: 00:00:00 - Track: Quest/Dell Room
Speaker: Prakash Heda
Abstract:
While you can find top queries, wouldn't it be awesome if you can find out which ones are the exact queries taking most of the resources in last hour and current situation? Now you can focus on those specific queries!
In this session, Prakash walks you through with scenario demos to find which exact queries are taxing production systems resources based on CPU/DISK/Memory/Network. They are all based on his own real-life experience from managing demanding database systems.
SessionID: 24494
Searching Binary Data in SQL Server 2012
Event Date: 27-07-2013 - Session time: 00:00:00 - Track: Red Gate Room
Speaker: Steve Jones
Title: Searching Binary Data in SQL Server 2012
Abstract:
More and more data collected in organizations is in an encoded format, essentially a binary classification of data. These can be images, audio files, video, or even common formats like Word and Excel files. This data contains lots of important data, but the formatting must be stripped out in order for users to effectively search this data. Filestream, Filetable, Full-Text Search, and Semantic Search are covered.
SessionID: 24947
Report Delivery - From Report Manager to the Cloud
Event Date: 27-07-2013 - Session time: 00:00:00 - Track: SIOS Room
Speaker: Phil Robinson
Title: Report Delivery - From Report Manager to the Cloud
Abstract:
SessionID: 24949
SQL Server encryption 3 ways - in transit, at rest and in the database
Event Date: 27-07-2013 - Session time: 00:00:00 - Track: Track 4
Speaker: Dan Hess
Title: SQL Server encryption 3 ways - in transit, at rest and in the database
Abstract:
Dude, where's my keys??!?!
Confused about the various ways SQL Server handles encryption? Tasked with securing your environment or trying to pass an audit? There's a lot of information that can be difficult to wade through. In this session, I'll go over three ways to encrypt SQL Server, showing practical examples of the various techniques. We'll look at encrypting the information at the network level (in transit), encrypting the data and backup files (at rest using Transparent Data Encryption) and encryption of sensitive information in the database (columns and stored procedures).
This will be a high level, hands-on discussion that will enable any administrator to put the techniques discussed into practice immediately. You'll see how encryption will fit into your overall security scheme.
SessionID: 25742
T-SQL Productivity
Event Date: 27-07-2013 - Session time: 00:00:00 - Track: SIOS Room
Speaker: Steve Stedman
Title: T-SQL Productivity
Abstract:
SessionID: 25743
Lunch Session A Day in the Life of a DBA
Event Date: 27-07-2013 - Session time: 00:00:00 - Track: Red Gate Room
Speaker: Steve Stedman
Title: Lunch Session A Day in the Life of a DBA
Abstract:
SessionID: 25744
Event Date: 27-07-2013 - Session time: 00:00:00 - Track: SIOS Room
Speaker: Steve Stedman
Abstract:
SessionID: 27397
Care and Feeding of Your System Databases
Event Date: 27-07-2013 - Session time: 00:00:00 - Track: Track 4
Speaker: Vicky Harp
Title: Care and Feeding of Your System Databases
Abstract:
Master, model, msdb, tempdb. You see them on all of your servers, but what do you really know about them? If you ever wanted to learn about the SQL Server system databases, their purpose, and the maintenance and configuration required to keep your server running its best, then this session is for you! Learn best practices and techniques, including how to restore master and how to configure tempdb to reduce contention. You'll leave with a better understanding of these shared resources and how they affect your database applications.
SessionID: 34803
Managing Log File Obesity
Event Date: 27-07-2013 - Session time: 00:00:00 - Track: Track 4
Speaker: Michael Fal
Title: Managing Log File Obesity
Abstract:
Have your efforts to trim a few pounds off your log file been met with frustration? Are you scratching your head on why that DBCC SHRINKFILE doesn’t seem to do anything? Log file obesity is a problem that can challenge DBAs of any level. This session will help you deal with your overweight database by covering how log files grow, why truncating the log is a bad idea, and what you can do to keep your files trim and fit.
SessionID: 34837
SQL Server Databaseology 201
Event Date: 27-07-2013 - Session time: 00:00:00 - Track: Track 4
Speaker: John Morehouse
Title: SQL Server Databaseology 201
Abstract:
Did you love "Bill Nye, the Science Guy" when you were a kid? Or maybe you were a MacGyver fan? Did you take apart your Mom's toaster or your Dad's alarm clock just to see how it ticked? Ever wonder how that database you built or support works behind the scenes? SQL Server Databaseology 201 is the science concerned with the study of SQL Server databases and their structures. This session will explore some of the deep inner workings of a SQL Server databases. The attendee will walk away with a deeper understanding of how SQL Server databases work which would allow them to build better and faster databases.
SessionID: 9659
5 Ways SSIS 2012 can Save You Time and Money
Event Date: 27-07-2013 - Session time: 00:00:00 - Track: Quest/Dell Room
Speaker: Angel Abundez
Title: 5 Ways SSIS 2012 can Save You Time and Money
Abstract:
Integration Services in SQL Server 2012 gives DBAs and BI developers new features that save time and money in terms of development and management. Whether you're automating DBA tasks, ETL processes, or System Integrations, SSIS has something for everyone.
Come learn about:
-Improvements in the design interface
-SSIS Parameters
-Easier Deployment with the SSIS Catalog
-New Standard Reports for monitoring SSIS
-New ways to control SSIS on the server.
If you're on SQL Server 2008, not to worry. I will show you an additional 3rd party tool that gives you a lot of this functionality. But nothing beats the ROI with SSIS 2012.
SessionID: 9765
Code-Less Securing of SQL Server
Event Date: 27-07-2013 - Session time: 00:00:00 - Track: SIOS Room
Speaker: Argenis Fernandez
Title: Code-Less Securing of SQL Server
Abstract:
Learn from a Microsoft Certified Master how to secure your SQL Server
infrastructure and your Windows installations to enhance resiliency
and minimize exposure to attacks—all without touching any of your
code!