sqlsathistory

Nr: 268

Back to Main list

SQLSaturday #268 - Connecticut 2014

Start Time (24h)	Speaker	Track	Title
00:00:00	Brandon Leach	Database Administration	Implementing a HIPAA Compliance Strategy with SQL Server
00:00:00	Jack Corbett	Development	Inroduction to Triggers
00:00:00	David Klee	Infrastructure / Virtualization	Squeezing Top Performance from Your Virtualized SQL Server
00:00:00	Edward Pollack	Development	Query Optimization Crash Course
00:00:00	John Miner	Development	Effective use of temporary tables
00:00:00	Juan Soto	Database Design	7 Great things you can do to improve and manage customer relationships
00:00:00	Kevin Goff	Business Intelligence	Implementing Data Warehouse Patterns with the Microsoft BI Tools
00:00:00	Lenni Lobel	Database Design	Native File Streaming with SQL Server 2012
00:00:00	Lenni Lobel	Database Design	Understanding your .NET 4.0 Data Access Options
00:00:00	Mike Hillwig	Database Administration	What the VLF?
00:00:00	Mike Hillwig	Database Administration	From Mess to Mastery: Managing Large Environments
00:00:00	Mike Walsh	Database Administration	What I Wish I Knew Before Becoming a DBA
00:00:00	Michael Nowill	Database Design	SQL Server Compression - Getting More Out of Less
00:00:00	Troy Gallant	Database Design	Indexing your Data Warehouse
00:00:00	Paresh Motiwala	Infrastructure / Virtualization	Database Forensics - Part 1
00:00:00	Paresh Motiwala	Infrastructure / Virtualization	Database Forensics - Part 2
00:00:00	Randy Knight	Development	But it worked great in Dev! Perfomance for Devs
00:00:00	Robert Pearl	Database Administration	HealthySQL 2.0
00:00:00	SB Chatterjee	Development	[Get-PowerShell-3
00:00:00	Thomas LaRock	Infrastructure / Virtualization	Monitoring Databases in a Virtual Environment
00:00:00	Steve Simon	Business Intelligence	DAX and the tabular model
00:00:00	Steve Simon	Business Intelligence	Challenges to designing financial warehouses, lessons learnt
00:00:00	Sunil Kadimdiwan	Business Intelligence	Develop Impressive Dashboards using SSRS 2014
00:00:00	Thomas Grohser	Infrastructure / Virtualization	Security and High Availability and DR
00:00:00	Todd Chittenden	Business Intelligence	Adding User Configurations to an Analysis Server Cube

SessionID: 10678

Implementing a HIPAA Compliance Strategy with SQL Server

Back to calendar

Event Date: 01-03-2014 - Session time: 00:00:00 - Track: Database Administration

Speaker: Brandon Leach

Title: Implementing a HIPAA Compliance Strategy with SQL Server

Abstract:

HIPAA puts a lot of responsibility on our companies and compliance can be hard to maintain. Today medical data is more valuable on the black market than a social security number or a credit card. As DBAs we're charged with the security of our data and thus act as a front line defense.

In this hour long session We'll delve into the Health Insurance Portability and Accountability Act (HIPAA) and what implications it has for us as data professionals. We'll discuss SQL Server best practices that can help protect ourselves, our company, and the people whom we serve. We'll also dive into features in SQL Server that can help in this endeavor.

SessionID: 11849

Inroduction to Triggers

Back to calendar

Event Date: 01-03-2014 - Session time: 00:00:00 - Track: Development

Speaker: Jack Corbett

Title: Inroduction to Triggers

Abstract:

This session will give a brief overview of the different types of triggers available in SQL Server (DDL DML) and then go into more detail on how and when to use DML triggers. This session will cover misconceptions about how triggers work, when triggers should and shouldn't be used (we will discuss options), common mistakes, and how to fix the most common mistakes. After attending this session a person will: 1. Identify different types of triggers and when to use them. 2. Be able to identify when a trigger is the right solution 3. Be able to write triggers that perform well

SessionID: 12532

Squeezing Top Performance from Your Virtualized SQL Server

Back to calendar

Event Date: 01-03-2014 - Session time: 00:00:00 - Track: Infrastructure / Virtualization

Speaker: David Klee

Title: Squeezing Top Performance from Your Virtualized SQL Server

Abstract:

Just about anyone can click through a SQL Server installation and get it working, but more than a little tuning is required to get the most performance out of your servers. Once virtualized, additional tuning can help get even more performance out of that virtual machine. David Klee (@kleegeek) will discuss valuable details for both VMware vSphere and Microsoft Hyper-V on how to tweak and tune your virtual infrastructure for business-critical virtualized SQL Servers. Tips on configuring your SQL Server installations for maximum performance when virtualized will be covered in detail.

SessionID: 13835

Query Optimization Crash Course

Back to calendar

Event Date: 01-03-2014 - Session time: 00:00:00 - Track: Development

Speaker: Edward Pollack

Title: Query Optimization Crash Course

Abstract:

Do you have users complaining that applications are running "too slow"? Do your DB traces look like a short story written by monkeys at typewriters?

This is a fun, fast-paced walkthrough of the most effective strategies for query tuning. We'll investigate the most common causes of sub-optimal queries (and some quite unusual ones) while building a foundation for solving any optimization problem that the application throws your way!

SessionID: 17041

Effective use of temporary tables

Back to calendar

Event Date: 01-03-2014 - Session time: 00:00:00 - Track: Development

Speaker: John Miner

Title: Effective use of temporary tables

Abstract:

Every developer eventually comes against business logic that can’t be handled with a single simple or complex query. TSQL provides the developer with several constructs that can store temporary result sets that are passed to the next query in the script.

I will be covering these various TSQL techniques with examples using the [AdventureWorks] database as well as a toy database called AUTOS. The pros and cons of each construct will be examined. Advanced options like enabling trace flag 1118 will be explored.

SessionID: 17652

7 Great things you can do to improve and manage customer relationships

Back to calendar

Event Date: 01-03-2014 - Session time: 00:00:00 - Track: Database Design

Speaker: Juan Soto

Title: 7 Great things you can do to improve and manage customer relationships

Abstract:

In the eyes of accountants, your a cost to a customer, period and end of discussion. So why do I always mention "We are a profit center" to my clients every chance we get? How do you handle a late project? How do you break bad news to a client, (Hint: With good news first). This and other highly effective management techniques are waiting for you at my session. So don't go to another Reporting Services session and instead come and learn how to improve and gain new business...unless you only do reporting services of course.

SessionID: 18265

Implementing Data Warehouse Patterns with the Microsoft BI Tools

Back to calendar

Event Date: 01-03-2014 - Session time: 00:00:00 - Track: Business Intelligence

Speaker: Kevin Goff

Title: Implementing Data Warehouse Patterns with the Microsoft BI Tools

Abstract:

You’ve read some of the content of well-known Data Warehousing books – now what? How do you take the structures and disciplines inside such books as the Ralph Kimball series and implement them? This session will take several of the key concepts in Data Warehousing and demonstrate some implementations using SQL Server Integration Services and Analysis Services. We’ll look at items such as Type 2 Changing Dimensions, Confirmed Dimensions, Dimension Outriggers, Role-Playing Relationships, Many-to-Many Bridge table relationships, Factless Fact tables, Handling of NULL foreign key values, and more.

SessionID: 19115

Native File Streaming with SQL Server 2012

Back to calendar

Event Date: 01-03-2014 - Session time: 00:00:00 - Track: Database Design

Speaker: Lenni Lobel

Title: Native File Streaming with SQL Server 2012

Abstract:

In this dynamic session, Lenni will teach you the ins-and-outs of unstructured data storage and native file streaming in SQL Server 2012. Learn all about FILESTREAM, an innovative feature introduced in SQL Server 2008 that integrates the relational engine with the NTFS file system. FILESTREAM revolutionized BLOB storage in the database, and now FileTable, new in SQL Server 2012, builds on FILESTREAM to deliver a logical file system—implemented as a FILESTREAM-enabled table in your database—on top of your BLOBs. Lenni will demonstrate how to program FILESTREAM using T-SQL and, for maximum performance, using the OpenSqlFileStream API in C#.

SessionID: 19116

Understanding your .NET 4.0 Data Access Options

Back to calendar

Event Date: 01-03-2014 - Session time: 00:00:00 - Track: Database Design

Speaker: Lenni Lobel

Title: Understanding your .NET 4.0 Data Access Options

Abstract:

The .NET 3.5 SP1 framework gave us Entity Framework (EF), Language-Integrated Query (LINQ), LINQ to SQL (and a variety of other LINQ providers) and ADO.NET Data Services. Now .NET 4.0 sports a revamped EF 4.0 with N-tier support and adds on WCF RIA Services.

How to you sort out this chaos? Is conventional ADO.NET dead? Is it possible to bridge the DataSet with Silverlight? How do you build an n-tier Silverlight app using domain services and EF 4.0? Lenni will answer these questions (and more) to help demystify the Microsoft data access juggernaut. We’ll compare the real advantages and disadvantages across this set of technologies so that you can choose the best architecture for your application. Attend this session and develop a clear perspective of .NET data access in today’s world.

SessionID: 20537

What the VLF?

Back to calendar

Event Date: 01-03-2014 - Session time: 00:00:00 - Track: Database Administration

Speaker: Mike Hillwig

Title: What the VLF?

Abstract:

Experienced DBAs know that SQL Server stores data in data files and transaction log files. What is less commonly known is that the transaction log file is broken up into smaller segments known as Virtual Log Files, or VLFs.

Having too many VLFs will cause performance to suffer. And having too few will cause backup performance to suffer. How do you strike the right balance?

In this more advanced session, veteran DBA Mike Hillwig will show you what VLFs are, how they're created, how to identify them, and how to strike the right balance between too few and too many.

SessionID: 20539

From Mess to Mastery: Managing Large Environments

Back to calendar

Event Date: 01-03-2014 - Session time: 00:00:00 - Track: Database Administration

Speaker: Mike Hillwig

Title: From Mess to Mastery: Managing Large Environments

Abstract:

In an era of "do more with less," IT staff are constantly being asked to manage environments without spending money. Worse yet, budgets are being cut for staff and tools.

IT veteran Mike Hillwig will show you how some of the integrated tools within SQL Server can help you manage your environment without spending a ton of money. We'll look at the Central Management Server, Management Data Warehouse, Multi-Server Administration, and Policy Based Management. Mike will also show you his tips for building an Environment Inventory Database, a tool you can use to track your servers, instances, and login credentials.

By leveraging what you already have in SQL Server, you'll certainly be able to do more with less.

SessionID: 20623

What I Wish I Knew Before Becoming a DBA

Back to calendar

Event Date: 01-03-2014 - Session time: 00:00:00 - Track: Database Administration

Speaker: Mike Walsh

Title: What I Wish I Knew Before Becoming a DBA

Abstract:

Are you interested in becoming a DBA? Would you consider yourself an accidental DBA?

In this talk, Mike Walsh will share some thoughts on the role of DBA - How to become one, What a DBA's priorities should be and what the pros and cons of being one are.

He'll look through his 13 years of DBA experience and share some of the lessons he wish he learned before he started out.

SessionID: 20987

SQL Server Compression - Getting More Out of Less

Back to calendar

Event Date: 01-03-2014 - Session time: 00:00:00 - Track: Database Design

Speaker: Michael Nowill

Title: SQL Server Compression - Getting More Out of Less

Abstract:

We are storing more information then we ever have before and we need to retain this information for longer periods of time. Do we keep adding more and more disk space? What about performance? What about cost? Is there some way we can use the existing space more efficiently? With data compression we can tackle these issues and do it with minimal or even no changes to our existing code.

SessionID: 21584

Indexing your Data Warehouse

Back to calendar

Event Date: 01-03-2014 - Session time: 00:00:00 - Track: Database Design

Speaker: Troy Gallant

Title: Indexing your Data Warehouse

Abstract:

One of the primary skill sets most database professionals are initially required to “master” is the art of proper indexing in our databases. We learn early on that an effective indexing configuration will go further in making our databases perform efficiently than probably any other single tuning technique. What’s not so commonly discussed though are the varying approaches one may wish to utilize when indexing your SQL Server enterprise data warehouse. This session will hopefully cause you to take a good look at your current indexing to see if indeed it could be operating even more efficiently.

SessionID: 21647

Database Forensics - Part 1

Back to calendar

Event Date: 01-03-2014 - Session time: 00:00:00 - Track: Infrastructure / Virtualization

Speaker: Paresh Motiwala

Title: Database Forensics - Part 1

Abstract:

These are the days of increasing cyber and computer crimes.

As DBAs and guardians of corporate data, it is your paramount duty to not only prevent any data loss but also discover lost , damaged or sabotaged data. But how can you do that without destroying evidence? Remember electronic evidence is extremely fragile. In this the first of the two part session, we will explore the following:

1. Fundamentals of Computer Forensics
2. Tools to use in Computer Forensics--Data Acquisition
3. Processing a crime scene
4. Network Forensics and Live Acquistions.
5. Submitting reports

SessionID: 21648

Database Forensics - Part 2

Back to calendar

Event Date: 01-03-2014 - Session time: 00:00:00 - Track: Infrastructure / Virtualization

Speaker: Paresh Motiwala

Title: Database Forensics - Part 2

Abstract:

Further to Database Foresnsics -Part 1, this session will discuss, various methods to analyse possible criminal actions and pin point it to a specific person/group of persons and time/time frame.

1. Analyzing Network Traffic
2. Searching for deleted, changed, renamed database files.
3. Discussing header info of Database files,(and footers)
4. Analyzing Logs: Transaction logs, Event Viewer, Trace Files, SQL Server Logs.
5. Trapping crime as it happens or before it happens, use of "Honey Pots"

SessionID: 22471

But it worked great in Dev! Perfomance for Devs

Back to calendar

Event Date: 01-03-2014 - Session time: 00:00:00 - Track: Development

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: 23544

HealthySQL 2.0

Back to calendar

Event Date: 01-03-2014 - Session time: 00:00:00 - Track: Database Administration

Speaker: Robert Pearl

Title: HealthySQL 2.0

Abstract:

Are your SQL Servers Healthy? Are all the SQL Servers you manage, healthy running optimally and has the high availability that is expected? How do you know for sure? Have you checked on the health of your SQL Servers lately? What is a HealthCheck, and how do we perform one? If you are a DBA, then you ought to know! Well Pearl Knows. Robert Pearl talks about the importance of regular health checks of your SQL Server(s). We will talk about the need to create a baseline provide some time-tested ways to determine if your SQL Servers are healthy and prove it to your managers, clients and heaven forbid, your IT auditors. Using various tools and scripts, you will come out of this session feeling much better :-) Session Level: Beginner Robert Pearl Speaker photo Robert Pearl, President of Pearl Knowledge Solutions, Inc., SQL MVP/SME, solutions-oriented Senior DBA with 12+ years of experience. He's SQLCommunity/SQLSaturday evangelist/promoter and maintains his regular blog Pearlknows

