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,806 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,804 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,070 reads
Blogs
How to get the Active Directory user password policy values
By SQLPals
Recently I have had to troubleshoot quite a bit of SQL login issues and...
How do you use PowerShell toc check if an active directory user locked out, disabled etc.?
By SQLPals
If your organization uses a password policy (there are very good odds these days...
DBA Myths: The system sessions are the ones with a session_id 50 or less
Anecdotally any session_id that’s 50 or less is going to be a system session...
Forums
Numeric and Decimal
Comments posted to this topic are about the item Numeric and Decimal, which is...
Is it possible get from Query Store historical ~ CPU % usage by each query ?
Is it possible get from Query Store historical ~ CPU % usage by each...
missing storage space
Hi I have a particular drive on one of my sql servers, it's gotten...
Ask SSC