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
1,955 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,842 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,151 reads
Blogs
ASF 030: Benni De Jagere interview
By Kamil
Introduction Benni De Jagere is a Senior Data Insights Consultant with a strong focus...
Figuring Out How To Hide Production Data
There’s a really simple conundrum that we go through all the time. The best...
Forums
Query Optimization Level
Comments posted to this topic are about the item Query Optimization Level
Now Is a Good Time for Choices
Comments posted to this topic are about the item Now Is a Good Time...
Design ideas for hostoric data & trending
Hi everyone, I have a use case (below) for which I am considering multiple...
Ask SSC