« first day (2010 days earlier)      last day (2858 days later) » 

mmarie
mmarie
3:53 AM
@wBob Thanks! How did you automate/schedule your Polybase queries to import data without using Data Factory?
 
 
5 hours later…
wBob
wBob
9:02 AM
@mmarie You just run ordinary T-SQL (with Polybase extensions). Polybase runs under the hood. There is an SSIS Feature Pack you might be interested in. We found loading data to ADW with the conventional SSIS OLEDB connectors really slow. Once you've set up an external table, loading a file is just a matter of it being in the right directory (Azure Blob Storage or HDFS).
 
 
2 hours later…
Tom V
Tom V
11:10 AM
"Oh, we're doing OCR in the database layer"
 
Marian
Marian
@TomV wtf? windows.forms, system.drawing?
 
ConcernedOfTunbridgeWells
ConcernedOfTunbridgeWells
@TomV * Smack *
Why?
 
Tom V
Tom V
God knows
it's a third party thing that happens to be the top CPU consumer on this instance
I kindly asked them to get off my lawn and remove that crap from my production instance
The "kindly" that involves men in long white coats and syringes.
 
ConcernedOfTunbridgeWells
ConcernedOfTunbridgeWells
@TomV And there is the #1 reason that you don't put CLR sprocs in your database for application code. You're paying database licensing on the CPUs you're running it on. I remember having this discussion nearly 15 years ago with java folks who thought Java sprocs running on an Oracle DB were just the best thing since sliced bread.
 
Tom V
Tom V
11:26 AM
LOL, that company's lead architect has "lifetime learner" in his linkedin blurb
I hope he lives a long life because he has a lot to learn
 
ConcernedOfTunbridgeWells
ConcernedOfTunbridgeWells
11:41 AM
Intelligence is figuring out how to do OCR from a stored procedure.
Wisdom is knowing why it's a really bad idea.
6
 
Phil
Phil
11:59 AM
@ConcernedOfTunbridgeWells How's things? Are you back to work yet?
 
ConcernedOfTunbridgeWells
ConcernedOfTunbridgeWells
@Phil Yes. I've been back in work since May.
How's life in SAP Land?
 
ypercubeᵀᴹ
ypercubeᵀᴹ
@ConcernedOfTunbridgeWells We were discussing with Jack yesterday that you are the only one that can initiate a gathering ;)
 
ConcernedOfTunbridgeWells
ConcernedOfTunbridgeWells
@ypercubeᵀᴹ Shall I initiate one then?
 
ypercubeᵀᴹ
ypercubeᵀᴹ
It's fine with me. I'll be away from 9-24 August
 
ConcernedOfTunbridgeWells
ConcernedOfTunbridgeWells
Hm. I'll be away from 20 aug to either 4 or 11 Sep. Maybe after that?
 
ypercubeᵀᴹ
ypercubeᵀᴹ
12:14 PM
There's still a whole month till August. Perhaps end of July / first days of August?
 
ConcernedOfTunbridgeWells
ConcernedOfTunbridgeWells
I've got someone staying with me until the end of July and I'll also be prepping for a house move. After that I'll be moving house then overseas for 2-3 weeks.
 
ypercubeᵀᴹ
ypercubeᵀᴹ
Ah. September then.
 
ConcernedOfTunbridgeWells
ConcernedOfTunbridgeWells
How about September 15?
 
ypercubeᵀᴹ
ypercubeᵀᴹ
I'm moving too at July 23.
 
ConcernedOfTunbridgeWells
ConcernedOfTunbridgeWells
@ypercube @Martin Smith @MarkSinkinson @MarkStoreySmith @JackDouglas @JamesLupolt - How about September 15 for drinkies?
6
@Darth_Wardy - do you live in or about London?
@Phil - fancy a sojourn down to London on Sep 15?
 
wBob
wBob
12:17 PM
@ConcernedOfTunbridgeWells That's the week after SQL Sat Cambridge.
 
ConcernedOfTunbridgeWells
ConcernedOfTunbridgeWells
September 22 then?
@wBob - do you live anywhere near London?
 
wBob
wBob
@ConcernedOfTunbridgeWells sorry I'm just thinking out loud - 15th was a fine suggestion.
@ConcernedOfTunbridgeWells Midlands. Work "down there" sometimes : )
 
