Top 3 Reasons Why Evernote is worth $1 billion to me

Everyone heard about Facebook’s recent purchase of Instagram for $1 billion dollars. No one can imagine how they came with such...

A Tale of Four Laptops

With the release of the 22nm Ivy Bridge microarchitecture less than three weeks away, at the end of April 2012,...

T-SQL Tuesday #029 – SQL 2012 and Treating TempDB like it’s really Temporary.

A while back, my young son thought it would be fun to use a CD as a virtual surfboard on...

X on XMLA: iii. Basic DDL Functions in XMLA (Create, Alter, Delete)

XMLA can be used to manage the structure of your multidimensional databases.  While many developers use Visual Studio (BIDS), to...

T-SQL Tuesday #029 – Useful Feature of SQL Server 2012

This month, T-SQL Tuesday is being hosted by Nigel Sammy. Since the RTM of SQL Server 2012 just occurred, he...

Simple Tips To Speed Up Your SSIS Data Flow

There are a few design choices that can make your SSIS packages run super fast when loading data from table...

Speaking In April #SQLSat111 and #SQLSat107

All Quite on the Western Front
It is going to get noisy soon though! I”m speaking at SQLSaturday #111 in Atlanta...

PASS DBA Virtual Chapter: Replication with Hilary Cotter

I’m pleased to announce that this Wednesday April 11th 2012 Hilary Cotter will be presenting for the PASS DBA Virtual...

SQLCLR: Good? Or Evil? #MemeMonday

Is SQLCLR good or evil?  Thomas LaRock (Blog | @SQLRockstar) is asking that question this month in his #MemeMonday blog party.
Let’s...

SQL Database roles and members

Q. How can I obtain the members of a role within a database?
A.  One method is to use sp_helprolemember
 
EXEC mydatabase.dbo.sp_helprolemember

--returns...