Using IronPython to talk to SQL Server
IronPython is a Python implementation build on .NET. This article shows how you can use IronPython to access SQL Server Management Objects.
2016-06-13
2,830 reads
Gerald Britton
- Interests: SQL Server, Python, opera (the music, not the browser), jazz, Amsterdam
- Twitter: @@GeraldBritton
- LinkedIn: https://www.linkedin.com/in/geraldbritton/
Using APPLY to make your queries DRYer
Using the APPLY operator to reduce repetition and make queries DRYer.
2016-06-10 (first published: 2015-04-02)
22,372 reads
Integration Services, MySql and SET FMTONLY ON
Challenges with integrating MySQL data in an ETL regime and the Amazing FMTONLY trick!
2015-06-25
3,450 reads
Blogs
Daily Coping 20 May 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Daily Coping 19 May 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Running dynamic SQL in a different database
This is one of those things that on hindsight was a stupid problem, but...
Forums
Running Trace - Error: Login timeout expired
Hi All, We have Project server 2019 (Sharepoint). The database server (Only Database services...
query perf issue
Hi Everyone, Good morning. I am new to Sql administration.Have one question. We work...
Looking for some guidance on avoiding Scalar UDFs for DB lookups
Hello. I am not a SQL Developer - just an IT generalist (if that)...
Ask SSC