Latest Blog Posts
I was lucky enough to be accepted to speak at SQL Nexus in Copenhagen and I attended the event a few weeks ago. This is the new Nordic SQL conference that seems to be replacing the SQL Rally. I’d never been to Denmark, but the trip was easy, and I… Read more
Saying that you should use the correct data type seems like something that should be very straight forward. Unfortunately it’s very easy for things to get confusing. Let’s take a simple… Read more
I’m pleased to announce the general availability of a new free ebook collaboration with James Green from ActualTech Media called “Modern Storage Strategies for SQL Server“. Storage is so vitally important to SQL Server performance, but the intricacies of one side’s administrators are rarely known by the other.… Read more
I’ve been working on tuning a query for the last week and I’ve had to make several changes to the query’s logic. I’m always a little nervous when making those types of changes so I try to do some careful testing before I even suggest the changes to the developers.… Read more
The purpose of the script is to restore database/s from a database backup. The requirement is to refresh ‘n’ databases.
The advantage is that the flexibility of passing restoreDbList to restore specific group of databases.
The Restore databases has three mandatory paramters
param ([Parameter(Mandatory=$true,Position=0)][String]$SourceServer – Source where you… Read more
First up on June 4th is SQL Saturday #517 Philadelphia (#SQLSAT517) - I am speaking at 2:45pm on "Getting Started with Extended Events." This is quickly becoming my favorite of the talks that I give…
The purpose of the script is to initiate backup only for desired group of databases. The requirement is to refresh databases.
The advantage is that the flexibility of passing a list of specific group of databases for backup.
The backup databases has three mandatory parameters
$SQLServer –… Read more
Have you ever wondered what Azure region would be the fastest to host your applications when those applications are accessed from your office? Obviously the closest data center would probably be the best choice (each region has multiple data centers), but how do you know what data center is the… Read more
Recently I have been using Azure DocumentDB to validate several business use cases for a variety of application purposes.
For those SQL DBA’s and others who are new to Azure DocumentDB, its a fairly recent entrant to the NoSQL document database world with MongoDB as its main industry competitor.… Read more
This month Wendy Pastrick is the host for T-SQL Tuesday #78. This month we have to “learn something new and blog about it.” There is likely to be a lot of coverage on the new features in SQL Server 2016, so I have decided to cover a new feature that… Read more
Tomorrow I’ll be presenting a new session for the PASS Virtualization Virtual Chapter called “Virtual SQL Servers, Actual Performance” tomorrow at 1PM Eastern time. Register for this free webinar today!
Presentation abstract: Virtualizing your business-critical SQL Servers should not imply that they will run slower than if they… Read more
Last week I did a little experimental webinar that was outside our (Pragmatic Works) norm. Instead of our traditional 1 hour session I delivered a 3 hour workshop that took you through the end to end process of developing Power BI solutions. The idea being to give you a taste… Read more
SQL Server supports row and page compression on tables, indexes and partitions. This can lead to reduced I/O and better performance. However, it can also result in additional CPU usage in some cases, outweighing the benefits of data compression. SQL Server query optimizer does not cost the overhead of expanding… Read more
0 comments, 2,643 reads
Posted in Ramesh Meyyappan’s SQL Server Performance Tuning Blog on 10 May 2016
One of the things I like best about joining in on Adam Machanic’s (b/t) TSQL Tuesday blog party is that it can force you to explore things you haven’t tried before. Well that’s exactly what Wendy Pastrick (b/t) wanted us to do.… Read more
So SQLBits has finished for another year. About 1500 people registered for the largest SQL Conference in Europe held over 4 days in Liverpool last week. 2 days of full day sessions and 2 days of shorter sessions, a pub quiz, a party (literally) out of this world.
It is… Read more
I have recently experienced an issue with a third-party backup application (Commvault) that was trying to backup the databases from the SQL 2014 . It was throwing a below error
“Description: Error encountered during backup. Error: [ Could not load file or assembly ‘Microsoft.SqlServer.BatchParser, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91’ or one of… Read more