Viewing 15 posts - 1 through 15 (of 51 total)
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...
February 14, 2017 at 7:26 am
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...
December 27, 2016 at 9:41 am
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...
June 20, 2016 at 11:53 am
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.
$SQLCmd = get-content "C:\PSFiles\PS1Executables\RunYourSqlFromHere.txt"
May 17, 2016 at 9:33 am
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...
April 11, 2016 at 9:09 am
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...
March 8, 2016 at 10:16 am
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...
February 29, 2016 at 2:24 pm
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...
February 16, 2016 at 3:36 pm
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...
December 29, 2015 at 7:47 am
November 5, 2015 at 1:11 pm
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...
November 5, 2015 at 7:37 am
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...
October 12, 2015 at 9:36 am
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...
May 7, 2015 at 6:34 pm
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...
May 7, 2015 at 4:08 pm
Thank you. I learned something about what I took for granted!
February 2, 2015 at 9:07 am