SQLBits XI Agenda Announced

The agenda for the SQLBits event in May was announced today and after a quick look earlier today, it looks...

#CISPA’s Coming Back: Time to Pay Attention Again

Update: The President’s cybersecurity Executive Order was  signed and released today (see the Wired article). “Although the order comes after...

“DBA: Transitioning to a BI Role” Presentation

Tomorrow (Wednesday, Feb 13th) at Noon CST I will be presenting the session “DBA: Transitioning to a BI Role” at...

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