Christ follower, SSIS/SQL Developer, MCT, SSRS/.Net Developer
Southlake, TX
Joined August 2011
- Tweets263
- Following152
- Followers176
- Likes47
Russ Loski retweeted
It's happening...the #NTSSUG meeting is next week! This month we have our very own @sqlmovers talking about Power BI, Synapse and Government API Data! RSVP here - meetup.com/north-texas-sql-s…
Call for Speakers for BRAIN Conference / SQLSaturday Baton Rouge BI 2023 is open on Sessionize and I've just submitted a session! sessionize.com/sqlsatbr-brai…
I signed up for the #SQLTrain from Portland to Seattle. You can too. eventbrite.com/e/sqltrain-20….
This is a reminder to use roles for permissions rather than hard coding user permissions. sqlmovers.com/sql-permission…
What are your options for querying CSV in #AzureSynapse serverless SQL? Filip Popović explains in youtu.be/HpBpFH-l11E how to speed up querying CSVs by using Parser_Version 2.0 rather than 1.0. 2.0 can be close to twice as fast as 1.0. 2.0 does have some limitations
More great innovations in #AzureSynapse.
The Cast Transform in pipeline dataflows makes it possible to cast strings and other data types to another data type. The current approach to converting strings to date involves some very detailed expressions. Now you can use Cast.
This Post is from a suspended account. Learn more
Another cool feature from the #AzureSynapse team: SynapseML. Watch the video to get an introduction. youtu.be/ycQPtC--VKU
I got into programming because I am lazy. I look forward to seeing what I can do with my data with as few key strokes as I can.
Interesting video about Managed VNets. I am not a network person and like the idea that this security feature is easy to set up. It provides the following benefits (from video):
1. Easy to setup
2. Auto-scaling
3. Advanced Spark Security
4. Data Exfiltration Protection
This Post is from a suspended account. Learn more
Call for Speakers for SQL Saturday RVA is open and I've just submitted a session! sessionize.com/sql-saturday-…
Call for Speakers for Data Saturday Atlanta is open and I've just submitted a session! sessionize.com/data-saturday…
Call for Speakers for SQLSaturday MN 2022 is open and I've just submitted a session! sessionize.com/sqlsaturday-m…
Call for Speakers for SQL Saturday Oregon/SW Washington is open and I've just submitted a session! sessionize.com/sql-saturday-…
Russ Loski retweeted
Announcing 3 new cloud-scale data transformation functions added to #MappingDataFlows expression language in @AzDataFactory and @Azure_Synapse:
topN()
substringIndex()
collectUnique()
We now have over 260 data transformation functions in our library!
techcommunity.microsoft.com/…
There is a lot of interesting new features in the June 2022 release of Azure Synapse Analytics. The top three for me:
User-defined functions in pipelines
Fuzzy joins in mapping data flows
Map data tool
This Post is from a suspended account. Learn more
This is an awesome new tool for a metadata approach to building a data flow in Azure Synapse.
🚨 Have you seen that the Map Data tool is now GA in @Azure_Synapse?
Find out more:
techcommunity.microsoft.com/…
#AzureSynapse #Azure #Analytics #SynapseInfluencers
I'm look forward to presenting an introduction to the Azure Synapse Studio at the Baton Rouge SQL Saturday Aug 6. This will be a quick introduction to the SQL editor, with more time spent looking at the notebook experience.
#AzureSynapse #azuresynapseanalytics
