Nr: 200
SQLSaturday #200 - Philadelphia 2013
SessionID: 10463
Using SQL Server for the Model in MVC
Event Date: 01-06-2013 - Session time: 00:00:00 - Track: Dev
Speaker: Bill Wolff
Title: Using SQL Server for the Model in MVC
Abstract:
SessionID: 10766
Awesome coaching questions every geek, analyst, leader, and consultant must know.
Event Date: 01-06-2013 - Session time: 00:00:00 - Track: Prof Dev/Misc
Speaker: Brian Moran
Title: Awesome coaching questions every geek, analyst, leader, and consultant must know.
Abstract:
You spend time tuning your database. How much time do you spend tuning questions?
This session is an introduction to the art and science of asking great coaching questions. We’ll explore a wide range of questions that are great to have in your quiver of question especially no matter what job you have in #sqlfamily.
Coaching takes years to master. Learning basic coaching skills can happen quickly impacting your life, career, and the people around you in a modest period of time. You’ll leave this session with practical skills that can be quickly embraced and which have the potential to change your life and career for the better.
SessionID: 11247
“Indexing” Encrypted Data
Event Date: 01-06-2013 - Session time: 00:00:00 - Track: DBA II
Speaker: Chris Bell
Title: “Indexing” Encrypted Data
Abstract:
As a SQL Server DBA I see my role having 2 main focuses. First is to protect the data and second is to ensure performance is maximized. More often than not companies forget about data security when they focus on performance tuning. In this presentation I will mention a few cases where encryption could have saved a lot of hassle. I will then demo a method that can be used to "index" commonly searched on encrypted values (ex: SSNs, Credit Card, etc) helping reduce the impact on the performance of a query.
SessionID: 12187
Loading a Partitioned Fact Table using SSIS 2012 (Continuation)
Event Date: 01-06-2013 - Session time: 00:00:00 - Track: Dev/Misc
Speaker: Darryll Petrancuri
Title: Loading a Partitioned Fact Table using SSIS 2012 (Continuation)
Abstract:
Get in-depth knowledge and architectural guidance on modeling, governing and managing large data sets through the use of Partitioned Tables and how to load and manage them.
• Learn an effective ETL architecture, strategy and tactics to support: 24x7 business intelligence availability with no data warehouse "down-time" for data loading
• Supporting complex, multi-column partition schemes given the current single-column limitation on partitioning functions
• Partition loading and switching with minimal impact on user activity (queries) High-performance business intelligence solutions by • leveraging ColumnStore indexes on partitioned tables
• Updating partitioned table with ColumnStore Indexes given the current read-only limitation on tables with ColumnStore indexes
• Use SQL Server Integration Services as purely a orchestration tool for these processes
• Leverage SQL Server Management Objects to deliver a set of robust methods for a more flexible ETL architecture
SessionID: 12389
SQL Server 2012 AlwaysOn Step-by-Step
Event Date: 01-06-2013 - Session time: 00:00:00 - Track: DBA II
Speaker: David Bermingham
Title: SQL Server 2012 AlwaysOn Step-by-Step
Abstract:
Cluster MVP David Bermingham will walk you through the process of creating high availability and disaster recovery configurations using the new features of SQL Server 2012 AlwaysOn Availability Groups as well as AlwaysOn Failover Clusters and Multisite Clusters. And then finally David will demonstrate how Availability Groups and Failover Clusters can be used together for a combination of High Availability and Disaster Recovery. This session will make use of VMs to demonstrate the technology in a "hands-on" fashion.
SessionID: 13236
Introduction to Spatial Data in SQL Server
Event Date: 01-06-2013 - Session time: 00:00:00 - Track: BI
Speaker: Dominic Falso
Title: Introduction to Spatial Data in SQL Server
Abstract:
We'll discuss concepts of Spatial Data, and how it is implemented in SQL Server. We'll look at Geometry vs. Geography, different spatial data instances, and functions operation on them.
SessionID: 13366
Event Date: 01-06-2013 - Session time: 00:00:00 - Track: BI/Dev
Speaker: Donald Scott
Abstract:
Enterprise Information Management (EIM) is an industry term for managing your data for data integration, quality, and governance, and is an important part of the SQL Server 2012 release: This session revolves around a demo which brings together our EIM functionality in SQL Server 2012 and which tells our Credible, Consistent Data story. We will show you how SQL Server Integration Services (SSIS), Data Quality Services (DQS), Master Data Services (MDS) and other Microsoft technologies work together to provide a comprehensive EIM solution.
SessionID: 13400
Loading a Partitioned Fact Table using SSIS 2012.
Event Date: 01-06-2013 - Session time: 00:00:00 - Track: Dev/Misc
Speaker: Darryll Petrancuri
Title: Loading a Partitioned Fact Table using SSIS 2012.
Abstract:
Get in-depth knowledge and architectural guidance on modeling, governing and managing large data sets through the use of Partitioned Tables and how to load and manage them. Learn an effective ETL architecture, strategy and tactics to support:
24x7 business intelligence availability with no data warehouse "down-time" for data loading
Supporting complex, multi-column partition schemes with given the current single-column limitation on partitioning functions
Partition loading and switching with minimal impact on user activity (queries)
High-performance business intelligence solutions by leveraging ColumnStore indexes on partitioned tables
Updating partitioned table with ColumnStore Indexes given the current read-only limitation on tables with ColumnStore indexes
Use SQL Server Integration Services as purely a orchestration tool for these processes
Leverage SQL Server Management Objects to deliver a set of robust methods for a more flexible ETL architecture
***** 2 Hours Pleas
SessionID: 14108
Partitioning for Perf and Mgmt of Large Tables
Event Date: 01-06-2013 - Session time: 00:00:00 - Track: Performance
Speaker: Eddie Wuerch
Title: Partitioning for Perf and Mgmt of Large Tables
Abstract:
Managing data in ever-growing transaction and history tables can be challenging. Activities with large chunks of data such as moving data to archive tables, batch-importing many rows, or defragging an entire table when only the active portion changes introduces heavy I/O and blocking. Table partitioning solves a host of headaches with minimal effort. Ever wanted to truncate or defrag part of a table, or insert an entire staging table of data into another table in milliseconds instead of hours? Come see what partitioning can provide for you.
SessionID: 14109
Page Latches for Mere Mortals
Event Date: 01-06-2013 - Session time: 00:00:00 - Track: Performance
Speaker: Eddie Wuerch
Title: Page Latches for Mere Mortals
Abstract:
Latching is a necessary function of the database engine. Although latching is a topic is normally presented only in expert-level sessions, a good grasp of the problems excessive latching exposes is important even for novice tuners. This session focuses on the PAGELATCH_* and PAGEIOLATCH_* wait types, explaining what is happening, why it is happening, and how to use the exposed information to tune queries and solve performance problems. If you've seen these wait types in Activity Monitor and wonder what they meant, then this session is for you!
SessionID: 15008
Event Date: 01-06-2013 - Session time: 00:00:00 - Track: Performance
Speaker: Hope Foley
Abstract:
You got the "It's Slow" call, yeah you know the one. There are many places to dig in and determine how true that is but we'll focus on what the server thinks utilizing Performance Monitor. We'll go a bit deep into those facts in the poster on the wall and tell you the what/where/whys of it all. We'll make sure you understand those items selected and what they mean. We will also go through ways to quickly analyze that mountain of data collected.
SessionID: 15522
Can you Restore Back to Yesterday? Always Answer YES!
Event Date: 01-06-2013 - Session time: 00:00:00 - Track: Dev/Misc
Speaker: John Abrams
Title: Can you Restore Back to Yesterday? Always Answer YES!
Abstract:
As every DBA knows, the one question you want to be able to answer affirmatively is “Can you recover that data?”
Monitoring is critical, but monitoring methods can be imperfect. Traditional methods are difficult to set up and maintain across your entire environment, resulting in incomplete monitoring and missed alerts, so that it’s difficult to be sure of your answer to that all important question.
This presentation will:
• Describe a better way to monitor your database environment that is more efficient, easier to maintain, and guarantees that you never miss an alert.
• Share key syntax, so that you are certain the databases you are responsible for are always up, always backed up, and never run out of disk/file space.
So that your answer to that all important question is always YES!
SessionID: 15707
Extend Your Knowledge with Extended Events!
Event Date: 01-06-2013 - Session time: 00:00:00 - Track: Performance
Speaker: Janis Griffin
Title: Extend Your Knowledge with Extended Events!
Abstract:
SessionID: 16222
Event Date: 01-06-2013 - Session time: 00:00:00 - Track: DBA II
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: 16247
Learn RegEx In TSQL Kick as{2}|a[s][s]+
Event Date: 01-06-2013 - Session time: 00:00:00 - Track: Dev
Speaker: Joshua Lynn
Title: Learn RegEx In TSQL Kick as{2}|a[s][s]+
Abstract:
Regular Expressions, aka RegEx, is a powerful syntax for finding patterns in text, which has been around since the 60’s. Until recently the power of RegEx has been an elusive tool to T-SQL Developers. This presentation will provide an introduction to Regular Expressions in general and concentrate on the tools and techniques for using them in T-SQL. Find out how easy and powerful Regular Expressions can be for everyday tasks such as basic where condition criteria to validating and scrubbing data. Come on you know you’ve always wanted to learn RegEx ever since you first saw them. Now is your chance to get a jump start on using them. You will leave with the tools, knowledge and resources to get you started.
SessionID: 16664
Exploring your Data with Power View
Event Date: 01-06-2013 - Session time: 00:00:00 - Track: BI
Speaker: Jessica Moss
Title: Exploring your Data with Power View
Abstract:
SessionID: 16798
AlwaysOn - Finally, A usable 'mirror'!
Event Date: 01-06-2013 - Session time: 00:00:00 - Track: DBA II
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: 18031
Business Analytics
Event Date: 01-06-2013 - Session time: 00:00:00 - Track: BI
Speaker: Kevin Bucher
Title: Business Analytics
Abstract:
SessionID: 18294
T-SQL for Application Developers - Attendees chose
Event Date: 01-06-2013 - Session time: 00:00:00 - Track: Dev
Speaker: Kevin Goff
Title: T-SQL for Application Developers - Attendees chose
Abstract:
That's right, attendees choose! I'll show 20 possible topics on the screen, and the attendees vote on which topics I'll cover. Everything from isolation levels to ranking...everything from GUIDs to table-valued functions....everything from querying temporal data to instances where subqueries are necessary....everything from update triggers to reading execution plans. The good news is that you'll walk away with 20 code samples, even though we'll only cover a portion of them in the presentation. This has always been a very popular session.
SessionID: 19395
Self Service BI using Office 2013 and SQL 2012
Event Date: 01-06-2013 - Session time: 00:00:00 - Track: BI/Dev
Speaker: Akesh Gupta
Title: Self Service BI using Office 2013 and SQL 2012
Abstract:
This session covers the Self Service BI solutions available using Office 2013 and SQL 2012 for business users to do their ad-hoc analysis. In addition, the Analysis Models can be used for by Power View for visual representation of the analysis.
SessionID: 19405
Big Data Microsoft SQL Server in the Real World
Event Date: 01-06-2013 - Session time: 00:00:00 - Track: Prof Dev/Misc
Speaker: Mark Kromer
Title: Big Data Microsoft SQL Server in the Real World
Abstract:
Let's go beyond the hype of Big Data and the Microsoft story around Big Data and talk about real-world actual implementations of Big Data Big Data Analytics solutions. I'll talk about implementing SQL Server, Big Data Analytics engines, Hadoop and Big Data visualizations tools.
SessionID: 19573
Building Datamarts with SQL Server 2012
Event Date: 01-06-2013 - Session time: 00:00:00 - Track: Dev/Misc
Speaker: Mark Scott
Title: Building Datamarts with SQL Server 2012
Abstract:
SessionID: 19880
Automating in the Cloud
Event Date: 01-06-2013 - Session time: 00:00:00 - Track: DBA I
Speaker: Matt Velic
Title: Automating in the Cloud
Abstract:
Looking for a way to test your backups? Need to find an offsite location as a part of a DR plan? What about defining your backup retention scheme? You can handle these common DBA problems by utilizing Cloud services in combination with PowerShell automation. In this session, we'll review the basic Cloud architecture, as well as some specifics as to the components of the solution.
SessionID: 20020
An Introduction to SQL Server Virtualisation
Event Date: 01-06-2013 - Session time: 00:00:00 - Track: DBA II
Speaker: Gethyn Ellis
Title: An Introduction to SQL Server Virtualisation
Abstract:
SessionID: 20206
Event Date: 01-06-2013 - Session time: 00:00:00 - Track: BI
Speaker: Mark Hudson
Abstract:
Whether predicting customers or All Stars, the process and the tools remain the same. Microsoft’s Analysis Services Data Mining tools enable you to quickly profile your data, identify hidden relationships and predict future outcomes based on those relationships. Join me to see what data mining is, what data mining is not and how Microsoft's data mining tools can help you analyze your business. During this session, I will walk us through a start-to-finish data mining prediction project. It's easier than you might have thought.
SessionID: 20233
Virtualizing SQL 2012: Doing IT Right
Event Date: 01-06-2013 - Session time: 00:00:00 - Track: DBA I
Speaker: Michael Corey
Title: Virtualizing SQL 2012: Doing IT Right
Abstract:
SessionID: 20523
What the VLF?
Event Date: 01-06-2013 - Session time: 00:00:00 - Track: DBA II
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: 20524
Recovery and Backup for Beginners
Event Date: 01-06-2013 - Session time: 00:00:00 - Track: BI/Dev
Speaker: Mike Hillwig
Title: Recovery and Backup for Beginners
Abstract:
We all know that backups are important. Don't we? And we know that our backups are only as good as our ability to restore them. Dont' we?
In this session, veteran DBA Mike Hillwig will walk through the basics of database backup and recovery, including the different types of backups. He'll also set the record straight around some very common myths around database backup and recovery.
SessionID: 21229
All about NoSQL databases !!
Event Date: 01-06-2013 - Session time: 00:00:00 - Track: Prof Dev/Misc
Speaker: Muthu Ramanathan
Title: All about NoSQL databases !!
Abstract:
Lets talk about some of the open source databases today CouchDB, MongoDB, HBase, PstgreSQL, Redis, Neo4J. You will learn and see how these databases are different and where they fit when desiging a data solution. We will cover Relational DB's, Document DB's, Graph DB's, Key-Value and columnar databases. We will then get into Big Data solutions and see some examples of MapReduce Hive queries on HDInsight.
SessionID: 21272
Easy Database Refactoring with SQL Server Database
Event Date: 01-06-2013 - Session time: 00:00:00 - Track: Performance
Speaker: Mark Wojciechowicz
Title: Easy Database Refactoring with SQL Server Database
Abstract:
Database development can be a daunting task when modifying many objects for a project or coordinating schema changes across a team of developers. Implementing those changes can be equally problematic, particularly when deploying them to different versions of the same database. SSDT makes database refactoring a breeze – tracking renamed objects, preventing data loss during deployment and maintaining references between objects in a database. See the latest features in SSDT and learn how to create and work within a database project. Learn the tips and tricks in Visual Studio that will cut your development effort and allow you to deploy 100s of changes without missing an object, with better quality code.
SessionID: 21612
Event Date: 01-06-2013 - Session time: 00:00:00 - Track: BI
Speaker: Vince Napoli
Abstract:
SessionID: 21705
15 aspects of SQL Server indexes that you might not know
Event Date: 01-06-2013 - Session time: 00:00:00 - Track: Performance
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: 21792
Upgrading to SSIS 2012
Event Date: 01-06-2013 - Session time: 00:00:00 - Track: BI/Dev
Speaker: Paul Rizza
Title: Upgrading to SSIS 2012
Abstract:
As the newest version of SQL Server, 2012 is introducing many new BI features. This session will look at what has changed in SSIS 2012 and how to best leverage these new features to get the most for your ETL effort!
SessionID: 22407
Run your Applications @ the Speed of Memory
Event Date: 01-06-2013 - Session time: 00:00:00 - Track: Performance
Speaker: Peter Wellauer
Title: Run your Applications @ the Speed of Memory
Abstract:
KEY BENEFITS
• Mixed workload on shared hosts with no risk to SLAs
• Protect data without impacting performance
Setting the Benchmark Standard for SQL performance
• 5x to 10x faster performance for all workloads
• 5x to 10x less latency
• Elastic scalability for cloud deployments
• Increase density and improve IT efficiency
• Reduce TCO through increased consolidation
SessionID: 22666
Goodbye Next Next Next, Hello Automated Installs
Event Date: 01-06-2013 - Session time: 00:00:00 - Track: Prof Dev/Misc
Speaker: Brian Davis
Title: Goodbye Next Next Next, Hello Automated Installs
Abstract:
SessionID: 22970
Building a Reusable ETL Framework using SSIS 2012
Event Date: 01-06-2013 - Session time: 00:00:00 - Track: BI/Dev
Speaker: Ravi Gudlavalleti
Title: Building a Reusable ETL Framework using SSIS 2012
Abstract:
In this session we'll discuss the important features of an Enterprise-grade ETL framework and how easy it is to build one leveraging the new improved features of SSIS 2012.
SessionID: 23028
Move Your On Premise Database to a Windows Azure SQL Database and Setup Data Sync
Event Date: 01-06-2013 - Session time: 00:00:00 - Track: DBA I
Speaker: Charles Rivel
Title: Move Your On Premise Database to a Windows Azure SQL Database and Setup Data Sync
Abstract:
This session will move your on premise SQL Server database to a Windows Azure SQL Database using SQL Server 2012 Management Studio. In addition, after the database has been moved into the cloud, we will setup a Data Sync process using the SQL Azure portal across different server locations.
SessionID: 23549
HealthySQL
Event Date: 01-06-2013 - Session time: 00:00:00 - Track: DBA I
Speaker: Robert Pearl
Title: HealthySQL
Abstract:
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 and 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 :-)
SessionID: 23799
Event Date: 01-06-2013 - Session time: 00:00:00 - Track: BI
Speaker: Dave Bermingham and Eric Schwartz
Abstract:
SessionID: 23897
Automate SSIS Development for Loading a Data Warehouse
Event Date: 01-06-2013 - Session time: 00:00:00 - Track: Dev
Speaker: Samuel Vanga
Title: Automate SSIS Development for Loading a Data Warehouse
Abstract:
SessionID: 24480
Searching Binary Data in SQL Server 2012
Event Date: 01-06-2013 - Session time: 00:00:00 - Track: DBA I
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: 25677
ABCs of CDC with SSIS 2012
Event Date: 01-06-2013 - Session time: 00:00:00 - Track: BI/Dev
Speaker: Steve Wake
Title: ABCs of CDC with SSIS 2012
Abstract:
SQL Server Integration Services (SSIS) 2012 added full support for Change Data Capture (CDC) on databases. In this session we will cover the basics of CDC in SQL Server 2012 and then how to build SSIS 2012 packages that make using CDC to load your Data Warehouses easier than they were before. No previous knowledge of CDC is required for this session, but some knowledge of any version of SSIS will make it easier to understand.
SessionID: 26107
Accelerating Microsoft SQL Databases Critical Applications with Fusion-io
Event Date: 01-06-2013 - Session time: 00:00:00 - Track: Sponsor Session
Speaker: Eric Schwartz
Title: Accelerating Microsoft SQL Databases Critical Applications with Fusion-io
Abstract:
SessionID: 26161
Common TSQL Mistakes
Event Date: 01-06-2013 - Session time: 00:00:00 - Track: Dev
Speaker: Kevin Boles
Title: Common TSQL Mistakes
Abstract:
SessionID: 26164
Transaction Log Deep Dive
Event Date: 01-06-2013 - Session time: 00:00:00 - Track: Dev/Misc
Speaker: Kevin Boles
Title: Transaction Log Deep Dive
Abstract:
Time for another deep dive from TheSQLGuru, this time on the transaction log. Architecture and internals, monitoring, tuning/optimizing will all be covered. A great learning experience on another pillar of the SQL Server relational engine.
SessionID: 26830
A Walk Around the SQL Server 2012 Audit Feature
Event Date: 01-06-2013 - Session time: 00:00:00 - Track: DBA I
Speaker: Timothy McAliley
Title: A Walk Around the SQL Server 2012 Audit Feature
Abstract:
In this session, we will start by covering an overview of server and database auditing capabilities of SQL Server 2012. The session will largely focus on the specifics of using the SQL Server Audit feature, and we will step through a demonstration on configuring, maintaining and troubleshooting SQL Server Audit for server and database events.
SessionID: 27702
Table Vars Temp Tables - What you NEED to Know!
Event Date: 01-06-2013 - Session time: 00:00:00 - Track: Dev/Misc
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: 27704
Windowing Functions in SQL Server 2012
Event Date: 01-06-2013 - Session time: 00:00:00 - Track: Dev
Speaker: Wayne Sheffield
Title: Windowing Functions in SQL Server 2012
Abstract:
SessionID: 35783
Data Career Paths and Decision Making Strategies
Event Date: 01-06-2013 - Session time: 00:00:00 - Track: Prof Dev/Misc
Speaker: Melissa Demsak
Title: Data Career Paths and Decision Making Strategies
Abstract:
SessionID: 9102
Analysis Services - Multidimensional vs. PowerPivot vs. Tabular/BISM
Event Date: 01-06-2013 - Session time: 00:00:00 - Track: BI
Speaker: A.J. Mee
Title: Analysis Services - Multidimensional vs. PowerPivot vs. Tabular/BISM
Abstract:
Remember the days when Analysis Services solely represented an OLAP engine? Are you unclear about when to still build cubes vs. invoke the new Tabular engine in SSAS? Do you feel confused about where the self-service capabilities of PowerPivot end and where enterprise BI begins? If you answered YES to any of those questions, please join A.J. Mee (Principal BI Specialist at Microsoft) for some practical, real-world guidance around the three modes of SQL Server Analysis Services. As with most of A.J.'s presentations, the vast majority of the time will be spent providing demonstrations of the technology. Both traditional (i.e. relational) and non-traditional (i.e. unstructured/semi-structured) data sources may be incorporated into the demonstrations.
SessionID: 9171
Is the Job of a DBA, just a DBA?
Event Date: 01-06-2013 - Session time: 00:00:00 - Track: DBA II
Speaker: Todd Phillippe
Title: Is the Job of a DBA, just a DBA?
Abstract:
As I enter into the World of Database Administration I found that I was not only concerned about the data within the Database but with other technologies that support the database. Where is the data stored and who is responsible for that device? How will that be accessed and what level of access should they be granted. What host will the Instance be installed and who is responsible for that?
These question lead to other question that we don’t have control so therefore we must find a way too intelligently and effectively communicate.
Let’s look at some of the ways to enhance the communication between administrative groups outside of the Database realm.
Is the Operating System and Network that supports the database functioning as expected?
Is the storage device providing us with optimal throughput?
Do we have enough space to continue to grow our data and Log files?
How can this be evaluated and effectively communicated to administrators that are not DBA’s?
SessionID: 9583
Building Your Professional Development Plan
Event Date: 01-06-2013 - Session time: 00:00:00 - Track: Prof Dev/Misc
Speaker: Andy Warren
Title: Building Your Professional Development Plan
Abstract:
SessionID: 9665
Event Date: 01-06-2013 - Session time: 00:00:00 - Track: DBA I
Speaker: Janis Griffin
Abstract:
Are you struggling with performance issues and your current tools are not providing answers? Confio’s flagship product, Ignite, may be your answer. This presentation outlines a method for determining the best approach for tuning SQL statements by utilizing response time analysis. The speaker will use real-life case studies to demonstrate the techniques.