I am trying to import the data from Excel file into SQL Server database. I am unable to do so because I am getting following errors in the log file. Please help. The log erros are as as follows:-
[OLE DB Destination [42]] Error: An OLE DB error has occurred. Error code: 0x80040E21. An OLE DB ...
@swasheck The fine sponsored mailing from PASS this morning. The trainers that are associated to the scripts have sued people in the past for providing training that was similar to their training. Seems in their part of Europe, they have exclusive access to all things SQL Server
You have mentioned TF 3214 in your materials. That's an undocumented TF that we cover so you can stop offering training on that or we'll sue you
At least, that was my 3rd party recollection of the skirmish
@swasheck Some years ago Ramesh decided Adam had given a PASS Summit talk based on some post or other Ramesh had written...without Adam giving him credit for the technical knowledge (!). It was something pretty basic about sort spills. Of course, Adam had never heard of the guy, but that didn't stop R being a dick and threatening to get lawyers involved.
i'd be tempted to reply as such, too. "we have patented such blatant legal extortion. we order you to cease and desist such activities or we will have to settle this in court."
@PaulWhite Interestingly enough, if I use the PoSH/SMO alternative, I have to grow it in KB, not MB or GB. Sort of addresses that bug, but also kind of annoying.
While running a T-SQL script that is performing massive amounts of deletes, I had the unpleasant experience of causing some sort of lock contention that prevented inserts of data in some tables for other connections. I tried to remedy this by breaking down the request into smaller transactions wi...
@MikeFal Ha. By the way, we haven't found the right day to try the hot sauce yet, but that doesn't mean I've forgotten or that I'm not looking forward to it.
i had a full english breakfast ... i thought i'd hate the baked beans (because i dont like baked beans) but i tried it in order to engage the culture. i actually liked it
@ConcernedOfTunbridgeWells you always know when the chili sauce is what did it to you
@ypercube You need it in the Powershell script. It's a syntactical thing, PoSH treats < and > like shell scripting, so you need -lt to denote less than
I suspect he's just trying to ensure he presents, so by having as many submissions as possible he has the breadth that if they pick any one, he has time to brush up on it... I mean, that's evident, right?
I firmly believe that giving two amazing talks for them to have to decide between is a much better alternative than "pick something off my laundry list please"
Because when you submit two with amazing briefs that fit the market and the expected skill level, it's just like applying for a job. You've done the research.
I only ever throw out two or three resumes at a time when I decide to switch jobs.
I could probably drop to 1 at this point in my career
I don't do the broad shot approach, it doesn't benefit anyone
While I agree that you may have one or two outliers that really want to know the top-level highly indepth information, generally you need to target the intermediate audience
Sure, there's DBA things and that's a core tenant but get into the fuzzy stuff, maybe there's interest in Excel Cube Functions. It's a valid thing but is Excel a SQL Server topic.
IF there is that much demand for several deep technology talks at the senior audience, then you should organize a second SQL Saturday in the region and MARKET THE TWO FOR THE DIFFERENCES
So, short story: I agree with Aaron. Homeboy is throwing down way too hard.
SELECT *
FROM Financial.AccrualsFact af
INNER JOIN Financial.IncomeExpenseReportDateWork w
ON af.ReportToDateKey IN (w.CurrentReportToDateKey, w.PriorReportToDateKey)
They haven't posted the slides from Summit but I sat through a presentation and have jumbled which was which.
The way my friend has his company structured, I believe is LLC. He takes a reasonable salary and the rest is passed through to the corporation of which, he's the only person at and he gets the rest of the earnings as ... dividends or whatever. Which is a lower tax rate than "straight" earnings. Plus, allows him to deduct everything (gas, internet, phone, etc)
YMMV, consult a lawyer and an accountant, etc. The other bit of advice I've been given is to have a sizeable reserve on hand (6 months preferable)
Client terms might be such that you don't get paid for up to 60 days from when you start billing.
That's strange, because from what I read, you get taxed less with an s-corp, i.e., you make 200k salary, and only take 100k for yourself, you only get taxed on that.
then whatever is left after expenses is distributed
FWIW I have been actively consulting since 1998 and I have never formed any type of corp, just go for 1099s. Not that that's what you should do, just a frame of reference. It's actually a good compromise - I can still claim all the usual business expenses (portion of home office, portion of vehicle, meals etc.) and the only extra paperwork is an extra form in April.
@AaronBertrand Yeah, I asked for 1099. This particular client is asking for corp-to-corp
@AaronBertrand I suppose this is what I was eluding to with the taxes (from those differences)
> Self-employment taxes. S corporations may have preferable self-employment taxes compared to the LLC because the owner can be treated as an employee and paid a reasonable salary. FICA taxes are withheld and paid on that amount. Corporate earnings after payment of the salary may be able to be treated as unearned income that is not subject to self-employment taxes. For more information and whether this might apply to your particular situation, please contact your accountant or tax adviser.
@Kermit don't know, sounds like the difference would still be taxed if you take the remainder out in any way; I don't know how much more expensive self-employment taxes are compared to standard income tax. You should contact a tax advisor.
Health should be an obvious one, especially since you are not single and have dependents - if your wife works you may be able to piggy-back off hers (that's what I do, only because wife's company is bigger and a couple of better benefits). If not, it can be quite expensive.
You should really scope that out because the difference may be astounding (depends on your state and what offerings there are for self-employed).
So one hand you look at this bigger check but you have to take into account the extra that's going to come out at some point.
When I was earning less and doing more consulting to compensate, irregularity of pay sucked. For example I'd do a website for $20K and get this fat check for a month's work, then no pay for a few months while I sourced and started on a new project. Maybe not the case for you if you are going to have a single client, but to keep in mind
Seems like an ineffective way to protest the police seeing as how without them you would get pancaked by people coming around that corner. Problem two is that pissing off the general populous is never a good way to get your message acrossed.
I am trying to import the data from Excel file into SQL Server database. I am unable to do so because I am getting following errors in the log file. Please help. The log erros are as as follows:-
[OLE DB Destination [42]] Error: An OLE DB error has occurred. Error code: 0x80040E21. An OLE DB ...
wow!this is the site where learning/reading materials are found.....thanks
