Welcome to Day 12 of my “A Month of PowerShell” series. This series will use the series landing page on this blog at http://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.

Creating Logins

One of the… Read more

Welcome to Day 11 of my “A Month of PowerShell” series. This series will use the series landing page on this blog at http://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.

Yesterday we took a look… Read more

Welcome to Day 10 of my “A Month of PowerShell” series. This series will use the series landing page on this blog at http://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.

Yesterday, a couple of different… Read more

Welcome to Day 9 of my “A Month of PowerShell” series. This series will use the series landing page on this blog at http://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.

This blog series is about… Read more

Welcome to Day 8 of my “A Month of PowerShell” series. This series will use the series landing page on this blog at http://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.

What is a snippet?

In… Read more

Welcome to Day 7 of my “A Month of PowerShell” series. This series will use the series landing page on this blog at http://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.

Sending messages to the user

Read more

Welcome to Day 6 of my “A Month of PowerShell” series. This series will use the series landing page on this blog at http://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.

Frequently when working with PowerShell,… Read more

Welcome to Day 5 of my “A Month of PowerShell” series. This series will use the series landing page on this blog at http://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.

After spending 4 days going… Read more

T-SQL Tuesday Party History

In case you’ve been hiding out in the desert, oblivious to all that goes on, there is a monthly force that comes out for a party on (normally) the second Tuesday of each month. It was started by Adam Machanic (blog|twitter), and… Read more

Welcome to Day 4 of my “A Month of PowerShell” series. This series will use the series landing page on this blog at http://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, part deux

Yesterday we… Read more

Welcome to Day 3 of my “A Month of PowerShell” series. This series will use the series landing page on this blog at http://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… Read more

Welcome to Day 2 of my “A Month of PowerShell” series. This series will use the series landing page on this blog at http://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… Read more

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… Read more

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

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”. Read more

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…

Read more

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… Read more

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… Read more

 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… Read more

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… Read more