#sqlfamily#Sqlhelp
I'm looking for an PowerBI contractor or expert that can look at our system of hundreds of reports and make sense of what is there. We had a report guy that was let go. And now it falls on my shoulders, and I am woefully unskilled nowadays in PBI.
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-sq…
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-brain
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.
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
@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.