It’s been an interesting ride, optimizing SQL Server, figuring out best use cases for the different flavors of SQL Server that we have come to rely on, and we’re seeing those choices pay off in terms of management, performance, and cost savings. The “flavors” I’m speaking of? AWS RDS SQL Server, Azure SQL DB specifically. Our event platform is based […]
Tag: sql server
(Aubrey Love) While installing SQL Server or creating databases and tables, we often run with the defaults. In most cases, that’s not a bad thing. However, when it comes to setting the COLLATION, we again often run with the default settings.
(blobeater) A quick post today about moving across database tiers. As you can see below I have a General Purpose Serverless Gen 5 1 vCore database (currently paused).
(Pinal Dave) Yesterday while, I was working with a client on the Comprehensive Database Performance Health Check we found a very interesting scenario with our client. We figured out that we have many active sessions from different users.
(Grant Fritchey) There is a war about primary keys in the database world. There are two camps. The first camp believes that primary keys should only ever be created on meaningful information.
Optimising The Performance Of Power Query Merges In Power BI, Part 4: Table.Join And Other Join Algorithms
(Chris Webb) In the previous post in this series I showed how you can use the Table.Join function and the SortMerge algorithm to get much better performance for merge operations in Power Query – but only if your data is sorted.
(Vitor Montalvao) Virtual machines (VM) are one of several resources that Azure offers and gives you total control to install and configure anything you need to perform your work. But how easy is to create and manage an Azure VM? Is there anything else that I should know before creating an Azure VM?
(James Serra) On the heels of More Azure Blob Storage enhancements come more enhancements for Azure Data Lake Store Gen2 (ADLS Gen2):
(Pinal Dave) Some questions never get old when working with SQL Server and recently one of my clients of Comprehensive Database Performance Health Check asked me if I know any way to open SSMS via Command Prompt. Of course, it is possible to do that in Windows.
(John Miner) There are existing on premises SQL Server Integration Services (SSIS) packages that use the Azure Blob Download and Azure Blob Upload tasks to move files between on premises and cloud storage systems.