SessionID: 24022

Get-PowerShell-3 | Get-SQLServer-2012

Back to calendar

Event Date: 01-03-2014 - Session time: 00:00:00 - Track: Development

Speaker: SB Chatterjee

Title: Get-PowerShell-3 | Get-SQLServer-2012

Abstract:

New version of the popular PowerShell+SQL Server presentation (presented in over 6 SQL Saturdays User Group events). 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 new PowerShell 3.0 language scripts and how it can be used for SQL Server 2012 administration (using SMO WMI providers) and development (ADO.Net OLEDB providers).

SessionID: 25136

Monitoring Databases in a Virtual Environment

Back to calendar

Event Date: 01-03-2014 - Session time: 00:00:00 - Track: Infrastructure / Virtualization

Speaker: Thomas LaRock

Title: Monitoring Databases in a Virtual Environment

Abstract:

When moving databases to a virtual environment the performance metrics DBAs typically use to troubleshoot performance issues such as O/S metrics, storage configurations, CPU allocation and more become unreliable. DBAs no longer have a clear, reliable view of the factors impacting database performance. Understanding the difference between the physical and virtual server environment adds a new dimension to the DBA tasks. This presentation describes the changes that DBAs need to make in their performance and monitoring practices.

SessionID: 25362

DAX and the tabular model

