Build Schedule

Advanced Filters:
  • Track

    clear all











  • Speaker


  • Level


  • Session Type

Sessions Found: 25
This session will cover an overview of the integration between SQL Server and Visual Studio with SQL Server R Services.
We'll demo these capacities and wrap up with guidelines/advice for your own advanced analytics journey.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques

Level: Intermedia

Session Code:

Date: September 03

Time: 1:30 PM - 2:30 PM

Room: Room 1

With the vast amount of changes that occur in our daily business environments, it becomes more and more difficult to achieve our corporate goals without some ‘lighthouse’ to guide our way. Data mining, (while not a panacea to resolve or ‘control’ the effects of these changes), can provide us with statistical trends by analyzing our data and highlighting probable outcomes.

In this hands on BEGINNERS presentation we shall be looking at Microsoft SQL Server’s Data Mining capabilities and we shall be discussing:

1)  Defining what questions we want answered and how to go about this in an effective and efficient manner.

2)  Creating the data model.

3)  How to gather the necessary data, discussing the training and testing aspect.

4)  Processing the model.

5)  Extracting information from our finished model, discussing the implications of this information.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Intermedia

Session Code:

Date: September 03

Time: 9:00 AM - 10:00 AM

Room: Room 3

In this panel led discussion we will look at what it takes to become  successful Business Intelligence Developer

The session will begin with a 30 minute overview of what is required of a business developer, what training options are available for you to and what career opportunities exist as you career progresses.
The final 20 minutes will be a Q&A session for you to ask the Panel any career related questions you may have.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: September 03

Time: 11:30 AM - 12:30 PM

Room: Room 5

In this panel led session we will look at what it takes to become a successful Database Administrator.

We will spend 20 minutes looking at what the typical day for a DBA looks like as well as training that you may need to become a DBA.
This will be followed by a 20 minute QA session where you will be given the opportunity to ask questions from senior DBA's
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: September 03

Time: 1:30 PM - 2:30 PM

Room: Room 5

In this panel led discussion we will look at what is required to become a successful SQL Developer.

This session will begin with a 30 minute overview of is required of a SQL Developer, what training options are available as well as what career prospects are as you career progresses.
This will be followed by a 20 min Q&A session where you will be able to ask the panel questions.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: September 03

Time: 10:15 AM - 11:15 AM

Room: Room 5

Modern self-service personal productivity analytic tools allow individual users to create sophisticated calculations and sets. However, for an organization to maximize the value of analytics this business logic must be released from myriad of spreadsheets and documents that it is embedded. Join us to discuss how analytic platforms allow data-driven organizations to centralize, share and contextualize this content.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Intermedia

Session Code:

Date: September 03

Time: 2:45 PM - 3:45 PM

Room: Room 2

Have you ever been in the situation that an application performed well the last day and - suddenly - you run into problems? Although you have Index Maintenance jobs and statistics up to date you will monitor a big degrade of performance! This session will demonstrate in a over 80 percent demo based presentation the following scenarios which happend this way in real life!
- Why performance degradation in spite of maintenance jobs?
- just one more database in the result set and the query runs really bad - why?
- usage of literals is completely different from the usage of variables - why?
- identical data types but the query runs in part perfect and in part bad...
- your execution plan shows an INDEX SEEK - but the table will be scanned!
- you get a query from the business which performs really bad but when you test it it runs pretty cool - why?
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: September 03

Time: 10:15 AM - 11:15 AM

Room: Room 1

ne of the main challenges organizations face in the BI world is to allow, via a single platform, contradicting needs of self-service BI with governance and Enterprise scale.
Come and see the game changing approach of Pyramid Analytics that allows organizations to obtain these impossible needs of business users and IT in a singular BI platform.
Pyramid Analytics the platform that Microsoft selected as a strategic partner for PowerBI.
 
Pyramid Analytics revolutionary platform provides a single platform that delivers:
•             Self Service – No code necessary.
•             Web based central administration and security.
•             Role based functionality for different roles in the organization (Professional, Analyst and Consumer).
•             Universal configuration – build once use anywhere (PC, Tablet and Mobile).
•             Enterprise scale – parallel processing, clustering and load balancing.
•             And more ….
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Intermedia

Session Code:

Date: September 03

Time: 9:00 AM - 10:00 AM

Room: Room 2

