Build Schedule

Advanced Filters:
  • Track

    clear all






  • Speaker


  • Level


  • Session Type

Sessions Found: 31
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.
Speaker:

Session Type:
Regular Session

Track:
Track 5

Level: Beginner

Session Code:

Date: July 12

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:
Track 4

Level: Intermedia

Session Code:

Date: July 12

Time: 12:00 AM - 1:00 AM

Room: TBD

This session will cover the process of benchmarking the underlying SQL server storage, test its performance and limits by using readily available tools. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 4

Level: Beginner

Session Code:

Date: July 12

Time: 12:00 AM - 1:00 AM

Room: TBD

Whether you are trying to setup a new data warehouse, keep it updated, audit changes to your databases or quickly load changes to another database Change Data Capture (CDC) is a solution for all of these and can now be setup and supported easily with SQL Server & SSIS 2012! Change Data Capture (CDC) has been around since SQL Server 2008, but has been underused because it was difficult to fully implement. SSIS 2012 now provides support for CDC with new components that make consuming the captured data very easy to apply. This session will define what CDC is and with live demos show how it is setup on your databases. Once it has been setup then you need to consume and apply those changes, this will be demonstrated with live demos using SSIS 2012 to create packages that apply the changes.
Speaker:

Session Type:
Regular Session

Track:
Track 1

Level: Intermedia

Session Code:

Date: July 12

Time: 12:00 AM - 1:00 AM

Room: TBD

Do you dread handing your T-SQL over for code review? Do your queries run slower than you expect? Does the DBA always want to tweak your T-SQL? In this demo heavy session, we’ll take a look at various ways to improve your T-SQL. You’ll learn about formatting T-SQL for readability and why top down design is not the best solution for writing T-SQL. You’ll learn why implicit conversions slow queries down and how to leverage simple techniques for minimizing the performance impact of explicit conversions. By changing some of your T-SQL writing habits you can improve performance of queries from the very beginning.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 2

Level: Beginner

Session Code:

Date: July 12

Time: 12:00 AM - 1:00 AM

Room: TBD

We are going to examine a variety of oopsies MANY developers fall prey to - some obvious, some pretty subtle and some down right sneaky! Lots of code examples with the bad AND good code presented. I GUARANTEE that you will find things here that will either prevent you from getting bad data, throwing unwanted errors or vastly improving your database application's performance.  I have given this talk over FIFTY times now and it is always very highly rated!
Speaker:

Session Type:
Regular Session

Track:
Track 1

Level: Intermedia

Session Code:

Date: July 12

Time: 12:00 AM - 1:00 AM

Room: TBD

This session will provide a deeper dive into the art of dimensional modeling. We will look at the different types of fact tables and dimension tables, how and when to use them. We will also some approaches to creating rich hierarchies that make reporting a snap. This session promises to be very interactive and engaging, bring your toughest Dimensional Modeling quandaries.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 5

Level: Intermedia

Session Code:

Date: July 12

Time: 12:00 AM - 1:00 AM

Room: TBD

Come learn about the new innovations and capabilities in Power BI for Office 365. Using Excel, SQL Server, and the power of the cloud, you will see what the BI landscape in Office 365 looks like and what you can potentially leverage today using the most popular BI tool on the planet. Come learn how to refresh your data with on-premise data sources, create visually compelling experiences on mobile devices, do time-series forecasting, and provide data governance through the Data Catalog and Natural Q&A. 

We will discuss what you will need in your Office 365 environment to get going, and some best practices when trying to set this up for your department or enterprise.
Speaker:

Session Type:
Regular Session

Track:
Track 2

Level: Beginner

Session Code:

Date: July 12

Time: 12:00 AM - 1:00 AM

Room: TBD

SQL Server 2014's In-Memory OLTP stores your data and indexes in a whole new way. In this session we'll take a look at way SQL Server 2014 In-Memory Database keeps track of your data with two new kinds of indexes, and why your data storage is so much more efficient.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 3

Level: Advanced

Session Code:

Date: July 12

Time: 12:00 AM - 1:00 AM

Room: TBD

Database restores are a key function of any database administrator's job. However, it can be an extremely time consuming task to sort through your backups, find the right files, and then get your database up and running. In an emergency this will have a disastrous impact on your Recovery Time Objective(RTO) and lead to the dreaded angry-CTO-in-your-cube effect. By leveraging some easy-to-use Powershell scripts, you can avoid the second disaster and the pain that comes with it.   By attending this session, you will understand how you can use the Powershell automation framework for database restores, see scripts that will let you restore faster, and learn techniques to extend these tools for migrating data and testing backups.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 3

Level: Intermedia

Session Code:

Date: July 12

Time: 12:00 AM - 1:00 AM

Room: TBD

Microsoft has brought business intelligence to the cloud. What does this mean and how does this work? In this session, we'll review the BI components available in the cloud BI stack. We'll also compare and contrast functionality of the cloud BI tools with on-premises tools. After attending this session, you'll have a better understanding of what's possible and whether it's time to launch your BI-in-the-cloud solution.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 4

Level: Beginner

Session Code:

Date: July 12

Time: 12:00 AM - 1:00 AM

Room: TBD

