David ... I could heartily agree until I got to the part about the data model being owned by someone outside of IT.  I believe that entities should be owned...

I have found the following SQL very handy to do pretty much the same thing -- check on the progress of a back up. You can substitute whatever other...

You will have to troubleshoot it by breaking it down into its parts. From the error message, it looks like you cannot execute the sqlcmd statement. To test...

I found this one somewhere (whoever you are, I really thank you!). Anyway, it is slightly different, but works great. For what it is worth.

#

cls

$SQLCmd = get-content "C:\PSFiles\PS1Executables\RunYourSqlFromHere.txt"

foreach...

Mayank ... this was helpful. You simplified the way SQL Server performs routine index operations. I hope all application vendors read what you wrote.

I have had experience...

Hugo ... nice article. Thanks.

I guess what I am about to say is akin to stating a religious dogma (or opposing a religious dogma). Nothing seems as contentious...

Ed, I think you're right. The only exception I would like to mention what occurred is in my "previous life" as a mainframe (DB2) DBA. Our data tables...

My current employment only uses purchased software. I find it amazing how many vendors do not create their indexes with a fill factor (other than the default). The...

Tom ... I really appreciate what you have demonstrated. I have been around awhile, first working on mainframe and Unix databases, and now for the last few years with...

Excellent. Thanks.

Thank you for providing this. I had to implement transactional replication without training and it wasn't pleasant. I still struggle with some aspects of it, especially the way...

I know this thread is a bit stale, but I just saw your post. True enough about crediting IBM with the first VM. I am dating myself, but I...

As I mentioned, continuous operations. SQL Server doesn't see that much of it yet, but it will be coming with a vengence. I don't mean "24x7" (which gets...

I really appreciated the article. I am a transplanted mainframe DB2 DBA and cursor processing was the standard on that platform. It had some additional features that allowed...

Thank you. I learned something about what I took for granted!