Create Dynamic External Table in Azure synapse Analytics
This script creates an external table in Synapse.
2023-08-21 (first published: 2023-07-26)
1,237 reads
Scripts
Validating different types of data like Gmail, Outlook email addresses, phone numbers, and URLs
Validating different types of data like Gmail, Outlook email addresses, phone numbers, and URLs in SQL can be a bit challenging since SQL is primarily used for data manipulation in databases and not for complex data validation. However, depending on the database system you are using, there might be some limited string manipulation functions available that can help you perform basic validation checks.
2023-07-28
415 reads
Another way to get a table list from a string
I prepared this version (my original did not used XML)
By being helped by forums feedback from SQL central
Forward it to yours peers.
2023-07-18 (first published: 2010-05-13)
1,888 reads
2023-07-18 (first published: 2010-03-18)
2,132 reads
Get a range of numbers
If you need to get a range sequence of numbers this script can help you to acomplish it. For example : the sequency of numbers between -5 and 5 or 1 and 200, etc..
2023-07-18 (first published: 2012-04-23)
1,496 reads
2023-07-18 (first published: 2009-03-13)
2,165 reads
2023-07-18 (first published: 2012-12-04)
1,719 reads
Parsing INTERNAL REPRESENTATION OF OVERPUNCH SIGNS
Some times you need to parse over punch values at the while running a query.
Here is an utility function to help with that task.
2023-07-18 (first published: 2018-10-31)
892 reads
Print Text Month Calendar
This function return the text format of a month calendar. It could be useful for sending through emails when you do do not have other tools, but T-SQL to send text emails.
2023-07-18 (first published: 2012-10-31)
1,955 reads
2023-07-18 (first published: 2009-04-28)
3,834 reads
Blogs
Building AgentDBA’s Slack Escalation
By Arun Sirpal
Until now, a CRITICAL finding did the right internal routing, but the last mile...
Changing the Owner Removes Permissions: #SQLNewBlogger
By Steve Jones
This is actually inspired by an article SQL Server Central, which taught me something...
T-SQL Tuesday #200 - I Bet It's Bad if I See...
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
Forums
ALAMAT BCA KCU PONTIANAK TLP/WA 08218200174
Telp Cs:(0821)8200174 Jl. Jenderal Ahmad Yani No.1, Benua Melayu Darat, Kec. Pontianak Sel., Kota...
ALAMAT BCA KCU TANJUNG PANDAN TLP/WA 08218200174
Telp Cs: (0821)8200174 Jl. Jend. Sudirman No.17, RT.008/RW.04, Pangkal Lalang, Kec. Tj. Pandan, Kabupaten...
How Clustering can be Used as a Preprocessing Technique for Classification in Azure Machine Learning
Comments posted to this topic are about the item How Clustering can be Used...
Question of the Day
Moving the Error Log
How can I change the location in which the SQL Server error log is written in SQL Server 2025?
See possible answers