Back to calendar

Event Date: 01-03-2014 - Session time: 00:00:00 - Track: Business Intelligence

Speaker: Steve Simon

Title: DAX and the tabular model

Abstract:

With the advent of the tabular model in SQL Server 2012, another analytical option has opened to the BI Specialist. We shall be looking at what critical factors should be analyzed prior to opting for the model and that done, how to extract data from a tabular model using Data Analysis Expressions (DAX).

We shall discuss many of the often used functions, discuss their 'overloads' (utilizing several practical examples) and see how to turn the extracted data into valuable information that may be used by decision makers to help the enterprise achieve its corporate goals.

SessionID: 25365

Challenges to designing financial warehouses, lessons learnt

Back to calendar

Event Date: 01-03-2014 - Session time: 00:00:00 - Track: Business Intelligence

Speaker: Steve Simon

Title: Challenges to designing financial warehouses, lessons learnt

Abstract:

In today’s rapidly changing financial world, designing robust and durable data warehouses can be a challenge that does not always stand the test of time.

In this presentation, we shall look at some of the challenges and design issues that were encountered whilst designing two custom warehouses and the steps that were required to cope with ongoing requirement changes, indecision from management, and shrinking budgets; all of which affected the progress of moving these projects from the design board to a profitable production stage.

SessionID: 25873

