Build Schedule

Advanced Filters:
  • Track

    clear all







  • Speaker


  • Level


  • Session Type

Sessions Found: 33
Does your data sit around mocking your best attempts to support good data practices?  Databases are also bound by the GIGO rule: Garbage In is Garbage Out.  In this presentation, Karen shows you examples of the types of mistakes, misunderstandings and outright cheats that lead to poor data quality, mistrust in IT systems and overall smelliness in our IT solutions.  Using real-life evidence of her own data in your systems.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Development

Level: Beginner

Session Code:

Date: March 15

Time: 12:00 AM - 1:00 AM

Room: TBD

As Big Data becomes the norm to deal with data volume, variety and velocity, it becomes increasingly harder for the Data Analyst to understand and work with data sets.  To overcome this we introduce Platfora, a Hadoop-backed data analysis framework which nicely complements more traditional data warehousing and BI solutions. We'll go over ingestion of new data and building of data sets and visualizations in a system that requires no more work than interacting with a graphical interface. More specifically, we will do so in the context of peer-to-peer lending, to show how insights on loan applicants and their risk profiles can be quickly revealed with no ETL development or demanding data transformation.
Speaker:

Session Type:
Regular Session

Track:
Big Data/Azure

Level: Intermedia

Session Code:

Date: March 15

Time: 12:00 AM - 1:00 AM

Room: TBD

You always have more report requests than you can possibly fulfill. Wouldn't it be great if you could speed up the generation of reports? Templates can streamline the life cycle of a report for the whole team. In this session, you'll learn how templates in your tool belt can help you efficiently gather requirements, quickly design mock-ups, and standardize the look and feel of your SSRS reports. 
Reports don't stop changing once they're released into production, and some reports are phased out over time. Wouldn't it be great to have a way to keep track of the changes a report takes on in production over time? We'll talk about how to keep track of change requests, how to analyze the utilization of existing reports, and how to track changes in users for the reports in production.
Speaker:

Session Type:
Regular Session

Track:
Business Intelligence

Level: Beginner

Session Code:

Date: March 15

Time: 12:00 AM - 1:00 AM

Room: TBD

Join a panel of Business Intelligence experts from SolidQ and learn the best practices for planning and delivering successful BI solutions.  Join Rushabh Mehta (former PASS President), Brett Tomson and Paul Turley to discuss how to bring BI to your organization, avoid common pitfalls, apply proven design patterns and learn from deployments in companies around the world.  Bring your hard questions and be prepared for an interactive discussion.In this first of two sessions, learn how to wrangle requirements from the business, plan, prototype, & design your solution.
Speaker:

Session Type:
Regular Session

Track:
Business Intelligence

Level: Intermedia

Session Code:

Date: March 15

Time: 12:00 AM - 1:00 AM

Room: TBD

In the second of this 2-part Expert Panel discussion, learn to apply best practices in design to build and deliver a successful BI solution in your organization.  BI solution experts and SolidQ Mentors Rushabh Mehta, Brett Tomson and Paul Turley will help you define an end-to-end BI solution including data sourcing & security, data quality controls, ETL, dimensional design, semantic modeling, interactive dashboards, reports and mobile BI delivery.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Business Intelligence

Level: Intermedia

Session Code:

Date: March 15

Time: 12:00 AM - 1:00 AM

Room: TBD

Everyone wants a dream job that they enjoy going to each week. However finding that job, and getting yourself hired can be hard for most people. Steve Jones will give you practical tips and suggestions in this session that show you how to better market yourself, how to get the attention of employers, and help improve the chances that the job you want will get offered to you. Learn about networking, blogging, and more.
Speaker:

Session Type:
Regular Session

Track:
Bonus Track

Level: Beginner

Session Code:

Date: March 15

Time: 12:00 AM - 1:00 AM

Room: TBD

Allan Hirt on #SANLess Clustering on the Ground and in the Cloud...more details to follow!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Database Administration

