-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

SqlServerZest.com - SQL in simple style

Suresh Raavi is a database professional, with a zest for SQL Server specializing in Administration and performance tuning. Presently, he is a Sr. SQL Server DBA at the Microsoft Products and Services IT SQL team, taking part in various challenging projects, focusing mainly on performance tuning, database development, high availability and database design. He is passionate about database technologies and "data" in general. He has earned the MCITP Database Administrator 2008, and holds a Master of Science degree in Engineering. He provides insights from the field on his blog at http://SqlServerZest.com. His hobbies includes Running and Travelling. You can follow him on Twitter @SqlServerZest

Our Ginger Slides’ Primer – Thinking To Move Your Data From On-Premise SQL Server to AWS DynamoDB?

The benefits of running databases in the AWS are compelling but how do you get your data there? In this session, we will explore how to use the AWS Database Migration Service (DMS) to migrate on-premise SQL Server tables to DynamoDB in AWS at a very high level. I will…

Read more

0 comments, 315 reads

Posted in SqlServerZest.com - SQL in simple style on 14 November 2017

AWS – No Password? No Problem! Generating Redshift Credentials via IAM Authentication

I know we are living in a world where phones and other devices with advanced biometric authentication have been increasingly becoming a norm. Apart from the tremendous convenience they offer, they also offer the highest level of security with no longer needing to type in a passcode and worrying about…

Read more

0 comments, 190 reads

Posted in SqlServerZest.com - SQL in simple style on 10 November 2017

AWS – Move Data from HDFS to S3

In the big-data ecosystem, it is often necessary to move the data from Hadoop file system to external storage containers like S3 or to the data warehouse for further analytics. In this article, I will quickly show you what are the necessary steps that need to be taken while moving…

Read more

0 comments, 228 reads

Posted in SqlServerZest.com - SQL in simple style on 6 November 2017

Mongodb – How to Iteratively Access Data Across all Databases and Collections

With some applications, there may be a need to pull data from other database instances, or from other databases within the same instance.  Often this can be achieved by having multiple connections from your application pointing to each of these data sources. This is great for this one application, but…

Read more

0 comments, 673 reads

Posted in SqlServerZest.com - SQL in simple style on 6 July 2017

Linux – How to generate and configure SSH Key authentication to connect to a remote system

Using SSH keys provide a more secure way of logging into a remote computer when compared to password authentication, and today I will walk you through how we can achieve this in 3 simple steps For this demo I will be configuring SSH key authentication for the user account accountsguru…

Read more

0 comments, 312 reads

Posted in SqlServerZest.com - SQL in simple style on 10 December 2016

Linux – How to Change Group and User Ownership of a Directory – using chown & chgrp

In this post, let’s learn how to use chgrp and chown commands to change group and user ownership of a directory On a Linux server, by default, the group owner of a file or directory is the primary group of the user who created the file directory. And it is…

Read more

0 comments, 275 reads

Posted in SqlServerZest.com - SQL in simple style on 7 December 2016

SQLServerZest is now DataGinger!

We are happy to announce the birth of DataGinger. Starting today we officially re-branded ourselves as DataGinger.com (previously SQLServerZest.com). The main motive for this change is to expand our blogging topics beyond SQL Server and widen our scope to include all data and supporting technologies. Enjoy learning! -Your Friends at…

Read more

0 comments, 305 reads

Posted in SqlServerZest.com - SQL in simple style on 15 July 2016

PowerShell – Disk Space Monitoring and Early Warning Reports

Disk space is one of those things that frequently runs out of space no matter how much you bump it up irrespective of the service you are running in the server. I know storage is cheap but who wouldn’t want to keep an eye on what’s cooking especially when it…

Read more

2 comments, 1,209 reads

Posted in SqlServerZest.com - SQL in simple style on 9 June 2016

SQL Server – Configuring custom Load Balancing in SQL Server 2012 and 2014 using Read-Only Routing

Starting with SQL Server 2012, AlwaysOn Availability Groups provided group level high availability for any number of databases for multiple secondaries known as ‘replicas’. The secondary replicas allow direct read-only querying or can enforce connections that specify ‘ReadOnly’ as their Application Intent using the new feature called Read-Only routing which…

Read more

4 comments, 1,332 reads

Posted in SqlServerZest.com - SQL in simple style on 1 October 2015

SQL Server – Dynamically Generate Scripts for Configuring Read-Only Routing URLs and Lists

Read-only routing refers to the ability of SQL Server to route incoming read-intent connection requests, which are directed to an availability group listener, to an available readable secondary replica. I find this little script very useful when I want to automate and and same time while limiting the human input…

Read more

1 comments, 378 reads

Posted in SqlServerZest.com - SQL in simple style on 1 October 2015

SQL Server – Script to generate Read-Only Routing URLs

If you are familiar with the new feature Read-Only Routing introduced in SQL Server 2012 with AlwaysOn then you should keep this script handy to generate URLs to be used in Read-Only Routing configuration instead of typing down yourself to limit any errors. Connect to each replica in your AlwaysOn…

Read more

1 comments, 444 reads

Posted in SqlServerZest.com - SQL in simple style on 1 October 2015

SQL Server – New Database Backup Encryption with SQL Server 2014

With the release of Microsoft SQL Server 2014, we have the first version of SQL Server that supports encrypting database backups directly from the database engine without any third party software being installed on the SQL Server. Preparing the Instance for Encrypted Backups Before you can have the SQL Server…

Read more

2 comments, 602 reads

Posted in SqlServerZest.com - SQL in simple style on 21 July 2015

SQL Server – Capture Execution Plan of a Currently Running Query/Process SPID

DBAs most often face scenarios where they need to capture graphical execution plan of a query currently running on a live production instance because of multiple reasons like: why a particular SPID is causing blocking why is my query running slow why isn’t the index getting used which operator is…

Read more

2 comments, 959 reads

Posted in SqlServerZest.com - SQL in simple style on 5 June 2015

SQL Server – How to Calculate Length and Size of any field in a SQL Table

Recently I came across a situation where queries are loading extremely slow from a table. After careful analysis we found the root cause being, a column with ntext datatype was getting inserted with huge amounts of text content/data. In our case DATALENGTH T-SQL function came real handy to know the…

Read more

4 comments, 623 reads

Posted in SqlServerZest.com - SQL in simple style on 4 June 2015

SQL Server – Changing Ownership for All the User Databases to “sa” Account

Most people prefer to have “sa”  account as the database owner, primary reason being sa login cannot be removed/deleted unlike any user account or service account and so the databases will never end-up in an orphaned stage. I came-up with the below method to change the ownership to sa on…

Read more

5 comments, 327 reads

Posted in SqlServerZest.com - SQL in simple style on 5 May 2015

SQL Server – Endpoint Authentication Error in AlwaysOn Availability Group Setup

According to MSDN: If the SQL Server service is running as a built-in account, such as Local System, Local Service, or Network Service, or a nondomain account, you must use certificates for endpoint authentication, and the Add New Replica wizard will be unable to create a database mirroring endpoint on…

Read more

0 comments, 571 reads

Posted in SqlServerZest.com - SQL in simple style on 6 February 2015

SQL Server – Ports used by Database Engine and other SQL Features

Most of us know the default port for SQL Server is 1433, but there are various ports being used by SQL Server for other database services and SQL features. In the below table I tried to list the ports that are frequently used by the Database Engine Item Port Default…

Read more

0 comments, 306 reads

Posted in SqlServerZest.com - SQL in simple style on 7 December 2014

SQL Server – Failed to bring availability group ‘[availability group name]’ online

I have been noticing one very common error that occurs while trying to failover an Availability Group in SQL Server 2012 AlwaysON setup. The Availability Group fails to come online during a fail over process. Here is the snippet of the error message. Failed to bring availability group ‘availability_group‘ online.…

Read more

4 comments, 1,586 reads

Posted in SqlServerZest.com - SQL in simple style on 28 October 2014

SQL Server – Aborted Online Index Operation & Observed Elevated Values for PWAIT_MD_RELATION_CACHE and MD_LAZYCACHE_RWLOCK Wait Types

Last week on one of our production servers (version 2011.110.3373.0), we’ve encountered a strange issue which is relatively new (only applicable for SQL Server 2012 and 2014 versions). Based on the symptoms observed and doing a quick Bing search found we encountered a product bug! I observed multiple SPIDs, around…

Read more

0 comments, 522 reads

Posted in SqlServerZest.com - SQL in simple style on 12 August 2014

SQL Server – Script to Identify and Update Database Auto-Growth Setting

An auto-growth event is the process by which the SQL Server engine expands the size of a database file when it runs out of space. The amount by which a database file should grow is determined by the value that is set in the SQL configuration. While every organization has…

Read more

10 comments, 1,003 reads

Posted in SqlServerZest.com - SQL in simple style on 25 June 2014

Older posts