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
3,710 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,741 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,758 reads
Blogs
A Couple Quick GENERATE_SERIES Tests
By Steve Jones
I had someone reach out about generate_series() recently, saying they hadn’t realized this was...
How I passed the DP-700 Exam
I recently took and passed the DP-700 exam, which is required for the Microsoft...
Which approach to take: Build it, buy it, cloud it?
As a Consultant, I would typically answer with – it depends! Then a typical...
Forums
Dynamic T-SQL Script Parameterization Using Python
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
How to Download and Restore AdventureWorks 2019 Database
Comments posted to this topic are about the item How to Download and Restore...
Tracking Table Sizes
Comments posted to this topic are about the item Tracking Table Sizes
Question of the Day
Counting Bits IV
What does this code return in SQL Server 2022+?
select bit_count(2.4)See possible answers