Level: Intermedia

Session Code:

Date: March 15

Time: 12:00 AM - 1:00 AM

Room: TBD

 The presenter will consider different architectures to move data across environments during the software development life-cycle. Whether you start from scratch working with XP, or you have to establish processes in already existing organization working in waterfall, whether the data to move is 1 MB or terabytes, the presenter will present ways to handle the tasks and outline the cons and pros of each approach.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Development

Level: Intermedia

Session Code:

Date: March 15

Time: 12:00 AM - 1:00 AM

Room: TBD

With the release of SQL Server 2012, the new SQL Server Data Tools serves as your primary development environment for building applications on top of SQL Server. SSDT plugs in to Visual Studio with tooling designed specifically for the application developer. With SSDT, developers no long need to constantly switch between VS and SSMS. In this session, Lenni demonstrates how SSDT is used to develop for (and deploy to) on-premise and Windows Azure SQL Database. You will learn how to use code navigation, IntelliSense, and refactoring with your database model, and how to design databases offline and under source control right from VS. Don’t miss out on this demo-centric information-packed session on the new generation of database tools for developers!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Development

Level: Intermedia

Session Code:

Date: March 15

Time: 12:00 AM - 1:00 AM

Room: TBD

Virtualizing SQL Server has many benefits, but performance isn't one of them.  Typically, I/O bottlenecks (due to storage) in a virtualized environment lead to poor and unpredictable database performance.  Throwing money at the problem by purchasing more storage hardware is often expensive, disruptive and doesn't quite solve the problem.A better way is to accelerate virtualized SQL Servers by reducing I/O latency with Flash Hypervisor software.In this session, we will discuss:.       Leveraging the virtualization platform to reduce costs and complexity of SQL Server deployments.       The performance challenges of virtualizing SQL Server.       Using Flash Hypervisor software to accelerate I/O and create high-performance SQL Servers.       Real-world results – faster queries, more transactions and shorter processing times
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Business Intelligence

Level: Beginner

Session Code:

Date: March 15

Time: 12:00 AM - 1:00 AM

Room: TBD

Dimensional Modeling (DM) is the de facto standard for the design of databases for BI reporting & analytics.  Regardless of whether a database is a data warehouse used for reporting or an OLAP cube or advanced analytics, DM should be the basis for the data model.  This session will cover the fundamentals of DM along with best practices in designing and implementing the data model.  Additionally, we will cover practical situations that require “breaking the rules” of DM and how to implement solutions to these problems. 
Speaker:

Session Type:
Regular Session

Track:
Bonus Track

Level: Beginner

Session Code:

Date: March 15

Time: 12:00 AM - 1:00 AM

Room: TBD

Are you confident that your application performs as expected on Leap Day?  Do you know how long it would take to run out of identity values in your major tables?  Can you support case-sensitive collations and non-standard sort orders?  If not, odds are good that you are not edge and corner testing your application.  In this session, learn how to define the edges of your application and start to stretch those boundaries by setting up challenging test and development environments.  For database administrators, learn what configurations in your environment may be a source of bugs in application code and what you can do about it.  Learn about edge cases that you can start hardening your code against on Monday morning!
Speaker:

Session Type:
Regular Session

Track:
Database Administration

Level: Beginner

Session Code:

Date: March 15

Time: 12:00 AM - 1:00 AM

Room: TBD

Today’s organizations face growing challenges extracting business value from their data. The need for rapid insight is made more challenging by the expanding volume, complexity, and velocity of data. Traditional approaches to information management fail to harness this “data deluge”. New paradigms for data management and data analytics are emerging. Transformation of data to business insight requires a holistic approach that aligns the right platforms, technologies, and processes to support the decision process and analysis that business demands. During the session, we will the examine the Microsoft’s vision of enabling organizations to manage any data at any scale while empowering business users through self-serve information management and self-serve business intelligence. Through demos and interactive discovery we  will explore how the PowerBI BI tools can be used with Hadoop /HDInsight to accelerate organizations’ journey from data to insight.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Big Data/Azure

