July 11, 2016 at 9:13 am
jasona.work (7/11/2016)
Michael L John (7/11/2016)
jasona.work (7/11/2016)
Ed Wagner (7/11/2016)
jasona.work (7/11/2016)
Boy what a weekend.../*Snipped*/
Yeah, we've looked at a whole-house generator, right now it's just not in the budget. Considering we'd only want to keep the fridge and sump running, it would be something of overkill as well, although it would have the benefit of running even if we weren't home...
As for the storm, you would almost think we had a tornado (or the beginnings of one) from the way the wind was swirling around...
My new house has a whole house generator. I can't figure out how to work it!
There's an easy way to figure that out...
Go outside and take an axe to the power lines to your house, you'll figure out the generator right-quick.
:hehe:
Actually, the significant other will know how the generator works as he will be walking back from the next county! 😉
July 11, 2016 at 9:49 am
djj (7/11/2016)
jasona.work (7/11/2016)
Michael L John (7/11/2016)
jasona.work (7/11/2016)
Ed Wagner (7/11/2016)
jasona.work (7/11/2016)
Boy what a weekend.../*Snipped*/
Yeah, we've looked at a whole-house generator, right now it's just not in the budget. Considering we'd only want to keep the fridge and sump running, it would be something of overkill as well, although it would have the benefit of running even if we weren't home...
As for the storm, you would almost think we had a tornado (or the beginnings of one) from the way the wind was swirling around...
My new house has a whole house generator. I can't figure out how to work it!
There's an easy way to figure that out...
Go outside and take an axe to the power lines to your house, you'll figure out the generator right-quick.
:hehe:
Actually, the significant other will know how the generator works as he will be walking back from the next county! 😉
That ax idea is a good one. I will try that out tonight when I get home!!! It's better than cutting the grass!
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
July 11, 2016 at 10:31 am
Michael L John (7/11/2016)
djj (7/11/2016)
jasona.work (7/11/2016)
Michael L John (7/11/2016)
jasona.work (7/11/2016)
Ed Wagner (7/11/2016)
jasona.work (7/11/2016)
Boy what a weekend.../*Snipped*/
Yeah, we've looked at a whole-house generator, right now it's just not in the budget. Considering we'd only want to keep the fridge and sump running, it would be something of overkill as well, although it would have the benefit of running even if we weren't home...
As for the storm, you would almost think we had a tornado (or the beginnings of one) from the way the wind was swirling around...
My new house has a whole house generator. I can't figure out how to work it!
There's an easy way to figure that out...
Go outside and take an axe to the power lines to your house, you'll figure out the generator right-quick.
:hehe:
Actually, the significant other will know how the generator works as he will be walking back from the next county! 😉
That ax idea is a good one. I will try that out tonight when I get home!!! It's better than cutting the grass!
I hear there's this thing called "manual" that you may need to resort to. I'd suggest looking at it before looking at the ax. If it's an in-place (usually on a poured cement pad) generator, you should have an automatic transfer switch inside your house. That'll come with its own manual. They're both probably on the manufacturer's web site.
Just don't go fiddling with the big wires before you understand what they do. I'm looking forward to Pittsburgh this year and don't really want to make a trip for a funeral. And no, don't have anyone else fiddle with them either, unless they're an electrician. 😉
July 11, 2016 at 10:54 am
Ed Wagner (7/11/2016)
Michael L John (7/11/2016)
djj (7/11/2016)
jasona.work (7/11/2016)
Michael L John (7/11/2016)
jasona.work (7/11/2016)
Ed Wagner (7/11/2016)
jasona.work (7/11/2016)
Boy what a weekend.../*Snipped*/
Yeah, we've looked at a whole-house generator, right now it's just not in the budget. Considering we'd only want to keep the fridge and sump running, it would be something of overkill as well, although it would have the benefit of running even if we weren't home...
As for the storm, you would almost think we had a tornado (or the beginnings of one) from the way the wind was swirling around...
My new house has a whole house generator. I can't figure out how to work it!
There's an easy way to figure that out...
Go outside and take an axe to the power lines to your house, you'll figure out the generator right-quick.
:hehe:
Actually, the significant other will know how the generator works as he will be walking back from the next county! 😉
That ax idea is a good one. I will try that out tonight when I get home!!! It's better than cutting the grass!
I hear there's this thing called "manual" that you may need to resort to. I'd suggest looking at it before looking at the ax. If it's an in-place (usually on a poured cement pad) generator, you should have an automatic transfer switch inside your house. That'll come with its own manual. They're both probably on the manufacturer's web site.
Just don't go fiddling with the big wires before you understand what they do. I'm looking forward to Pittsburgh this year and don't really want to make a trip for a funeral. And no, don't have anyone else fiddle with them either, unless they're an electrician. 😉
Of all the things left behind by the previous owners, that's one of things that has no documentation.
It's not set up to automatically start. You need to flip off the main breaker, and then flip a breaker to the on position on a sub panel, and then start the generator. It's kind of mickey mouse. I haven't had the chance to test fire the generator yet. The garage is still too full of boxes to get at it!
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
July 11, 2016 at 11:20 am
Michael L John (7/11/2016)
Ed Wagner (7/11/2016)
Michael L John (7/11/2016)
djj (7/11/2016)
jasona.work (7/11/2016)
Michael L John (7/11/2016)
jasona.work (7/11/2016)
Ed Wagner (7/11/2016)
jasona.work (7/11/2016)
Boy what a weekend.../*Snipped*/
Yeah, we've looked at a whole-house generator, right now it's just not in the budget. Considering we'd only want to keep the fridge and sump running, it would be something of overkill as well, although it would have the benefit of running even if we weren't home...
As for the storm, you would almost think we had a tornado (or the beginnings of one) from the way the wind was swirling around...
My new house has a whole house generator. I can't figure out how to work it!
There's an easy way to figure that out...
Go outside and take an axe to the power lines to your house, you'll figure out the generator right-quick.
:hehe:
Actually, the significant other will know how the generator works as he will be walking back from the next county! 😉
That ax idea is a good one. I will try that out tonight when I get home!!! It's better than cutting the grass!
I hear there's this thing called "manual" that you may need to resort to. I'd suggest looking at it before looking at the ax. If it's an in-place (usually on a poured cement pad) generator, you should have an automatic transfer switch inside your house. That'll come with its own manual. They're both probably on the manufacturer's web site.
Just don't go fiddling with the big wires before you understand what they do. I'm looking forward to Pittsburgh this year and don't really want to make a trip for a funeral. And no, don't have anyone else fiddle with them either, unless they're an electrician. 😉
Of all the things left behind by the previous owners, that's one of things that has no documentation.
It's not set up to automatically start. You need to flip off the main breaker, and then flip a breaker to the on position on a sub panel, and then start the generator. It's kind of mickey mouse. I haven't had the chance to test fire the generator yet. The garage is still too full of boxes to get at it!
Okay, so it's a manual transfer switch. No big deal - it's actually simple to test and you sound like you already know how. Whatever you do, DO NOT EVER turn the transfer switch to on until the main feed is off. It can be deadly.
If your generator supports it, you could have an electrician replace the transfer switch with an automatic one. It won't be cheap, but it is ultra-convenient to have the generator start up and the feed switch as soon as it detects a loss of power.
July 11, 2016 at 11:33 am
Ed Wagner (7/11/2016)
Michael L John (7/11/2016)
Ed Wagner (7/11/2016)
Michael L John (7/11/2016)
djj (7/11/2016)
jasona.work (7/11/2016)
Michael L John (7/11/2016)
jasona.work (7/11/2016)
Ed Wagner (7/11/2016)
jasona.work (7/11/2016)
Boy what a weekend.../*Snipped*/
Yeah, we've looked at a whole-house generator, right now it's just not in the budget. Considering we'd only want to keep the fridge and sump running, it would be something of overkill as well, although it would have the benefit of running even if we weren't home...
As for the storm, you would almost think we had a tornado (or the beginnings of one) from the way the wind was swirling around...
My new house has a whole house generator. I can't figure out how to work it!
There's an easy way to figure that out...
Go outside and take an axe to the power lines to your house, you'll figure out the generator right-quick.
:hehe:
Actually, the significant other will know how the generator works as he will be walking back from the next county! 😉
That ax idea is a good one. I will try that out tonight when I get home!!! It's better than cutting the grass!
I hear there's this thing called "manual" that you may need to resort to. I'd suggest looking at it before looking at the ax. If it's an in-place (usually on a poured cement pad) generator, you should have an automatic transfer switch inside your house. That'll come with its own manual. They're both probably on the manufacturer's web site.
Just don't go fiddling with the big wires before you understand what they do. I'm looking forward to Pittsburgh this year and don't really want to make a trip for a funeral. And no, don't have anyone else fiddle with them either, unless they're an electrician. 😉
Of all the things left behind by the previous owners, that's one of things that has no documentation.
It's not set up to automatically start. You need to flip off the main breaker, and then flip a breaker to the on position on a sub panel, and then start the generator. It's kind of mickey mouse. I haven't had the chance to test fire the generator yet. The garage is still too full of boxes to get at it!
Okay, so it's a manual transfer switch. No big deal - it's actually simple to test and you sound like you already know how. Whatever you do, DO NOT EVER turn the transfer switch to on until the main feed is off. It can be deadly.
If your generator supports it, you could have an electrician replace the transfer switch with an automatic one. It won't be cheap, but it is ultra-convenient to have the generator start up and the feed switch as soon as it detects a loss of power.
The biggest concern for me is the actual generator. I haven't had a chance to get into it to see if it will fire up, how much maintenance it may need, and so forth. Considering that the previous owner "has a buddy that does that" for just about everything, I'm thinking that there were probably some shortcuts taken when it was installed. Plus, he was divorced 8 years ago, and had been in poor health for 5 years so there was a lot of things that needed attention at the house. I have a feeling that this hasn't been touched in a long time.
Most of that was cosmetic, like the landscaping, but you never know. Especially things that nobody would see.
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
July 11, 2016 at 12:15 pm
Michael L John (7/11/2016)
The biggest concern for me is the actual generator. I haven't had a chance to get into it to see if it will fire up, how much maintenance it may need, and so forth. Considering that the previous owner "has a buddy that does that" for just about everything, I'm thinking that there were probably some shortcuts taken when it was installed. Plus, he was divorced 8 years ago, and had been in poor health for 5 years so there was a lot of things that needed attention at the house. I have a feeling that this hasn't been touched in a long time.
Most of that was cosmetic, like the landscaping, but you never know. Especially things that nobody would see.
Sounds like you will need an oil change at least. Since I know nothing about generators, I would have a service person come and check it out.
July 12, 2016 at 5:29 am
GAAAAAAAAAAAAAAAAAAAAAAAHHHHHHHHHHHHHHHHHHHHHH!
Last week before upgrade and the stupid IP addresses for my AGs and one of my sql instances aren't responding to pings.
Who has the porkchop launcher? Does it have enough velocity to send me into orbit around the sun? I could use the head clearing.
July 12, 2016 at 5:53 am
Maybe I should get off my butt and start a blog for commenting on things like this: SIEUFERD
Yet another wonder tool (so far only an academic project) to "simplify" querying a database. The article itself can't seem to make up its mind as to whether this is just an end-user front-end or a database itself (at least it read that way to me.) Certainly no mention of how "good" the queries it constructs behind the scenes are.
It uses the SQL-92 language for the queries, so no "optimized" or specialized operators in the various vendor-specific variants. Which likely means that while it can be used against almost any back-end RDBMS as-is, I'd bet the performance of the queries will be horrible, plus you'll end up with queries that murder the back-end RDBMs itself...
July 12, 2016 at 6:54 am
jasona.work (7/12/2016)
plus you'll end up with queries that murder the back-end RDBMs itself...
Aren't there laws about this?
And if there aren't, we should all lobby Congress and the Senate. No RDBM murder!
I'd love to see their faces as they struggle to understand what we're talking about. :hehe:
July 12, 2016 at 7:01 am
Brandie Tarvin (7/12/2016)
jasona.work (7/12/2016)
plus you'll end up with queries that murder the back-end RDBMs itself...Aren't there laws about this?
And if there aren't, we should all lobby Congress and the Senate. No RDBM murder!
I'd love to see their faces as they struggle to understand what we're talking about. :hehe:
Nope a true politician would tell you they will look into it and then tax you to pay for a study that will confirm that a study needs done.
July 12, 2016 at 7:55 am
Brandie Tarvin (7/12/2016)
GAAAAAAAAAAAAAAAAAAAAAAAHHHHHHHHHHHHHHHHHHHHHH!Last week before upgrade and the stupid IP addresses for my AGs and one of my sql instances aren't responding to pings.
Who has the porkchop launcher? Does it have enough velocity to send me into orbit around the sun? I could use the head clearing.
The new explosive-ram trebuchet model might do it for you. Be warned, though... I normal reserve it for hardcore ANSI/ISO-must-always-be-portable-code users so no guarantees that you'll come back in an unflattened state. 😛
--Jeff Moden
Change is inevitable... Change for the better is not.
July 12, 2016 at 7:59 am
jasona.work (7/12/2016)
Maybe I should get off my butt and start a blog for commenting on things like this: SIEUFERDYet another wonder tool (so far only an academic project) to "simplify" querying a database. The article itself can't seem to make up its mind as to whether this is just an end-user front-end or a database itself (at least it read that way to me.) Certainly no mention of how "good" the queries it constructs behind the scenes are.
It uses the SQL-92 language for the queries, so no "optimized" or specialized operators in the various vendor-specific variants. Which likely means that while it can be used against almost any back-end RDBMS as-is, I'd bet the performance of the queries will be horrible, plus you'll end up with queries that murder the back-end RDBMs itself...
Unfortunately, spreadsheets still make the world go round. Even Double-Click.Net used to provide their "spotlight" return information as a TSV the was formatted as a grouped-columns, multi-line header that would make a really nifty spreadsheet but was a huge PITA to import as anything normalized. In other words, they may have quite the audience just waiting for something like this.
And, yeah... no guarantees on performance. There almost never is on something like this.
--Jeff Moden
Change is inevitable... Change for the better is not.
July 12, 2016 at 8:25 am
Jeff Moden (7/12/2016)
Brandie Tarvin (7/12/2016)
GAAAAAAAAAAAAAAAAAAAAAAAHHHHHHHHHHHHHHHHHHHHHH!Last week before upgrade and the stupid IP addresses for my AGs and one of my sql instances aren't responding to pings.
Who has the porkchop launcher? Does it have enough velocity to send me into orbit around the sun? I could use the head clearing.
The new explosive-ram trebuchet model might do it for you. Be warned, though... I normal reserve it for hardcore ANSI/ISO-must-always-be-portable-code users so no guarantees that you'll come back in an unflattened state. 😛
Can I borrow that when you get it back?
/begin venting
I need it for our guy in marketing who has a new title "web application specialist", whatever that means. Yesterday at a meeting we were discussing the requirements for a new project they have cooked up. I told them the best way to implement this is an SSIS package and would take me 2-3 days. I said I would be happy to work on it as soon as we can get it on the schedule. I also let them know I don't set my schedule but with the current work load it would likely be 6-9 months at the earliest. This guy then asked what is SSIS. A reasonable question but it was followed up with "guess I need to start reading up on that so I can do it myself next week". Sure, no problem, go ahead and create an SSIS package with no oversight from anybody with any actual sql knowledge. This guy even said he can just use the production database to build it. Thankfully the IT manager and I are on the same page. He asked for access to sql to build the package. I applaud his zeal and desire to learn but just going cowboy developer style in production is not going to work out too well.
/end venting
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
July 12, 2016 at 9:03 am
jasona.work (7/11/2016)
Yeah, we've looked at a whole-house generator, right now it's just not in the budget. Considering we'd only want to keep the fridge and sump running, it would be something of overkill as well, although it would have the benefit of running even if we weren't home...As for the storm, you would almost think we had a tornado (or the beginnings of one) from the way the wind was swirling around...
FYI, we have a whole house. The generac from Home Depot. The 10k one we got was around $2.5k. I poured the pad, paid about $1k for installation and testing. The big part was them moving 10 circuits from the main breaker to the included panel. Took about 1/2 day. We used propane bottles (100lb) ones to power it, chained to a post set in the ground. I have 2, change them periodically, but it's been really nice.
I think you can get by with a smaller, 7k one if you just need a few things, but it's probably still a $3k job, if you do some work yourself.
Viewing 15 posts - 54,916 through 54,930 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply