Author: SQLAdmin

SQL Saturday Precon 08 Sep 2017 – Hot ideas and plain cold facts on making Integration Services work for YOU! with Steve Simon

Course details:
Data availability is only a half the story in being able to provide timely information to the decision maker. Moreover, this information is oft times critical to the corporate mission success.

This “hands on” pre-conference session will be concentrating on how to optimally utilize the features of SQL Server Integration Services to build an Integration Services solution which will process corporate data in a manner in which corporate information may be formulated from our data.

Topics will include:

  • Package storage: the pros and cons of database storage vs. file system storage.
  • Introduction to the package concept. Physically creating packages and a detailed discussion of many of the gotcha’s that you may and will encounter.
  • What is a package and why do we use them (20 minutes).
  • Why utilize SQL Server Integration Services (20 minutes):  An introduction to the product.
  • We shall be developing and implementing both.
  • Performance testing of packages.
  • Creating SQL Serve Agent Jobs, running scheduling these jobs and we shall be discussing in detail many of the gotcha’s including maintaining accurate agent execution plans.
  • Integration Services and Master Data Services daily load processing.
  • Integration Services and Data Quality Services daily load processing.
  • Extracting data from the cloud and loading of data into local warehouses.
  •  Utilizing Integration Services controls to extract, manipulate and transform, and load our raw data into our databases and warehouses in the most efficient and effective manner.
  • The effective utilization of Integration Services “transforms”.
  • Control flows and Data Flows. What are they and why do we need them? How do we utilize them?
  • All the techniques that we shall be working through have been utilized on two major North American projects. One point though, rest assure that you will leave this session with more questions than answers!

Presenter:
Steve Simon is a Data Platform MVP and a senior BI Development Engineer with Carousel Industries. He has been involved with database design and analysis for over 32 years. Steve has presented papers at numerous PASS Summits and PASS SQL Rallies. He is also regular presenter on the SQL Saturday circuit and he is a regular contributor on SQLShack.com

Book Now!

SQL Saturday Precon 08 Sep 2017 – SQL Server for T-SQL and .Net Developers with Mladen Prajdic

Course details:
Aimed at T-SQL and .Net developers, and DBA’s that want to see what developers have to deal with, in this pre-conference session we’ll go over what every developer dealing with SQL Server and .Net has to know to be as effective and productive as possible. This day-long session is the result of years working with .Net and SQL Server and hopefully it will give you more than a few ideas on how to apply them.

The modules we’ll cover are:
1) Normal forms, data structures and data types to make you understand why the database is designed the way it is and how to make it better and faster from the start.

2) Isolation levels and locking provide us with knowledge about concurrency and blocking issues and how to maintain good data integrity.

3) T-SQL tips and tricks will teach you to write better, faster and more optimized queries.

4) Diving into the .Net SqlClient to show some interesting database access features to make your programming easier.

5) Saving the best for last, we’ll look at a few attack vectors that can be used against your company, with not only focusing on technical, but on social engineering aspects as well, and what you as a developer can and should do to protect against them.

Presenter:
Mladen Prajdic is a SQL Server MVP from Slovenia and has been a C# and SQL Server developer for over 15 years. He blogs at http://weblogs.sqlteam.com/mladenp and develops a popular add-in for SSMS called SSMS Tools Pack (http://www.ssmstoolspack.com).

Book Now!

SQL Saturday Precon 08 Sep 2017 – Understanding Execution Plans with Hugo Kornelis

Course details:
For troubleshooting long-running queries, looking at the execution plan is often a good starting point. Once you know how the query is executed, you know why it’s slow and what you can do to speed it up.

But what if the execution plan is just beyond your understanding? What if it uses operators you have seen before, but do not really understand? What if you look at the execution plan, but just don’t see the problem?

In this full-day workshop, you will learn everything you need to be able to read and understand any execution plan. We’ll start with an overview of execution plans as a whole, and then dive in and look at all the components, and how they fit together. This will increase your understanding on why the optimizer picks a plan, and what you can do to make it pick a better plan.

Whether you have read your share of execution plans or whether you wouldn’t know where to find them, this workshop will teach you everything you need to know about execution plans.

Presenter:
Hugo Kornelis is an established SQL Server community expert who spends a lot of time at various conferences. He is also a blogger, technical editor of a variety of books, and Pluralsight author. He is a SQL Server MVP since 2006.

When not working for the community, he is busy at his day job: freelance database developer/consultant.
Hugo has almost 20 years of SQL Server experience in various roles. He has a strong database design background but also loves to write and tune complex queries.

Book Now!

SQL Saturday Precon 08 Sep 2017 – Azure Infrastructure with Denny Cherry

Course details:
In this daylong session, we’ll review all the various infrastructure components that make up the Microsoft Azure platform. When it comes to moving SQL Server systems into the Azure platform having a solid understanding of the Azure infrastructure will make migrations successful and making support solutions much easier.

Designing your Azure infrastructure properly from the beginning is extremely important. An improperly designed and configured infrastructure will provide performance problems, manageability problems, and can be difficult to resolve without downtime.

With the introduction of multiple Azure data centers now available in India many companies will be begin moving services from data centers into the Azure and a solid foundation is key to successful migrations.

•Understanding design decisions and impacts
•Designing for performance
•When can slow be well performing
•Moving deployments from Classic to Research Manager
•Understanding Azure Security

Presenter:
Denny Cherry is the owner and principal consultant for Denny Cherry & Associates Consulting and has over a decade of experience working with platforms such as Microsoft SQL Server, Hyper-V, vSphere and Enterprise Storage solutions. Denny’s areas of technical expertise include system architecture, performance tuning, security, replication and troubleshooting. Denny currently holds several of the Microsoft Certifications related to SQL Server for versions 2000 through 2014 including the Microsoft Certified Master as well as being a Microsoft MVP for several years. Denny has written several books and dozens of technical articles on SQL Server management and how SQL Server integrates with various other technologies.

