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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
Date: 05/20/2015
Administrator login in Azure SQL DB
Consider the database name is ‘test’. Connect to ‘master’: CREATE LOGIN...
Date: 02/26/2015