SMO and Index Fragmentation

When working with SMO and Indexes there are times that you want to get the fragmentation of this particular index.  In SMO there is a method on the Index called EnumFragmentation.  When you call this method, there is a bug in SMO out on Connect (SMO Index Enum Fragmentation…) that you should vote for.  This… Continue Reading

Powershell, SMO and Database Files

In response to some questions about renaming a physical file for a database, I have 2 versions of Powershell scripts that do this for you, including taking the database offline and then online to make the physical change match the meta-data. First, there is an article about this at http://msdn.microsoft.com/en-us/library/ms345483.aspx.  This explains that you start… Continue Reading

An honor to be among the SQL Server MVPs

I just found out last night that I was officially awarded SQL MVP.  I am honored to be among those that I respect and admire.  I don’t contribute for the recognition and as a former MVP Lead I know the caliber of those that contribute to the SQL Server community, and even those that are… Continue Reading

I am loving Office 2010

I have installed Office 2010 and found that Office OneNote is included in the Office 2010 Professional Plus. It is a very nice Suite of products and is very clean and polished. The thing I love most is the improved version of Outlook. It is now in the same realm as the other products in… Continue Reading

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… Continue Reading

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… Continue Reading

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… Continue Reading

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… Continue Reading

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… Continue Reading

Filed Under: IIS
Skip to toolbar