SQL Performance

MARCH 15, 2021

This wasn't for performance reasons, directly, or to simply follow Microsoft's documented best practices, but revolved more around the decisions you might make when you only have access to some of the data. The Microsoft.SqlServer.Management.Trace namespace that contains the Microsoft SQL Server Trace and Replay objects are also deprecated.

Servers 64

Servers Azure Best Practices Monitoring 64

SQL Server According to Bob

JULY 13, 2016

20+ years ago when I joined Microsoft I was handed a diskette (maybe it was two), and was told “Here is SQL Server. So I proceeded to install SQL Server 4.20 There was a GUI as part of setup but within just a few clicks, SQL Server was installed and ready for use. So now there are more choices to make when installing SQL Server.

Servers 40

Servers Media Engineering Virtualization 40

Percona

APRIL 12, 2023

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. ” Nothing nefarious there.

Open Source 83

Open Source Programming Database Servers 83

SQL Server According to Bob

JANUARY 26, 2017

My goal is to resolve mysteries about SQL Server I encounter but do this without going straight the source code first. The first case that helped me start this journey was asked by a MVP within the SQL Server community (his first name starts with Joey<g>). The question went something like this….

Servers 40

Servers Database Azure Cache 40

SQL Performance

AUGUST 11, 2021

One is using a function called DATE_BUCKET , which at the time of writing is only available in Azure SQL Edge. Another is using a custom calculation that emulates the DATE_BUCKET function, which you can use in any version, edition, and flavor of SQL Server and Azure SQL Database. DATE_BUCKET. Emulating DATE_BUCKET.

Azure 139

Azure Code Database Servers 139

SQL Performance

AUGUST 14, 2019

GetNums ( 1 , @rows_per_partition ) AS RPP ; Our pitfall has both a logical side to it with a potential logical bug as well as a performance side with a performance penalty. The performance penalty is relevant only when the window function is optimized with row-mode processing operators. It took this query about 4.5

Best Practices 108

Best Practices Servers Database Azure 108

SQL Server According to Bob

JANUARY 28, 2018

Note: SQL Server can be a client using a linked server, allowing SQL Server to become an APP and/or an RM ). DtcGetTransactionManager contacts the host, performing a remote registry access to determine the connection and proxy information. Once the connection to SQL Server is established the APP executes the odbc!

Servers 40

Servers Azure Engineering Java 40

SQL Performance

MAY 7, 2019

I’m going to introduce you to wait statistics and explain how critical they are for troubleshooting workload performance in SQL Server. The execution of SQL Server’s internal code is done using a mechanism called threads. When that happens, SQL Server makes a note of why the thread had to wait and this is called the wait type.

Servers 40

Servers Azure Metrics Tuning 40

The Symphonia

DECEMBER 6, 2017

Correspondingly, 3GB functions should see a 2x CPU performance improvement over 1.5GB Lambdas, but this is through doubling the number of cores the function has access to, rather than double the virtualized time-slices. Despite the fanfare, therefore, AWS is still behind Microsoft Azure Functions when it comes to debug tooling.

Serverless 40

Serverless Lambda AWS Traffic 40

Smashing Magazine

JULY 6, 2021

With Luminary’s 21 years of experience in the digital space, my experience of 17 years in the CMS space as well as our focus on Headless since 2016, here are my two cents on what you should look out for. But beware of circular references to content which could cause headaches and performance issues. Microservices architecture.

Cache 143

Cache Website Mobile Google 143