Build Schedule

Advanced Filters:
  • Track

    clear all







  • Speaker


  • Level


  • Session Type





Sessions Found: 43
Are you performing all of the regular maintenance you should on your servers? Do you not run CHECKDB because "it takes too long"? How about Index Maintenance - does that take too long? Do you really have the appropriate backups in place?Do you have benchmark numbers in place to compare when your server is "slow"? Come discuss the answers to these and other questions - we will discuss the free Maintenance Solution scripted tools from Ola Hallengren and how they can help you fix these and other problems with a little easy coding you can do yourself. We will also discuss other tips and tricks to help you maintain and troubleshoot your SQL Server instances.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Database Administrator

Level: Intermedia

Session Code:

Date: July 25

Time: 12:00 AM - 1:00 AM

Room:

What exactly does it mean to have optimistic concurrency? What is the alternative? Is SQL Server 2012's SNAPSHOT Isolation optimistic?  How can SQL Server 2014's In-Memory OLTP provide truly optimistic concurrency? 

In this session, we'll look at what guarantees the various isolation levels provide, the difference between pessimistic and optimistic concurrency, and the new data structures in SQL Server 2014 that allow the enormous benefits of having totally in-memory storage with no waiting!
Speaker:

Session Type:
Regular Session

Track:
Database Administrator

Level: Intermedia

Session Code:

Date: July 25

Time: 1:45 PM - 2:45 PM

Room: Dell

Come learn how to build and automate data sets and data models in Excel using the Power BI toolset. We'll pull data from a variety of on-premise and cloud data sources to familiarize yourself with the latest capabilities of Power Query and Power Pivot. Then we'll review the software required to automate your Power BI analysis whether you are trying to refresh your Excel workbooks on a file server, in SharePoint Online, or SharePoint on-premise.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Business Intelligence

Level: Intermedia

Session Code:

Date: July 25

Time: 8:30 AM - 9:30 AM

Room: Tegile

Machine Learning is a subfield of computer science concerned with systems that learn from data. In this session, learn how a Microsoft Azure Machine Learning solution comes to life: From the creation of a workspace, to the preparation of data, to experimentation with machine learning algorithms, and then finally to the integration and integration of predictive insights.

This session has been specifically designed to describe machine learning fundamentals, and to help enable and inspire existing developers taking their first steps to leverage cloud-based predictive models delivered with Azure Machine Learning. It is guaranteed to thrill you with potential, and excite you with the relative ease in which it can be accomplished.
Speaker:

Session Type:
Regular Session

Track:
Other

Level: Intermedia

Session Code:

Date: July 25

Time: 1:45 PM - 2:45 PM

Room: Profisee

Becoming certified in SQL Server is a great career enhancement for a database professional.  This session will provide you with an overview of the SQL Server Certification program, including the numerous changes made to the program for SQL 2012.  You'll discover several reasons why you should become certified, and some of the best ways in which to do so.  You'll also leave the session armed with some tips and tricks for passing the exams that the presenter has used over the last thirteen years.
Speaker:

Session Type:
Regular Session

Track:
Professional Development

Level: Beginner

Session Code:

Date: July 25

Time: 9:45 AM - 10:45 AM

Room: Dell

The benefit of a direct-connected pivot table for the SQL Admin/Developer is: you no longer have to write and constantly tweak reports! Just give your users permission to run a stored procedure, and they can satisfy all their reporting needs through self-service.

Benefits for your business user: they can always drill down to the detail, be confident that it was not changed after retrieval from the database, and change parameters and refresh whenever they want, even after rearranging the report.

It requires no client software besides Excel, and has worked similarly since Excel 97. Nothing is required on the server except any version of SQL. (You can also connect to any data source with an ODBC driver!)

Although the concept is straightforward, there are some stumbling blocks to avoid. I will cover all the important points for setting up this solution, including:
1) Making the Connection
2) Configuring and Arranging the Table
3) Allowing Users to Change Parameters
Speaker:

Session Type:
Regular Session

Track:
Business Intelligence

Level: Intermedia

Session Code:

Date: July 25

