Art

SQL Database Administrator/Developer. Background in developing OLTP/document based databases, SQLXML and performance tuning with an unhealthy fascination for the SQL query optimiser!

Blog Post

Updated blog Site

This post is mainly to test the syndication still works correctly from my heavily updated web/blog site so apologies for...

2014-11-12

408 reads

Blog Post

Updated blog Site

This post is mainly to test the syndication still works correctly from my heavily updated web/blog site so apologies for...

2014-11-12

144 reads

Blogs

Azure Networking: Designing for Change

By

Failing to plan is planning to fail. When organizations first begin implementing Azure networking,...

Using Customer Docker Compose File Names

By

As I use containers more and more to run various things, I decided I...

SQL Server Failover Cluster Instances

By

Old Reliable Still Matters If you’ve been around SQL Server for a while, you’ve...

Read the latest Blogs

Forums

Spirit Airlines

By reyatrail12

The Spirit Airlines Newark Liberty Airport Terminal is well integrated into the broader transportation...

SQL Server authentication vs. Trusted connection

By Rod at work

I maintain an application written years ago, where the database is on a Windows...

Handling Engagement Rings & Wedding Band

By iBling Jewels

I’m working on a jewelry e-commerce project and need advice on designing an efficient...

Visit the forum

Question of the Day

The Duplicate Cursor

Can I run this code:

DECLARE ANewTable CURSOR FOR 
SELECT * FROM ANewTable

See possible answers