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

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

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

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

Using 2008 Features in a 2000 Compatibility Database

I saw a note recently from someone asking if they could use CROSS APPLY on a SQL Server 2008 instance...

Why I can not connect sql server ???

       Recently, I installed sql server 2012 on windows 7 laptop, today when I wanted to login sql server with TCP/IP, I got...

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

April #Meme15 Assignment

Before the advent of the modern “Social Network”, many of us were already connected through tools that had much less...

Enabling Contained Databases in SQL Server 2012

One of the new features in SQL Server 2012 is the Partially Contained Database feature. I gave a talk on...

Need a Blogging Nudge? Try Plinky

If you want to blog you need ideas, something to write about, and sometimes that leads to the blank stare...