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

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

April #Meme15 Assignment

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

SSIS How-To: Reuse Existing Connection Manager to Execute SQL in Script Task

There’s a myriad of examples out there on how to execute a sql task via OLEDB connections and C# in a...

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

Onward and Upward!

As you may have heard by now, I am joining the wonderful team at SQLskills as a Principal Consultant starting...

SQL Saturday #107 in Houston, TX

SQL Saturday #107 in Houston, TX
Houston Skyline

SQL Saturday #107 in Houston, TX is almost here. I will be leaving for...

SSAS development quick tip

When creating a new cube in SSAS, you are frequently making changes that cause the whole cube to reprocess when...

Thoughts on Twitter

We hear a lot about social media these days:  Facebook, LinkedIn, Google+, Twitter, etc.  More and more, we’re expected to...

Quick Reference: How Do I Read an Excel XSLM (Macro-Enabled) File in SSIS?

Excel 2010 (and presumably the next version of Excel) have taken some security precautions with regards to macros in Excel files.  If a spreadsheet has macros in it, you...