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,077 reads
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,077 reads
Using the APPLY operator to reduce repetition and make queries DRYer.
2016-06-10 (first published: 2015-04-02)
22,479 reads
Challenges with integrating MySQL data in an ETL regime and the Amazing FMTONLY trick!
2015-06-25
3,568 reads
By Steve Jones
Today’s coping tip is to focus on what’s good, even if today feels tough....
By Steve Jones
SQL Data Compare (SDC) is a great way to sync data among tables. It’s...
By Steve Jones
Today’s coping tip is to be gentle with yourself when you make mistakes. I...
I have a two-replica SQL Server Availability Group running on Windows VMs in the...
I have a SQL agent job which starts the trace (for audit purpose) everyday...
I have a number of databases on a sql server 2017 instance. For most...