SQL

Often you might be hearing complaints that SQL queries running slow on Windows Server 2008 R2 or Windows Server 2012. You will be puzzled after finding CPU, Memory, Disk, and Network utilization normal but still the queries are running slow when compared with other Windows Server 2003 boxes. Many people I talked to said they […]

{ 0 comments }

You may notice the below error while configuring your SQL server to support backup compression by executing sp_configure ‘backup compression default’ ’1′ SQL command. The configuration option ‘backup compression default’ does not exist, or it may be an advanced option. The reason for this failure is, simple. You SQL server version is not supporting compression. […]

{ 0 comments }

Given the feedback I received for my Powershell free e-books collection, I want to do similar thing for other technologies that I go through. As part of that, I am starting this post to list all SQL related free ebooks, materials, videos, etc. I will keep updating this list with resources as and when I […]

{ 2 comments }

While looking for a quick way to check when a SQL database was last backed up, the immediate thing that came into my mind is this post. I trolled around the parameters and functions of  ‘Microsoft.SqlServer.Management.smo.Server’ object and developed below tiny script to list the last backup date time of databases in a SQL server. […]

{ 0 comments }

Below small function helps you to list databases in a given database server using powershell. This will come handy for you when you quickly want to check the databases list without logging on to the server. function Get-SQLDatabases { param( [Parameter(mandatory=$true)] [string]$DBServer ) [System.Reflection.Assembly]::LoadWithPartialName(‘Microsoft.SqlServer.SMO’) | Out-Null $server = New-Object (‘Microsoft.SqlServer.Management.Smo.Server’) “$DBServer” $server.databases | select Name […]

{ 1 comment }