In this webinar, you will learn about the configuration of clusters in the cloud, some real-world examples of problems, and alternatives for maintaining a shared storage infrastructure within Azure.
In this tip we look at different things you should consider when developing your database systems to ensure you are also thinking about security best practices as well.
SQL Server 2008 and earlier used the CONVERT functions to handle date formatting. In this tip, we look at how to use the FORMAT function for Date and Time formatting in SQL Server.
Learn how to build a process to retry tasks that fail within a SSIS package. Instead of just failing the SSIS package, setup a delay and retry the process again.
In this tip we will walk through how to create a PowerShell module to get a list of files and subfolders of a Windows folder and store this information in a SQL Server table.
Learn how to use new SQL Server features including STRING_SPLIT and CONCAT_WS to write more compact and simpler code as compared to earlier SQL Server versions.
In this tip I will show you how to enable the row mode memory grant feedback and how to capture it to verify if there is any improvement for your existing queries using SQL Server 2019.
Learn about new functions in SQL Server 2016 and 2017 to have more readable and compact code including STRING_AGG, TRIM, TRANSLATE and DROP... IF EXISTS.
In this tip we cover the steps you need to follow to upgrade or migrate an existing SQL Server failover cluster and still use the same virtual network name and virtual IP address.
