Photographing the Sky
One of the most engaging things at night in the sky is the moon. I Managed to get this shot of the moon about a month ago. Heavily cropped as I only used a 300mm zoom (450 effective).
SQL Server Free tools
As DBA’s and Developers we find ourselves performing more and more tasks which need to be achieved quickly and efficiently. People expect us to be using a variety of sophisticated tools to achieve what we need quickly and accurately. Here
Reporting Services Tips – Weekend highlights for reporting clarity
When looking at a monthly report showing all the days of the month it can help to split up the days by highlighting the weekends. We do this by applying a change in background colour (in each column) with the method
SQL Bits 9 Videos
Some of the videos and presentation material for SQL Bits 9 is available at http://sqlbits.com/. This is a great way to catch up with any missed sessions or as a refresher.
Deprecated commands in SQL Server 2012
More and more of the old commands are being deprecated as SQL moves forward with integrating these more into standard T-SQL commands. Some commands which were marked as not supported in a future version of SQL Server in 2008 R2
Sum of a group in Reporting Services
Let’s imagine we’re producing some simple reports and we only can track the number of pies returned across a whole despatch and not for each despatch type. We have a single query whose results breakdown each DespatchID into the various
DPM and Log Shipping
When using DPM with log shipping if you setup DPM to protect your database and then add log shipping later, DPM does not automatically pick up the change and thus eventually will break the log chain resulting in a log
MVP Deep Dives
The next book MVP Deep Dives, Volume 2 is now available! on Pre-Order from manning http://www.manning.com/delaney/ or from Amazon UK at http://www.amazon.co.uk/SQL-Server-Deep-Dives-Vol/dp/1617290475 The first book was a collection of short insights into sql in all areas by notable contributors and was
Poll – Denali CTP3
New Poll, Have you downloaded Denali CTP3? Results Next Week
SQLBits IX
SQLBits IX was amazing.. again. Another fantastic event with great speakers and content it was again obvious that it would be one more SQLBits that wouldn’t disappoint. It didn’t. Attending some of the dev sessions, for a change, seemed to