ConcernedOfTunbridgeWells
ConcernedOfTunbridgeWells
Fancy a trip down for drinkies?
We do a semi-regular drinkies in London for folks who live in the area.
 
wBob
wBob
@ConcernedOfTunbridgeWells I would like to sometime, definitely. I sometimes come down for the SQL Supper user group and/or work permitting.
 
ypercubeᵀᴹ
ypercubeᵀᴹ
Haha, they corrected my code and made it worse
 
ConcernedOfTunbridgeWells
ConcernedOfTunbridgeWells
12:21 PM
@wBob Pencil in 15 September then. We can see if anyone's got somewhere you can crash. Unfortunately I probably won't by then.
 
wBob
wBob
@ypercubeᵀᴹ [chants] rollback ... rollback ... ROLLBACK!
@ConcernedOfTunbridgeWells [pencilling] thanks for the invite
 
Darth_Wardy
Darth_Wardy
12:38 PM
@ConcernedOfTunbridgeWells nope
 
Tom V
Tom V
@ConcernedOfTunbridgeWells Poking around that database I guess they wanted to support different systems (NAV, AX and CRM) without writing too much logic in the different systems but also without writing a middle tier
 
ConcernedOfTunbridgeWells
ConcernedOfTunbridgeWells
@TomV Doubtless it was something like that. Bone-headed architectural decisions are frequently underpinned by bone-headed political constraints and objectives.
I've heard an aphorism that goes something to the effect of 'Any sufficiently large software project will have a structure that mirrors the political structure of the organisation implementing it.'
 
Jack Douglas
Jack Douglas
1:29 PM
@ConcernedOfTunbridgeWells you moving?
ah
reading back :)
 
James Lupolt
James Lupolt
1:43 PM
@ypercubeᵀᴹ I noticed that Hillary Clinton is not popular in Greece:
Is that likely related to her son-in-law's hedge fund?
 
Lamak
Lamak
she has some surprisingly (for me) good numbers though
 
Colin 't Hart
Colin 't Hart
2:03 PM
Urgh, I'm in the 14% of the Swedes then.
 
swasheck
swasheck
2:37 PM
@Colin'tHart me too. except i'm not swedish.
also ... i have no confidence in trump, either.
 
Tom V
Tom V
Q: Do you have confidence in $politician doing the right thing for the world, A: No
 
swasheck
swasheck
ding ding ding
so ... go wales
 
Aaron Bertrand
Aaron Bertrand
2:57 PM
Oh people are awesome.
I can do without your help, thanks. Please don't answer to any of my questions in the future or you will have to live with appropriate responses to your "suggestions". — John 2 mins ago
Makes me so happy I decided to contribute an answer today. And makes me wonder why the hell I bother.
People are ungrateful tools.
 
swasheck
swasheck
@AaronBertrand LIVES!
 
Aaron Bertrand
Aaron Bertrand
Yo, how is everyone doing? Sorry, two kids keep me f*ing busy
 
swasheck
swasheck
it's the way life goes
doing well
people are getting laid off here
 
ypercubeᵀᴹ
ypercubeᵀᴹ
3:13 PM
@JamesLupolt We have no confidence for Americans at all. Being a woman doesn't help ;)
@JamesLupolt First time I've heard of that. Was this something that hit the news recently?
 
James Lupolt
James Lupolt
@ypercubeᵀᴹ His hedge fund that tried to game the Greek financial crisis and failed? I've noticed more articles about it lately but it might just be my filter bubble.
 
swasheck
swasheck
> This problem occurs when you open a text file or CSV file and the first two characters of the file are the uppercase letters "I" and "D".
yay excel bug!
 
billinkc
billinkc
3:43 PM
Design choice, effendi
 
mmarie
mmarie
4:02 PM
@wBob Yeah. I know how Polybase works. I meant are you using SSIS, ADF, or Powershell with run books to schedule the queries/stored procedures.
@wBob Yeah. I meant are you using SSIS, ADF, or Powershell with run books to schedule the queries/stored procedures.
@swasheck Like right now today?
 
swasheck
swasheck
@mmarie yesterday we lost some mgmt
not going to lie ... i'm polishing the resume just in case
 
mmarie
mmarie
@swasheck If you want to come to the BI side, you know how to contact me ;-)
 
