Remove Azure Remove Database Remove Servers Remove Tuning
article thumbnail

Bandwidth-friendly Query Profiling for Azure SQL Database

SQL Performance

SQL Server has always provided the ability to capture actual queries in an easily-consumable rowset format – first with legacy SQL Server Profiler, later via Extended Events, and now with a combination of those two concepts in Azure SQL Database. Enter the New SQL Server Profiler.

Azure 96
article thumbnail

SQL Server dbcc clonedatabase – Gotcha

SQL Server According to Bob

SQL Server dbcc clonedatabase ​​ - ​​ Gotcha The dbcc clonedatabase is a ​​ handy command to clone metadata and ​​ information such as ​​ query disk store. The new database generated from DBCC CLONEDATABASE is primarily intended for troubleshooting and diagnostic purposes.

Servers 45
Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Trending Sources

article thumbnail

Is MongoDB Open Source? Is Planet Earth Flat?

Percona

Whereas many open source software offerings — like the community version of MySQL — use the GNU General Public License ( GPL ), MongoDB has been under the GNU Affero General Public License ( AGPL ) and more recently under the Server Side Public License ( SSPL ), introduced by MongoDB itself.

article thumbnail

Microsoft Engineering loves SQLBits

SQL Server According to Bob

Microsoft engineering is actually sending quite a few folks over the Atlantic to come talk about SQL Server 2017, SQL Server on Linux, GDPR, Performance, Security, Azure Data Lake, Azure SQL Database, Azure SQL Data Warehouse, and Azure CosmosDB. SELECT * FROM Azure Cosmos DB – Andrew Liu.

article thumbnail

How to Setup a WordPress MySQL Database in the Cloud

Scalegrid

MySQL is a free open source relational database management system that is leveraged across a majority of WordPress sites, and allows you to query your data such as posts, pages, images, user profiles, and more. Managing a database is hard, as it needs continuous updating, tuning, and monitoring to ensure the performance of your website.

Database 166
article thumbnail

Updated Azure SQL Database Tier Options

SQL Performance

Azure SQL Database is Microsoft's database-as-a-service offering that provides a tremendous amount of flexibility. Microsoft is continually working on improving their products and Azure SQL Database is no different. HyperScale Database. Hyperscale databases are provisioned using vCores.

Azure 55
article thumbnail

PREVIEW : SentryOne Plan Explorer Extension for Azure Data Studio

SQL Performance

Last year, I got together with one of my dev teams at SentryOne – they call themselves the SQL Injectors – to talk about the possibility of replicating Plan Explorer functionality inside of Azure Data Studio. First, ensure you meet our requirements: Azure Data Studio 1.9.0 or newer ( July announcement post ).NET or better).

Azure 90