I recently talked with Mark Wright, CTO of Nitrosphere, a company that optimizes SQL Server application performance. Let us talk about it.
SQL SERVER – Improve Application Performance on Cloud While Reducing Bandwidth Cost
It is very common for people to move database now a day to the cloud. The very first question I often hear from them is – How to Improve Application Performance on Cloud While Reducing Bandwidth Cost?
SQL Server – When to Use a Sledgehammer and When to use a Screwdriver
While it is almost always a good idea to place the data near the application, choosing Always On may be using a sledgehammer to do a screwdriver’s job.
SQL SERVER – Speed Up Performance Without Code Change
In this blog post we are going to leave about how to Speed Up Performance Without Code Change or Configuration Change in SQL Server.
SQL SERVER – Analysis Services and the Network Performance
SQL Server Analysis Services (SSAS) is becoming increasingly popular as an OLAP platform for business analysts. Network Performance
SQL SERVER – Performance Choice – Coding or Automation
We talk a lot about optimizing SQL with building the most efficient queries and application architectures. It’s what we enjoy doing and what we’re paid to do. We love to twiddle bits and tweak code, and can spend day after day doing this. But are we looking at the big picture? Is what we are working on the highest priority for the business or organization we work for? Are we extending our value beyond just implementing and optimizing SQL databases and applications? Can we deliver value that has a return on investment (ROI) to organizations? That ROI can be in terms of making people more productive, saving infrastructure costs, and even making trade-offs for when we should code and when we should automate. This even applies to when to use consultants like me. Can an hour of consultation with me save days or weeks of research and trial-and-error in addressing a major performance roadblock?
SQL SERVER – Whitepaper – Optimizing SQL Server Network Performance
I have blogged before regarding how to Identify Application vs Network Performance Issues using SQL Server Dynamic Management Views (DMV).