swasheck
swasheck
i dont know how to bi
 
Aaron Bertrand
Aaron Bertrand
I can spell it.
 
James Lupolt
James Lupolt
we have two vacancies now
 
Aaron Bertrand
Aaron Bertrand
4:08 PM
I can also make juvenile jokes about it.
 
ypercubeᵀᴹ
ypercubeᵀᴹ
@JamesLupolt on bi?
 
James Lupolt
James Lupolt
@ypercubeᵀᴹ for sql server DBAs
 
swasheck
swasheck
@AaronBertrand setting the bar pretty high, eh?
@JamesLupolt quite the commute
 
Aaron Bertrand
Aaron Bertrand
@swasheck always.
 
swasheck
swasheck
@JamesLupolt is one of them your position?
 
James Lupolt
James Lupolt
4:09 PM
@swasheck yes, i'm moving to another company nearby next month
 
ypercubeᵀᴹ
ypercubeᵀᴹ
1
Q: How much disk space do I need to add a primary key to a very large table?

GlazedI'm using Microsoft SQL Server 2014 - 12.0.4100.1 Enterprise Edition (64-bit) on Windows NT 6.3 (Build 9600: ) I have a 491 GB table with 3.6 billion rows that does not have a primary key. The primary key I wish to add will only cover a single bigint column which contains unique values. The dat...

sql-server-2014
 
bluefeet
bluefeet
morning heapers
 
swasheck
swasheck
@JamesLupolt congrats!?! i know that's something you've entertained for a while
 
mmarie
mmarie
morning @bluefeet
 
swasheck
swasheck
@bluefeet you're late
 
James Lupolt
James Lupolt
4:10 PM
@swasheck thanks
why are people getting laid off?
 
bluefeet
bluefeet
@swasheck late posting in here, I've been lurking though
 
swasheck
swasheck
@JamesLupolt new cto's initiative. brought in to trim the fat. he's a hatchet
 
James Lupolt
James Lupolt
i'll be surprised if they let you go
 
swasheck
swasheck
it's not likely, honestly. however, the workload is going to intensify significantly for me. between training my teammates' replacements and picking up their on-call shifts, i'm going to be grumpier than i already am
 
James Lupolt
James Lupolt
oh
your teammates have left? or you think they'll get laid off?
 
billinkc
billinkc
4:13 PM
/me googles how seth could be any grumpier
 
swasheck
swasheck
@JamesLupolt some have been victims
@billinkc piss off
 
billinkc
billinkc
Aug 19 '14 at 14:33, by swasheck
i'm always angry
Although I was looking for where you had linked the Avengers scene
 
swasheck
swasheck
whoah! nearly two years ago!
 
Andriy M
Andriy M
@swasheck I think always covers that.
 
swasheck
swasheck
fair enough
 
wBob
wBob
4:39 PM
@mmarie Sure, we were using a conventional SSIS with Agent job. We looked at ADF, I mean, it's raw.
 
mmarie
mmarie
@wBob Yeah, I'm not a fan of ADF. But my project is all azure with no VMs, so SSIS is out. So I'm probably doing some ADF or using PowerShell with a run book.
 
wBob
wBob
@mmarie Good luck! : )
 
 
1 hour later…
Tom V
Tom V
6:18 PM
GO WALES!
 
swasheck
swasheck
6:43 PM
^^^ +1
eff portugal.
> "It is without question the biggest game in 140 years of Welsh international football history."
espn hype machine
 
 
2 hours later…
Tom V
Tom V
8:28 PM
 
swasheck
swasheck
ahahahahahaahahahaha
 
 
1 hour later…
wBob
wBob
9:36 PM
0
A: Change Name of Extended Event Session

wBobNo, there is no way to rename an Extended Events session without dropping and recreating it. The NAME property is not part of the ALTER EVENT SESSION syntax, nor is it supported by sp_rename. Simply use SSMS to script and recreate the session easily. You don't lose anything by doing this.

I wanted to finish this reply with "Anything else?" <- Kylo Ren reference
but it sounds a bit rude. What do you think? : )
 
Lamak
Lamak
@wBob I wouldn't get the reference because I haven't bother with the last star wars movie. I would take your comment at face value
 
wBob
wBob
@Lamak lol ok. It's not so bad.
 

« first day (2010 days earlier)      last day (2858 days later) »