Wayne Sheffield
@DBAWayne
Followers
2K
Following
51
Media
2K
Statuses
21K
Microsoft Certified Master - SQL Server and author. SQL Saturday Richmond organizer. I enjoy SQL, teaching, and classic rock.
Joined February 2011
A Month of PowerShell – Day 5 (Scripting – Putting it together)
blog.waynesheffield.com
A Month of PowerShell – Day 5 (Scripting – Putting it together) - Script that uses hash tables and WMI objects to retrieve volume partition information
0
0
0
Previously in our blog: Vertical Scroll Bar Map Mode (Day 6)
blog.waynesheffield.com
Let your SSMS scroll bar double for a code preview section and guide. This tip shows you how to utilize the new Scroll Bar Map Mode option in SSMS.
0
0
0
Previously in our blog: Dealing with negative session ids
blog.waynesheffield.com
How to kill transactions with a negative spid when used with distributed transactions
0
0
0
Did you miss "A Month of PowerShell – Day 23 (JobServer: Alerts)"?
blog.waynesheffield.com
A Month of PowerShell – Day 23 (JobServer: Alerts) - Checking for and creating alerts.
0
0
0
Previously in our blog: Working with the registry from within SQL Server
blog.waynesheffield.com
Utilizing the undocumented stored procedures to work with the registry from within your T-SQL scripts.
0
0
0
Did you miss "A Month of PowerShell – Day 19 (Databases: Scalar Functions)"?
blog.waynesheffield.com
A Month of PowerShell – Day 19 (Databases: Scalar Functions) - Creating, Altering and Dropping Scalar Functions.
0
0
0
Avoiding a split brain in database mirroring
blog.waynesheffield.com
Avoiding a split brain condition in database mirroring.
0
0
0
Did you miss "Tab Groups (Day 3)"?
blog.waynesheffield.com
How to use SSMS Tab Groups to easily view multiple queries at the same time, either vertically or horizontally.
0
0
0
Previously in our blog: Using Google Chrome with SSRS
blog.waynesheffield.com
In this post, you will learn how to resolve the Kerberos Double-Hop issue and SSRS browser login when using Google Chrome to run SSRS reports.
0
0
0
Previously in our blog: Analytic Functions – LAG / LEAD
blog.waynesheffield.com
An overview of how the new LAG and LEAD Analytic functions in SQL Server "Denali" work, with examples.
0
0
0
Previously in our blog: Checking for temporary table existence
blog.waynesheffield.com
There are many wrong ways to verify temporary table existence. In this post, I'll show you why they are wrong, and I'll also show you how to do it correctly.
0
0
0
Did you miss "Analytic Functions – Overview"?
blog.waynesheffield.com
An overview of the new Analytic functions introduced in SQL Server "Denali". This is the start of a series to introduce all of these functions to you.
0
0
0
Did you miss "Scalar UDF Inlining in SQL Server 2019"?
blog.waynesheffield.com
SQL Server 2019 introduces Scalar UDF Inlining, which is supposed to improve the performance of Scalar UDFs. This post investigates this new feature.
0
0
0
Did you miss "A Month of PowerShell – Day 11 (SMO: Databases)"?
blog.waynesheffield.com
A Month of PowerShell – Day 11 (SMO: Databases) - Adding, altering and dropping databases with PowerShell
0
0
0
Analytic Functions – CUME_DIST / PERCENT_RANK
blog.waynesheffield.com
An overview of how the new CUME_DIST and PERCENT_RANK Analytic functions in SQL Server "Denali" work, with examples.
0
0
0
Did you miss "Add color to connections (Day 17)"?
blog.waynesheffield.com
Help prevent mistakes of running code on the wrong server! Add color to the connections you use in SSMS in order to help identify certain SQL instances.
0
0
0
Did you miss "Assumptions and clusters – the double whammy"?
blog.waynesheffield.com
When working with a cluster, you need to ensure that all nodes are configured identically. Here's an example of why.
0
0
0
Previously in our blog: Using the Full Screen Mode in SSMS (Day 33)
blog.waynesheffield.com
The Full Screen Mode in SSMS allows you to maximize the SSMS query window to the full size of your monitor, removing most toolbars and menu options, giving you a clutter-free, minimalist window to...
0
0
0
Did you miss "Are CHECKSUMs being performed with a Compressed Backup?"?
blog.waynesheffield.com
Investigating whether performing a compressed database backup utilizes the CHECKSUM option.
0
0
0
Previously in our blog: Dealing with orphaned users
blog.waynesheffield.com
Finding and fixing orphaned users after restoring a database on a different SQL Server instance.
0
0
0