SQLPHX

Each day brings you life lessons, some are just harder to process

[SQLPHX @SQLPHX1]

@SQLEspresso Thank you!

[SQLPHX @SQLPHX1]

@SQLEspresso Monica, if I sign up for the session and I am not able to attend, would it be recorded so it can be viewed later?

[The Lincoln Project @ProjectLincoln]

Here’s the letter George H. W. Bush left Bill Clinton on the first day of his presidency.

A lesson in grace.

[SQLPHX @SQLPHX1]

Then I need to grab the appropriate columns from Excel and add them to the “H”eader or “L”ine line in order to import the CSV. I don’t use excel much, any recommendations on the quickest way to do this? Thanks! #sqlhelp 2/2

[SQLPHX @SQLPHX1]

I have an excel spreadsheet that needs to be converted to CSV following using a certain format, then imported into the db. The primary key will be created during the import but I have to split each Excel line into 2 lines on the CSV file: “H” & “L” (header and lines) #sqlhelp 1/2

[SQLPHX @SQLPHX1]

@DesertIsleSQL Makes sense. I have been telling everyone that it was such a great experience and that's how a conference should be run. Had fun seeing you on the panel during the Speaker Idol finals!

[SQLPHX @SQLPHX1]

@SQLEspresso You did a great job! Thank you!

[SQLPHX @SQLPHX1]

@SQLEspresso I am there! Looking forward to the precon!

[SQLPHX @SQLPHX1]

@SQLEspresso Thank you! Registered and looking forward to it.

[SQLPHX @SQLPHX1]

@pshore73 @ALevyInROC @psdbatools Thank you for all your help!

[SQLPHX @SQLPHX1]

Starting out as "accidental dba" & wanted to see what you use to automate manipulation of CSV files. I get a CSV file from a vendor with a lot of garbage in it. Is there a way to automate it so I can pull only certain fields from it and then import it into my DB? Thx! #sqlhelp

[SQLPHX @SQLPHX1]

@pshore73 @ALevyInROC Thank you, guys. I have no experience with PowerShell. Would you recommend any sources to help me get started to tackle this issue? I assume there are already scripts out there that can be modified? Thanks again!

[SQLPHX @SQLPHX1]

@hackdba Different file name each time. Thanks!

[SQLPHX @SQLPHX1]

@beeftext I lost all my combos after the update. Is there any way to get them back or I lost everything? Thanks!

[SQLPHX @SQLPHX1]

@DesertIsleSQL @DataCamp Congratulations!

[SQLPHX @SQLPHX1]

@SQLEspresso @MVPAward @DCACco Congrats! Well deserved!