Alter Multiple Databases at Once
This is a quick and dirty method I often use when I want to make a change to multiple databases...
2019-04-26 (first published: 2018-06-26)
2,426 reads
This is a quick and dirty method I often use when I want to make a change to multiple databases...
2019-04-26 (first published: 2018-06-26)
2,426 reads
In relation to the GDPR, I’ve recently been looking at the tools available within SQL Server to support auditing our...
2019-04-26 (first published: 2017-09-26)
5,699 reads
I mentioned in my previous post about manually updating statistics that you can specify whether they’re updated using a full...
2019-04-26 (first published: 2017-08-15)
1,439 reads
Unlike some other languages, T-SQL doesn’t have the concept of a constant.
As good coders, we’ve all at some point tried...
2019-04-26 (first published: 2017-10-10)
3,649 reads
I’m a big fan of using queries based on the dynamic management view sys.dm_exec_query_stats to capture the most resource hungry...
2019-04-26 (first published: 2017-11-01)
4,653 reads
As part of my job I manage a bunch of SQL instances for Development and Test.
Access is managed though Active...
2019-04-26 (first published: 2018-10-02)
2,288 reads
I manage a few servers used to host SQL Instances for development and test purposes. Each of those instances hosts...
2019-04-26 (first published: 2018-04-24)
2,818 reads
I recently had an incident where I was looking into the cause of a long running process for a client....
2019-04-26 (first published: 2018-09-18)
2,083 reads
If you’re a long time Profiler user like me then you probably often take the option of saving (or loading)...
2019-04-26 (first published: 2018-08-08)
2,113 reads
When I’m using Profiler to analyse performance issues I often save the results to a table, or upload a trace...
2019-04-26 (first published: 2018-10-16)
2,109 reads
In this step-by-step tutorial, learn how to run MySQL, PostgreSQL, MongoDB, and other stateful...
By Steve Jones
The 11th episode is now live, recorded a few weeks ago at the PASS...
By Steve Jones
mornden – n. the self-container pajama universe shared by two people on a long...
Comments posted to this topic are about the item Computer Algebra
Comments posted to this topic are about the item Renaming a Database
Comments posted to this topic are about the item A First Look at SSMS...
If I want to rename the OldSales database to ArchiveSales, how can I do this? (choose 2)
See possible answers