© 2023 Hashnode
#mssql
This handy SQL query list all connections to an mssql database and a corresponding kill command. The kill command will just be printed, not executed. DECLARE @database_name NVARCHAR(255); SET @database_name = 'name of database' SELECT D…
This article exposes tips and challenges of SQL Server to PostgreSQL database migration based on the experience of Intelligent Converters specialists. Despite which method or converter would have been chosen for the migration project, the r…
As of this writing, it is not possible to directly use the AWS console to restore an MSSQL database backup from AWS S3 Bucket to AWS RDS for SQL Server, unlike Aurora or MySQL databases. But, it is st…
This error occurs while trying to save a new data connection in SAC. This is because SAC Cloud Agent encountered an issue while trying to connect to the specified MSSQL database as the database could …
2019 was a pivotal year that will remain in our memories forever. The coronavirus pandemic has drastically altered our lives, leaving us with more questions than answers. When will this come to an end…
In the season of summer, the pool becomes overcrowded and needs to be managed properly; this is not the case for other seasons. On the other hand, the database connections pool needs to be managed irr…
Create sample dataframe import pandas as pd from io import StringIO SAMPLEDATA = StringIO(''' tweet_id,sentiment,author,content 1956967341,"empty","xoshayzers","@tiffanylue i know i was listenin to b…
Recently I had a requirement, wherein I had to import the data from one of the internal applications to the SQL Server for further processing. We had REST-API open at a particular endpoint so any other service can consume the API and fetch …
This week at work I've started writing some tests for a small application I've been developing over the last few months (late to write tests but better late than ever), and for the last couple days I've been struggling to mock mssql. The ma…
SQL Server provides three mechanisms to track data changes in the table objects. This mechanism is also a useful solution for implementing the audit and logging process for the SQL Server Instance. The mechanisms are Change Tracking also kn…