Table partitioning can be daunting and may not work as expected. You may have tried to implement partitioning only to find you created greater performance issues. In this session you will be taken through the theory of table partitioning with practical examples you can use. We will learn what partitioning is, what it is not, how to implement it, how to maintain it, how to use it for maintenance and how you can improve query performance under certain conditions. After this session you will have the confidence to apply partitioning in your environment.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: September 03

Time: 1:30 PM - 2:30 PM

Room: Room 4

Are you underpaid? Would you like to know what a market related salary is for your skill set? What are the most in demand IT Developer profiles in the market today? Is your CV going to stand out from the guy sitting next to you? Come along to my presentation and we will have a look at what a market related salary for you is; are you keeping your skills relevant for today’s needs and are you representing yourself well enough to stand out.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: September 03

Time: 9:00 AM - 10:00 AM

Room: Room 5

If you are a developer+DBA, consultant+DBA, IT Manager+DBA, Intern+DBA, technical support+DBA or just a DBA, this session will be useful to you. After working for many years as developer and consultant, the SQL Server MVP Fabiano Amorim has being working with many day-by-day DBA tasks. In this session he will speak a little about the DBA job and show some very good tips about how to do it with efficiency.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: September 03

Time: 11:30 AM - 12:30 PM

Room: Room 1

Far too few database developers in this day and age get the opportunity to learn how to design relation databases.  In most cases, they will on occasion be asked to add a few objects to an existing system while following the standards of the organisation. These relatively infrequent changes do not hone the skills needed for effective design.

This session will go through the fundamentals of database design.  Topics such as normalization, Understanding Data Relationships as well as the Language of  Data Modeling and Design will be discussed. The Database Design Sequence Phases of Conceptual, Logical and Physical will be introduced as well.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: September 03

Time: 9:00 AM - 10:00 AM

Room: Room 1

If there’s one thing that we, as SQL developers, do, it's not 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:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: September 03

Time: 2:45 PM - 3:45 PM

Room: Room 1

These days when you say "database server" it could really mean many things.

For something like SQL server there are so many options: on-premise server, off-premise server. On-premise server with off-premise data. Then there are the various  Azure offerings with fancy names like Azure SQL, Data Lake, Hadoop.

You also get graph databases and document databases.

This session will cover some of the more popular types of data stores that are available today and we will look at their use cases. While SQL server is great for many things, one has to be aware of the other options that are available out there.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: September 03

Time: 10:15 AM - 11:15 AM

Room: Room 2

JSON is finally supported SQL Server! In this session we take a look at different built-in SQL Server 2016 T-SQL functions that can be used to process JSON data into data warehouse solutions. We also look at different ways to convert a relational data mart into a JSON format.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: September 03

Time: 2:45 PM - 3:45 PM

Room: Room 3

With this presentation you will be provided with insight into not only the history of Tabular but also the differences between Tabular and Multidimensional. We will  cover the painless process of building, deploying and processing a Tabular model and finally take a brief look at some of the BI Tools on the market that are using it.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: September 03

Time: 1:30 PM - 2:30 PM

Room: Room 3

At the heart of Power BI is the Power Query Formula Language (informally known as M), a dynamically typed, case-sensitive functional language for creating mashup queries, similar to the F# language.

Although Power BI Desktop has a number of great UI features for transformations, under the hood it's all M, and the better you understand the language, the more you can take advantage of the capabilities inherent in Power BI.

In this session I will introduce you to the basics of the M language and demonstrate some of the more advanced features.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Beginner

Session Code:

Date: September 03

Time: 10:15 AM - 11:15 AM

Room: Room 2

In this session we will  explore  how SQL Server 2016 StretchDB changes the way we look at  our archiving strategies.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: September 03

Time: 10:15 AM - 11:15 AM

Room: Room 4

The world is, by and large, a much more equitable place to be than ever in human history. But that doesn't mean we've solved all our problems. The question of how to attract women to the tech sector' is one of the unsolved ones. In this interactive discussion, we'll try and work out what the problems are, and maybe find a few solutions.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: September 03

Time: 2:45 PM - 3:45 PM

Room: Room 5

SQL 2016 introduces the Query Store, a mechanism that has been built into the SQL 2016 database engine in order to facilitate rapid identification and resolution of performance and scalability bottlenecks in SQL application scenarios. In the session we will examine Query Store architecture and features and gain an understanding of how the tools should be used.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Other

Level: Intermedia

Session Code:

Date: September 03

Time: 9:00 AM - 10:00 AM

Room: Room 1

Sessions Found: 25
Back to Top
cage-aids
cage-aids
cage-aids
cage-aids