Replying to @tjaybelt
I am working with PBI right now and might be available. You can email me at rloski @@ hotmail
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…
Replying to @Rad_Reza @leila_etaati
My prayers are with you Leila.
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…
Replying to @BuckWoodyMSFT
@BuckWoodyMSFT : It looks like you are still a hurricane magnet.
weather.com/storms/hurricane…
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.
unavailable
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
unavailable
Time in application and database design sqlmovers.com/time-in-applic…
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-…
Replying to @Ko_Ver
@Ko_Ver has a good summary of the tasks of the ETL Developer in mssqltips.com/sqlservertip/7…
One element that he emphasized was the need to make the ETL process so that it can be rerun multiple times with the same results. That is the task that I am particularly lazy at.
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/…



