Nr: 213
SQLSaturday #213 - Providence 2013
SessionID: 10820
Reporting Services for Mere DBAs
Event Date: 21-09-2013 - Session time: 00:00:00 - Track: Track 2
Speaker: Jason Brimhall
Title: Reporting Services for Mere DBAs
Abstract:
As a DBA in the modern era, you may be required from time to time to do something outside of your comfort zone. One of these things may be to become quickly acquainted with SSRS. Even better is that you may be required to do things you have not considered in a standard report. In this session, you will learn how to implement a framework to help provide a common ground for your reports. This session will delve into fun topics such as dynamic grouping and dynamic sorting. We are not talking about the interactive sorting that your accountant may use. Attendees will also be introduced to a few quick methods of exporting Reports from the report server - this is from a DBA perspective after-all!
SessionID: 10822
SQL 2012 Table Compression
Event Date: 21-09-2013 - Session time: 00:00:00 - Track: Track 4
Speaker: Jason Brimhall
Title: SQL 2012 Table Compression
Abstract:
SQL Server 2008 has introduced Table compression to the DBA toolkit. We all know there are different kinds of compression available in SQL Server. What some may not know is the subtleties of compression. Such subtleties include that not all Page Compressed tables are entirely page compressed. This session will show you how to reach into the database and discover compression states at the page level. At the lower level, this session will also show how to determine compression settings of objects in the database. Participants will be able to use undocumented commands as well as commands such as PIVOT to derive some interesting information from the database engine.
SessionID: 11026
Power Programming in SSIS 2008 R2 and 2012
Event Date: 21-09-2013 - Session time: 00:00:00 - Track: Track 2
Speaker: Bryan Cafferky
Title: Power Programming in SSIS 2008 R2 and 2012
Abstract:
Learn how to load any external file confidently and easily, how to take direct control of SSIS processes using the Script Task and the Script Component, how to select the best configuration and deployment approach to meet your requirements, how to design a package to make it flexible and extensible. This promises to be a meeting where you will come away with new ideas and techniques to apply in your job.
SessionID: 11855
An Introduction to Extended Events
Event Date: 21-09-2013 - Session time: 00:00:00 - Track: Track 2
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:
- How to investigate XEvents objects using the DMV's
- How to create an XEvents Session
- How to transition an existing Trace to an XEvents Session.
What you should know coming in:
- Basic use of SSMS
- Familiarity with Trace/Profiler
SessionID: 12903
Building Your First Tabular Model
Event Date: 21-09-2013 - Session time: 00:00:00 - Track: Track 2
Speaker: Dan Clark
Title: Building Your First Tabular Model
Abstract:
SessionID: 12904
Mastering Date-Time Based Analysis in DAX
Event Date: 21-09-2013 - Session time: 00:00:00 - Track: Track 4
Speaker: Dan Clark
Title: Mastering Date-Time Based Analysis in DAX
Abstract:
SessionID: 13840
Query Optimization Crash Course
Event Date: 21-09-2013 - Session time: 00:00:00 - Track: Track 1
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: 14525
SQL Server 2012 AlwaysOn Availability Groups
Event Date: 21-09-2013 - Session time: 00:00:00 - Track: Track 2
Speaker: George Walters
Title: SQL Server 2012 AlwaysOn Availability Groups
Abstract:
The AlwaysOn Availability Groups feature is a high-availability and disaster-recovery solution that provides an enterprise-level alternative to database mirroring.
SessionID: 14526
SQL Server 2012 Failover Clustering
Event Date: 21-09-2013 - Session time: 00:00:00 - Track: Track 3
Speaker: George Walters
Title: SQL Server 2012 Failover Clustering
Abstract:
SQL Server 2012 has significant improvements in Failover Clustering. This will review instance clustering and illustrate the new features.
SessionID: 16730
Event Date: 21-09-2013 - Session time: 00:00:00 - Track: Track 2
Speaker: John Flannery
Abstract:
SessionID: 17034
Effective Data Warehouse Storage Patterns
Event Date: 21-09-2013 - Session time: 00:00:00 - Track: Track 3
Speaker: John Miner
Title: Effective Data Warehouse Storage Patterns
Abstract:
Unexpected information growth in your data mart may lead to a performance impacted reporting system. In short, your users will be lining up at your cube for their daily reports.
How do you reduce the size of your data mart and speed up data retrieval?
This presentation will review the following techniques to fix your woes.
Coverage:
1 – What is horizontal partitioning?
2 – Database sharding for daily information.
3 – Working with files and file groups.
3 – Partitioned views for performance.
4 – Table and Index partitions.
5 – Row Data Compression.
6 – Page Data Compression.
7 – Programming a sliding window.
8 – What are Federations in Azure SQL?
SessionID: 17036
Full Text Indexing Basics
Event Date: 21-09-2013 - Session time: 00:00:00 - Track: Track 3
Speaker: John Miner
Title: Full Text Indexing Basics
Abstract:
Abstract:
Today’s large data fields (LDF) are full of unstructured information stored in varchar, text, varbinary or xml data types. How do you write an
application to search the column for patterns? Traditional SQL techniques using a column INDEX and LIKE operator result in a query plan that contains a full table scan.
I will be introducing the brother’s grimm database that has the full text of each fairy tale. I will create a full text catalog / index, select a change tracking strategy,
define optional stop list / thesaurus file, and then populate the index. I will use CONTAINS and FREETEXT operators in SELECT queries to leverage the FTI. This resulting query plan performs index seek.
Coverage:
1 – Creating a database from scratch.
2 – Creating a table with LOB field.
3 – Loading files via BULK INSERT.
4 – Performance via traditional techniques.
5 – Creating a full text index.
6 – Performance with the full text index.
7 - What's new in SQL 2012?
SessionID: 17561
Creating an SSIS Framework
Event Date: 21-09-2013 - Session time: 00:00:00 - Track: Track 2
Speaker: James Phillips
Title: Creating an SSIS Framework
Abstract:
In this session we will cover what is a SSIS Framework, why you need a SSIS Framework, and how to implement it.
SessionID: 19334
Event Date: 21-09-2013 - Session time: 00:00:00 - Track: Track 1
Speaker: atif yasin
Abstract:
Sharepoint 2013 is the comprehensive solution for enterprise content management. It has a performance point service application that enables users to create business intelligence (BI) dashboards that provide insight into an organization's performance.
In this hands-on presentation, we shall be creating a performance point dashboard that will consists of sample reports, filters and tabular data sources and we shall discuss some of the gotcha’s that one must look for.
SessionID: 19396
Building Tabular Analysis Models in Excel 2013
Event Date: 21-09-2013 - Session time: 00:00:00 - Track: Track 1
Speaker: Akesh Gupta
Title: Building Tabular Analysis Models in Excel 2013
Abstract:
This session covers the methodology to convert the relational databases to business models for analysis by end users. As Excel users always feel comfortable staying within the realms of Excel, Tabular Analysis bring a lot of value to the business end users to do their ad-hoc analysis. As the data models prove more beneficial, the models can then be extended to department and enterprise levels.
SessionID: 20525
What the VLF?
Event Date: 21-09-2013 - Session time: 00:00:00 - Track: Track 3
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: 20528
DBA's Rules for Dummies... And Developers
Event Date: 21-09-2013 - Session time: 00:00:00 - Track: Track 4
Speaker: Mike Hillwig
Title: DBA's Rules for Dummies... And Developers
Abstract:
In many organizations, there is a rift between DBAs and developers. The root cause is that there isn't often an established framework between what the DBAs need to manage the data and what developers need to help solve business problems. Many DBAs think that developers just write code without considering the impact to the data. And many developers think that DBA means 'Dont' Bother Asking."
In this session for developers, veteran production DBA Mike Hillwig will help you understand the DBA's needs in order to help you bridge that gap in your organization and work better to help solve business problems.
SessionID: 20618
What I Wish I Knew Before Becoming a DBA
Event Date: 21-09-2013 - Session time: 00:00:00 - Track: Track 1
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: 21659
Database Forensics - Part 1
Event Date: 21-09-2013 - Session time: 00:00:00 - Track: Track 1
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:
- Fundamentals of Computer Forensics
- Tools to use in Computer Forensics--Data Acquisition
- Processing a crime scene
- Network Forensics and Live Acquistions.
- Submitting reports
SessionID: 21660
Database Forensics - Part 2
Event Date: 21-09-2013 - Session time: 00:00:00 - Track: Track 1
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.
- Analyzing Network Traffic
- Searching for deleted, changed, renamed database files.
- Discussing header info of Database files,(and footers)
- Analyzing Logs: Transaction logs, Event Viewer, Trace Files, SQL Server Logs.
- Trapping crime as it happens or before it happens, use of "Honey Pots"
SessionID: 21701
5 Key Points for Effective T-SQL Unit Testing
Event Date: 21-09-2013 - Session time: 00:00:00 - Track: Track 4
Speaker: Sebastian Meine
Title: 5 Key Points for Effective T-SQL Unit Testing
Abstract:
In this session we are going to look at the five things you need to know when starting to unit test your T-SQL code. After attending the session you will know how to pick a good unit testing framework, how to write your first test, how to spy on procedures, how to fake tables and how to deal with constraints. We will also briefly cover test case heuristics that help with these questions: "How do I pick the first test?" and "How many tests is enough?"
SessionID: 21702
15 aspects of SQL Server indexes that you might not know
Event Date: 21-09-2013 - Session time: 00:00:00 - Track: Track 3
Speaker: Sebastian Meine
Title: 15 aspects of SQL Server indexes that you might not know
Abstract:
You probably know that indexes make you queries faster. But do you know why? Knowing how the different index types work under the covers will help you make the right decisions when (re-)designing you indexing strategy.
After attending this demo rich session you will be able to
- Explain the differences between SQL Servers 9 "index" types
- Identify the layout of SQL Server data on disk
- Decide which index types are the right ones to use for a given query
- Assess the impact of the Key on access speed
SessionID: 25196
Adding Strategic Value By Leveraging Business Intelligence
Event Date: 21-09-2013 - Session time: 00:00:00 - Track: Track 4
Speaker: Steve Simon
Title: Adding Strategic Value By Leveraging Business Intelligence
Abstract:
SessionID: 25330
I 'wanna' learn SQL Server
Event Date: 21-09-2013 - Session time: 00:00:00 - Track: Track 1
Speaker: Steve Simon
Title: I 'wanna' learn SQL Server
Abstract:
SessionID: 25871
Self Service BI: Office 2013 and SQL 2012
Event Date: 21-09-2013 - Session time: 00:00:00 - Track: Track 3
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: 26971
Master Data Management Using MDS on SQL Server 2012
Event Date: 21-09-2013 - Session time: 00:00:00 - Track: Track 3
Speaker: Todd Chittenden
Title: Master Data Management Using MDS on SQL Server 2012
Abstract:
Master Data Services was introduced to the SQL suite starting with 2008 R2. The product is for managing "Master Data" or data that is core to the business process; the 'nouns' of the business; the 'who' and the 'what'. The 2012 version has undergone some major improvements.
In this session we'll discuss the philosophy of "Master Data Management" and how an MDS implementation is NOT a Data Warehouse, but can certainly enhance one. We'll dive into the two popular user interface choices and options of the product to help you understand how you can get the best out of it. We'll set up a basic model during the demo and also take a peak under the covers to see some what we can touch inside the database, and what is dangerous ground.
SessionID: 27693
Table Vars Temp Tables - What you NEED to Know!
Event Date: 21-09-2013 - Session time: 00:00:00 - Track: Track 4
Speaker: Wayne Sheffield
Title: Table Vars Temp Tables - What you NEED to Know!
Abstract:
Almost every SQL Developer is familiar with Table Variables and Temporary Tables. While each of these objects represent temporary storage, there are also substantial differences between them. Understanding the differences between Table Variables and Temporary Tables, and the ramifications that those differences cause, is essential to being able to properly select the appropriate object for use in your development tasks. In this code filled session, we’ll discover the differences and similarities of Temporary Tables and Table Variables, dispel some widespread myths about each, and answer the most important questions of them all, "When do I use one or the other and what are the various impacts of doing so?"
SessionID: 27695
Windowing Functions in SQL Server 2012
Event Date: 21-09-2013 - Session time: 00:00:00 - Track: Track 4
Speaker: Wayne Sheffield
Title: Windowing Functions in SQL Server 2012
Abstract: