sqlsathistory

Nr: 184

Back to Main list

SQLSaturday #184 - North Haven 2013

Start Time (24h)	Speaker	Track	Title
00:00:00	Jack Corbett	SQL 2012	An Introduction to Extended Events
00:00:00	David Eichner	BI	SRS Report Builder for Business Intelligence
00:00:00	Daniel Bowlin	BI	Using templates for professional looking reports
00:00:00	Grant Fritchey	Data Base Administration	Query Tuning in the Clouds
00:00:00	Grant Fritchey	Data Base Administration	Database Backups for the Accidental DBA
00:00:00	John Miner	SQL 2012	How to audit and prevent unwanted user actions.
00:00:00	Kathy Gibbs	Data Base Administration	Best Practices for Monitoring Databases on VMware
00:00:00	Martin Schoombee	BI	Temporal Fact Tables: The Road Less Traveled
00:00:00	Matt Velic	Development	Build your own Virtual Lab
00:00:00	Mike Hillwig	SQL 2012	Building Your Own Monitors with the SQL Agent
00:00:00	Mike Hillwig	Professional Development	How Not to Be a Cranky DBA
00:00:00	Paresh Motiwala	Professional Development	Network or Perish
00:00:00	Paresh Motiwala	Professional Development	Best Practices Document
00:00:00	Robert Pearl	Data Base Administration	Much Ado About Indexes - Tips, Tricks and TSQL
00:00:00	SB Chatterjee	Development	[Get-PowerShell
00:00:00	Thomas LaRock	Data Base Administration	Database Design: Size DOES Matter
00:00:00	Steve Simon	Development	Database design for mere developers
00:00:00	Steve Simon	Development	I 'wanna' learn SQL Server
00:00:00	Sunil Kadimdiwan	BI	Self Service BI: Office 2013 and SQL 2012
00:00:00	Thomas Grohser	SQL 2012	SQL Server Storage Engine under the hood
00:00:00	Thomas Grohser	SQL 2012	Establishing a SLA
00:00:00	Todd Chittenden	BI	Building Tabular Analysis Models in Excel 2013
00:00:00	Melissa Demsak	Professional Development	Data Career Paths and Decision Making Strategies
00:00:00	Aaron Bertrand	Development	T-SQL : Bad Habits and Best Practices

SessionID: 11847

An Introduction to Extended Events

Back to calendar

Event Date: 02-03-2013 - Session time: 00:00:00 - Track: SQL 2012

Speaker: Jack Corbett

Title: An Introduction to Extended Events

Abstract:

XEvents were introduced with SQL Server 2008 and enhanced in SQL Server 2012 and with the announcement that SQL Trace/Profiler is being deprecated now is the time to begin learningXEvents. We will look at why you should start working with Extended Events, when you should start, and how to start. What you will learn:

1. How to investigate XEvents objects using the DMV's
2. How to create an XEvents Session
3. How to transition an existing Trace to an XEvents Session.

What you should know coming in:

1. Basic use of SSMS
2. Familiarity with Trace/Profiler

SessionID: 12711

SRS Report Builder for Business Intelligence

Back to calendar

Event Date: 02-03-2013 - Session time: 00:00:00 - Track: BI

Speaker: David Eichner

Title: SRS Report Builder for Business Intelligence

Abstract:

Learn how easy it is to utilize the free download from Microsoft that allows users to create maps, charts, dashboard objects and reports against any kind of data easily without having to use Visual Studio. See how SQL Report Builder makes creating executive dashboards easy!

SessionID: 12880

Using templates for professional looking reports

Back to calendar

Event Date: 02-03-2013 - Session time: 00:00:00 - Track: BI

Speaker: Daniel Bowlin

Title: Using templates for professional looking reports

Abstract:

This session will walk through the various elements that are important to professional and consistent looking reporting. After a review of the report elements we will develop a template using all those elements and then show how to use that template in all your future reports.

SessionID: 14766

Query Tuning in the Clouds

Back to calendar

Event Date: 02-03-2013 - Session time: 00:00:00 - Track: Data Base Administration

Speaker: Grant Fritchey

Title: Query Tuning in the Clouds

Abstract:

Just because you're using an Azure SQL database does not mean you can avoid tuning queries. Microsoft has throttling in place that could seriously impact your systems if your queries are using up lots of resources. This session will introduce you to the tools you have available to identify poor performing queries, such as dynamic management objects and others. You'll learn how to understand why a query is running slow using the Azure Portal execution plans. This understanding will enable you to fix your poorly performing queries. All in the cloud.

SessionID: 14767

Database Backups for the Accidental DBA

Back to calendar

Event Date: 02-03-2013 - Session time: 00:00:00 - Track: Data Base Administration

Speaker: Grant Fritchey

Title: Database Backups for the Accidental DBA

Abstract:

You've fallen into a job that requires you to manage a SQL Server Database Management System. Now you have to keep these databases on their feet. You've heard of this concept called a backup, and it sounds great, but you sure don't know what it is. This session is for you. We're going to go over backups, right from the beginning, so that when you come out of this session you can go back to your systems and set up backups, log backups, differentials, and anything else you might need. Further, you'll know how to recover your database in the event of an actual failure. The fundamentals you need to get a good backup in place and then be able to restore it will be covered in this session.

SessionID: 17029

How to audit and prevent unwanted user actions.

Back to calendar

Event Date: 02-03-2013 - Session time: 00:00:00 - Track: SQL 2012

Speaker: John Miner

Title: How to audit and prevent unwanted user actions.

Abstract:

Many corporations are composed of small divisions located in countries throughout the world. While you might be the lead DBA for your corporation, there are several other employees who have the keys to the kingdom. This presentation will review techniques on how to prevent and/or audit data and schema changes. 1 – Granting correct user access is vital 2 – DML triggers to keep a DATA audit trail. 3 – DDL triggers to keep a SCHEMA audit trail. 4 – Preventing unwanted DATA modifications 5 – Preventing table TRUNCATIONS 6 – Preventing unwanted SCHEMA changes 7 – New Feature (2008) – change data capture

SessionID: 17975

Best Practices for Monitoring Databases on VMware

Back to calendar

Event Date: 02-03-2013 - Session time: 00:00:00 - Track: Data Base Administration

Speaker: Kathy Gibbs

Title: Best Practices for Monitoring Databases on VMware

Abstract:

SQL Server on VMware??? Many of our customers are either virtualizing databases or planning to do so soon. I hear from many groups that attempted running their database on VMware but went back to physical hardware because of performance issues. There are many reasons this may have happened, but quite often the decision to go back to physical was not based on hard facts. This presentation will explore the fundamentals of monitoring databases running in a VMware environment. If you are using classic O/S monitoring tools, you may be getting misleading data. Understand what metrics are important and how to get to that data.

SessionID: 19746

Temporal Fact Tables: The Road Less Traveled

Back to calendar

Event Date: 02-03-2013 - Session time: 00:00:00 - Track: BI

Speaker: Martin Schoombee

Title: Temporal Fact Tables: The Road Less Traveled

Abstract:

Snapshot fact tables are a common approach when a point-in-time reference is required. In some cases though, even snapshots are not an option due to the amount of data it will generate.

In this session we will walk through a practical example of when and how to implement temporal fact tables, and how these can be a viable alternative to snapshots in certain situations.

SessionID: 19872

Build your own Virtual Lab

Back to calendar

Event Date: 02-03-2013 - Session time: 00:00:00 - Track: Development

Speaker: Matt Velic

Title: Build your own Virtual Lab

Abstract:

If you don't have the chance to work on different kinds of projects, it may be tough to grow all the necessary skills to further your career. By building a virtual lab at home, you can take control of the situation.

This session will focus on setting up a basic network environment using VirtualBox, free (downloadable) software, and your home computer. It's aimed towards individuals that aren't afraid to modify server settings or use the command line. This session is focused mainly on virtualization and networking topics, and not so much on SQL Server. However, you'll be in the position to tackle larger projects, such as SQL Server clustering or Availability Groups, once complete.

SessionID: 20559

Building Your Own Monitors with the SQL Agent

Back to calendar

Event Date: 02-03-2013 - Session time: 00:00:00 - Track: SQL 2012

Speaker: Mike Hillwig

Title: Building Your Own Monitors with the SQL Agent

Abstract:

See those things around your ankles? You hope they're your socks because no DBA wants to be caught with their pants down.

Whether you're an accidental DBA, a DBA who has just inherited a bunch of servers, or someone who works in a shop that won't buy monitoring tools, this session will help you get basic monitoring in place to make sure you know what's going on in your environment.

You'll learn how to implement simple scripts that perk their ears up and start barking like a dog after a stranger walks in the house. They are the canary in your coal mine. You'll know when backups fail, when they run longer than usual, when data files are getting full, when transaction logs have excessive VLFs, and more.

SessionID: 20560

How Not to Be a Cranky DBA

Back to calendar

Event Date: 02-03-2013 - Session time: 00:00:00 - Track: Professional Development

Speaker: Mike Hillwig

Title: How Not to Be a Cranky DBA

Abstract:

Mike Hillwig is known as the Cranky DBA. You probably have pain points in your environment that make you cranky, too. Mike has lots of horror stories to tell about bad SQL Server implementations and practices. More importantly, he has developed a list of 12 key tips for managing your SQL Server environment. By following these tips, you’ll make your DBAs, developers, and system administrators a little less cranky.

SessionID: 21661

Network or Perish

Back to calendar

Event Date: 02-03-2013 - Session time: 00:00:00 - Track: Professional Development

Speaker: Paresh Motiwala

Title: Network or Perish

Abstract:

As IT personnel, we tend to get boxed-in, stranded on our own little island. We fail to make people aware of our activities, both within our own organization and in our wider professional circles. Just like a shipwrecked captain waiting for the rescue boat on a desert island, if you fail to communicate, your career will be stuck with no possibility of progression. This presentation will show you how to leverage networking and self-marketing techniques that will allow you to set sail off the island and into new opportunities.

SessionID: 21663

Best Practices Document

Back to calendar

Event Date: 02-03-2013 - Session time: 00:00:00 - Track: Professional Development

Speaker: Paresh Motiwala

Title: Best Practices Document

Abstract:

As DBAs we are often straddled with writing a best practices document. In this session, I will start with a bare bones template and then we can collectively come up with a Best Practices Document by the end of the session. I challenge you that this document can come in handy, no matter where you go.If time permits, we can also discuss how to implement this in organizations with varying degrees of acceptance.

SessionID: 23542

Much Ado About Indexes - Tips, Tricks and TSQL

Back to calendar

Event Date: 02-03-2013 - Session time: 00:00:00 - Track: Data Base Administration

Speaker: Robert Pearl

Title: Much Ado About Indexes - Tips, Tricks and TSQL

Abstract:

Much Ado about Indexes - Tips, Tricks and Tuning.. In my session, I will offer some practical tips and tricks on a wide-array of Index Analysis methods that will allow you to find out everything about a client's indexes and were afraid to ask! What better way to optimize the performance of the database than talk about their indexes. What do you need to know in order to make these suggestions, and implement them. This session will cover the basics on indexes, and then demonstrate ways to improve DB performance. Missing Indexes, Duplicate Indexes, Fragmented Indexes, Covering Indexes, Clustered Nonclustered indexes, and the queries that love them. I will also demo how to correlate the worst performing queries with missing indexes

SessionID: 24017

Get-PowerShell | Get-SQLServer

Back to calendar

Event Date: 02-03-2013 - Session time: 00:00:00 - Track: Development

Speaker: SB Chatterjee

Title: Get-PowerShell | Get-SQLServer

Abstract:

PowerShell is a command-line scripting language primarily designed for system administration development. Unlike VBScript or DOS batch files, PowerShell is built upon the .NET Platform which makes it customizable and extensible. This introductory session will show the PowerShell language constructs scripts and how it can be used for SQL Server administration (using SMO WMI providers) and development (ADO.Net OLEDB providers).

SessionID: 25128

Database Design: Size DOES Matter

Back to calendar

Event Date: 02-03-2013 - Session time: 00:00:00 - Track: Data Base Administration

Speaker: Thomas LaRock

Title: Database Design: Size DOES Matter

Abstract:

Great database performance starts with great database design. During the database design process it is important to select your datatypes wisely. The wrong choices will often lead to wasted space, increased response times, and less stability. Additionally you run the risk of having your design not scale as well as it should. Leave this session armed with the knowledge you need to help your databases perform at their peak efficiency.

SessionID: 25308

Database design for mere developers

Back to calendar

Event Date: 02-03-2013 - Session time: 00:00:00 - Track: Development

Speaker: Steve Simon

Title: Database design for mere developers

Abstract:

SQL Server 2012: Efficient and effective database design is so important that leaving it solely to the DBAs is simply not a solution. We as developers will more than likely have to create applications to access the data stores and as such must ensure that all application related considerations are taken into account within the database design.In this session, (aimed at software developers) we shall be touching upon several concepts of special importance to the developer. These include database development "patterns and anti-patterns", final proofing of design and creating versatile deployment scripts that can and will be utilized in future endeavors.

SessionID: 25318

I 'wanna' learn SQL Server

Back to calendar

Event Date: 02-03-2013 - Session time: 00:00:00 - Track: Development

Speaker: Steve Simon

Title: I 'wanna' learn SQL Server

Abstract:

This presentation is meant to introduce the power of SQL Server to the "total novice". Often folks arrive at SQL Saturdays hoping to attend a session aimed at the novice. Well this is your chance!!. This hands on presentation assumes that you know NOTHING about SQL Server and that you must come up to speed in a minimal amount of time. We shall learn about the varied components of the product and end up creating a few simple queries, giving you enough knowledge to go back to your workplace and to perform like a star.

SessionID: 25875

Self Service BI: Office 2013 and SQL 2012

Back to calendar

Event Date: 02-03-2013 - Session time: 00:00:00 - Track: BI

Speaker: Sunil Kadimdiwan

Title: Self Service BI: Office 2013 and SQL 2012

Abstract:

In this session I will focus on how you can use the new features of Office 2013 such as Power View in Excel. How do you connect to multiple data models? How can you layout your data on a Map? How can you drill down to the details? And much more.

SessionID: 26117

SQL Server Storage Engine under the hood

Back to calendar

Event Date: 02-03-2013 - Session time: 00:00:00 - Track: SQL 2012

Speaker: Thomas Grohser

Title: SQL Server Storage Engine under the hood

Abstract:

How SQL Server performs I/O

How is SQL Server really accessing the data and log files on the disk? What's done asynchronous and what's synchronous and what impact does that have on our queries and DML statements. Which impact have features like database mirroring and replication, what's different when SQL Server is starting up.   Which I/O Subsystems (including SSD) are best for which type of data and what's the impact if you choose a different one. Which files can be placed on the same volume and which should not.

SessionID: 26118

Establishing a SLA

Back to calendar

Event Date: 02-03-2013 - Session time: 00:00:00 - Track: SQL 2012

Speaker: Thomas Grohser

Title: Establishing a SLA

Abstract:

Most DBA's rarely establish Service Level Agreements (SLA) with the Management and if they do they sometimes just come up with some random numbers for availability. Then when at some point something goes really wrong everybody wonders why it takes so long to bring everything back online.

  This Session will teach you how to ask the right questions, analyze your databases and servers and generate from the gathered data a realistic SLA.

SessionID: 26973

Building Tabular Analysis Models in Excel 2013

Back to calendar

Event Date: 02-03-2013 - Session time: 00:00:00 - Track: BI

Speaker: Todd Chittenden

Title: Building Tabular Analysis Models in Excel 2013

Abstract:

Microsoft Excel is the most popular data analysis tool in use. But most users tend to extract data for their analysis and end up with large volume spreadsheets that only they can understand and use. Data Analysts outside the official IT Department need a tool that will allow them to build and browse data models without extensive time lag to stand up traditional SSAS cubes.

Learn how to build SSAS Tabular Models in Excel and Visual Studio. Skirt around Tabular's Parent/Child limitation using DAX Expressions. Use Excel 2013 and SharePoint to build PowerView reports to visualize data trends. Browse a Tabular Model with the DAX Query language.

SessionID: 35782

Data Career Paths and Decision Making Strategies

Back to calendar

Event Date: 02-03-2013 - Session time: 00:00:00 - Track: Professional Development

Speaker: Melissa Demsak

Title: Data Career Paths and Decision Making Strategies

Abstract:

In recent years Data Careers have expanded beyond the conventional role of a DBA. This is due to the ever expanding amount of data, a larger variety of tools and the need for business to use data to drive their own performance goals. This session will provide an overview of Data Careers, a discussion of personal traits and life stages that may align with different Data Careers. The new Career areas such as Data Science, Analytics and Data Journalism will be reviewed. In addition, the attendees will be provided with a template that will enable them to make more strategic career-related decisions.

SessionID: 8918

T-SQL : Bad Habits and Best Practices

Back to calendar

Event Date: 02-03-2013 - Session time: 00:00:00 - Track: Development

Speaker: Aaron Bertrand

Title: T-SQL : Bad Habits and Best Practices

Abstract:

The session will cover a collection of minor bad habits that can occasionally lead to major problems.

This site is open source. Improve this page.