Nr: 435
SQLSaturday #435 - El Paso 2015
SessionID: 36355
Becoming Certified In Microsoft SQL Server
Event Date: 29-08-2015 - Session time: 09:15:00 - Track: Professional Development
Speaker: Chris Hyde
Title: Becoming Certified In Microsoft SQL Server
Abstract:
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.
SessionID: 36668
What’s this ‘Scaffolding a CRUD’ all about? Build a Website from your SQL Database
Event Date: 29-08-2015 - Session time: 09:15:00 - Track: Application Database Development
Speaker: Gabriel Villa
Title: What’s this ‘Scaffolding a CRUD’ all about? Build a Website from your SQL Database
Abstract:
So you have a SQL Server database, and you want a web site for your tables? Come see how to develop and deploy a simple .NET website against any SQL Server database. See firsthand how to use Microsoft’s Entity Framework, ASP.Net MVC and other tricks to develop a website by writing very little code. Take home the ability to create and deploy a simple website to your own database once this demonstration is seen.
SessionID: 38916
Why should I care about the plan cache?
Event Date: 29-08-2015 - Session time: 09:15:00 - Track: Enterprise Database Administration Deployment
Speaker: Rick Lowe
Title: Why should I care about the plan cache?
Abstract:
SessionID: 36353
Row-Based Security in SSRS and SSAS
Event Date: 29-08-2015 - Session time: 10:25:00 - Track: BI Platform Architecture, Development Administration
Speaker: Chris Hyde
Title: Row-Based Security in SSRS and SSAS
Abstract:
It is relatively straight-forward to grant a user access to a particular SSRS report, multi-dimensional cube, or tabular model table, but what happens when the user needs access to the object but should be denied access to view certain rows of data? In this session we'll investigate a real-world solution to this common BI problem.
SessionID: 38232
Common TSQL Mistakes
Event Date: 29-08-2015 - Session time: 10:25:00 - Track: Application Database Development
Speaker: Kevin Boles
Title: Common TSQL Mistakes
Abstract:
SessionID: 38710
Build Android and iOS Apps with C# and Xamarin
Event Date: 29-08-2015 - Session time: 10:25:00 - Track: Strategy and Architecture
Speaker: Russ Burns
Title: Build Android and iOS Apps with C# and Xamarin
Abstract:
You can build Android apps with Java and iOS apps with ObjectiveC or Swift. But Xamarin allows developers to use c# and still produce native applications. This is not a marketing session. We will discuss (and demonstrate) the very real situation where an organization can take advantage of existing code and existing skills and still reach the mobile audience.
SessionID: 36399
The Ins and Outs of SQL Indexes
Event Date: 29-08-2015 - Session time: 12:40:00 - Track: Application Database Development
Speaker: Mindy Curnutt
Title: The Ins and Outs of SQL Indexes
Abstract:
SessionID: 38182
Relational Databases to Relational Leadership - how to be a great leader
Event Date: 29-08-2015 - Session time: 12:40:00 - Track: Professional Development
Speaker: Hasani X
Title: Relational Databases to Relational Leadership - how to be a great leader
Abstract:
As a tech expert, you’ve excelled as an individual, but now you’re moving out of your comfort zone into a leadership role. This transition is not only challenging but also critical to continued career advancement.
If you’re an emerging leader in transition or looking to someday lead, join us for an intense session based on the Rise Of A Leader program. In our session, we’ll share leadership tools, insights, and pragmatic approaches for going from relational databases to relationship leadership.
Learn:
The 15 Core Principles of RISE Leadership
Your Personal Rise Formula (PRF) and
How to Maximize Leadership Performance
SessionID: 38324
Reporting with Spatial Data
Event Date: 29-08-2015 - Session time: 12:40:00 - Track: Analytics and Visualization
Speaker: Russ Burns
Title: Reporting with Spatial Data
Abstract:
With Microsoft's Spatial Data type, we can represent locations and shapes in the database. Far more than just strings and decimals, geometries and geographies are objects we can compare and manipulate. From basic maps to custom areas, we will explore the power of adding Spatial to your data.
SessionID: 40516
Solving Business Problems Using SQL Window Functions
Event Date: 29-08-2015 - Session time: 12:40:00 - Track: Advanced Analysis Techniques
Speaker: Swan Webb
Title: Solving Business Problems Using SQL Window Functions
Abstract:
In this presentation, the CIO of one of the largest transportation companies in the US will introduce SQL window functions and demonstrate their use tackling real-world challenges including both time series and geospatial problems.
SessionID: 36666
Don’t fall victim to Little Bobby Tables: Guide to Developing a Secure Database Application
Event Date: 29-08-2015 - Session time: 13:50:00 - Track: Application Database Development
Speaker: Gabriel Villa
Title: Don’t fall victim to Little Bobby Tables: Guide to Developing a Secure Database Application
Abstract:
Is your SQL Server driven application safe? Does your application have 'sa' anywhere in the code? Are you a victim of SQL Injection? If you answer "yes" or "not sure", come see how to secure a SQL Server driven .Net application. Learn about some exploits and vulnerabilities and implementing best practices for securing SQL Server driven applications. See firsthand how to use Object Relation Mappers, MVC.Net and other tips to develop a secure application. Take home the ability to defend your SQL Server and your data at your applications level.
SessionID: 38165
Data Warehouse Design Decisions
Event Date: 29-08-2015 - Session time: 13:50:00 - Track: BI Platform Architecture, Development Administration
Speaker: Colleen Barnitz
Title: Data Warehouse Design Decisions
Abstract:
SessionID: 38233
SQL Server Defaults SUCK!!
Event Date: 29-08-2015 - Session time: 13:50:00 - Track: Enterprise Database Administration Deployment
Speaker: Kevin Boles
Title: SQL Server Defaults SUCK!!
Abstract:
If you just click next-next-next and think you have a good-to-go SQL Server . . . THINK
AGAIN!! :-) There are umpteen things you just GOTTA change right out of the box if you want your potentially very expensive and always precious SQL Server resource to perform optimally and behave correctly.
This session will cover a laundry list from BIOS Power Setting to data file growth and many useful items in between sitting everywhere from the physical server to the storage to the VM to Windows to SQL Server to database.
SessionID: 36401
SQL Server Bingo – Install, Migration Config
Event Date: 29-08-2015 - Session time: 15:00:00 - Track: Enterprise Database Administration Deployment
Speaker: Mindy Curnutt
Title: SQL Server Bingo – Install, Migration Config
Abstract:
Get ready to play SQL Buzzword Bingo with the subject matter being SQL Install, Migration Configuration. Are you preparing to move a database from one SQL Server to another? Whether it's your first SQL install, a SQL Server Upgrade or changing from physical to virtual, there is a lot to consider. In some areas of the setup, you get only one chance to "get it right." Come to this session and find out all about the process - and have some fun while you're at it. First one to hit BINGO! will win a copy of the book SQL Server 2012 - Step by Step.
SessionID: 38235
SQL Server 2014 New Features
Event Date: 29-08-2015 - Session time: 15:00:00 - Track: Other
Speaker: Kevin Boles
Title: SQL Server 2014 New Features
Abstract:
There is MUCH more to SQL Server 2014 than just Hekaton and Updatable Column Store Indexes!! This session will be a medium-to-high-level overview of many of the new features and enhancements coming in SQL Server 2014. When I thought of doing this session I initially wanted to have some demos, but there are SOOO many things to cover I couldn't fit in any demos in a 1 hour session!
SessionID: 40148
Breaking Productivity Boundaries with BIML
Event Date: 29-08-2015 - Session time: 15:00:00 - Track: BI Platform Architecture, Development Administration
Speaker: Adrian Chacon
Title: Breaking Productivity Boundaries with BIML
Abstract:
Has your ETL process ever bogged down productivity because of the repetitive tasks needed to prepare data for usability? Business Intelligence Markup Language (BIML) is an XML Dialect that can be used to create SSIS Packages in Visual Studio’s Business Intelligence Developer Studio. This session will cover the BIML basics and introduce some design patterns for code generation.