Level: Beginner

Session Code:

Date: March 15

Time: 12:00 AM - 1:00 AM

Room: TBD

HDInsight is the latest evolution of Hadoop on the Windows platform.  It allows you to manage big and unstructured data while using the rich Business Intelligence tools provided by SQL Server.  This session will cover big data architecture and demonstrate map/reduce, the nucleus of big data technology.  You will also see how you to get maximum value out of big data by incorporating it into your BI architecture with tools such as Hive, Excel, PowerQuery, and Tabular models.
Speaker:

Session Type:
Regular Session

Track:
Big Data/Azure

Level: Intermedia

Session Code:

Date: March 15

Time: 12:00 AM - 1:00 AM

Room: TBD

The cloud is a polarizing buzzword in IT, especially for DBAs. The reality is that all of us will be affected by it over the next few years in one way or another much like we have been by virtualization. One of the best uses for the cloud is creating disaster recovery easier than we have been able to do in the past. This session will discuss the cloud from a SQL Server DBA perspective and how things like hybrid on premise/cloud solutions can be architected today to bring resiliency to current solutions with features like availability groups in SQL Server 2012 and 2014.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
SQL Server 2014 Launch Track

Level: Intermedia

Session Code:

Date: March 15

Time: 12:00 AM - 1:00 AM

Room: TBD

Managing concurrency is one of the most challenging aspects of working with any enterprise DBMS. There is much confusion out there about locking, blocking, and deadlocks. In this demo heavy session we will clear up the confusion.
Speaker:

Session Type:
Regular Session

Track:
Database Administration

Level: Intermedia

Session Code:

Date: March 15

Time: 12:00 AM - 1:00 AM

Room: TBD

In this class you will see various machine learning tools and products that best integrate with the Microsoft business intelligence and analytics stack. Techniques include use of clustering, time series prediction, market-basket analysis, text mining and neural networks . We also cover real-world data preparation for model building, including outlier detection and removal, discretization and other common machine learning techniques. You will take away practical experience with machine learning processes that you can use in common business scenarios with Microsoft software, and particularly Office.
Speaker:

Session Type:
Regular Session

Track:
Big Data/Azure

Level: Intermedia

Session Code:

Date: March 15

Time: 12:00 AM - 1:00 AM

Room: TBD

In-memory OLTP is probably one of the most radical technologies to hit SQL Server in a long time. It has become the topic of endless discussions, debates, and the unavoidable myths. In this session we will cover the actual pains that drove the design of in-memory OLTP. We will understand WHAT it was created for, WHY it solves challenges that proved to be extremely hard to solve, HOW to find out if it is the right technology for you and not less important, what it was NOT designed for. We will cover a few real stories of applications that have utilized In-Memory OLTP successfully.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
SQL Server 2014 Launch Track

Level: Intermedia

Session Code:

Date: March 15

Time: 12:00 AM - 1:00 AM

Room: TBD

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.
Speaker:

Session Type:
Regular Session

Track:
Database Administration

Level: Intermedia

Session Code:

Date: March 15

Time: 12:00 AM - 1:00 AM

Room: TBD

In this presentation we will discuss the Parallel Data Warehouse Technology from Microsoft in-depth. We will cover its main use cases, why it was built, and how PDW works. We will then talk about how we use Polybase and big-data technologies within PDW to access data stored in Hadoop. With the new Appliance Update release in 2014, we are now able to automatically create MapReduce code based on T-SQL. In this overview we will cover PDW’s ability to implement Predicate Push-Down and show how we integrate with Hadoop natively.
Speaker:

Session Type:
Regular Session

Track:
Big Data/Azure

Level: Intermedia

Session Code:

Date: March 15

Time: 12:00 AM - 1:00 AM

Room: TBD

Sessions Found: 33
Back to Top
cage-aids
cage-aids
cage-aids
cage-aids