sqlsathistory

Nr: 335

Back to Main list

SQLSaturday #335 - Athens 2014

Start Time (24h)	Speaker	Track	Title
00:00:00	Mihail Mateev	Track 1	Node.js and Open Source Software Development on Microsoft Azure
00:00:00	Satya Jayanty	Track 1	SQL Server Data platform upgrade Techniques, best practices notes from the field
00:00:00	Stelios Tzavaras	Track 1	AlwaysOn Availability Groups: Offloading reporting workloads to secondary replicas
00:00:00	Kevin Boles	Track 1	Common TSQL Mistakes
00:00:00	Kevin Boles	Track 1	File IO Stalls and Wait Stats: Tune Like a Guru!
00:00:00	Antonios Chatzipavlis	Track 1	Configuring SQL Server

SessionID: 20355

Node.js and Open Source Software Development on Microsoft Azure

Back to calendar

Event Date: 04-10-2014 - Session time: 00:00:00 - Track: Track 1

Speaker: Mihail Mateev

Title: Node.js and Open Source Software Development on Microsoft Azure

Abstract:

Node.js is an exciting platform that has been increasing in popularity for the past few years. It offers a server side JavaScript programming model ideal for building highly scalable and performant network applications whether on premise or in the cloud. In this talk we will take a look at various options for building and deploying Node applications on Microsoft Azure. This session is how to useAzure SQL Databse and Azure Storage with Node.js

SessionID: 25055

SQL Server Data platform upgrade Techniques, best practices notes from the field

Back to calendar

Event Date: 04-10-2014 - Session time: 00:00:00 - Track: Track 1

Speaker: Satya Jayanty

Title: SQL Server Data platform upgrade Techniques, best practices notes from the field

Abstract:

Why Upgrade?This is the big question that every SQL Server user will be asking, from my experience I say not just for shiny new features but increase your productivity and do-more with-less practices.Data Platform Upgrade topic has been a popular session that I've presented in major conferences like Microsoft Tech-Ed (North America, Europe India) and SQLbits since 2008.In this session, we will overview end-to-end upgrade process that covers the essential phases, steps and issues involved in upgrading SQL Server 2000, 2005, 2008 R2 SQL Server 2012 (with a good overview on 2014 too) by using best practices and available resources. We will cover the complete upgrade cycle, including the preparation tasks, upgrade tasks, and post-upgrade tasks. Real-world examples from my Consulting experience expanding on why how such a solution is offered.

SessionID: 25251

AlwaysOn Availability Groups: Offloading reporting workloads to secondary replicas

Back to calendar

Event Date: 04-10-2014 - Session time: 00:00:00 - Track: Track 1

Speaker: Stelios Tzavaras

Title: AlwaysOn Availability Groups: Offloading reporting workloads to secondary replicas

Abstract:

SQL Server AlwaysOn Availability Groups is a HADR feature introduced in SQL 2012. In this presentation we’ll talk about setting up readable secondary replicas, the impact of running reporting workloads on a secondary replica, and finally about monitoring data latency.

SessionID: 26471

Common TSQL Mistakes

Back to calendar

Event Date: 04-10-2014 - Session time: 00:00:00 - Track: Track 1

Speaker: Kevin Boles

Title: Common TSQL Mistakes

Abstract:

We are going to examine a variety of oopsies MANY developers fall prey too - some obvious, some pretty subtle and some down right sneaky! Lots of code examples with the bad AND good code presented. I GUARANTEE that you will find things here that will either prevent you from getting bad data, throwing unwanted errors or vastly improving your database application's performance. I have given this talk over FIFTY times now and it is always very highly rated!

SessionID: 26472

File IO Stalls and Wait Stats: Tune Like a Guru!

Back to calendar

Event Date: 04-10-2014 - Session time: 00:00:00 - Track: Track 1

Speaker: Kevin Boles

Title: File IO Stalls and Wait Stats: Tune Like a Guru!

Abstract:

When you know how to find out WHAT your queries are waiting on you get a very good how to fix then - or help the server as a whole in myany cases. Lots of stuff here you will want to put in your bag of tuning tricks

SessionID: 9689

Configuring SQL Server

Back to calendar

Event Date: 04-10-2014 - Session time: 00:00:00 - Track: Track 1

Speaker: Antonios Chatzipavlis

Title: Configuring SQL Server

Abstract:

SQL Server has a plethora of configuration settings that are spread at server, database and connection level. The purpose of this session is to notify and clarify the most important configuration settings

This site is open source. Improve this page.