T-SQL script to purge all the tables including foreign key references. The script has been made smart enough to use TRUNCATE wherever there is no foreign key reference and to use DELETE wherever there is foreign key reference.
2019-12-10
2,541 reads
In this tip we look at how to cleanup the SQL Server query store after a database has been restored to ensure that query store starts data collection starts fresh.
2019-01-30
2,074 reads
This came up one day at my work when a developer was using it....
I’m sure I’ve never mentioned that I’m an amateur radio operator. Like Vegans and...
By Steve Jones
When in doubt, overtip – from Excellent Advice for Living This is close to...
Comments posted to this topic are about the item How Much AI Code Would...
Comments posted to this topic are about the item Browsing for Instances
Comments posted to this topic are about the item Creating a Date Dimension (Calendar...
I have a SQL Server instance that is not listening for connections on port 1433. By default, all ports are locked down on my server, except for the SQL Server port. What can I do to allow users to connect to the instance without knowing the port?
See possible answers