Have you ever wondered what four guys from Sacramento have to say about SQL Server?  Come find out when Mitch Bottel, Dan Hess, Dilip Nayak and Joe Simmons talk about our favorite DBMS, sharing experiences and tips/tricks and well as telling you how to do your job quickly and more efficiently.  We'll discuss SQL Server Management Studio (SSMS) in depth, talk about FREE SQL Server tools that every DBA should know about and finish off with a hands on presentation on using certificates to sign stored procedures. 

Presenters are board members for the Sacramento SQL Server user group:

Mitch Bottel - president;
Dan Hess - vice president/treasurer;
Dilip Nayak - event coordinator;
Joe Simmons - public relations;
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 5

Level: Beginner

Session Code:

Date: July 12

Time: 12:00 AM - 1:00 AM

Room: TBD

Part 1: Have you inherited an Oracle-based application, and are you not sure what you need to know to keep it running? Here are the basics, explained in terms familiar to Microsoft SQL administrators, including: - making sure you have, and keep, SYSDBA access - locating the ALERT log and checking for non-default PARAMETER - enabling ARCHIVELOG mode, scheduling RMAN backup, and testing restore - management of TABLESPACE and DATAFILE - using DBMS_MONITOR and TKPROF to trace SQL queries - using STATSPACK for performance troubleshooting  Part 2: Have you gotten the go-ahead to convert an Oracle database to SQL Server, and are you not sure how? Here is a proven and repeatable (and free) process, which achieves consistent results without requiring the source Oracle database to be read-only during the conversion. Microsoft's SSMA (SQL Server Migration Assistant) is just the beginning!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 3

Level: Intermedia

Session Code:

Date: July 12

Time: 12:00 AM - 1:00 AM

Room: TBD

SQL Server implements three different physical operators to perform joins. In this session we will examine how each of these operators work, its advantages and challenges. We will try to understand the logic behind the optimizer's decisions on which operator to use for various joins using (semi) real life examples and we will see how to avoid common join related pitfalls.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 1

Level: Advanced

Session Code:

Date: July 12

Time: 12:00 AM - 1:00 AM

Room: TBD

PowerShell is the Windows IT Pro's new best friend however it has not gotten much love from SQL Server in the past.  Still with the newest releases including Preview version 5 we can do some amazing things and there is no reason we can't share the love back to our favorite RDBMS!  Lets automate SQL Server together with PowerShell.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 2

Level: Intermedia

Session Code:

Date: July 12

Time: 12:00 AM - 1:00 AM

Room: TBD

Andy has over 15 years experience in the DBA field. Starting with SQL 6.5 to 2014, he is always retooling himself to be on the cutting edge of technology. He currently works for USC Keck Medical center as the Senior DBA and is using the techniques in this session in production.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 4

Level: Beginner

Session Code:

Date: July 12

Time: 12:00 AM - 1:00 AM

Room: TBD

Want to quickly roll out ultra-flexible reports that will wow your end users? Want to learn how to display the data in multiple layouts on the same report? Want to consolidate similar reports while still providing flexibility to your end users? This can all be achieved by leveraging the three controls based on the Tablix template: Table, Matrix, and the List control. 

In this demo-heavy session, you'll learn how to create a columnar report that grows vertically as well as horizontally. You'll see the magic of having multiple layouts for the same data on the same report. You'll see how to do more useful things with fewer reports, and you’ll come away with a bag full of new tricks to make your reports flexible and scalable works of art.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 3

Level: Intermedia

Session Code:

Date: July 12

Time: 12:00 AM - 1:00 AM

Room: TBD

In this presentation I'll show you a no SQL code required, all SQL Server 2012 self-service BI solution from the data warehouse all the way up to Report Builder 3. This is a solution I've put in place at Sutter, and it's something simple enough to use at virtually any company.
Speaker:

Session Type:
Regular Session

Track:
Track 3

Level: Intermedia

Session Code:

Date: July 12

Time: 12:00 AM - 1:00 AM

Room: TBD

Extended Events were introduced in SQL Server 2008.  With SQL 2012, we have seen a significant upgrade to this feature.  Join me for a little adventure into what extended events are.  We will discuss how to use extended events to aid in performance tuning and in day to day administration.  We will also explore some background and the architecture of extended events.  
Speaker:

Session Type:
Regular Session

Track:
Track 2

Level: Advanced

Session Code:

Date: July 12

Time: 12:00 AM - 1:00 AM

Room: TBD

Your SQL Server instance has been placed on a VMWare virtualized machine (VM), now what.    When a SQL Server instance moved to a virtualized architecture, the DBA typically loses visibility to CPU, Memory, Storage and network metrics.    This session will cover basic virtualization concepts specifically related to VMWare,  VMWare tools, as well as discuss specific tools to help restore the visibility of server metrics and correlate those metrics directly to SQL Server performance.   Monitoring the server metrics along with monitoring overall SQL Server performance provides for an effective solution to manage & monitor your SQL Server/VMWare virtualized environment.
Speaker:

Session Type:
Regular Session

Track:
Track 5

Level: Beginner

Session Code:

Date: July 12

Time: 12:00 AM - 1:00 AM

Room: TBD

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