Recently I’ve started using Azure Backup http://azure.microsoft.com/en-us/services/backup/ since it offers an acceptable balance of cost, durability and ease of use.Installing the Azure Backup Agent we can setup up to three scheduled backups of directories. If we have regular SQL Server
For some time now I’d been wanting to look into the one wire interface, mainly for the temperature sensors. There seems to be a lot of experimentation and projects around using the Raspberry Pi, the Arduino and plenty of free
I wanted to arrive early to network, meet my friends and colleagues in the community and then discuss the various vendor solutions with the sponsors. Also I’d made a point of staying in a particular track this time, rather than
To find out which SQL Agent job is running your SSRS schedule simply use the query below substituting your ReportServer name and your ReportName. Many reports can run using the same shared schedule so use caution if running the job
The conversion from a float datatype to varchar datatype can be fraught with peril! Lets take our fictional number 7555000001 which is helpfully stored in a float datatype. Now in the context of a telephone number we have an issue.
The Second Shot offer for taking certain certifications from Microsoft is back so for a limited time, you’ll get a free second chance. If you’re thinking of taking the new SQL Server 2012 exams or finishing your exam track on
Monitoring SQL Server Agent jobs and getting alerts is one of the most important ways we can react to any instance or server issues. Database Mail is great! It’s our friend that can let us know when SQL Server isn’t
Plan your migration When migrating our older databases in versions 7 and 2000 we have a few more things to consider than a migration from 2005 or above to a later version but the gains in ease of administration are fantastic.
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