I recently had a scary moment at a customer when I was testing to see how long it would take to copy a data file between two of their disks using Robocopy and an old and relatively small backup file. If you haven't heard of Robocopy, then you should look into it as a command line (cmd) tool for..
Recently, while working with a customer to help restore their SQL services, I came across an issue I hadn’t seen before and more interestingly, one where little information can be found within the community.
Configuring scheduled database backups has always been an important activity for database professionals. As we transition our SQL Server workloads into Microsoft Azure Infrastructure-as-a-Service (IaaS), we now have a number of options available for backing up databases which at first glance can..
July has brought some exciting news to the SQL Server community and, at the same time, Microsoft has released a bunch of security updates for Windows that will help in keeping our environments protected from malware vulnerabilities. See below the latest SQL Server and Windows updates along with..
UNION ALL returning incorrect results? I recently came across an interesting behaviour when executing queries that included a UNION ALL statement, the examples below were created using SQL Server 2016 Service Pack 1.
Hey there! In the second part of my Azure Data Factory best practices I’ll be talking about controlling the flow of your tasks.
The next version of Microsoft’s heavyweight database platform came one step closer to arriving this week when Microsoft released Release Candidate 1 of SQL Server 2017. Microsoft usually provides a couple of release candidates, meaning the final version is likely to appear sometime this autumn.
1. New technology This does not mean implement every possible new feature or design methodology, but that enough knowledge is gained so that the most appropriate decisions are taken when building the foundation of a solution. Existing functionality may already be offered as part of a 3rd party..
Microsoft has updated its list of free to download eBooks and once again there’s some current and relevant books in the list - as well as some less useful ones and aging whitepapers.
In the last decade, mobile technology has transformed our lives - and now we are seeing it transform the retail landscape.