Time: 9:45 AM - 10:45 AM

Room: Profisee

Big Data and Data Science are two of the most hyped areas in high tech today.  But what do Big Data and Data Science really mean, and how can you move into these hot career paths?  In the discussion we will: Discuss the different roles in Big Data and Data Science teams; talk about the qualifications around each of the roles.  Andrew will also provide starting points and pointers on how to get started in these fields.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Professional Development

Level: Beginner

Session Code:

Date: July 25

Time: 8:30 AM - 9:30 AM

Room: Microsoft

This introductory session describes and demonstrates how to create a big data analytics solution with structured data by using Azure HDInsight and Excel 2013. This session will be of interest to those new to the concept of big data, new to self-service data modeling with Power Pivot, and for those interested to understand how big data can play a role in a self-service BI solution. Demonstrations will reinforce the introductory theory by showing how to store data files, and how to use Pig to transform data, and Hive to query data. The “big data” will then be retrieved and queried by using Power BI add-ins in Excel 2013, including Power Query, Power Pivot and Power View. 
Speaker:

Session Type:
Regular Session

Track:
Business Intelligence

Level: Intermedia

Session Code:

Date: July 25

Time: 11:00 AM - 12:00 PM

Room: Dell

In this session you will learn various uses of Common Table Expressions, how to declare, stack CTE's, and how to use recursive CTE's. Examples will be shared of how they can be used in useful and not so useful (but informative) ways. This session is intended for those comfortable using T-SQL but wanting to learn more about what is available. My intention is to heavily cover recursive CTE’s in this session. We will also go over windowed functions which will be used in some CTE examples.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DB Developer

Level: Intermedia

Session Code:

Date: July 25

Time: 4:15 PM - 5:15 PM

Room: Micron

Understanding how SQL Server organizes your data under the hood can seem like a daunting task. In this session we’ll take a look at how objects such as tables and indexes are stored in the data file. We’ll also look at how these concepts tie in to your work as a DBA or developer. We’ll see these concepts in action using demos and see how we can use this knowledge to better design solutions. We’ll start off by looking at the structure of a row and then move on the concept of a data page. From there we’ll cover a few special page types like the index allocation map. Then we’ll look at index structures and talk about the differences between heaps and clustered indexes.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Database Administrator

Level: Advanced

Session Code:

Date: July 25

Time: 3:00 PM - 4:00 PM

Room: Profisee

Grab your lunch and join Trent Mera and Susan Wong in the Dell room for an informative presentation while you eat!

How SharePlex Replicates from Oracle to SQL Server and Eight Other Targets

Replicate from Oracle to a more economical and potentially easier-to-manage platform like SQL Server and experience less frustration when support is required. Offloading database activities to a SQL Server replica will leave more processing power and faster response times for your Oracle users. Users on the SQL Server target will enjoy near-real-time data on an instance that is tuned specifically for the purpose of reporting, analytics and other database activities while the Oracle production system remains tuned for online transaction processing (OLTP). In addition, SharePlex can be used to completely migrate an Oracle database to SQL Server without taking users offline during the migration process. A SQL Server target replica could be used to accomplish archiving or serve as a data warehouse
Speaker:

Accompanying Materials:

No material found.

Session Type:
Lunch Session (75 minutes)

Track:
Lunch

Level: Beginner

Session Code: Lunch

Date: July 25

Time: 12:15 PM - 1:30 PM

Room: Dell

Wait statistics get more complaints about a lack of documentation than just about anything in SQL Server. The documentation that is available is not always very clear. Let's clear up these gray areas once and for all.

This session will cover what you need to know about wait stats like the best way to investigate them, how to interpret their meanings, and which wait types are important and which can be ignored.
Speaker:

Session Type:
Regular Session

Track:
Database Administrator

Level: Intermedia

Session Code:

Date: July 25

Time: 4:15 PM - 5:15 PM

Room: Microsoft

Event Registration
Speaker:

Accompanying Materials:

No material found.

Session Type:
Registration/Check-in (60 minutes)

Track:
Non-Session

Level: Beginner

