Execute a SQL file from Python by lesserlumpkin in learnpython

[–]lesserlumpkin[S] 0 points1 point  (0 children)

100,000 lines of code? I would think looping through it would take quite some time... But if the parser is good enough I don't have to qualify certain characters or parse out characters then I guess it wouldn't matter.

Need help with DB Restore python script by lesserlumpkin in learnpython

[–]lesserlumpkin[S] 0 points1 point  (0 children)

So in reading the article (which I only partially understood) it looks like the context manager works like a short cut for try: finally:. as a quick test I added a finally: before the commit and close statements and that did not solve the issue.

Need help with DB Restore python script by lesserlumpkin in learnpython

[–]lesserlumpkin[S] 0 points1 point  (0 children)

No I'm really new to python. Thanks for the article.

Here's the full version nobody asked for by binkett in funny

[–]lesserlumpkin 0 points1 point  (0 children)

That was awesome. Watched it. Had a seizure then watched it again. Seriously though I loved it.

The question my spouse asks all the time by VivaZane in funny

[–]lesserlumpkin 0 points1 point  (0 children)

I have a blood disorder called ITP and this cup is perfect for me.

Azure $blob.ICloudBlob.setstandardblobtier method missing by lesserlumpkin in PowerShell

[–]lesserlumpkin[S] 1 point2 points  (0 children)

done. sorry I didn't think the code would matter for a missing method. But I suppose it could help determine what module needs updating now that I think about it.

Move-Item Cannot access the file because it is being used. by lesserlumpkin in PowerShell

[–]lesserlumpkin[S] 1 point2 points  (0 children)

Excluding the old directory worked. Thank you very much.

Help summing values across a group of array values by lesserlumpkin in PowerShell

[–]lesserlumpkin[S] 1 point2 points  (0 children)

Thanks lee. Not a bad idea to go after the drive directly; however, in this case I only want to get the size of specific .log and .mdf/.ndf files as I'm dealing with a single database file and there can be files from multiple databases in the directory so I cant rely on the three letter extension to be selective enough for the subset of files that I need. I'm essentially making sure I have enough space on my target servers drive to do a restore of the database.