Book Now!

SQL Saturday Precon 08 Sep 2017 – A-Z of BI with Glenn Morris

The A to Z of BI
This SQLSaturday Pre-Conference Day will discuss, demo and build out a number of scenarios that deal with data harvesting, data wrangling, data visualization and databases. Primarily through the lenses of the Microsoft Data Platform we will discuss SQL Server 2016/SQL Server 2017, The Azure Data Tools, Big Data, Azure Functions, Artificial Intelligence and Power BI with a view to how it applies to business and how you can get your business using some of the amazing capabilities that are available to assist you in making sense of and being proactive with data. Underpinned by the fact that, ultimately, most businesses want good, accurate reporting and insights we will approach this need from a number of angles using the different technologies available to us.

The world is changing at a pace never seen before and while we all want “Business Intelligence” our goal should be the “Intelligent Business” that uses the capabilities and tools available to us to make better use of our data and the data available to us through other channels.

Presenter:
With over 18 years of experience in the IT Industry, Glenn Morris is truly one of the most respected MVP’s, Microsoft Certified Trainers and Consultants in Australia.

A Mathematics graduate turned IT Wrangler, Glenn quickly immersed himself in the world of code while also looking ‘beyond the code’ at an area that he then termed “Intelligent Business”. Combining the code with the business processes he took a role Lecturing at the London School of Accounting and Management where he taught Programming, Performance Analytics and Business Intelligence. He subsequently moved into the Data Science which he saw as his ‘sweet spot’ and this has been what has underpinned his IT life since.

Glenn lives on the beautiful Gold Coast of Australia.

Book Now!

SQLCape May Meetup

Good Day Professional!

This month we had Nolan Schoonraad speaking on Extended Events – say goodbye SQL Profiler

We learnt why extended events are the preferred over SQL profiler.

Bio:
Nolan Schoonraad has over 18 years of IT experience. He is the Database Specialist as well as the manager of the data team for Capitec Bank. Originally, a core banking system programmer he converted to a DBA and has now been working as a DBA for 10 years. His main focus is optimisation and troubleshooting on high volume OLTP systems. Passionate about data, he works closely with the data warehousing teams and assists in optimising ETL processes. Nolan was involved in the POC and implementation of the first PDW in South Africa.

Presentation:
Extended Events - Say goodbye to SQL profiler NS

Azure Bootcamp Cape Town 2017

This year we had the first Global Azure Bootcamp in Cape Town held at the Bytes offices in Cape Town. There was a fantastic turnout and amazing speakers.

We were privileged to have the following speakers:

  • Gary Hope
  • Johan Myburgh
  • Peter Wilmot
  • Nicolas Blank
  • Allan Pead

We would like to say a special thanks to our Global Sponsors!

         

Below are some of the presentations from the event:

Gary Hope – Keynote & Welcome

Azure Bootcamp Keynote

 

Peter Wilmot – Azure Hosting for ASP.Net and SQL on Linux

Azure Hosting for ASP.Net and SQL on Linux

 

Gary Hope – Azure Function Fundamentals

Azure Bootcamp Functions Sesions

 

Allan Pead – Building Connected Cross Platform Apps with Xamarin and Azure

Cross Platform Connected apps with Azure

 
Below was the lineup at the event:

Timeslot Speaker Presenter
 08h30-09h00 Keynote & Welcome  Gary Hope
 09h10-10h00 Getting started with Blockchain in Azure Johan Myburgh
 10h10-11h00 A quick tour of the tools and features available from .Net Core and SQL vNext on Linux – hosted on an Azure Ubuntu VM. Peter Willmot will also point out some of the key limitations and challenges that you will encounter when migrating your existing ASP.Net apps to a hosted Linux platform Peter Wilmot
 11h10-12h00 Azure Function Fundamentals  Gary Hope
 12h00-12h30 Lunch
 12h30-13h30 Backup and DR as a service

Azure offers several backup and DR options for on-premises and cloud hosted services. Join Nicolas as he explores what options are available to build robust backup and restore options using Azure based services.

 Nicolas Blank
 13h30-14h30 Building Connected Cross Platform Apps with Xamarin and Azure

Introduction to Xamarin
What is Xamarin Forms?
Azure Mobile Services

 Allan Pead
 14h30-15h00  Prize Giving

 

GenesisOne™ T-SQL Source Code Unscrambler™

Have you ever worked with code that is impossible to read and decipher? You could use SQL Prompt which will format the code into a readable format, however what if there is so much going on you are still unable to decipher what is happening?

Recently I came across this problem where a function was doing so many things I couldn’t tell where it started and where it ended. There is an amazing tool that was super helpful, it is the T-SQL Source Code Unscrambler that is offered by GenesisOne.

This was a lifesaver for me, saving many hours of trying to figure out code. This tool allows you to connect to your SQL Server database and view any tables, views, stored procedures and functions.

This tool allowed me to select the function that was a mess and in the diagram view I could see what the function was trying to do. It shows if there are conditions, variables and the flow of the function.

This tool is also brilliant for doing technical documentation with diagrams of the systems and data flow in stored procedures and functions.

Below are a few screen shots of the different views and information this tool provides:

Diagram View:
homepage

Table View:
tableview

Summary View:
summaryview

Stored Procedure View:
stored-procedure

Dependency View:
dependencyview

Graphical View of Dependencies:
graphicdependency

How to Export:
newexport

For a full list of all the amazing features that comes with this application, click here.