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

This is an awesome new tool for a metadata approach to building a data flow in Azure Synapse.

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

Announcing 3 new cloud-scale data transformation functions added to #MappingDataFlows expression language in Azure Data Factory and Azure Synapse Analytics: topN() substringIndex() collectUnique() We now have over 260 data transformation functions in our library! techcommunity.microsoft.com/t5/azure-data-…

Call for Speakers for SQL Saturday Oregon/SW Washington is open and I've just submitted a session! sessionize.com/sql-saturday-o…

Call for Speakers for SQLSaturday MN 2022 is open and I've just submitted a session! sessionize.com/sqlsaturday-mn…

Call for Speakers for Data Saturday Atlanta is open and I've just submitted a session! sessionize.com/data-saturday-…

Call for Speakers for SQL Saturday RVA is open and I've just submitted a session! sessionize.com/sql-saturday-r…

Time in application and database design sqlmovers.com/time-in-applic…

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

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.

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.

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

This is a reminder to use roles for permissions rather than hard coding user permissions. sqlmovers.com/sql-permission…

I signed up for the #SQLTrain from Portland to Seattle. You can too. eventbrite.com/e/sqltrain-202….

Leaning about DLT

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

It's happening...the #NTSSUG meeting is next week! This month we have our very own Russ Loski talking about Power BI, Synapse and Government API Data! RSVP here - meetup.com/north-texas-sq…