Joined November 2008
- Tweets 646
- Following 204
- Followers 192
- Likes 255
30 Photos and videos
19 Jul 2023
#ADF Azure Data Factory How do you get the error message from a script activity. I have tried @activity('ActivityName).error.Message
@activity('ActivityName').error?.message
@activity('ActivityName').output.errors[0].Message
All fail with error(s) property does not exist.
1
53
30 Jun 2023
#sqlhelp I am getting this in SSMS
An error occurred while executing batch. Error message is: Index (zero based) must be greater than or equal to zero and less than the size of the argument list.
Once it starts all queries even sp_who get this. Open a new window it works fine.
166
Lance Harra retweeted
19 Dec 2022
This feature is blowing our minds. On Spellbook, you can have the AI read an entire contract and draft an email.
It provides an overview of the contract and potential risks. The wild part is how often it's right.
Try it for yourself👇
269
379
1,935
11,023,980
Lance Harra retweeted
30 Mar 2023
"Ambition is when you expect yourself to close the gap between what you have and what you want.
Entitlement is when you expect others to close the gap between what you have and what you want."
– @JamesClear
1
3
460
Lance Harra retweeted
20 Feb 2023
Interesting Reading: Trove of spices from around the world found on sunken fifteenth-century Norse ship buff.ly/40MeZkP
2
5
554
Lance Harra retweeted
9 Jan 2023
🚨 NEW GIVEAWAY!! 🚨
Sending 2 random followers that retweet this by Jan 23rd, 2023 (12PM EST) a free VIPER™ Titanium Money Clip of their choice. Good luck!
Check out your options at SuperiorTitanium.com Winners take their pick!!
44
735
589
1,194,135
Lance Harra retweeted
5 Jan 2023
An Australian network engineer was visiting - he came from a LAN down under
66
76
865
69,181
20 Dec 2022
Is it possible to use an ADF web activity to scaleup a hyperscale sql database similar to what you can do for DTU based sql servers.
This is the json body I use in a web activity for my DTU sql servers.
{"sku":{"name":"P1","tier":"Premium"}, "location": "West Europe"}
1
85
18 Nov 2022
#PassDataCommumitySummit I need to spend some time learning & using ScriptDom @sqlmal is showing some good use cases for this tool.
16 Nov 2022
#PASSDataCommunitySummit Watched @BrentO present Everything You Know About Parallelism is Wrong. That was an eye opening session. Brent did an outstanding job presenting and answering questions.
1
1
16 Nov 2022
#PASSDataCommunitySummit Attended Itzik Ben-Gan's session on non deterministic code. Lots of great information.
2
15 Nov 2022
#PASSDataCommunitySummit
The datafactory precon with
@AndyLeonard
was excellent. Lots of good information and demos for people wanting to learn about ADF.
5
Lance Harra retweeted
14 Nov 2022
I am the classy type of person who pastes a SQL query into a page in a Sheets or excel workbook because we may as well admit that spreadsheets are not only the most popular database, they are also version control
8
2
43
Lance Harra retweeted
15 Nov 2022
It’s official, she registered for the #PASSDataCommunitySummit and she’s contemplating which sessions to attend. I bet she guides me to an accessibility session by @MMarie.
ALT Service Dog in Training, Annie, with BC & Alberta Guide Dogs, rest on her bed, while in the foreground her registration badge for the PASS Data Community Summit shows she’s part of the event crew, and she has a “first timer” ribbon on the bottom of her badge.
7
4
49
14 Nov 2022
#PASSDataCommunitySummit
Virtually attending Andy Leonard's precon on data factory. As always Andy has lots of great information and is doing an awesome job presenting it.
1
6
14 Oct 2021
How can I stop Azure Data Studio from opening a jupiter notebook everytime I start it? It crashed while running this notebook and now when I start ADS it try's to run this notebook.
1