How many times the T-SQL inside the CTE is executed?

Introduction

Common Table Expression (CTE) has become very popular these days. However, many users of CTE still have a myth that...

How to change the SQL Server service account

It’s easy. First you click here:

Then you find the SQL Server 2008 or 2008 R2 program group

Open those and then...

Will You Buy Refurbished? Part 2

Yesterday I shared the small adventure of buying a refurbished laptop. While I was at Compusa looking at laptops I...

PASS Board of Directors – Who I’m Voting For

I was inspired by fellow blogger and all around good guy Nic Cain (Twitter, blog) to write about the PASS BoD...

#meme15 – Why Do You Blog?

Jason Strate (blog|@StrateSQL) is starting a new blog meme: #meme15.  The overall topic of #meme15 will be social networking, obviously...

SQL Saturday 99 – SSWUG Interview

Welcome to the fifth of a few sponsor interview posts from SQL Saturday 99.  After reading Arnie Rowland’s (Blog | @ArnieRowland)...

Why I blog #Meme15

I’d seen various #meme tweets on twitter but it wasn’t until I saw this blog by John Sansom (Blog|Twitter) that...

PowerPivot Data Connection Error

PowerPivot report returns the following error from Excel Services:
The data connection uses Windows Authentication and user credentials could not be...

Execute Permissions

Written by Ian Treasure
Gethyn posted on the use of execute permissions a while ago (db_executor at http://www.gethynellis.com/2010/04/dbexecutor-role.html). Briefly, this approach...

Why Did You Start Blogging?

That’s easy, because Brent Ozar (Blog|Twitter) challenged me to……
Finding time to keep up with awesome blog content can be tough....