In Windows Server 2016, Microsoft have implemented a strong security concept called Shielded Virtual Machines. Shielded VMs have been improved in the Windows Server 2019 release. In the second part of this series, Nicolas describes what Shielded Virtual Machines are and how to configure them using PowerShell.
2018-06-18
2,979 reads
Describes the idle connection resiliency feature, which allows ODBC and SqlClient data access applications to maintain their connections to SQL Server 2014 or an Azure SQL Database.
2018-06-18
2,632 reads
Brent shows what Perfmon counter to watch after your SQL Server restarts.
2018-06-15
5,646 reads
Its possible to use some comparable expressions to a full regular expression library for matching certain patterns with T-SQL using the like operator. This tutorial uses these expressions for filtering price phrases involving alphabetic, numeric, and special characters
2018-06-14
4,713 reads
Data governance must be included in DevOps practices. William Brewer explains how to define business policies and standards to ensure compliance with privacy regulations and bring data governance to all aspects of continuous delivery.
2018-06-13
2,693 reads
Greg Larsen talks about how indexes that are not being used are costing you valuable resources and causing your update statements to run longer.
2018-06-12
3,648 reads
This paper describes best practices for security, networking, and component architecture for building a hybrid business intelligence (BI) environment by using a combination of Microsoft Office 365, Microsoft Azure, and on-premises data sources. Many organizations are taking advantage of the benefits of cloud computing such as lower capital expenditures and increased agility, while still maintaining data in on-premises data stores.
2018-06-12
2,710 reads
In-Memory OLTP was introduced with SQL Server 2014 as a way to improve transaction performance. There are several scenarios that are not supported, such as some data types, and Darko Martinovic describes the issues and provides workarounds. He also has provided a tool to assist in migrating disk-based tables to In-Memory optimized tables.
2018-06-11
3,363 reads
Watch in awe and wonder as Brent Ozar creates a deadlock, then uses sp_BlitzLock after the fact to show you which queries and tables were involved.
2018-06-08
4,429 reads
In this tip Aaron Bertrand looks at how to generate scripts for triggers using simple T-SQL statements. This tip shows how to easily build scripts for disabling, enabling, dropping and creating.
2018-06-07
3,640 reads
By Ed Elliott
SQL Server Management Studio (SSMS) has recently added support for Github Copilot. This is...
By Steve Jones
If it fails where you thought it would fail that is not a failure....
Quite a long title for a short blog post ??While deploying a DACPAC (from...
Comments posted to this topic are about the item Don't Create Workslop
Comments posted to this topic are about the item What is the original database...
Comments posted to this topic are about the item The DBScan algorithm tutorial
What is returned when this code is run?
SELECT ORIGINAL_DB_NAME()See possible answers