This was posted just to share an experience of tackling a problem we encountered when we needed to connect an SSRS Server 2016 to an older SQL Server database (Windows Server 2008 R2) and what steps we took to troubleshoot the issue. After all the … [Continue reading]
Can Python work with SQL Server database? Some may argue that SQL Server is not the best SQL database for Python, but in most cases it actually does not matter. In my corporate experience, SQL Server may be the easiest database to use with Python. … [Continue reading]
At times, you need to do a quick query against LDAP, but if your access is quite restricted, sometimes instead of using SQL Server Management Studio, you can also use SSIS Project within Visual Studio to do it. Steps Launch Visual … [Continue reading]
After one client was notified that her passwords were found in a data leak and may compromise the accounts from her iPhone: Compromised... Some of your passwords have appeared in a data leak, putting those accounts at high risk of … [Continue reading]
One morning, you discovered your SSIS package failed to run with the following error message: This is typically caused by a simple setting that is too often overlooked during deployment. In general, you do not want to save any connection ID … [Continue reading]