Jonathan Allen - LogParser-quicker than SSIS, easier than BCP
This session will introduce people to a free tool from Microsoft that will speed up adhoc data import processes and file parsing among other data manipulation uses. LogParser uses a SQL-like query language to work with data in many formats (CSV, IISW3C, HTML, XML, ADS, REG, EVT, BIN and many more) and can convert the data into may outputs types (CSV, NAT, SQL, W3C, XML etc). It has many uses and can be employed in many ways to assist a busy DBA.
William Durkin - Database Replication - What, How, Why?
Database replication doesn't get much attention, especially now that the AlwaysOn features have been released into the wild. However, replication offers another way to make data available on multiple servers/locations that steps outside of "normal" HA/DR scenarios. This session will explain what database replication is, what the different parts are that make up the replication architecture and when/why you would use replication. The content will be valid for all versions of SQL Server from 2005 onward.
Tobiasz Koprowski - Windows Azure Databases for Beginners
Andre Kamman - Running SQL Server 2014 On A Scale Out File Server
A few years ago when someone would suggest to run SQL Server on a file share I would protest and start a rant about latency versus throughput etc.
But today I think that some of the coolest new features of SQL Server 2014 are actually Windows Server 2012 R2 features. In this session I will show you how to use Storage Spaces and Auto Tiering and some other features to build a highly available, fast, scale out file server. And then we'll use it to host SQL Server data & log files on it. Which is fully supported when using SQL Server 2014.
Mladen Prajdic - SQL Server and Application Security for Developers
A lot of companies have a philosophy of ship early with as much features as possible.
Thoughts about security are an afterthought since it isn't fun to do and no one will attack them anyway.
But the dark side never sleeps and security breaches have always happened.
Many have left companies severely exposed or even bankrupt.
In this session we'll look at a few attack vectors that can be used against your company,
and what you as a developer can and should do to protect against them.
It will involve good mix of security conscious SQL Server and application development.
Because you care about your work and nobody messes with you.