SQL Saturday #190 Denver Wrap Up

I must admit… Denver is my favorite town in this country. The outdoor things to do, the wide variety of...

SQL Server :Part 1 : Architecture of Transaction Log

In our earlier post, we have discussed in detail about the architecture of the data file and different types of...

The MERGE statement doesn’t have a WHERE clause.

What the heck? Even indexes have WHERE clauses these days. I can’t remember what I was reading when I saw...

SQL Server Statistics

INTRODUCTION
Statistics contain information about the data. How the data is distributed inside the table. They are representation of a table....

Do you want me to tell you the truth or do you want me to tell you what you want to hear?

We live in a Dilbert age.
If you are a DBA and have worked in organizations of any size you are...

Houston Tech Fest 2013 - SQL Admin Best Practices with DMV's

Here is the downloadable file with all my sample scripts and slidedeck from my SQL Admin Best Practices with DMV's presentation from...

Strategizing your Index Maintenance in SQL Server

Index maintenance is part of the DBA’s life. Surely you have a maintenance task for this somewhere running daily or...

Azure Offerings Continue to Expand

We just received word of a bunch of new functionality over at Scott Guthrie’s blog. Not a lot of stuff...

Interviews with Great SQL People – Authors, MVPs, many more

I’m trying really hard to write a blog that goes over all the great #sqlpass interviews we’ve done, but work...

List all mapping users of SQL login account

Find a useful system store procedure to list all mapping user of SQL login account.

sp_msloginmappings @Loginname , @Flags
@loginname: the login account name, If...