SQL Agent Jobs – Schedule in seconds

1)   How can I execute a SQL Server Agent Job every few seconds? Administrators try to use SQL Server Agent as...

SQL SERVER connectivity error: SQL Server does not exist or access denied

Recently I was troubleshooting a connectivity issue in a development environment from an application. The application was using the connection...

Help JHD Help MND

My good friend Justin Hostettler-Davies (JHD) aka @JHDAVIES , the same JHD who recently scaled Kilimanjaro, is on the fund raising...

Twitter, John, Building a Blog and #MEME15

I saw an interesting post this morning care of the micro-blogging/social networking site twitter that really got me thinking about...

Extending the Publisher to the Cloud

SQL Azure Data Sync
This weekend I decided to setup a SQL Azure sync group to synchronize a SQL Azure database...

Including Missing Values in Data Ranges Without a Lookup Table

Including Missing Values in Data Ranges Without a Lookup Table
Including Missing Data

One of the ways that I learn new things...

PASS: Time to Change the By-Laws

Yesterday Bill Graziano announced the appointment of two Directors (Kendal Van Dyke and James Rowland-Jones) to fill vacancies on the...

Using TDD To Create A Working Application In C# : Part 2

Last FM Wrapper
You know that web project we created? You can completely forget about that for now as this is...

Friday SQL Nugget #1

Gee thanks Jes (blog|twitter). Just what I wanted, a little extra work on a Friday afternoon. I used to like...

Answer the Question Asked

“Bill, are you running SQL R2 on your desktop?”
This seems like a simple enough question, yet I usually cannot get...