Session Code:

Date: July 25

Time: 7:30 AM - 8:30 AM

Room: Microsoft

Come see the Sacramento SQL Server User Group board present their lightning talks. We will be different features of SQL server in this fun, quick paced, multi session of SQL goodies. It is promised to be entertaining and enlightening!
Agenda
Dan Hess talking about Signing stored procedures with certificates: Server security groups before SQL Server 2012
Dilip Nayak Discussing Auditing your actions using SQL Audit
Glenn Burnett talking about SQL Server Query Store in SQL 2016
Mitch Bottel will be talking SQL Server Management Studio Tips and Tricks

Come have fun with this session!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Database Administrator

Level: Beginner

Session Code:

Date: July 25

Time: 9:45 AM - 10:45 AM

Room: Micron

Flash disk and/or SSD technology options have been creeping into SQL Server database deployments more frequently. Knowing what options are out there and how they differ is key to successful deployments because the flash revolution is here to stay, and not all flash is created the same. Oracle ACE Bert Scalzo will present the many significantly different alternatives for utilizing flash disk and/or SSD in SQL Server deployments. Additionally, he will review SQL Server 2012 and 2014 features that support or best utilize flash.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Other

Level: Intermedia

Session Code:

Date: July 25

Time: 4:15 PM - 5:15 PM

Room: Dell

Few subjects in Microsoft SQL Server inspire the same amount of Fear, Uncertainty, and Doubt (FUD) than Extended Events.  Many DBA's continue to use Profiler and SQL Trace even though they have been deprecated for years.  Why is this?

Extended Events started out in SQL Server 2008 with no user interface and only a few voices in the community documenting the features as they found them.  Since then it has blossomed into a full feature of SQL Server and an amazingly low-impact replacement for Profiler and Trace.

Come learn how to get started - the basics of sessions, events, actions, targets, packages, and more.  We will look at some base scenarios where Extended Events can be very useful as well as considering a few gotchas along the way.  You may never go back to Profiler again!
Speaker:

Session Type:
Regular Session

Track:
Database Administrator

Level: Beginner

Session Code:

Date: July 25

Time: 8:30 AM - 9:30 AM

Room: Dell

Do you wish you could quickly and easily get some or your data into the hands of your end users? Well… SQL Server Reporting Services (SSRS) is part of SQL:  You’ve already paid for it, so put it to use!  In this introductory level session designed for users with no exposure to SSRS we will cover the basics of developing, publishing and using SQL Server Reporting Services.  From building a dataset through automating report delivery you will learn how you can return to the office and present meaningful data to your end users with minimal time and effort.  Come learn how this very powerful and easy to use tool can relieve you from data delivery tasks and thrill your end users all at the same time.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Business Intelligence

Level: Beginner

Session Code:

Date: July 25

Time: 1:45 PM - 2:45 PM

Room: Micron

We will review the bear minimum PowerShell CmdLets you should learn when you start learning PowerShell which will give you a good primer for exploring other more specific CmdLets.  You will learn what makes up PowerShell CmdLets, and basic syntax for using them, and how to dissect the .NET Objects that are returned by them.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Other

Level: Beginner

Session Code:

Date: July 25

Time: 11:00 AM - 12:00 PM

Room: Tegile

Using Response Time Analysis and Wait Types is a newer method for tuning SQL Server instances. As a result, there is often confusion on exactly what the data means. The issue typically centers around the fact the wait time data is analyzed at the wrong level or the collected wait time data is not detailed enough. This presentation will focus on these problems and review several real-life case studies of using SQL Server Wait Type data coupled with Response time performance analysis to solve the most difficult performance related issues. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Database Administrator

Level: Beginner

Session Code:

Date: July 25

Time: 11:00 AM - 12:00 PM

Room: Microsoft

Lunch Sessions from Event Sponsors
Speaker:

Accompanying Materials:

No material found.

Session Type:
Lunch Session (75 minutes)

Track:
Non-Session

Level: Beginner

Session Code:

Date: July 25

Time: 12:00 PM - 1:15 PM

Room: Dell

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