SQL

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 }