Select Page
Screenshot of Windows Event Viewer

Windows Admin Center unleashes Server Core adoption

Since the general availability of Windows Server 2019, we have seen the fastest adoption rate of Windows Server Core in history. If you havent heard of Windows Server Core, then youre really missing out! Windows Server Core is the lightest ... continue reading
Talking Database II

Talking Database II

First published on TECHNET on Nov 24, 2015Authored by Santos MartinezHello All, this is ConfigNinja here to Talk about Databases. Welcome to the second blog post on Talking Database, since the first blog post was good and now that we ... continue reading

Executing SQL Server Assessments from PowerShell

Summary: Using the SQLServer module cmdlets to review and monitor SQL Server instance and database configuration Q: Hey, Doctor Scripto! I have loads of SQL Servers in my area of responsibility and I know they all need certain configuration settings ... continue reading
QS_SSMS_Reports_m.jpg.png

Using Query Store with least privileges instead of db_owner to archive Separation of Duties

When using the Query Store in a production environment, sometimes customers need to delegate very specifically who can do what in terms of Performance Analysis and/or Tuning. The Query Store is a component that can be activated per database and ... continue reading
createnewSQLDB.png

Getting started with Azure SQL Database Hyperscale

Azure SQL Database Hyperscale (or Hyperscale for short :smileyhappy:) takes your database to the next level by removing size and query limitations typically found in cloud databases. Your database can scale up to 100 TB in size and handle more ... continue reading
The easiest way to create Azure VM that can access your Azure SQL Managed Instance

The easiest way to create Azure VM that can access your Azure SQL Managed Instance

First published on MSDN on Sep 21, 2018 Azure SQL Managed Instance is fully managed and secured SQL Server Database engine hosted in Azure cloud, placed in your private Azure VNet. In order to access your Managed Instance, you need ... continue reading

PowerShell cmdlets for managing SQL Vulnerability Assessments

First published on MSDN on Jul 05, 2018 We are pleased to announce the availability of PowerShell cmdlets for managing SQL Vulnerability Assessments for your SQL Servers. The cmdlets can be used to run assessments programmatically, export the results and ... continue reading
Azure Log Analytics (OMS) Agent now collects SQL Server audit logs

Azure Log Analytics (OMS) Agent now collects SQL Server audit logs

First published on MSDN on Dec 28, 2017 We are happy to inform that the Azure Log Analytics (OMS) Agent is now capable of pushing SQL Server audit logs into Azure Log Analytics (OMS), supporting SQL Server both on-premises, as ... continue reading
Configure Azure Storage for SQL Database backups

Configure Azure Storage for SQL Database backups

First published on MSDN on Oct 17, 2017 SQL Server 2012+ and Azure SQL Managed Instance support native BACKUP commands that can backup a database to Azure Blob Storage URL. Setting-up Azure Storage account might not be so easy as ... continue reading
createnewSQLDB.png

Getting started with Azure SQL Database Hyperscale

Azure SQL Database Hyperscale (or Hyperscale for short) takes your database to the next level by removing size and query limitations typically found in cloud databases. Your database can scale up to 100 TB in size and handle more queries ... continue reading