Develop Impressive Dashboards using SSRS 2014

Back to calendar

Event Date: 01-03-2014 - Session time: 00:00:00 - Track: Business Intelligence

Speaker: Sunil Kadimdiwan

Title: Develop Impressive Dashboards using SSRS 2014

Abstract:

Microsoft Reporting Services 2014 has many exciting features. You can show your business data on Maps, Charts including Sparklines, Data bars and Indicators. Make them interactive, so that your users can drilldown to details. In this session I will show you how can make use of these and other enhancements in SSRS 2014.

SessionID: 26116

Security and High Availability and DR

Back to calendar

Event Date: 01-03-2014 - Session time: 00:00:00 - Track: Infrastructure / Virtualization

Speaker: Thomas Grohser

Title: Security and High Availability and DR

Abstract:

How the manage security across multiple servers at production and DR sites. What needs to be configured on each server what gets moved over automatically. Best practices on how to keep the systems in sync and what surprises might SQL Server have for you when you use AlwaysOn, Database Mirroring, Logshipping or simple backup/restore.

SessionID: 26970

Adding User Configurations to an Analysis Server Cube

Back to calendar

Event Date: 01-03-2014 - Session time: 00:00:00 - Track: Business Intelligence

Speaker: Todd Chittenden

Title: Adding User Configurations to an Analysis Server Cube

Abstract:

Any analysis of a business's operations is going to include some proprietary values or conversion factors that only that industry or particular company will understand. And, it is likely that those values will need to be specific to some aspect of the business. In this session we'll look at several different ways to add user configurable values and conversion factors to an Analysis Server cube. We'll use some advanced T-SQL querying functions to produce a solution that is easy to understand, maintain, and extend.

This site is open source. Improve this page.