One of your five a day
I’ve been looking at trying to get some Azure SQL Database wait stats for some time now. We’ve had the useful resource statistics dynamic management views for a while but they only really provided information of utilisation of the CPU, I/O,
On November 16th 2016 Microsoft released the availability of SQL Server 2016 Service Pack 1 (SP1). Normally a service pack release isn’t the most exciting news to blog about, but this release is different – This SQL Server 2016 SP1
Sometimes in SSIS we want a particular task to succeed but still have two paths or options, almost like a SSIS Success on Failure outcome. For example, we may want a package to check to see if a file exists before
When running a trace using SQL Profiler we need to be Importing trace files to perform some analysis on the results. To import the files we will simply use the fn_trace_gettable function. SELECT * INTO tracetable FROM dbo.fn_trace_gettable (‘C:\tracefiles\trace_1_1.trc’, default)
At the weekend I had a question from an attendee at SQL Saturday in Cambridge. We were discussing SQL Azure and what it supports and didn’t and the significant improvements in version 12 (v12). v12 made massive differences in what
The Edinburgh (UK) SQL Server User Group will be starting up again on Thursday 3rd September from 6pm to 9pm.Myself @sqltomato and Satya @SQLMaster will be talking about “a look at some of the new features of SQL 2016 CTP2”
This morning I was asked about Automatic Page Restore as it had been mentioned this was a feature in database mirroring and whether or not it was included in Availability Groups.Since the underlying technologies and disk access layer are similar between database mirroring
Recently I’d been asked to increase the partner timeout of all the mirrored databases on an instance. There were many databases on this instance so I decided to use the undocumented feature sp_MSforeachdb instead. This system stored procedure returns all
SQL Server 2012 Service Pack 2 is now available at http://www.microsoft.com/en-us/download/details.aspx?id=43340 for the main versions.More information available at http://support.microsoft.com/kb/2755533
In a previous post I’d looked at 1-wire interface for temperature sensors to get the temperature from a 1-wire device.For the next part I purchased a combined Temperature, Humidity sensor from Sheepwalk Electronics at http://www.sheepwalkelectronics.co.uk/product_info.php?cPath=23&products_id=55This device is actually a HIH-4031 analogue