T-SQL Tuesday #081: Sharpen Something

This month I am asking you to not only write a post but to do a little homework - first. In other words, plan to do something, carry out...

T-SQL Tuesday #081: Sharpen Something

Sharpen Something
It has now been 30 months since the last time I hosted a TSQL Tuesday, that was TSQL Tuesday...

What’s Database Drift?

The first time I heard someone mention drift at Redgate, it made sense to me. After all, in the context...

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...