Read more

For the past six months or so I’ve hosted a daily status meeting for a large project. It started out scheduled for 15 minutes and as the team grew, I found that we often ran out of time – not due to idle chit chat, but because we spent 3… Read more

Thanks to the organizers and volunteers for making SQL Saturday #108 an overwhelming success.  I’m just wrapping up the day following the Redmond SQL Saturday held in the Commons on the Redmond Microsoft campus.  Greg Larsen and all of the organizers did a fantastic job to make this a successful… Read more

SQL Saturday 108 (Redmond, WA) Session Files

Session files are now available for download. The zip file contains the PowerPoint slide deck and demo code.

Zip file: ReplicationMagic.zip (5.2 KB)

Included files:
• Demo: Initializing replication from a log backup
  • InitializeFromLogPub.sql
  • InitializeFromLogSub.sql
• Demo: Initializing replication from…

Read more

Read more

Read more

This post explains how to list Event Log Messages with Powershell Get-EventLog  , on multiple servers and output the results to a HTML file.

It is only one extra step to send an email attachment.

This example iterates through a list of servers and returns Error messages from the System… Read more

On Feb 22, 2012, Microsoft released SQL Server 2008 R2 SP1 Cumulative Update 5, which is Build 10.50.2806. This CU has 16 fixes listed.

If you are still on the SQL Server 2008 R2 RTM code branch, you would want to take a look at SQL Server 2008 R2… Read more

SQL Server 2012 introduces several significant enhancements to spatial types, such as support for new subtypes of circular arcs, new and updated methods and aggregates for all subtypes, improved precision, and updates to the geography type.

More info:

New Spatial Features in SQL Server Code-Named “Denali”

Video Microsoft SQL… Read more

Welcome to the Friday Re-Blog summary post.  The aim of these posts is to bring some old posts that newer readers may not have had a chance to see.  Also a chance to bring back to the forefront posts that some may have seen but forgot about.

If you have… Read more

Yep, that’s correct, the SQL Lunch has expanded to the UK with one slight change.  Unlike the SQL Lunch that I host online here in the U.S., the SQL Lunch UK, which is hosted by Dave Bally (@davebally), will be held at a physical location.  Well except for the… Read more

Yep, that’s correct, the SQL Lunch has expanded to the UK with one slight change.  Unlike the SQL Lunch that I host online here in the U.S., the SQL Lunch UK, which is hosted by Dave Bally (@davebally), will be held at a physical location.  Well except for the… Read more

On the corner of my rather messy desk is little recognition item in the image to the right. It’s a 5 year marker, representing my 5 years as a Microsoft MVP. I’m honored that they think I’m doing enough for the community to be recognized.

Next week is the annual… Read more

Developers constantly ask about placing the latest code\feature\process\third party applications onto  Production Database Servers.

I’m building an FAQ  to supply Developers – as this could save me having very similar conversations .  

 Some other reasons for retaining a process is :

a)       Maintain database standards such as ISO-11179 Naming… Read more

Today one of my auditors sent me her matrix for auditing Microsoft SQL Server. I had seen part of it and some questions about some of the technical details I saw. In the email thread I discovered that some of it was taken from a guidance document from our professional… Read more

Read more

Read more

I have become dependent on my tablet, here is why, thanks to a great summary from the Globe and Mail. Read more

February 23, 2012 – Today, LINCHPIN PEOPLE, LLC, offering technical advisory, consulting and training services in the Microsoft SQL Server Space, announces the addition of two key partners to the firm.

Mike Walsh, SQL Server MVP (blog|twitter) Founder and Owner of StraightPath IT Solutions,… Read more

I wanted to follow-up on the partner announcement of the great new concept and venture, started by my friends and sql compatriots , Andy Leonard and Brian Moran, who have added two new Partners to the LinchPin People lineup.  Fresh from the first official Linchpin Summit,  Mr. Mike Walsh has pulled the LinchPin out of… Read more