Nr: 302
SQLSaturday #302 - Albany 2014
SessionID: 10683
Treating Tables Like Legos, Partitioning Basics
Event Date: 26-07-2014 - Session time: 00:00:00 - Track: Database Design
Speaker: Brandon Leach
Title: Treating Tables Like Legos, Partitioning Basics
Abstract:
SessionID: 11027
PowerShell for Database Developers
Event Date: 26-07-2014 - Session time: 00:00:00 - Track: Development
Speaker: Bryan Cafferky
Title: PowerShell for Database Developers
Abstract:
PowerShell has become the backbone of Windows Administrators but not heavily adopted by SQL Developers and this presentation is out to change that. Do you ever need to encrypt, decrypt, zip, unzip, combine files, export to csv format , import from csv format, move, copy, rename, even provide a nice interface to some powerful script you wrote? Bryan will even demonstrate how a PowerShell script can automatically navigate web pages doing tasks for you on the internet. In short, there is nothing PowerShell can't do an if you are a SQL Developer or DBA, you need to be leverage its Power!
SessionID: 11107
BIML--Step by Step
Event Date: 26-07-2014 - Session time: 00:00:00 - Track: Business Intelligence
Speaker: Julie Smith
Title: BIML--Step by Step
Abstract:
BIML--Business Intelligence Markup Language is your key to faster development of SSIS Packages. This session will guide you through an introduction to BIML. We'll explore the capabilities of BIML and BIMLScript, available through the free Codeplex BIDSHelper download. We'll move through basic syntax of plain BIML, and progress to BIMLScript, which enables exponentially faster development of SSIS packages.
SessionID: 11270
The Spy Who Loathed Me - An Intro to SQL Security
Event Date: 26-07-2014 - Session time: 00:00:00 - Track: BI / DBA
Speaker: Chris Bell
Title: The Spy Who Loathed Me - An Intro to SQL Security
Abstract:
You have lots of data you have painstakingly collected over the years. How do you ensure that data is protected from hackers, spies and other ne’er-do-wells? Understanding the vast array of security features available in SQL Server is the first step in helping you determine what actions you need to take now to protect your data.
SessionID: 11514
Ten T-SQL Techniques with Tally Tables
Event Date: 26-07-2014 - Session time: 00:00:00 - Track: Development
Speaker: Chris Hyde
Title: Ten T-SQL Techniques with Tally Tables
Abstract:
Chris Hyde has been working with the Microsoft SQL Server stack for over twelve years and has completed certification exams in SQL versions 2012, 2008, 2005, and 2000. He is a Senior Consultant with Leidos Health specializing in the healthcare market, which he particularly enjoys as he gets to tackle different types of data problems at each client. He is currently on the board of the Albuquerque chapter of SQL PASS.
SessionID: 12889
SSIS Optimization techniques
Event Date: 26-07-2014 - Session time: 00:00:00 - Track: Business Intelligence
Speaker: Daniel Bowlin
Title: SSIS Optimization techniques
Abstract:
SessionID: 13588
Remove the Linked Server 2 Hop Limitation by Implementing Kerberos
Event Date: 26-07-2014 - Session time: 00:00:00 - Track: Database Administration
Speaker: Derek Stanley
Title: Remove the Linked Server 2 Hop Limitation by Implementing Kerberos
Abstract:
Some of us have had to experience SSPI, untrusted domain, for login failed for NT Authority\Anonymous Logon errors can have come to the conclusion that there is a limitation when using windows authentication and linked servers. This is actually a limitation to the authentication method and not the linked servers. By implementing the new Kerberos authentication method in your Active Directory environment, you can overcome this 2 hop limitation.
SessionID: 14533
Hybrid Cloud Scenarios with SQL Server 2014
Event Date: 26-07-2014 - Session time: 00:00:00 - Track: Database Administration
Speaker: George Walters
Title: Hybrid Cloud Scenarios with SQL Server 2014
Abstract:
SQL 2014 has significant changes to allow seamless hybrid cloud scenarios. This session will talk about "why cloud" as well as the options available with backup, deployment, and new development scenarios with SQL 2014 and Azure.
SessionID: 14779
Statistics and Query Optimization
Event Date: 26-07-2014 - Session time: 00:00:00 - Track: Database Design
Speaker: Grant Fritchey
Title: Statistics and Query Optimization
Abstract:
There are any number of tricks and traps around getting the query optimizer to provide you with an optimal execution plan that gets you your data quickly and efficiently. But, at the end of the day, the principal driving factor of the optimizer, and therefore of your queries, are the statistics that define your data. This session teaches you how those statistics are put together and maintained by SQL Server. Different types of maintenance results in different levels of accuracy within statistics so we detail what the structures and information looks like after this maintenance. Your understanding of how the optimizer works with statistics will better enable you to understand why you’re getting the performance and types of execution plans that you are getting. Understanding enables you to write better t-sql statements and deal with performance problems such as bad parameter sniffing.
SessionID: 15720
Event Date: 26-07-2014 - Session time: 00:00:00 - Track: Database Administration
Speaker: Janis Griffin
Abstract:
SessionID: 16734
What the Hekaton
Event Date: 26-07-2014 - Session time: 00:00:00 - Track: Database Design
Speaker: John Flannery
Title: What the Hekaton
Abstract:
SessionID: 17010
Basic Database Programming
Event Date: 26-07-2014 - Session time: 00:00:00 - Track: General Use
Speaker: John Miner
Title: Basic Database Programming
Abstract:
Abstract:
You just found out that a client needs a SQL database to be designed from scratch. However, you existing DBA has given two week notice.
This presentation is meant for the Accidental DBA that has little to no experience with creating Transaction SQL objects.
After this presentation, will be ready to meet that clients need.
Coverage:
1 - How is a view better than ad-hoc SQL?
2 - Abstracting underlying tables via a view.
3 - Avoiding DML updates to views.
4 - Using triggers to enforce business rules.
5 - Using triggers to prevent data modifications.
6 - What are the different types of functions?
7 - Simple use of each type.
8 - Using stored procedures as an application interface.
9 - Batch programming using stored procedures.
10 - How to schedule batch jobs.
SessionID: 17012
Effective use of temporary tables
Event Date: 26-07-2014 - Session time: 00:00:00 - Track: Development
Speaker: John Miner
Title: Effective use of temporary tables
Abstract:
Abstract:
Every developer eventually comes against business logic that can’t be handled with a single simple or complex query. TSQL provides the developer with several constructs that can store temporary result sets that are passed to the next query in the script.
I will be covering these various TSQL techniques with examples using the [AdventureWorks] database as well as a toy database called AUTOS. The pros and cons of each construct will be examined. Advanced options like enabling trace flag 1118 will be explored.
Coverage:
1 – Derived tables.
2 – Local temporary tables.
3 – Global temporary tables.
4 – Table variables.
5 – Common Table Expressions (CTE).
6 – User databases in [tempdb].
7 – Trace Flag 1118.
SessionID: 17527
Show me whatcha workin' with: Big Data Edition
Event Date: 26-07-2014 - Session time: 00:00:00 - Track: Business Intelligence
Speaker: Josh Luedeman
Title: Show me whatcha workin' with: Big Data Edition
Abstract:
SessionID: 17550
Creating an SSIS Framework
Event Date: 26-07-2014 - Session time: 00:00:00 - Track: Business Intelligence
Speaker: James Phillips
Title: Creating an SSIS Framework
Abstract:
In this session we will cover what is a SSIS Framework, why you need a SSIS Framework, and how to implement it.
SessionID: 17611
Seven Strategies for Awesome Excel Dashboards
Event Date: 26-07-2014 - Session time: 00:00:00 - Track: BI / DBA
Speaker: Joe Rourke
Title: Seven Strategies for Awesome Excel Dashboards
Abstract:
SessionID: 18041
Entity Framework - Optimization Best Practices
Event Date: 26-07-2014 - Session time: 00:00:00 - Track: Development
Speaker: Kelly Gendron
Title: Entity Framework - Optimization Best Practices
Abstract:
SessionID: 19649
DANGER: The Art and Science of Presenting
Event Date: 26-07-2014 - Session time: 00:00:00 - Track: General Use
Speaker: Mark Vaillancourt
Title: DANGER: The Art and Science of Presenting
Abstract:
Is there a great difference in the brain chemistry of someone fleeing a hungry mountain lion and someone presenting to a group of colleagues in a corporate board room? The answer is: NO. Over the past decade, a lot has been learned about the chemistry of the brain and why humans react the way we do to events in our environment. The concept of EQ (Emotional Intelligence) is a compelling and growing concept that applies this knowledge in a set of learnable, improvable skills for leading human beings. While EQ is often applied to corporate leadership, the parallels to presenting are fantastic. This session will explain the basics of EQ and demonstrate how you can apply it to make your presentations better in the following areas: * Crafting better slide decks * Preparing yourself for presenting * Delivering your content * Dealing with the unexpected Understanding and practicing the concepts of EQ can make your presentations a better experience for everyone in the room--including you.
SessionID: 20508
How Not to Be a Cranky DBA
Event Date: 26-07-2014 - Session time: 00:00:00 - Track: General Use
Speaker: Mike Hillwig
Title: How Not to Be a Cranky DBA
Abstract:
Mike Hillwig is known as the Cranky DBA. You probably have pain points in your environment that make you cranky, too. Mike has lots of horror stories to tell about bad SQL Server implementations and practices. More importantly, he has developed a list of 12 key tips for managing your SQL Server environment. By following these tips, you’ll make your DBAs, developers, and system administrators a little less cranky.
SessionID: 20989
SQL Server Compression - Getting More Out of Less
Event Date: 26-07-2014 - Session time: 00:00:00 - Track: Database Design
Speaker: Michael Nowill
Title: SQL Server Compression - Getting More Out of Less
Abstract:
SessionID: 21141
101 Stupid Things Your Colleagues Do When Setting Up SQL Server
Event Date: 26-07-2014 - Session time: 00:00:00 - Track: Database Design
Speaker: Matt Slocum
Title: 101 Stupid Things Your Colleagues Do When Setting Up SQL Server
Abstract:
SessionID: 21635
Database Forensics - Part 1
Event Date: 26-07-2014 - Session time: 00:00:00 - Track: General Use
Speaker: Paresh Motiwala
Title: Database Forensics - Part 1
Abstract:
These are the days of increasing cyber and computer crimes.
As DBAs and guardians of corporate data, it is your paramount duty to not only prevent any data loss but also discover lost , damaged or sabotaged data.
But how can you do that without destroying evidence? Remember electronic evidence is extremely fragile.
In this the first of the two part session, we will explore the following:
- Fundamentals of Computer Forensics
- Tools to use in Computer Forensics--Data Acquisition
- Processing a crime scene
- Network Forensics and Live Acquistions.
- Submitting reports
SessionID: 21636
Database Forensics - Part 2
Event Date: 26-07-2014 - Session time: 00:00:00 - Track: General Use
Speaker: Paresh Motiwala
Title: Database Forensics - Part 2
Abstract:
Further to Database Foresnsics -Part 1, this session will discuss, various methods to analyse possible criminal actions and pin point it to a specific person/group of persons and time/time frame.
- Analyzing Network Traffic
- Searching for deleted, changed, renamed database files.
- Discussing header info of Database files,(and footers)
- Analyzing Logs: Transaction logs, Event Viewer, Trace Files, SQL Server Logs.
- Trapping crime as it happens or before it happens, use of "Honey Pots"
SessionID: 23553
HealthySQL 2.0
Event Date: 26-07-2014 - Session time: 00:00:00 - Track: BI / DBA
Speaker: Robert Pearl
Title: HealthySQL 2.0
Abstract:
Are your SQL Servers Healthy? Are all the SQL Servers you manage, healthy running optimally and has the high availability that is expected? How do you know for sure? Have you checked on the health of your SQL Servers lately? What is a HealthCheck, and how do we perform one? If you are a DBA, then you ought to know! Well Pearl Knows. Robert Pearl talks about the importance of regular health checks of your SQL Server(s). We will talk about the need to create a baseline provide some time-tested ways to determine if your SQL Servers are healthy and prove it to your managers, clients and heaven forbid, your IT auditors. Using various tools and scripts, you will come out of this session feeling much better :-) Session Level: Beginner Robert Pearl Speaker photo Robert Pearl, President of Pearl Knowledge Solutions, Inc., SQL MVP/SME, solutions-oriented Senior DBA with 12+ years of experience. He's SQLCommunity/SQLSaturday evangelist/promoter and maintains his regular blog Pearlknows
SessionID: 25444
DAX and the tabular model
Event Date: 26-07-2014 - Session time: 00:00:00 - Track: Business Intelligence
Speaker: Steve Simon
Title: DAX and the tabular model
Abstract:
With the advent of the tabular model in SQL Server 2012, another analytical option has opened to the BI Specialist. We shall be looking at what critical factors should be analyzed prior to opting for the model and that done, how to extract data from a tabular model using Data Analysis Expressions (DAX).
We shall discuss many of the often used functions, discuss their 'overloads' (utilizing several practical examples) and see how to turn the extracted data into valuable information that may be used by decision makers to help the enterprise achieve its corporate goals.
SessionID: 25880
Develop Impressive Dashboards using SSRS 2014
Event Date: 26-07-2014 - Session time: 00:00:00 - Track: BI / DBA
Speaker: Sunil Kadimdiwan
Title: Develop Impressive Dashboards using SSRS 2014
Abstract:
Microsoft Reporting Services 2014 has many exciting features. You can show your business data on Maps, Charts including Sparklines, Data bars and Indicators. Make them interactive, so that your users can drilldown to details. In this session I will show you how can make use of these and other enhancements in SSRS 2014.
SessionID: 26109
SQL Server Storage Engine under the hood
Event Date: 26-07-2014 - Session time: 00:00:00 - Track: Database Administration
Speaker: Thomas Grohser
Title: SQL Server Storage Engine under the hood
Abstract:
How is SQL Server really accessing the data and log files on the disk? What's done asynchronous and what's synchronous and what impact does that have on our queries and DML statements.
Which impact have features like database mirroring and replication, what's different when SQL Server is starting up.
Which I/O Subsystems (including SSD) are best for which type of data and what's the impact if you choose a different one. Which files can be placed on the same volume and which should not.
SessionID: 26664
Know Backups and Know Recovery
Event Date: 26-07-2014 - Session time: 00:00:00 - Track: Database Administration
Speaker: Tim Radney
Title: Know Backups and Know Recovery
Abstract:
SessionID: 28338
MongoDB for the Relational DBA
Event Date: 26-07-2014 - Session time: 00:00:00 - Track: Development
Speaker: Justin Dearing
Title: MongoDB for the Relational DBA
Abstract:
NoSQL is the buzzword of the moment, and MongoDB is the leader of the pack. Its probably running in your enterprise in production, and eventually its going to break. As a DBA its your job to fix it when it breaks, and back it up before it does.After all, there's not RELATIONAL in DBA.
On the technical side, this talk will focus on what a DBA needs to know about running MongoDB on windows. This includes setting it up as a service, importing and querying data, and of course backing up and restoring the database.
On the non-technical side, this talk will focus on when you would want to use MongoDB, and when you would not want to.
SessionID: 9597
Creating Access 2013 Web Apps based on SQL Azure using SharePoint
Event Date: 26-07-2014 - Session time: 00:00:00 - Track: BI / DBA
Speaker: Andy Tabisz
Title: Creating Access 2013 Web Apps based on SQL Azure using SharePoint
Abstract:
Access 2013 web apps feature a new, full integration with SQL Azure. When you create a web app on SharePoint, Access Services will create SQL Azure database that houses all of your Access objects. This opens up new opportunities for SQL developers to extend and work with the data in Access apps. In this session you will learn to easily create an Access Web Apps with automatic views, view the online development environment and see a real-world, production web app in action. We’ll discuss different the use of hybrid applications and integrating office web apps as well as learn about app distribution, deployment and upgrades. And lastly, see the pros/cons of Access Web Apps in a corporate environment.