Question I’m breaking some new ground and trying to get into Azure Data Studio. I’m having a problem with intellisense that seems to be a bug with Azure Data Studio but I’m not sure. I have issues with basic queries. Foreign keys, select statements and … [Read More]
Question I have an "Basic" pricing tier Azure SQL database with a table of 7 columns, an ID column of int that is the clustered index and primary key, one datetime2(0) column, 3 varchar(100) columns and 2 varchar(MAX) columns, all nullable. The table has no … [Read More]
Question Diving on dba.stackexchange.com I found a nice answer that teach me how to open a .bacpac file with File Explorer. I gave it a try with the database AdventureWorks2008R2 and all I did was: Save the database as .bacpac file Rename the file extension … [Read More]
Question We have a job which imports data daily from a remote SQL Server every night, I’ll call it Import-Job. Most of the time this job runs through in about 15 minutes and everything is fine but due to a rather unstable VPN connection sometimes … [Read More]
Question I have seen on this site how to get the the third Friday of the month: How would I get the first Monday after this third Friday? asked 2021-08-12 by Ivan Answer "The first Monday after the third Friday" could be rewritten as "Three … [Read More]
Question I have 2 node Windows Failover Cluster with Quorum disk. SQL agent is NOT a resource of the cluster. I needed to enable service broker on the server; for that I need to set SQL Agent offline, run tsql statement then simply put it … [Read More]
Copyright © 2024 | Andy Mallon | am2.co