Microsoft Cloud and Datacenter MVP David Bermingham will discuss best practices for moving standalone and clustered SQL Server 2008 instances into Azure to take advantage of the extended security updates for SQL Server and Windows.
In this tip I'm going to discuss the three types of functions in SQL Server and what the next version does to address scalar UDF performance specifically.
In this tip we look at how to generate a dynamic report for Reporting Services that automatically adjusts the layout based on the query passed to the report.
The Microsoft platform enables us to work with SQL Server databases and R together. With powerful statistical tools we can get started using statistical methods to extract meaningful information from voluminous amounts of data.
In this tip we will look some of those additional configuration steps when using the Azure-SSIS Integration Runtime (IR) which allows you to lift and shift your existing SSIS projects to the Azure cloud.
In this tip we look at how to monitor if an extended events session is running or not and how to automatically stop or start an extended events session using a SQL Server Agent job.
