2019-10-09 Europe Sessions

SQL Server Developer Tricks

1 Comment
Target Audience: The session content targets SQL Developers but is equally meaningful for DBAs. Either way, two years of genuine experience is expected to get most out of the demos. Abstract: If you are programming with SQL Server, you ought to know how your query is being treated inside the engine. Join this session to…
Read More

Query Store without SQL 2016 = Open Query Store

No Comments
Target Audience: DBAs and Devs that are stuck on SQL Server versions below SQL 2016 Abstract: When SQL Server 2016 was released, it offered a fantastic new feature with the Query Store. Long term, statistics based, query tuning became a reality. But what about the thousands of servers that aren’t upgrading to SQL 2016 or…
Read More

Working with Very Large Tables Like a Pro in SQL Server 2017

1 Comment
Target Audience: This session is intended for database administrators and database developers, who have a basic understanding of indexes, statistics and partitioning. Abstract: A common use case in many databases is a very large table, which serves as a fact table or an activity log, with an ever-increasing date/time column. This table is usually partitioned,…
Read More

Eight hours of work in 20 minutes – partitioning rocks

Target Audience: Database developers and database administrators with little or no experience with table partitioning. Abstract: If you ever experienced an ETL process getting slower and slower, this might be it. Partitioning and partition switching. Once an enterprise feature. Now in every edition of SQL Server. I’m going to be very hands-on. I’ll reveal some…
Read More
CI and CD with SSDT and Living to Tell About It - with Eitan Blumin

CI and CD with SSDT and Living to Tell about It

Target Audience: Application DBA, SQL, DevOps Abstract: Until a few years ago, it was common to have the database development lifecycle completely separate from the main application development lifecycle. While the app dev team enjoyed modern lifecycle techniques, the DBAs find themselves inventing their own solutions for things that already come pre-packaged and ready-to-use for…
Read More

Dynamic Search Queries and How to Protect Them

Target Audience: Application DBA, SQL, T-SQL Programming, Stored Procedures Abstract: What is the solution for implementing truly dynamic search queries? Not just a stored procedure with optional parameters, but something even more dynamic than that? Let the end-user choose the exact fields and, more importantly, the operator types to use on them, in order to…
Read More

Tips and Tricks of a Power BI (Premium) Implementation at a Financial Institute

Target Audience: Do you consider implementing Power BI or already buying Premium capacity? Do you struggle with the number of Power BI licenses to give out? Do you struggle between tight IT-control or user-friendliness of creating workspaces? A basic knowledge of Power BI is assumed, there’s no deep technical knowledge necessary. Abstract: Back to September…
Read More
Menu