I spend a lot of my time creating new features that simplify my companies business processes. A good example of this is an invoicing system I created. Instead of users working off different spreadsheets and copying and pasting data between various different programs the user can click a couple of buttons and...
I use SQL Server Management Studio all the time for writing queries, getting data and general SQL development. I have enjoyed seeing the improvements that each new version of SQL Server Management Studio (SSMS) introduced. One great improvement was intellisense. This feature saves typing and reduces errors by...
I recently read a blog post by Pinal Dave about how you can backup straight to Azure Storage. The procedure he described is only available for SQL Server 2014 or later. I won’t go into detail of this method as Pinal describes it better than I can, but the basic of it requires setting up credentials and then running a...
For historical reasons I use Microsoft Access as the front-end for all my line of business databases. Access allows you to create an ADP file that can connect to your SQL Server database. However Office has dropped support for this, so the last version of office that I can use is Office 2010. Before I start hating on...
Today is my day off, but I wake up and have a quick look at nagios to see if there is anything I need to worry about. Yes there is, SQL Server has run out of disk space on its data disk. I race downstairs and VPN onto the server to find out what has happened. One of my monitoring databases has had runaway log growth...
I have been recently working on a database that hasn’t been designed but has been hacked together by lots of people over the years. It started life as an Microsoft Access database created by my director to keep track of all the projects that our company does. It was not much more than one table listing everything. At...
One of my jobs is adding extra features to our internal databases. There is a fair amount of risk in doing this. I could make a change to one of the queries in the database that stops the rest of the company using it as they need to. This could be a costly mistake, almost as bad as the database server being...