Nr: 144
SQLSaturday #144 - Sacramento 2012
SessionID: 10347
Event Date: 28-07-2012 - Session time: 00:00:00 - Track: BI Track
Speaker: Benjamin Nevarez
Abstract:
SessionID: 11327
Business Intelligence for Managers/Decision Makers
Event Date: 28-07-2012 - Session time: 00:00:00 - Track: BI Track
Speaker: Carlos Bossy
Title: Business Intelligence for Managers/Decision Makers
Abstract:
Business Intelligence is an essential component for any business today and a successful BI implementation has the power to change the way an organization functions. In this non-technical session Carlos Bossy will discuss the components of a BI project, including the data warehouse, reporting and analysis, predictive models, and the promise of Big Data. He will show how to determine its measures of succes and ROI, the makeup of a good BI team, how to define the success of a BI implementation, and how to fix a BI project gone bad. You will also learn how to evaluate your BI Analytics Strategy so that you leave this session with better knowledge of how to plan, build and deploy effective Business Intelligence solutions.
SessionID: 11330
Fast-track to BI Analytics with SQL Server 2012
Event Date: 28-07-2012 - Session time: 00:00:00 - Track: Misc Track
Speaker: Carlos Bossy
Title: Fast-track to BI Analytics with SQL Server 2012
Abstract:
SessionID: 11745
Replication Basics
Event Date: 28-07-2012 - Session time: 00:00:00 - Track: DBA Track
Speaker: Meredith Ryan-Smith
Title: Replication Basics
Abstract:
Let's cover the basics of setting up and monitoring SQL server Replication. I will focus on configuring transactional replication including options for the distributor, and where to run your log reader agents - but rest assured we will touch on merge and snapshot replication as well.
SessionID: 13089
Stop Bad Data in its OLTP Tracks
Event Date: 28-07-2012 - Session time: 00:00:00 - Track: SQL Dev Track
Speaker: Denise McInerney
Title: Stop Bad Data in its OLTP Tracks
Abstract:
Incorrect, inaccurate and misleading data can get into a database in a variety of ways. It causes bugs, impacts customers and hurts business. This session will explain how DBAs and developers can proactively ensure the data coming into a transactional system is clean and correct. The topics covered will include table design, the pitfalls of NULL, “garbage in”, transactions, change management, and coding standards.
The presentation will draw on the speaker's years of personal experience managing busy e-commerce databases supporting multi-million dollar businesses. The speaker will use real-life examples and demos to illustrate the many ways that OLTP data quality can be compromised.
SessionID: 14351
From T-SQL Turtle to T-SQL Rabbit: Macro Scripting
Event Date: 28-07-2012 - Session time: 00:00:00 - Track: SQL Dev Track
Speaker: Eric Freeman
Title: From T-SQL Turtle to T-SQL Rabbit: Macro Scripting
Abstract:
Do you ever find yourself frustrated writing query, after query, after query? In this session we will go over two fairly simple methods to write fast(er) and reliable T-SQL code. What is macro scripting? Come find out how you can spend a little bit of time today and how it can save you a lot of time in the future. We will also go "over" some of the new features in SQL 2012 window functions and how to save time using them. Yes, there will be a live demo.
SessionID: 14943
Introduction to Log Shipping and Mirroring
Event Date: 28-07-2012 - Session time: 00:00:00 - Track: DBA Track
Speaker: Harry Chandra
Title: Introduction to Log Shipping and Mirroring
Abstract:
In this introductory session, we will go through an overview of SQL Server Mirroring and Log Shipping. What are the parts and modes of database mirroring. You will also be introduce to log shipping and how it works. We will have a demo part of the session where we will go through every step of how to set up mirroring and log shipping. By the end of this session, you should have a general understanding and ability to deploy database mirroring and log shipping to meet your High Availability and Disaster Recovery requirement.
SessionID: 15285
Quick Easy SQL Tips Part 1
Event Date: 28-07-2012 - Session time: 00:00:00 - Track: BI Track
Speaker: Ike Ellis
Title: Quick Easy SQL Tips Part 1
Abstract:
SessionID: 15675
Extend Your Knowledge with Extended Events!
Event Date: 28-07-2012 - Session time: 00:00:00 - Track: Misc Track
Speaker: Janis Griffin
Title: Extend Your Knowledge with Extended Events!
Abstract:
SessionID: 15831
Isn't that Spatial
Event Date: 28-07-2012 - Session time: 00:00:00 - Track: SQL Dev Track
Speaker: Jason Horner
Title: Isn't that Spatial
Abstract:
this session is a whirlwind tour of the spatial features introduced in Sql Server 2008.
We will cover the basics of working with spatial data including: importing, querying, and visualizing.
As time permits, we will dive into some best practices for working with spatial data and ways to improve spatial query performance.
SessionID: 17841
Seeking SQL Server Secrets
Event Date: 28-07-2012 - Session time: 00:00:00 - Track: DBA Track
Speaker: Kalen Delaney
Title: Seeking SQL Server Secrets
Abstract:
Many experienced DBAs are aware that there are many undocumented commands and traceflags in SQL Server, and some DBAs may even keep track of all references to such options whenever they read about them in an article or blog posts, or hear about them at a conference. In this session, I’ll not only tell you about some of my favorite undocumented features, I’ll also tell you some of my tricks for discovering more undocumented secrets.
SessionID: 20134
Master Data Services in SQL Server 2012
Event Date: 28-07-2012 - Session time: 00:00:00 - Track: BI Track
Speaker: Mark Gschwind
Title: Master Data Services in SQL Server 2012
Abstract:
SessionID: 20834
Easily Manage your Servers with Policy Based Mgmt
Event Date: 28-07-2012 - Session time: 00:00:00 - Track: Misc Track
Speaker: Mitchell Bottel
Title: Easily Manage your Servers with Policy Based Mgmt
Abstract:
In this session, you will learn how to setup and implement Central Management Server (CMS) to run queries against multiple SQL servers in your environment. We will also cover Policy Based Management (PBM) and how to use out of the box best practices and create custom policies to maintain your environment. We will then look at using both CMS and PBM in conjunction with each other to monitor your environment.
SessionID: 22264
SQL Server 2012 AlwaysON in action
Event Date: 28-07-2012 - Session time: 00:00:00 - Track: DBA Track
Speaker: Prakash Heda
Title: SQL Server 2012 AlwaysON in action
Abstract:
This session will demo some of the key high availability features of SQL 2012 in action...
What is SQL Server AlwaysOn
What is AlwaysOn Availability Group
FCI AlwaysON VS WSFC SQL Cluster
Live Demo of:
Configure 3 node always on FCI instance
Configure Availability Groups with Always ON dashboard
Automatic manual failover using Virtual Name
Readable secondaries
Taking backups from secondaries
SessionID: 22492
But it worked great in Dev! Perfomance for Devs
Event Date: 28-07-2012 - Session time: 00:00:00 - Track: SQL Dev Track
Speaker: Randy Knight
Title: But it worked great in Dev! Perfomance for Devs
Abstract:
If you've ever found yourself stating the above, this session is for you. For many developers, writing T-SQL that works is not the challenge. But too often, functional T-SQL is not the same as good T-SQL. In this session, we will examine why "SQL that works" is not good enough. Understanding indexes, exectuion plans, sargability, and more are all critical to writing good T-SQL. We will also examine several real-world examples of T-SQL that "worked great in dev" but caused major issues when it hit production.
SessionID: 24456
Encryption in SQL Server
Event Date: 28-07-2012 - Session time: 00:00:00 - Track: DBA Track
Speaker: Steve Jones
Title: Encryption in SQL Server
Abstract:
There are a number of encryption options in SQL Server and this session will talk about many of them, looking briefly at TDE, hashing, encryption keys, and SSL encrpytion.
SessionID: 24611
Advanced SQL Injection techniques
Event Date: 28-07-2012 - Session time: 00:00:00 - Track: SQL Dev Track
Speaker: Slavik Markovich
Title: Advanced SQL Injection techniques
Abstract:
SQL injection remains one of the most widely-used tactics used by hackers to exploit security vulnerabilities of databases in order to get at sensitive information or to gain further system access to wreak havoc with more attacks. Though the majority of SQL injections are fairly simple and familiar, the more advanced ones can evade detection by some conventional security measures. I will offer up an in-depth analysis of some sophisticated SQL injection hacks and attacks, and offer up some best practices on how to harden your applications and databases against them in order to keep business-critical information safe.
SessionID: 27038
Event Date: 28-07-2012 - Session time: 00:00:00 - Track: SQL Dev Track
Speaker: Tom Keller
Abstract:
SessionID: 27325
Event Date: 28-07-2012 - Session time: 00:00:00 - Track: BI Track
Speaker: Varun Singh
Abstract:
Achieving scale-out quickly and easily for MS SQL Server environments can be extremely difficult, if not impossible. Other areas that are difficult or costly to achieve for SQL Server environments include transparent caching of Read queries, as well as instrumentation and Analytics of all SQL queries in real-time. In this session, you will learn how ScaleArc has developed SQL Server infrastructure software that achieves instant scale-out, caching, load balancing, firewall/filtering and higher availability…without any changes or modifications to existing applications or SQL Server databases. For those interested in migrating to SQL Server 2012, we will also discuss how ScaleArc can assist and add-value in a 2012 migration.
SessionID: 34655
From Geek to Grand Poo-bah
Event Date: 28-07-2012 - Session time: 00:00:00 - Track: Misc Track
Speaker: Helen Norris
Title: From Geek to Grand Poo-bah
Abstract:
From Geek to Grand poo-bah: how technical folks can move into management. This session will discuss how a technical professional can prepare him or herself to move into the management ranks.
SessionID: 34810
Managing and Auditing SQL Server Permissions
Event Date: 28-07-2012 - Session time: 00:00:00 - Track: Misc Track
Speaker: Michael Fal
Title: Managing and Auditing SQL Server Permissions
Abstract:
When your boss asks you who has access to your databases, do you break out into a cold sweat? Or, instead, are you worried about those other people who might have 'sa' access to your server and might be causing trouble on your server? Either way, as DBAs we need to be able to audit our SQL Server security. This presentation will give you a general overview of the different types of roles that you can use to manage access, what they mean, and how we look at the security gremlins hiding under the covers of our databases.
SessionID: 34812
Exposing the Core: SQL 2012 on Server Core
Event Date: 28-07-2012 - Session time: 00:00:00 - Track: DBA Track
Speaker: Michael Fal
Title: Exposing the Core: SQL 2012 on Server Core
Abstract:
Everything that's old is new again, as Windows Server moves back to the terminal interface. With SQL 2012, we can now run our SQL Servers on Server Core, a version of the Windows OS that is smaller and more secure. This presentation will introduce you to Server Core, how to prepare it for a SQL installation(including using Powershell for management), and how to actually install SQL 2012 on to it.
SessionID: 34822
Social Networking Is Alive!
Event Date: 28-07-2012 - Session time: 00:00:00 - Track: Misc Track
Speaker: John Morehouse
Title: Social Networking Is Alive!
Abstract:
Social Networking is all over the news today. Did you see that on Facebook? Johnny 5 said what on Twitter?? Can you believe Susie moved to that company?? Do any of those sound familiar? No? Never heard of Twitter? Don't have any fear as this session is for you! Social networking can be a very confusing place and when you don't know where to start, that makes it even worse. In this session, we will go over different facets of Social Networking and how you can use them to enhance not only your personal lives but just as importantly, your professional one. We'll be covering Facebook, LinkedIn and Twitter.
SessionID: 9370
Reporting Services - Practical tips and tricks
Event Date: 28-07-2012 - Session time: 00:00:00 - Track: BI Track
Speaker: Jonathan Amen
Title: Reporting Services - Practical tips and tricks
Abstract:
Practical tips and tricks to solve every day Reporting Services administration and development issues. Real world administration questions / issues along with real world scripts and solutions. Typical development issues with simple answers.
SessionID: 9653
Mobile BI with SSRS and SharePoint
Event Date: 28-07-2012 - Session time: 00:00:00 - Track: BI Track
Speaker: Angel Abundez
Title: Mobile BI with SSRS and SharePoint
Abstract: