SQLAzureKKB

How to downgrade a SQL Server from 2008 R2 to SQL Server 2005?

Here's the situation. You have done an in-place upgrade of SQL Server from 2005 to SQL Server 2008...

Author: Karthik Krishnamurthy Brahmavar Date: 11/04/2015

Find the percentage of fragmentation in a table for a database (What's the permission level needed?)

I can find out the percentage of fragmentation for a particular table using the below query: USE...

Author: Karthik Krishnamurthy Brahmavar Date: 07/29/2015

DBCC CHECKDB - Good to know!

If you're a DBA, then you'll need the below content at least once in your career. Your company needs...

Author: Karthik Krishnamurthy Brahmavar Date: 07/27/2015

SQL Server Agent jobs collecting useful information, how to save them?

Hi, I was working on an OLTP environment where tempdb started growing crazy! Before even I got a...

Author: Karthik Krishnamurthy Brahmavar Date: 07/27/2015

What should my backup strategies be for system databases?

If you're a DBA, you'll say, it's simple; in the maintenance plan, just select 'all databases' or if...

Author: Karthik Krishnamurthy Brahmavar Date: 07/26/2015

What did I learn?

This blog is slightly non-technical rather it's a bit about myself. I worked in Microsoft IGTSC for...

Author: Karthik Krishnamurthy Brahmavar Date: 07/26/2015

Check connectivity to Azure SQL Database using Azure PowerShell

This comes in handy to see if the customer is able to connect to the database server or not. In...

Author: Karthik Krishnamurthy Brahmavar Date: 06/12/2015

Slow disk IO issues for SQL Server

There are 100's of blogs on the topic that I am writing about today. It always helps me to look at...

Author: Karthik Krishnamurthy Brahmavar Date: 06/02/2015

Permissions for Windows administrator to perform SQL Server setup

You're starting a SQL Server setup | you've faced permission related errors during SQL Server setup...

Author: Karthik Krishnamurthy Brahmavar Date: 06/02/2015

How to find thumbprint of an Azure certificate for Windows Powershell

It's going to be a simple blog post. If you're new to Azure PowerShell and you're looking to find...

Author: Karthik Krishnamurthy Brahmavar Date: 06/02/2015

Basics of Windows Powershell

In my college days, I used to run dir, ls, mkdir. Recently when WS 2012 was released, someone told...

Author: Karthik Krishnamurthy Brahmavar Date: 05/20/2015

Administrator login in Azure SQL DB

Consider the database name is ‘test’. Connect to ‘master’: CREATE LOGIN...

Author: Karthik Krishnamurthy Brahmavar Date: 02/26/2015