A Join on SQL And Everything Else. The default configuration for TempDb leaves a lot to be desired, and although good changes are on the way in 2016. It will be quite some time before any of us get to use that in production. This script is meant to run against a new server that has the default settings in place for Tempdb, with a single data and log file.

Swimming through the Sea of SQL. When the SQL Server install runs, it asks where you want to put your database files. The default location is on the same drive where SQL Server is installed, which is typically the same drive as the OS installation. Do NOT accept this default, just say NO! These are not the only defaults you should change, but these are two that.

Developed a report to show all servers that have collection maintenance windows. Very handy for cross checking servers in multiple maintenance windows, or supplying a list to support change control. List Computers with Maintenance Window.

HTML formatted table for your SQL alerts or reports. Alerts and reports in plain text are the easiest to setup, fastest to render and smallest to send so why should you bother with HTML formatting? When emails look like this, who can ignore them? I scraped some data from Twitter to load a test table and did a quick sum to see who is the top tweeter in a arbitrary span of time.

Hope you enjoy your stay! Sunday, 28 June 2015. I just could not resist this gorgeous BOM, that Jacqelynne is running. Anyhow here is my first block- I love it. Enjoying this muchly thanks heaps Jacquelynne Steves. Wednesday, 10 June 2015. Look forward to sharing soon. Cheers Vickie Thanks for dropping in. Saturday, 7 February 2015. Also have cut out pretty much all sugars. Back on the Wii and loving i.