Wayne Sheffield

My blog about SQL Server

Welcome to Day 3 of my “A Month of PowerShell” series. This series will use the series landing page on this blog at //blog.waynesheffield.com/wayne/a-month-of-powershell/. Please refer to this page to see all of the posts in this series, and to quickly go to them. Scripting So far, we’ve only performed one simple task. It may […]

Welcome to Day 2 of my “A Month of PowerShell” series. This series will use the series landing page on this blog at //blog.waynesheffield.com/wayne/a-month-of-powershell/. Please refer to this page to see all of the posts in this series, and to quickly go to them. Variables As you start working with any scripting language, you inevitably […]

Welcome to Day 1 of my “A Month of PowerShell” series. PowerShell is one of those things that I know I need to learn more about in this profession. Recently, I was reading a SQLSkills Insider email where Paul Randal mentioned that he wants to learn PowerShell also – but he likes to learn in […]

I ran into an interesting problem recently. There is a 4TB database that is log shipped to a DR site, and some new data files needed to be added to the database. Mistake #1: The drive volumes on the DR server are not configured the same as the primary site. Mistake #2: This mismatch was […]

This month’s T-SQL Tuesday is hosted by Jason Brimhall. Being as this is January, lots of people are making New Year’s resolutions. Well, Jason doesn’t want to hear about that… but he does want to know how you have stood firm by a story that utilizes “resolve”, “resolute” or “resolution”. Last year, in my quest […]

I’ve been digging deeper into the Ghost Cleanup process recently, and quite naturally my quest lead to Paul Randal’s blog. He has a post about the Ghost Cleanup process in depth, and in this post is this line: The ghost cleanup task will leave a single record on the page to avoid having to deallocate […]

  Here we are at TSQL Tuesday #37 – the start of the fourth year. Sebastian Meine (@sqlity / blog) is hosting this month’s T-SQL Tuesday blogging party, and he wants us to “write about topics like the good and the bad patterns of joining you have seen out there”. (Sebastian is also running a […]

Chris Yates (@YatesSQL / blog) is hosting the T-SQL Tuesday blogging party this month, and he wants to know “What does the SQL Community mean to you?”. SQL Community To me, the SQL Community is folks helping other folks. Being supportive. Giving advice. Mentoring. Teaching others to fish from the SQL Pond. From what I’ve […]

The Myth One misconception that I see a lot deals with how data is stored in a clustered index. Specifically – is the data in a clustered index stored on the page in physical order? Most people will say “Yes”, and they get this from the definition (see BOL: Clustered and Nonclustered Indexes Described), which […]

The Scenario: You just restored a production database on a development server. You’ve told the developers that it’s restored, and you start to relax in your chair. 30 milli-seconds later, your phone is ringing… the developers can’t connect to the database that you just restored. You check the server, and the login exists. You check […]

%d bloggers like this:

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close