Day 27 of 31 Days of Disaster Recovery: Restoring Part of a Database

Today is day 27 of my series 31 Days of Disaster Recovery, and I want to talk about restoring a...

Deploying SSRS artefacts using Powershell ( Simply)

As ive stated in the past,  i’m presently part of a team on an ALM project for a major UK...

Generate Random Passwords using T-SQL

Use following script to generate random Passwords
DECLARE @id int,@list varcharSET @list ='abcdefghijkmnopqrstuvwxyzABCDEFGHIJKLMNPQRSTUVWXYZ23456789.,-_!$@#%^&*'selectreplace(SUBSTRING(CONVERT(varchar(255),NEWID()),8, 8),'-','')as RANDOM

Example:
Suppose you have a table tblUser with columns[id],[userid],[password].
CREATETABLE [dbo].[tblUser](     ...

Install .NET Framework using #Powershell (#TSQL2sday!)

One of the really great things about being married to an MCM is that I can steal recycle his blogs,...

Is your LOG backed up?

You have been doing a fantastic job of late.  You have all of your databases being backed up on a...

Las Vegas February 2013 UG

I know it is right in the middle of TSQL2SDAY when this post is to go live.  If you don’t know what that is, you should go check out...

Las Vegas February 2013 UG

I know it is right in the middle of TSQL2SDAY when this post is to go live.  If you don’t...

New Year Aspirations – Gina Walters – User Groups

Thanks for agreeing to do this Gina; from your emails things do sound quite frantic at the moment so I...

Restore SSP || Create SSP with Backup|| Create SSP with Full customization again

Friends, Life is not easy and every time we cannot create a fresh/new server, environment or a new configuration. What...

SELECT TOP 5 PERCENT WITH TIES

LinkedIn sent me an email on Monday that said my profile was in the top 5% of viewed profiles in...