Question Each night my SQLServer replication failed on a big table with the following error. It is failing on a different table each night but always on a relatively big table ( > 200,000 rows) The process could not bulk copy into table ‘"dbo"."Table01"’. (Source: … [Read More]
I’ve seen more and more events & communities adopt Codes of Conduct. Even local events, local user groups, and smaller online communities are adopting Codes of Conduct. That’s GREAT! …but it’s just a great start. It’s not that easy. Discoverability The issue of discoverability is … [Read More]
Question I am trying to import a bacpac file to my SQL Server Express 2016. An exception is thrown during the import with Returns: Incorrect syntax near ‘ADMINISTER’. I am running the import as the sa user. Later when I try to run the SQL … [Read More]
Question I’m simulating the situation where I take a backup from instance A and restore it on instance B. I followed the doc to Backup to Disk with Encryption. Since I’m using only my desktop to simulate the whole process, after taking the backup of … [Read More]
Question This has probably been asked before, but I couldn’t find the answer. I have a complex datamodel in sql-server-20XX (more likely to be something old) in which cascade delete has been turned off (by design). A large chunk of our database has been sold … [Read More]
Question I’m really confused by this SQL here, I have this sample where I am using the value from the main query in the subquery and then using XML PATH to add a comma between the dates. The setup is 2 tables one with the … [Read More]
I recently saw a question on DBA Stack Exchange (it has since been deleted by the author), who had a “special process” that ran regularly, and as part of that process, they disabled the trigger, did some stuff, and re-enabled it. During that process, the … [Read More]
Question Our team is migrating one of our databases to Amazon RDS MS SQL Server. As part of that, we have to rewrite some of our stored procedures. We have a stored procedure that performs a database backup to a network storage. The above stored … [Read More]
Question When I am running: Ctrl+Alt+R will run the web browser in an SSMS tab. However, this now produces the message: I do have MS Edge installed but SSMS is not finding it. What should I do to help SSMS find MS Edge and use … [Read More]
Question I’m trying to find a way to allow an application to create tables and insert data into them on a SQL Server 2019 while protecting from injection attacks in case the app credentials would leak. My experience is limited when it comes to writing … [Read More]
Copyright © 2024 | Andy Mallon | am2.co