Nr: 301
SQLSaturday #301 - Cape Town 2014
SessionID: 14366
Lies, Damned Lies And Statistics
Event Date: 06-09-2014 - Session time: 00:00:00 - Track: DBA
Speaker: Gail Shaw
Title: Lies, Damned Lies And Statistics
Abstract:
Ever wondered what the things called statistics are, why they're important and what needs to be done to maintain them? If so, this session is for you! In this session well take a look at what statistics are and why SQL keeps them; at how SQL maintains them and under what circumstances that maintenance is insufficient; and well look at the problems that result when they are inaccurate. Finally well cover some suggestions and options around maintenance of statistics when the automatic maintenance is not sufficient.
SessionID: 14367
On Transactions and Atomic Operations
Event Date: 06-09-2014 - Session time: 00:00:00 - Track: DBA
Speaker: Gail Shaw
Title: On Transactions and Atomic Operations
Abstract:
If there’s one thing that we, as SQL developers, don’t do, it’s use enough transactions.
Transactions are critical when multiple changes need to be made entirely or not at all, but even given that it’s rare to see transactions used at all in most production code.
In this session, we’ll look at what transactions are and why we should use them. We’ll explore the effects transactions have on locking and the transaction log. We’ll investigate methods of handling errors and undoing data modifications, and we’ll see why nested transactions are a lie.
SessionID: 14391
an Introduction to AzureML
Event Date: 06-09-2014 - Session time: 00:00:00 - Track: Azure
Speaker: Gary Hope
Title: an Introduction to AzureML
Abstract:
introducing Microsoft’s technology entry into the machine learning capability
SessionID: 14718
Power BI in Office 365
Event Date: 06-09-2014 - Session time: 00:00:00 - Track: BI
Speaker: Gordon Beeming
Title: Power BI in Office 365
Abstract:
In this session we will explore the power of Power QA in Office 365. We'll look at getting data into O365 enabling it for QA and then using Power QA on that data. We'll then switch to Sample Data available in Office 365 to demo some capabilities with a larger data set.
SessionID: 17100
Exploring CloudOS
Event Date: 06-09-2014 - Session time: 00:00:00 - Track: Azure
Speaker: Jody Roberts
Title: Exploring CloudOS
Abstract:
SessionID: 18495
UNIQUEIDENTIFIERs as Primary Keys in SQL Server
Event Date: 06-09-2014 - Session time: 00:00:00 - Track: Dev
Speaker: Klaus Aschenbrenner
Title: UNIQUEIDENTIFIERs as Primary Keys in SQL Server
Abstract:
SessionID: 18502
Inside the SQL Server Query Optimizer
Event Date: 06-09-2014 - Session time: 00:00:00 - Track: DBA
Speaker: Klaus Aschenbrenner
Title: Inside the SQL Server Query Optimizer
Abstract:
Things you don't want to know about SQL Server
SessionID: 19322
Custom Prompt Pages for Microsoft Reporting Services
Event Date: 06-09-2014 - Session time: 00:00:00 - Track: BI
Speaker: Lyndon Johnson
Title: Custom Prompt Pages for Microsoft Reporting Services
Abstract:
When a client migrated from IBM Cognos to SQL Server Reporting Services as their reporting tool, we needed to provide the same functionality and user experience they were getting with the Cognos prompt pages. The standard Reporting Services prompt pages could not meet these requirements, so we developed and implemented a custom prompt page solution, using ASP, JavaScript and jQuery, from which to run the Reporting Services reports. This session will cover how we developed this solution and how it works.
SessionID: 19742
Who's in Control? Use Sql Server Resource Governor
Event Date: 06-09-2014 - Session time: 00:00:00 - Track: DBA
Speaker: Martin Phelps
Title: Who's in Control? Use Sql Server Resource Governor
Abstract:
SessionID: 20153
Introduction to Data Analysis Expressions (DAX)
Event Date: 06-09-2014 - Session time: 00:00:00 - Track: BI
Speaker: Matt Horn
Title: Introduction to Data Analysis Expressions (DAX)
Abstract:
In this session we will explore a number of basic data modelling and analytical problems and how to use DAX to solve them.
While this session will not make you a DAX Jedi It should provide you with a good understanding of the fundamentals of the language.
SessionID: 20791
Relational Data Management on Microsoft Azure
Event Date: 06-09-2014 - Session time: 00:00:00 - Track: Azure
Speaker: Mine Tokus
Title: Relational Data Management on Microsoft Azure
Abstract:
Start with data management features available on Microsoft Azure and learn about the various options for using SQL Server in Windows Azure. Explore the differences between Azure SQL Database (PaaS) and SQL Server in infrastructure as a service (IaaS), and see how to deploy and manage both approaches.
SessionID: 21439
SQLCLR Real World Usage
Event Date: 06-09-2014 - Session time: 00:00:00 - Track: Dev
Speaker: Niels Berglund
Title: SQLCLR Real World Usage
Abstract:
SQLCLR was introduced in SQL Server 2005 with much fanfare. Unfortunately the uptake of it was not as good as Microsoft would have wanted. This does not mean however that SQLCLR is not useful, it is very useful in the right circumstances. In this session we will see how to use SQLCLR and how it is being used in production to solve real-world hard problems. The session is high on code and low in slides!
SessionID: 22323
Securing your SQL Database Applications
Event Date: 06-09-2014 - Session time: 00:00:00 - Track: Dev
Speaker: Peter Willmot
Title: Securing your SQL Database Applications
Abstract:
- Understanding and mitigating Injection risks
- Mitigating storage and resource denial-of-service risks
- Mitigating data disclosure risks
SessionID: 23812
SQL 2014 Enhancements Overview
Event Date: 06-09-2014 - Session time: 00:00:00 - Track: Azure
Speaker: Serdar Altug
Title: SQL 2014 Enhancements Overview
Abstract:
SessionID: 25241
Event Date: 06-09-2014 - Session time: 00:00:00 - Track: Dev
Speaker: Stanley Roos
Abstract:
An effective indexing strategy is one of the most important responsibilities of a database professional. In this session we will briefly look at the internals of indexes and how the engine decides how to utilise them. We will explore the different options and choices available in the different versions from 2005, 2008,2012 and 2014.
SessionID: 25250
SQL Source … controlled in the studio
Event Date: 06-09-2014 - Session time: 00:00:00 - Track: Dev
Speaker: Stefan Cronje
Title: SQL Source … controlled in the studio
Abstract:
With the introduction of Database Projects in Visual Studio, SQL developers have finally had a way of controlling their source code. When used with TFS, you can take advantage of further enhancements such as automated builds, and workflows.
Tools being discussed, Visual Studio, TFS, Powershell, SQL Server, branching.“
SessionID: 25442
SQL Server Reporting Services 2014 on Steroids!!
Event Date: 06-09-2014 - Session time: 00:00:00 - Track: BI
Speaker: Steve Simon
Title: SQL Server Reporting Services 2014 on Steroids!!
Abstract:
Reporting requests that are required ‘yesterday or sooner’, oft times necessitate working more efficiently and effectively. We have all been through this at one time or another.
In this hands on presentation we shall be looking some of the more challenging techniques of extracting our data from our Multidimensional and Tabular Models, in addition to our Data Mining Models.
We shall be utilizing concepts of ‘Openquery()’ and ‘linked servers’ as a means to extract data, in addition to looking at the way that these two concepts can help us extract our data utilizing MDX, DMX and DAX expressions; AND YET maintain the flexibility and the ability to utilize all those wonderful techniques that may be done with T-SQL.
SessionID: 25463
Database design for mere developers
Event Date: 06-09-2014 - Session time: 00:00:00 - Track: Dev
Speaker: Steve Simon
Title: Database design for mere developers
Abstract: