SQLSaturday #301 - Cape Town 2014
Event Date: 09/06/2014 00:00:00
Event Location:
- Protea Hotel
- Techno Park
- Stellenbosch, Western Cape, South Africa
This event has completed. All data shown below is from the historical XML public data available.
If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).
Sessions
This is a list of sessions from the event, based on the schedule in the XML files.
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.
Speaker(s):
- Steve Simon
Track and Room: BI - N/A
Title: SQL 2014 Enhancements Overview
Abstract: SQL Server 2014’s mission is to deliver for mission critical performance for the most demanding database applications, hitting on all aspects of mission critical criteria from performance to security, scalability and high availability along with the mission critical support. For business intelligence our mission is to deliver faster insights into any data big data, small data, all data and most importantly deliver BI in a consumable manner for business users through familiar tools. Finally, SQL Server 2014 will enable new unique hybrid cloud solutions that can positively impact your bottom line and allow you to create new innovative hybrid cloud solutions for your database applications.
Speaker(s):
- Serdar Altug
Track and Room: Azure - N/A
Title: Inside the SQL Server Query Optimizer
Abstract: Things you don’t want to know about SQL Server
Speaker(s):
- Klaus Aschenbrenner
Track and Room: DBA - N/A
Title: Database design for mere developers
Abstract: SQL Server 2012: Efficient and effective database design is so important that leaving it solely to the DBAs is simply not a solution. We as developers will more than likely have to create applications to access the data stores and as such must ensure that all application related considerations are taken into account within the database design.In this session, (aimed at software developers) we shall be touching upon several concepts of special importance to the developer. These include database development “patterns and anti-patterns”, final proofing of design and creating versatile deployment scripts that can and will be utilized in future endeavors.
Speaker(s):
- Steve Simon
Track and Room: Dev - N/A
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.
Speaker(s):
- Lyndon Johnson
Track and Room: BI - N/A
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!
Speaker(s):
- Niels Berglund
Track and Room: Dev - N/A
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.
Speaker(s):
- Gordon Beeming
Track and Room: BI - N/A
Title: Indexing for performance
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.
Speaker(s):
- Stanley Roos
Track and Room: Dev - N/A
Title: UNIQUEIDENTIFIERs as Primary Keys in SQL Server
Abstract: UNIQUEIDENTIFIERs as Primary Keys in SQL Server - a good or bad best practice? They have a lot of pros for DEVs, but DBAs just cry when they see them enforced by default as unique Clustered Indexes. In this session we will cover the basics about UNIQUEIDENTIFIERs, why they bad and sometimes even good, and how you can find out if they affect the performance of your performance critical database. If they are affecting your database negatively, you will also learn some best practices how you can resolve those performance limitations without changing your underlying application.
Speaker(s):
- Klaus Aschenbrenner
Track and Room: Dev - N/A
Title: an Introduction to AzureML
Abstract: introducing Microsoft’s technology entry into the machine learning capability
Speaker(s):
- Gary Hope
Track and Room: Azure - N/A
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.
Speaker(s):
- Gail Shaw
Track and Room: DBA - N/A
Title: Who’s in Control? Use Sql Server Resource Governor
Abstract: As a DBA do you control what is utilising the resources within Sql or do the the Applications? Learn how to setup and configure Sql Server Resource Governor, and how it can be used to determine what application or users are hogging the resources and how to limit those that are impacting on the overall system performance.
Speaker(s):
- Martin Phelps
Track and Room: DBA - N/A
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.
Speaker(s):
- Matt Horn
Track and Room: BI - N/A
Title: Exploring CloudOS
Abstract: In this session we will explore the way forward using the MS CloudOS platform and how it helps to simplifly our business.
Speaker(s):
- Jody Roberts
Track and Room: Azure - N/A
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.
Speaker(s):
- Mine Tokus
Track and Room: Azure - N/A
Title: Securing your SQL Database Applications
Abstract:
- Understanding and mitigating Injection risks
- Mitigating storage and resource denial-of-service risks
- Mitigating data disclosure risks
Speaker(s):
- Peter Willmot
Track and Room: Dev - N/A
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.“
Speaker(s):
- Stefan Cronje
Track and Room: Dev - N/A
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.
Speaker(s):
- Gail Shaw
Track and Room: DBA - N/A
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Gary Hope
Gary is a legend
Gordon Beeming
Twitter: - GordonBeeming
LinkedIn: Gordon Beeming
Contact: http://beeming.net/
Gordon Beeming is a Software Developer at Derivco in the sunny city of Durban, South Africa. He spends most his time hacking away at the keyboard in Visual Studio or with his family relaxing. He is a Visual Studio ALM Ranger, Visual Studio ALM MVP and Friend of Red Gate. His blog is at beeming.net and you can follow him on Twitter at twitter.com/gordonbeeming.
Klaus Aschenbrenner
Twitter: - @Aschenbrenner
Contact: http://www.SQLpassion.at/blog
Klaus Aschenbrenner provides independent SQL Server consulting services across the United States and Europe, focusing on the .NET Framework and SQL Server 2005 and 2008. In 2004 and 2005, he received the Microsoft MVP award for his support of the .NET community. Klaus has also written a book, “Pro SQL Server 2008 Service Broker,” published by Apress (2008).
Lyndon Johnson
Contact: http://products.e-magination.co.za/lyndonjohnson/
Lyndon has been working as a BI Professional for the past 10 years, specialising in IBM Cognos and SQL Server Reporting Services. Since 2010, he has been a cofounder of e-magination Info Solutions and consults in business intelligence and reporting solutions. He enjoys learning new reporting technologies, formulating innovating solutions to meet the client’s needs and mentoring and sharing his knowledge to nurture young talent.
Niels Berglund
Twitter: - nielsberglund
LinkedIn: Niels Berglund
Contact: https://nielsberglund.com
Niels works as Software Architect at Derivco, where he develops software as well as “dreaming” up new and innovative ways to use existing and new technology. Before joining Derivco, Niels worked as researcher/instructor at Developmentor where he was responsible for the database curriculum. He was a co-author of the first SQL Server 2005 book for developers: quot; A First Look at SQL 2005 for Developersquot;. He has presented at all leading technical conferences; Tech-ED, SQL PASS, DevWeek, Ignite the Tour, etc., and is also a Microsoft Data Platform MVP.
Martin Phelps
Twitter: - https://twitter.com/mphelps1968
LinkedIn: Martin Phelps
Martin Phelps is database architect at MiX Telematics. Specialising in Solution Architecture across their OLTP and DW databases. With 20 years of in-the-trenches experience with Sql Server he has provided solutions using Sql Server since version 4.2. Has previously done work for Insurance, ICT, Marketing and Mining companies.
Gail Shaw
Twitter: - @SQLInTheWild
Contact: http://sqlinthewild.co.za
Gail Shaw is a Database Specialist focusing on database performance tuning and database recovery, with a particular interest in topics such as indexing strategies, execution plans, and writing T-SQL code that performs well and scales gracefully. Gail holds a Microsoft Certified Master certification for SQL Server 2008 and is a Data Platform MVP. She’s a frequent poster on the SQLServerCentral forums, a Pluralsight author, writes articles for both SQLServerCentral.com and Simple-Talk.com, and has spoken at SQLSaturdays, SQL Bits and at the PASS Community Summit. Gail has been responsible for extending the lifespan of many an application, by performance-tuning their databases and providing technical guidance on all things SQL Server related.
Serdar Altug
-
Peter Willmot
Peter has been writing software (and teaching folk how to write software) for over 30 years. He has worked with SQL Server as an architect and developer for more than 20 years (since SQL 4.2) and has also worked extensively with the .Net and various other development platforms.
Peter is a past MSDN Regional Director and was also an MVP (SQL Server and Architecture) for many years. He is a passionate and regular speaker and various industry events around the world.
Steve Simon
Twitter: - SQLServerBoffin
LinkedIn: Steve Simon
Contact: http://www.sqlservercentral.com/blogs/simon_says/
Steve Simon is a Database Solutions Architect with Business Knowledge Services Inc. He has been involved with database design and analysis for over 35 years. Steve has presented papers at numerous PASS Summits and PASS SQL Rallies. He is also regular presenter on the SQLSaturday circuit and he is a contributor on SQLShack.com
Stanley Roos
Stanley Roos is a SQL Server MCM with 20 years experience in SQL server from version 4.2. He is an independent contractor based in South Africa.
Steve Simon
Twitter: - SQLServerBoffin
LinkedIn: Steve Simon
Contact: http://www.sqlservercentral.com/blogs/simon_says/
Steve Simon is a Database Solutions Architect with Business Knowledge Services Inc. He has been involved with database design and analysis for over 35 years. Steve has presented papers at numerous PASS Summits and PASS SQL Rallies. He is also regular presenter on the SQLSaturday circuit and he is a contributor on SQLShack.com
Mine Tokus
Graduated from Hacettpe University Computer Science (Ankara - Turkey) department at 2004 and had master degree from Middle East Technical University on Software Engineering. Mine has 10 years experience on software development and testing, first on aerospace industry (Boeing) and then on Microsoft. She joined Microsoft on 2010 as a Software Design Engineer in Test for SQL Server group in Redmond USA. She participated development of various features for SQL Server 2012 and SQL Server 2014.
Stefan Cronje
Lead Developer
Gail Shaw
Twitter: - @SQLInTheWild
Contact: http://sqlinthewild.co.za
Gail Shaw is a Database Specialist focusing on database performance tuning and database recovery, with a particular interest in topics such as indexing strategies, execution plans, and writing T-SQL code that performs well and scales gracefully. Gail holds a Microsoft Certified Master certification for SQL Server 2008 and is a Data Platform MVP. She’s a frequent poster on the SQLServerCentral forums, a Pluralsight author, writes articles for both SQLServerCentral.com and Simple-Talk.com, and has spoken at SQLSaturdays, SQL Bits and at the PASS Community Summit. Gail has been responsible for extending the lifespan of many an application, by performance-tuning their databases and providing technical guidance on all things SQL Server related.
Klaus Aschenbrenner
Twitter: - @Aschenbrenner
Contact: http://www.SQLpassion.at/blog
Klaus Aschenbrenner provides independent SQL Server consulting services across the United States and Europe, focusing on the .NET Framework and SQL Server 2005 and 2008. In 2004 and 2005, he received the Microsoft MVP award for his support of the .NET community. Klaus has also written a book, “Pro SQL Server 2008 Service Broker,” published by Apress (2008).
Jody Roberts
Twitter: - Jody_Wp
LinkedIn: Jody Roberts
Contact: http://JodyWP.wordpress.com
Jody Roberts is a Microsoft Data Platform MVP based in Cape Town, South Africa. He specializes in SQL Server architecture, disaster recovery (DR), and server optimization.
Jody serves as a PASS Regional Mentor responsible for the Middle East amp; Africa, Chapter Lead of the SQLCape user group, and Co-Lead of the PASS Cloud Virtual Chapter. Jody is a Principal Consultant at Northern Data.
Matt Horn
Matt Horn is a senior consultant with Aphelion software and a regular speaker at SQLSaturdays and other community events.
He has been the co lead of the BIDN BI user group in Johannesburg and an active member of SQLCape and the JHB SQL Usergroup.
Sponsors
The following is a list of sponsors that helped fund the event: