Ben Miller Blog - SQL Server and PowerShell

Let’s Talk Shop

When You Love Data as Much as I Do…

I’ve been working in data for a long time. After a while, you recognize the issues that everyone runs into sooner or later—and hopefully, can come up with some pretty creative solutions. I love being able to wax profound (or at least, long-winded) about why these issues come up and how I like to go about resolving them. Or just pose a question to my fellow data professionals so we can discuss. Check out my past blog articles here, or get in touch if there’s a topic you think I should cover.

Portrait of smart casual businessman looking at camera in contemporary office

Featured

Why Become a PowerShell DBA

If you find this article valuable and you decide that you want to get your learn on with PowerShell and SQL Server, there is a SQLSkills class that I am teaching this year, please join me to get a great start in how to get your toolset growing by adding PowerShell to your toolbelt. Early

February 20, 2019

Recent

The Best Thing I Learned at PASS

Being that I have never missed a PASS Summit yet (in the US), I thought I would share my experience about last PASS and previous PASS conferences. I attended a Pre-Con with Kalen Delaney on Query Tuning and Plan Guides. I also remember sessions last PASS that were very relevant to my job. Each year

July 1, 2009

Windows 7 is pretty cool

I have downloaded Windows 7 and installed the x64 version on my Dell Latitude D820 last week. My experience is this: 4 GB, Core 2 Duo 2.0 GHz, 200 GB – 7200 RPM drive. Install: < 30 minutes from CD in drive to Login Boot-up: < 20 seconds from Off to Login The only thing

January 18, 2009

GP 10 and eConnect and RMTransaction

I have been working on a project that involves eConnect 10 for Microsoft Dynamics GP 10. The documentation exists, but is very sparse when it comes to specifics about using the interface. When using the RM transactions and distributions, the first bite that we had was that there is a property in the taRMTransaction called

October 24, 2008

Vista SP1 on x64

I have installed SP1 on my Dell Lattitude D820 with Vista Ultimate x64 on it. It is quite a bit more snappy in the internet browsing, and the OS seems to not be so sluggish. I don’t have any more than that as I just installed it, but thought I would share that the install

March 19, 2008

Vista and IIS and ASP

I was doing a project and it involved ASP connecting to SQL Server. Now this was a script that was being snipped, so there was a potential of having script errors. So I went through the following ordeal and found that there was a configuration that would help me to be effective in troubleshooting my

February 11, 2008

SQL PASS 2007 has concluded

I went to the SQL PASS 2007 Summit this past week, and I have to say that this was one of the best ones I have been to. I went to a pre-conference session with Kalen Delaney on Managing and the Reuse of Query Plans. Everything that I learned, I could use in my current

September 24, 2007

Error in SQL (Error: 17806, Error: 18452) SSPI Problem

I recently came across this while managing a clustered SQL Server. There were various messages listed out on forums, etc., but for me we found that the error was originating because we have DNS issues and Domain Controllers (DC) was unreachable due to a network switch configuration problem. So if you see these errors, you

August 31, 2007

Working with SSIS in SQL Server 2005

I thought I would document my exploits in SQL Server SSIS 2005 conversion of DTS packages and the scheduling. I had a DTS package that used the ProtectionLevel “Encrypt Sensitive Data with User Key” that I did not design or create. When I migrated them from SQL 2000 to SQL 2005, I used BI studio

August 20, 2007

SQL 2005 Cluster bug on connect

I just created a Connect item about my post on SQL Server 2005 clustering. Feel free to vote on this bug. Connect Item 289092 Have a happy day.

July 25, 2007

Verified SQL 2005 Cluster bug…

In an earlier post, I mentioned a bug that I think that we found in SQL Server 2005 Clustering. I have confirmed the bug. The bug goes again like this: You have 2 Windows 2003 machines and one or both have been named with lower at least 1 lower case letter in the name. Now

July 23, 2007

My podcast on MVP with April Spence

I just found out that they released the podcast on Voice of Support on Channel 9 that features myself and April Spence (MVP Lead). I know that I am no longer with Microsoft, but it does not change my opinion or passion for MVPs. The podcast is here. Check it out.

July 5, 2007

SQL Server and Clustering

I will be setting up an environment to repro an issue that we found in installing a SQL Server cluster. We had 2 Windows Server 2003 R2 Enterprise servers that we were to cluster and then put SQL 2k5 in a cluster as well. We go to the point of installing the SQL Server in