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,090 reads
Gerald Britton
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)
21,880 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,197 reads
Blogs
What Agent Jobs are Running??
By gbargsley
Do you run SQL Agent Jobs in your environment? Do you know what is...
Unboxing SQL Clone 2020 for a PoC
By Steve Jones
When I got a new machine, I had SQL Clone on my old machine,...
Daily Coping 4 Aug 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Extended Events
I have set up an extended event to capture the queries users may be...
Script logins and all permissions: no longer supported in SSMS generate script?
Okay, maybe I've just gone crazy but I was certain it used to be...
Recursive Select runs slow
Hello, I have a recursive Select that runs ultra slow. My test table has...
Ask SSC