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,567 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,112 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,346 reads
Blogs
Daily Coping 21 Oct 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
#PowershellBasics: Get a list of files from a directory.
I’ve got a project I’m working on at the moment and it includes a...
Join me next week at my first GroupBy session
2021 has been the year people want to learn about Temporal Tables, it seems....
Forums
Managed Instance, cross-database queries. What are the hidden requirements?
Have a managed instance with 2 databases. In theory I should be able to...
Need the (default) port to connect - why is this not implicit.
So I have 2 instances (1 x 12, 1 x 19). Both have the...
Extract data from XML field
Hello, I have a SQL view with a column called GlobalCountryRegionXML. Here is an...
Ask SSC