When was this database restored?

I frequently need to know where backups went and I restore those backups for operational recovery on a regular basis....

Another Query to Help Find the Right Event

Finding the right event or combination of events to monitor may seem like quite a daunting task with so many...

Azure SQL IaaS – TempDB Performance on SSD vs Premium Disk

[read this post on Mr. Fox SQL blog] When it comes to deploying SQL Server onto an Azure IaaS VM, it is sometimes difficult to know the best option to deploy the SQL Server...

Check out the latest and greatest...Great Value It Training Offers

Here's this weeks list of courses. At £750 plus VAT... I can't see how you can fail

1902: Linux Virtualisation 4...

PowerSQL – Get SQL TraceFlag SQL Service and Config Information

Get SQL Server configuration, service info, start type along with enabled Trace Flags of local or remote servers.
This script outputs...

SELECT * FROM....Writing SQL Queries...

This week is my fourth week on the spin being involved in a Learning Tree Course. This week we have...

Using a Lookup Component in SSIS for Surrogate Keys in a Fact table

There are many suggestions for loading a data warehouse using SQL Server integration Services (SSIS). Once you get started, you...

Webinar Followup: New Security Features in SQL Server 2016

I recently presented a free webinar for Pragmatic Works where I discussed new security features in SQL Server 2016. You can...

Blogger Questions: What should I blog about?

Over the last four years I’ve blogged almost 400 times. It’s become a refuge, a resource, a source of pride,...

Fourth Week in July

This is the fourth week of four of my July training programming and this week we have two courses that...