Build Schedule

Advanced Filters:
  • Track

    clear all





  • Speaker


  • Level


  • Session Type

Sessions Found: 25
SQL injection remains one of the most widely-used tactics used by hackers to exploit security vulnerabilities of databases in order to get at sensitive information or to gain further system access to wreak havoc with more attacks. Though the majority of SQL injections are fairly simple and familiar, the more advanced ones can evade detection by some conventional security measures. I will offer up an in-depth analysis of some sophisticated SQL injection hacks and attacks, and offer up some best practices on how to harden your applications and databases against them in order to keep business-critical information safe.
Speaker:

Session Type:
Regular Session

Track:
SQL Dev Track

Level: Intermedia

Session Code:

Date: July 28

Time: 12:00 AM - 1:00 AM

Room: TBD

Business Intelligence is an essential component for any business today and a successful BI implementation has the power to change the way an organization functions. In this non-technical session Carlos Bossy will discuss the components of a BI project, including the data warehouse, reporting and analysis, predictive models, and the promise of Big Data.  He will show how to determine its measures of succes and ROI, the makeup of a good BI team, how to define the success of a BI implementation, and how to fix a BI project gone bad. You will also learn how to evaluate your BI & Analytics Strategy so that you leave this session with better knowledge of how to plan, build and deploy effective Business Intelligence solutions.
Speaker:

Session Type:
Regular Session

Track:
BI Track

Level: Beginner

Session Code:

Date: July 28

Time: 12:00 AM - 1:00 AM

Room: TBD

If you've ever found yourself stating the above, this session is for you.  For many developers, writing T-SQL that works is not the challenge.  But too  often, functional T-SQL is not the same as good T-SQL.  In this session, we  will examine why "SQL that works" is not good enough.  Understanding  indexes, exectuion plans, sargability, and more are all critical to writing  good T-SQL.  We will also examine several real-world examples of T-SQL that  "worked great in dev" but caused major issues when it hit production. 
Speaker:

Session Type:
Regular Session

Track:
SQL Dev Track

Level: Beginner

Session Code:

Date: July 28

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session, you will learn how to setup and implement Central Management Server (CMS) to run queries against multiple SQL servers in your environment. We will also cover Policy Based Management (PBM) and how to use out of the box best practices and create custom policies to maintain your environment. We will then look at using both CMS and PBM in conjunction with each other to monitor your environment.
Speaker:

Session Type:
Regular Session

Track:
Misc Track

Level: Beginner

Session Code:

Date: July 28

Time: 12:00 AM - 1:00 AM

Room: TBD

There are a number of encryption options in SQL Server and this session will talk about many of them, looking briefly at TDE, hashing, encryption keys, and SSL encrpytion.
Speaker:

Session Type:
Regular Session

Track:
DBA Track

Level: Beginner

Session Code:

Date: July 28

Time: 12:00 AM - 1:00 AM

Room: TBD

Everything that's old is new again, as Windows Server moves back to the terminal interface.  With SQL 2012, we can now run our SQL Servers on Server Core, a version of the Windows OS that is smaller and more secure.  This presentation will introduce you to Server Core, how to prepare it for a SQL installation(including using Powershell for management), and how to actually install SQL 2012 on to it.
Speaker:

Session Type:
Regular Session

Track:
DBA Track

Level: Beginner

Session Code:

Date: July 28

Time: 12:00 AM - 1:00 AM

Room: TBD

SQL Server Extended Events can be used to gather a wide range of performance information, and in troubleshooting in SQL Server.  Extended Events use less system resources and provide better information than SQL Profiler and they allow for correlation of SQL Server event data along side of OS or Application event data. This presentation will explore what Extended Events are, how to set them up and use them in several case studies.

Speaker:

Session Type:
Regular Session

Track:
Misc Track

Level: Beginner

Session Code:

Date: July 28

Time: 12:00 AM - 1:00 AM

Room: TBD

SQL Server 2012 has made it easier to make the move to Business Intelligence and in this session Carlos Bossy will present three new features you can (and should) implement immediately.  The new Analytics functions in T-SQL, Columnstore indexes, and the Tabular model are powerful features that will give your users the ability to analyze data in a faster, more effective manner.  Each of these features was targeted at casual or beginning BI developers and DBAs who more familiar with traditional relational database models.  You will leave this session with a good understanding of the next steps to take to get on the fast-track to BI.
Speaker:

Session Type:
Regular Session

Track:
Misc Track

Level: Beginner

Session Code:

Date: July 28

Time: 12:00 AM - 1:00 AM

Room: TBD

From Geek to Grand poo-bah: how technical folks can move into management.  This session will discuss how a technical professional can prepare him or herself to move into the management ranks.
Speaker:

Session Type:
Regular Session

Track:
Misc Track

Level: Intermedia

Session Code:

Date: July 28

Time: 12:00 AM - 1:00 AM

Room: TBD

Do you ever find yourself frustrated writing query, after query, after query? In this session we will go over two fairly simple methods to write fast(er) and reliable T-SQL code. What is macro scripting? Come find out how you can spend a little bit of time today and how it can save you a lot of time in the future. We will also go "over" some of the new features in SQL 2012 window functions and how to save time using them. Yes, there will be a live demo.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
SQL Dev Track

Level: Intermedia

Session Code:

Date: July 28

