@DBAWayne profile picture
Wayne Sheffield @DBAWayne

Microsoft Certified Master - SQL Server and author. SQL Saturday Richmond organizer. I enjoy SQL, teaching, and classic rock.

Joined February 2011
  • Tweets 23,847
  • Following 227
  • Followers 2,111
1,980 Photos and videos
Primary Replica Jobs blog.waynesheffield.com/wayn…

Primary Replica Jobs - Wayne Sheffield

When you have an Availability Group, you will end up with jobs that you want to run only on the primary replica. Yet, the job should be installed identically on all replicas. This post shows several...

blog.waynesheffield.com
1
7
Are CHECKSUMs being performed with a Compressed Backup? blog.waynesheffield.com/wayn…

Are CHECKSUMs being performed with a Compressed Backup?

Investigating whether performing a compressed database backup utilizes the CHECKSUM option.

blog.waynesheffield.com
9
Did you miss "Stop waiting for SQL Server Service Pack 1 before upgrading!"? blog.waynesheffield.com/wayn…

Stop waiting for SQL Server Service Pack 1 before upgrading! - Wayne Sheffield

Don't like to upgrade to a new version of SQL Server until Service Pack 1 is released? It's time to change that practice.

blog.waynesheffield.com
9
Did you miss "The SSMS Super Clipboard (Day 13)"? blog.waynesheffield.com/wayn…

The SSMS Super Clipboard (Day 13) - Wayne Sheffield

The Super Clipboard built into SSMS remembers the last 20 items in the clipboard. Easily cycle through these items while you are working with a query.

blog.waynesheffield.com
10
Quick Editing Tips (Day 23) blog.waynesheffield.com/wayn…

Quick Editing Tips (Day 23) - Wayne Sheffield

Use these Quick Editing Tips in SSMS to quickly navigate, convert text, indention, or just to comment out (or un-comment) the selected lines.

blog.waynesheffield.com
9
Did you miss "A Month of PowerShell – Day 15 (Databases: Adding Foreign Keys)"? blog.waynesheffield.com/wayn…

A Month of PowerShell – Day 15 (Databases: Adding Foreign Keys)

A Month of PowerShell – Day 15 (Databases: Adding Foreign Keys)

blog.waynesheffield.com
15
Previously in our blog: Assumptions and clusters – the double whammy blog.waynesheffield.com/wayn…

Assumptions and clusters - the double whammy

When working with a cluster, you need to ensure that all nodes are configured identically. Here's an example of why.

blog.waynesheffield.com
14
Previously in our blog: Vertical Scroll Bar Map Mode (Day 6) blog.waynesheffield.com/wayn…

Vertical Scroll Bar Map Mode (Day 6) - Wayne Sheffield

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.

blog.waynesheffield.com
10
A Month of PowerShell – Day 28 (Using Windows PowerShell Remoting) blog.waynesheffield.com/wayn…

A Month of PowerShell – Day 28 (Using Windows PowerShell Remoting)

A Month of PowerShell – Day 28 (Using Windows PowerShell Remoting)

blog.waynesheffield.com
5
Did you miss "Working with Query Files (Day 5)"? blog.waynesheffield.com/wayn…

Working with Query Files (Day 5) - Wayne Sheffield

SSMS provides a way to quickly open the folder that the current query file was opened from (and with the file selected), and to easily copy the full path of that file.

blog.waynesheffield.com
5
Getting the lowdown on 18456 errors blog.waynesheffield.com/wayn…

SQL Server login 18456 error

What the 18456 error code means in SQL Server, and some solutions for correcting it.

blog.waynesheffield.com
3
Availability Group issues fixed with Alerts blog.waynesheffield.com/wayn…

Availability Group issues fixed with Alerts - Wayne Sheffield

Learn how to use the SQL Server Agent Alerting system to detect Availability Group issues and to respond to them by running jobs.

blog.waynesheffield.com
5
Did you miss "A Month of PowerShell – Day 24 (JobServer: Jobs)"? blog.waynesheffield.com/wayn…

A Month of PowerShell – Day 24 (JobServer: Jobs)

A Month of PowerShell – Day 24 (JobServer: Jobs) - Creating jobs, job steps and job schedules.

blog.waynesheffield.com
8
Previously in our blog: A Month of PowerShell – Day 5 (Scripting – Putting it together) blog.waynesheffield.com/wayn…

A Month of PowerShell – Day 5 (Scripting – Putting it together)

A Month of PowerShell – Day 5 (Scripting – Putting it together) - Script that uses hash tables and WMI objects to retrieve volume partition information

blog.waynesheffield.com
1
4
Previously in our blog: Using the Full Screen Mode in SSMS (Day 33) blog.waynesheffield.com/wayn…

Using the Full Screen Mode in SSMS (Day 33) - Wayne Sheffield

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

blog.waynesheffield.com
7
Did you miss "Presenting with SSMS (Day 29)"? blog.waynesheffield.com/wayn…

Presenting with SSMS (Day 29) - Wayne Sheffield

Whenever you are presenting with SSMS, there are certain settings that you should change to make it easier for your audience to see what you are doing. Read on for what to change, and a new easier...

blog.waynesheffield.com
8
Previously in our blog: Controlling what appears in the status bar and query tabs (Day 32) blog.waynesheffield.com/wayn…

Controlling what appears in the status bar and query tabs (Day 32) - Wayne Sheffield

Learn how to control what information SSMS displays in the status bar and in the query tabs. You can choose to de-clutter either, or just not have duplicate or irrelevant (to you) information.

blog.waynesheffield.com
12
Did you miss "A Month of PowerShell – Day 22 (Restores)"? blog.waynesheffield.com/wayn…

A Month of PowerShell – Day 22 (Restores)

A Month of PowerShell – Day 22 (Restores) - Restoring a database

blog.waynesheffield.com
12
ORDER BY Clause with clustered index blog.waynesheffield.com/wayn…

ORDER BY clause and queries on table with clustered index

Demo to prove that you do need an ORDER BY clause on a query against a table with a clustered index to guarantee results ordered by the clustered index.

blog.waynesheffield.com
20
Previously in our blog: Running totals in “Denali” CTP3 blog.waynesheffield.com/wayn…

Performance test of running totals in SQL Server "Denali"

A performance test of performing running totals using the expanded capabilities of the OVER clause in SQL Server "Denali".

blog.waynesheffield.com
11
Load more