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...
2019-10-30
10 reads
Kind of proud about this accomplishment. I get asked all the time at user groups and SQL Saturday events, “How can I get started with SQL Server”. There is...
2019-10-30
8 reads
Kind of proud about this accomplishment. I get asked all the time at user groups and SQL Saturday events, “How can I get started with SQL Server”. There is...
2019-10-30
7 reads
Kind of proud about this accomplishment. I get asked all the time at user groups and SQL Saturday events, “How can I get started with SQL Server”. There is...
2019-10-30
4 reads
Kind of proud about this accomplishment. I get asked all the time at user groups and SQL Saturday events, “How can I get started with SQL Server”. There is...
2019-10-30
55 reads
Kind of proud about this accomplishment. I get asked all the time at user groups and SQL Saturday events, “How can I get started with SQL Server”. There is...
2019-10-30
5 reads
Behold! There’s a scary monster called skip-2.0, announced by ESET: This backdoor targets MSSQL Server 11 and 12, allowing the attacker to connect stealthily to any MSSQL account by...
2019-10-30
3 reads
PASS Summit 2019 starts up next Monday with pre-conference sessions. I’ve got my schedule all set, and I’m going to be busy: I’m speaking in two full-day pre-conference sessions,...
2019-10-30
8 reads
sometime we observed that errorlog recycle is failed this happens when we monitor/read errorlog using our monitoring tool or monitoring application/scripts during this task if we want to recycle...
2019-10-29
30 reads
I am honored to have been selected to speak at SQL Saturday Oregon this year. They always have so many sessions submitted with only 40 slots available. I was...
2019-10-29
12 reads
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
Is there a good syllabus for reading these two together? (Yes, it's called the...
Comments posted to this topic are about the item GPX distance and time analysis...
Comments posted to this topic are about the item The DBA is Dead; Long...
In SQL Server 2025, if I want to remove an IP from a listener, what do I do?
See possible answers