Abstracts

Analysis Services Development with Biml Studio

12 Comments
Target Audience: This session is designed to show developers how to build Analysis Services projects with Biml. Abstract: Have you ever needed to modify Analysis Services databases based on an ever-changing data environment? Have you ever wanted to start an Analysis Services project with a preset group of objects? Have you ever needed to create…
Read More

Dapper: the microORM that will change your life

7 Comments
Target Audience: Developers, DBA Abstract: ORM or Stored Procedures? Code First or Database First? Ad-Hoc Queries? Impedance Mismatch? If you’re a developer or you are a DBA working with developers you have heard all this terms at least once in your life…and usually in the middle of a strong discussion, debating about one or the…
Read More

NoSQL Server: JSON superpowers!

1 Comment
Target Audience: Developers, DBAs Abstract: Everyone asked for JSON in the last years….and now finally we have JSON support within SQL Server! The much-asked, long-waited feature is finally here! In this session we’ll see how the JSON support works within SQL Server, what are the pros and cons, the capabilities and the limitations, and will…
Read More

Apache Zeppelin and SQL Server: two best friends

1 Comment
Target Audience: DBA, DEV, BI Abstract: Apache Zeppelin can help not only the Data Scientist but also DBAs and DEVs to creating nice-looking, interactive, shareable dashboards, just using T-SQL…or more if you want to adventure into Markdown, Python and other exotic things. By definition of its own creators it’s a “A web-based notebook that enables…
Read More

Optimizing your SQL Server for Azure VMs

Target Audience: DBAs, consultants & architects planning to run their SQL Server on Azure VMs Abstract: SQL Server running on-premises is no different than SQL Server running on Azure VM. While this is true, there are certain configurations and optimizations specific to Azure platform which every DBA, database consultant and architect need to be aware…
Read More

Get Spatial With It

Target Audience: Intended for developers with little or no exposure to Geographic Information Systems (GIS). Abstract: We encounter spatial data just about daily in many ways. Think Google searches for nearby Thai food, or that Facebook notification about friends at the restaurant next door. But outside the world of GIS professionals, spatial data doesn’t get…
Read More

Architecture and Customer Case Studies with In-Memory OLTP

6 Comments
Target Audience: Developers, Architects, and DBAs. Some familiarity with T-SQL is beneficial. Abstract: In-Memory OLTP can bring incredible performance benefits with both SQL Server and Azure SQL Database, but it can be a little daunting to understand whether it can benefit a given application. In this session we discuss where and how In-Memory OLTP is…
Read More

TFS Database backups/restore

2 Comments
Target Audience: Mainly TFS Admins or any DBA with overlapping TFS Admin roles looking for a cheaper way to backup and restore TFS Abstract: TFS (Team Foundation Server) utilizes multiple databases to store data for source control, work item tracking, server configuration and reporting. In order for TFS to perform correctly, these databases must be kept in a…
Read More
Menu