Nr: 202
SQLSaturday #202 - Edinburgh 2013
SessionID: 10560
Microsoft Access Power Hour
Event Date: 08-06-2013 - Session time: 00:00:00 - Track: Track 2
Speaker: Bob Duffy
Title: Microsoft Access Power Hour
Abstract:
This fun and demo packed hour is a look at some of cool stuff you can do with Micosoft Access and SQL Server
Learn:
- How you can create complex data entry forms in 2 minutes
- Use access as a RAD or prototyping tool
- Publish database forms to sharepoint
- Create complex reports
- No need for ETL processes. Learn how to master the black art of cut and paste.
- Go behind the scenes to see how access uses extended properties to extend SQL Data Models
- How to create a 200 user access solution (we have one!)
- Some horror stories and how people abuse Access
Rotten Tomatoes Provided for anyone that really hates Microsoft Access
SessionID: 12077
Session Details not available
Event Date: 08-06-2013 - Session time: 00:00:00 - Track: Track 2
Speaker: n/a n/a
Title: Session Details not available
Abstract:
Session Details not available
SessionID: 15384
Event Date: 08-06-2013 - Session time: 00:00:00 - Track: Track 2
Speaker: Niko Neugebauer
Abstract:
This session will concentrate on explanation of how to start using and analysing the data from one of the most popular social networks - Twitter. We shall take a look at the different dashboards and we shall try to understand some of the meanings. This presentation shall try to explore the best of the existing Microsoft technologies for an accessible Twitter data analysis.
SessionID: 17056
Solving Complex Problems with Extended Events
Event Date: 08-06-2013 - Session time: 00:00:00 - Track: Track 1
Speaker: Jonathan Kehayias
Title: Solving Complex Problems with Extended Events
Abstract:
New to SQL Server 2008, Extended Events provide a refreshingly new method of looking at what occurs inside of SQL Server. This session will show you how to leverage Extended Events to solve complex problems by identifying the root cause faster than other methods of data collection provide.
SessionID: 17124
Troubleshooting Query Plan Quality Issues
Event Date: 08-06-2013 - Session time: 00:00:00 - Track: Track 1
Speaker: Joe Sack
Title: Troubleshooting Query Plan Quality Issues
Abstract:
SessionID: 17602
Thinking Big Understanding PDW
Event Date: 08-06-2013 - Session time: 00:00:00 - Track: Track 1
Speaker: James Rowland-Jones
Title: Thinking Big Understanding PDW
Abstract:
We will visit the architectural components of PDW and look at some of the new features available in V2. We will also dive into some of the lessons learned developing systems for PDW in the field.
You will leave this session understanding why you should be thinking about PDW for your data warehouse and how you can accelerate the delivery of your PDW project.
SessionID: 18713
SQL Azure from Plan, to Backup, to Cloud
Event Date: 08-06-2013 - Session time: 00:00:00 - Track: Track 1
Speaker: Tobias Koprowski
Title: SQL Azure from Plan, to Backup, to Cloud
Abstract:
Microsoft released SQL Azure more than two years ago - that's enough time for testing (I hope!). So, are you ready to move your data to the Cloud? If you’re considering a business (i.e. a production environment) in the Cloud, you need to think about methods for backing up your data, a backup plan for your data and, eventually, restoring with Red Gate Cloud Services. In this session, you’ll see the differences, functionality, restrictions, and opportunities in SQL Azure and On-Premise SQL Server 2008/2008 R2/2012. We’ll consider topics such as how to be prepared for backup and restore, and which parts of a cloud environment are most important: keys, triggers, indexes, prices, security, service level agreements, etc.
SessionID: 19537
SQL Server AlwaysOn for Dummies
Event Date: 08-06-2013 - Session time: 00:00:00 - Track: Track 1
Speaker: Mark Broadbent
Title: SQL Server AlwaysOn for Dummies
Abstract:
Welcome to Microsoft's world of the buzzword. Yes, they've done it again and created another ambiguous term that no one really understands. AlwaysOn is a powerful group of highly available technologies, and in this presentation, we will delve into their murky world reveal the technology behind the buzz.
Focusing specifically on the two key components of SQL Server 2012 AlwaysOn in Failover Clustered Instances and Availability Groups, we will investigate their pre-requisites, setup, administration, use drawbacks. We will look at:
Using Windows 2008, 2012 and Server Core
Windows Clustering
Quorum
Failover Clustered Instances
Availability Groups
Readable Secondaries
Clustering Tools and PowerShell
Dummies and higher are welcome
SessionID: 21543
Data Explorer - The future of selfservice ETL
Event Date: 08-06-2013 - Session time: 00:00:00 - Track: Track 2
Speaker: Oliver Engels
Title: Data Explorer - The future of selfservice ETL
Abstract:
SessionID: 23966
SQL Server 2012 Integration with MDS DQS
Event Date: 08-06-2013 - Session time: 00:00:00 - Track: Track 2
Speaker: Sanjaya Padhi
Title: SQL Server 2012 Integration with MDS DQS
Abstract:
Data Quality Services is a solution for helping maintain the quality of data and ensure the data is suited for business usage.
MDS is the solution for master data management in the enterprises by providing a central data hub to ensure the consistency of data across different applications and environments. In this session we will have a quick look at the basics of DQS and MDS in SQL Server 2012 and discuss the integration of DQS and MDS with the enterprise environments along with some interesting demos.
SessionID: 9287
Hadoop for the Business Intelligence Professional
Event Date: 08-06-2013 - Session time: 00:00:00 - Track: Track 2
Speaker: Allan Mitchell
Title: Hadoop for the Business Intelligence Professional
Abstract: