A Month of PowerShell – Day 12 (Logins, Users and Roles)

Welcome to Day 12 of my “A Month of PowerShell” series. This series will use the series landing page on...

Annual Catch Up and End of Job/Contract Networking Steps

It’s easy to get comfortable in a job and neglect to capture the relationships and connections you’ve built – for me...

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...

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...

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...