T-SQL Tuesday - Use Powershell to Restore a Database on a Different Server

T-SQL Tuesday - This month's party is hosted by Wayne Sheffield (blog|twitter), and the topic is about Powershell and how to use...

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

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

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

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

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

T-SQL Tuesday #39 - Here's what my PoSH is cooking

My first official entry for T-SQL Tuesday (my first was a guest post hosted by Kendal Van Dyke (blog|twitter), so I’m not really counting it) is brought to you...

February 2013 – Monthly SQL Server Checklist

February is a short month… and if you are following the Monday’s you know that today’s the second Monday of the...

XML Support and SQL Server (Part 3)

Checkout the third part of my XML support and SQL Server article series here.
In this part, I talked about the...

SQL Agent Alert System Error: [264] An attempt was made to send an email when no email session has been established

Today, I received an email from the development team complaining why they have not received any of the SQL Agent...