Category Archives: Uncategorized

How to encode a date condition in Azure Data Factory

I keep forgetting the correct format; here is an example; where created_date >= \\’2017-05-11\\’ Advertisements

Posted in Azure, Uncategorized | Leave a comment

How to remove a search term/url from Edge

The other day I wanted to lookup the price of a PlayStation in France. I entered amazon.fr into Edge and found the details – all was good. However, now whenever I start to type ‘am..’ into Edge it keeps trying … Continue reading

Posted in Uncategorized | Leave a comment

Monitoring the progress of CreateIndex

One of the frustrating aspects of SQL Server is the lack of progress indicators. One such command falling into this pit is CreateIndex. However, this is a great link for a solution; http://sqlblog.com/blogs/michael_zilberstein/archive/2013/10/21/51415.aspx Step 1 – Before you run the following … Continue reading

Posted in SQL Server, Uncategorized | Leave a comment

Problem shrinking tempdb – could not be moved because it is a work table page

SQL holds a lot of cached information in tempdb. Until it’s cleared it won’t allow tempdb to be shrunk. So here’s a quick script you might have some joy with (obviously be aware that you will suffer the cost of … Continue reading

Posted in SQL Server, Uncategorized | Leave a comment

How to check the progress of SQL Server Shrink Database

Periodically run; SELECT GetDate(),percent_complete, start_time, status, command, estimated_completion_time, cpu_time, total_elapsed_time FROM sys.dm_exec_requests where command = ‘DbccFilesCompact’

Posted in SQL Server, Uncategorized | Leave a comment

SQL Server – The log cannot be rebuilt because

I had the blood-drawn-from-face moments when a database stated is was ‘pending recovery’. Ultimately the transaction log file was broken. Actually I didn’t care about that because I knew it was pretty much all read-only data. So how to recover … Continue reading

Posted in SQL Server, Uncategorized | Leave a comment

Azure Table Insert, one of the request inputs is out of range

Whilst trying to insert a new row via a TableEntity derived class I hit a strange error; ‘one of the request inputs is out of range’ Looking at my object it all seemed fine to me. The problem was that … Continue reading

Posted in Uncategorized | Leave a comment