In this webcast we will look at the importance of indexing for SQL Server data and how to ensure the indexes you have created are getting you the best performance out of SQL Server.
In this article we cover the new Microsoft Learn website and some of the features to help you learn about different platforms like Azure, SQL Server and more.
This tip covers container naming conventions, the internals of container images, configuring persistent storage for SQL Server containers and running multiple SQL Server containers on a single host machine.
In this tip we look at a PowerShell script that can help identify mismatches for logins for SQL Server Database Mirroring principal and mirror instances.
In the first part of this tip series we looked at how to map and view JSON files with the Glue Data Catalog. In this second part, we will look at how to read, enrich and transform the data using an AWS Glue job.
I noticed the Lookup function in SQL Server Reporting Services. In this tip we look at all three SSRS lookup functions: Lookup, LookupSet and MultiLookup.
In this tip we look at different ways to build SSIS expressions to handle things like email addresses, random values, vile names, rounding, OR and XOR logic and more.
In this tip we look at an overview of SQL Server xp_cmdshell to help a SQL Server professional to know when, why, and how to invoke the xp_cmdshell extended stored procedure in SQL Server solutions.
Learn about the new SQL Server 2019 feature Accelerated Database Recovery and the difference in time this new feature makes when recovering a SQL Server database.
In this second part of this tip series we will look into further automation of this solution by calling the runbook from an Azure Data Factory pipeline through webhooks.