Time: 12:00 AM - 1:00 AM

Room: TBD

How do you find information that was saved misspelled, or when your search is misspelled? Fuzzy-string processing! And if your information is in a database, the best place to do that processing is in the database. But there are some performance lessons to learn along the way. This session graphically illustrates the Damerau-Levenshtein Distance algorithm, and explains how it was optimized for T-SQL, using www.fuzzy-string.com and Confio Ignite.
Speaker:

Session Type:
Regular Session

Track:
SQL Dev Track

Level: Intermedia

Session Code:

Date: July 28

Time: 12:00 AM - 1:00 AM

Room: TBD

Achieving scale-out quickly and easily for MS SQL Server environments can be extremely difficult, if not impossible.  Other areas that are difficult or costly to achieve for SQL Server environments include transparent caching of Read queries, as well as instrumentation and Analytics of all SQL queries in *real-time*.  In this session, you will learn how ScaleArc has developed SQL Server infrastructure software that achieves instant scale-out, caching, load balancing, firewall/filtering and higher availability…without any changes or modifications to existing applications or SQL Server databases.  For those interested in migrating to SQL Server 2012, we will also discuss how ScaleArc can assist and add-value in a 2012 migration.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI Track

Level: Intermedia

Session Code:

Date: July 28

Time: 12:00 AM - 1:00 AM

Room: TBD

In this introductory session, we will go through an overview of SQL Server Mirroring and Log Shipping.  What are the parts and modes of database mirroring. You will also be introduce to log shipping and how it works. We will have a demo part of the session where we will go through every step of how to set up mirroring and log shipping.  By the end of this session, you should have a general understanding and ability to deploy database mirroring and log shipping to meet your High Availability and Disaster Recovery requirement. 

Speaker:

Session Type:
Regular Session

Track:
DBA Track

Level: Beginner

Session Code:

Date: July 28

Time: 12:00 AM - 1:00 AM

Room: TBD

this session is a whirlwind tour of the spatial features introduced in Sql Server 2008. 
We will cover the basics of working with spatial data including: importing, querying, and visualizing.
As time permits, we will dive into some best practices for working with spatial data and ways to improve spatial query performance.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
SQL Dev Track

Level: Beginner

Session Code:

Date: July 28

Time: 12:00 AM - 1:00 AM

Room: TBD

When your boss asks you who has access to your databases, do you break out into a cold sweat? Or, instead, are you worried about those other people who might have 'sa' access to your server and might be causing trouble on your server? Either way, as DBAs we need to be able to audit our SQL Server security. This presentation will give you a general overview of the different types of roles that you can use to manage access, what they mean, and how we look at the security gremlins hiding under the covers of our databases. 
Speaker:

Session Type:
Regular Session

Track:
Misc Track

Level: Beginner

Session Code:

Date: July 28

Time: 12:00 AM - 1:00 AM

Room: TBD

A recent survey by Information Week found that data qality is the greatest barrier to BI adoption in enterprises.  MDS addresses this challenge with modelling, validation, alerting and security capabilities.  In this presentation, you will learn how to configure MDS to model your data to ensure correctness, update it with changes from your ERP, and alert users to data conditions that require attention.  You will get tips on best practices and on how to engage uses with an MDM project.  By learning this tool, and its new features in 2012, BI professionals will gain a valuable new skill that addresses the greatest risk to success for BI projects - data quality.
Speaker:

Session Type:
Regular Session

Track:
BI Track

Level: Intermedia

Session Code:

Date: July 28

Time: 12:00 AM - 1:00 AM

Room: TBD

Today's executives and information workers want to use mobile devices to get at their business information, make critical decisions, and thrive. Let's help them get there with SQL Server Reporting Services and SharePoint. Tablets are common place now, and smart phones have been in place for years, but have we devoted enough attention to make effective use of the new form factors? Let's discuss how our design approach changes when we want to launch mission-critical dashboards and reports on smaller screen sizes using touch-screen technology. We'll look at iPad and other mobile devices, SSRS and SharePoint, BI Developer and Business User, with emphasis on data visualization best practices.
Speaker:

Session Type:
Regular Session

Track:
BI Track

Level: Intermedia

Session Code:

Date: July 28

Time: 12:00 AM - 1:00 AM

Room: TBD

This is a 100-level session, filled with tips and tricks to make you a better DBA and database developer.  We'll talk about everything from using automated tools, to common table expressions, and windowing functions.  Come learn from MVP Ike Ellis about easy things you can do to be a better DBA.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI Track

Level: Beginner

Session Code:

Date: July 28

Time: 12:00 AM - 1:00 AM

Room: TBD

Let's cover the basics of setting up and monitoring SQL server Replication.  I will focus on configuring transactional replication including options for the distributor, and where to run your log reader agents - but rest assured we will touch on merge and snapshot replication as well.
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
DBA Track

Level: Beginner

Session Code:

Date: July 28

Time: 12:00 AM - 1:00 AM

Room: TBD

Practical tips and tricks to solve every day Reporting Services administration and development issues. Real world administration questions / issues along with real world scripts and solutions. Typical development issues with simple answers.
Speaker:

Session Type:
Regular Session

Track:
BI Track

Level: Beginner

Session Code:

Date: July 28

Time: 12:00 AM - 1:00 AM

Room: TBD

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