I`m an SQL Server consultant experienced in areas such as database design, T-SQL advanced programming, database administration and business intelligence. I have a good understanding of a few subject domains, for example, finance, trading, telecoms and insurance. Right now I`m running a small database consultancy and a blog, though I'm also an active stock trader.

All authors

All authors

Blogs

How I Troubleshoot a Slow SQL Server Live

By

No two SQL Server environments are alike. A fix that resolves a performance issue...

T-SQL Tuesday #201 Invitation: Temp Tables, Friend or Foe?

By

My T-SQL Tuesday #201 invitation. Do temp tables help performance or hurt it? I...

Monday Monitor Tips: The MCP Server

By

I have been experimenting with MCP servers in a few ways, and pressing on...

Read the latest Blogs

Forums

Test topic for spam filtering

By philip.scott

A new thread for testing the spam filter. Adding a link: https://www.bbc.co.uk/weather

Removing production permissions when restoring database to non-prod

By webrunner

Hello experts, An application team has asked us to modify a SQL Agent job....

Advanced T-SQL: Replacing Slow Cursors with Window Functions

By sabyda

Comments posted to this topic are about the item Advanced T-SQL: Replacing Slow Cursors...

Visit the forum

Question of the Day

The Service Name

What does @@servicename return?

See possible answers