Tag Archives: T-SQL Tuesday

T-SQL Tuesday #90 – The Elephant’s Name is Database

T-SQL Tuesday is a monthly blog gathering for the SQL Server/Data Professional community  It is the brainchild of Adam Machanic (B|T) and is not limited to just things around the SQL Server database engine. Each month a blogger hosts the event and … Continue reading

Posted in TSQL Tuesday | Tagged , , | Leave a comment

T-SQL Tuesday #89 – There is No Cloud

April’s T-SQL Tuesday blog. A look on how moving or not moving to the cloud affects my role as a database administrator. Continue reading

Posted in TSQL Tuesday | Tagged | 1 Comment

T-SQL Tuesday #67 – Extended Events

A look on how I am using extended events to monitor which SQL logins are authenticating to the sql instance. Continue reading

Posted in Administration | Tagged , , , | Leave a comment

T-SQL Tuesday #65 – Failing Over with PowerShell

A look at how I’m using Powershell to hep control who is the owner of a clustered resource for serviceability. Continue reading

Posted in Administration, TSQL Tuesday | Tagged , , | 4 Comments

T-SQL Tuesday #18 – A Better Solution

My first post for T-SQL Tuesday #18. Here I describe how I used a CTE to solve the need to query multiple tables and return data from only specific ones without having to use ‘IF’ statements. Continue reading

Posted in General Conversations | Tagged , , | 4 Comments