A great script that I wrote some time ago to allow the last database backup to be restored across a linked server to another server, after running a remote sproc on the destination to kill off any users on the receiving side.
2016-03-14 (first published: 2016-02-25)
824 reads
2016-03-11 (first published: 2014-09-11)
2,761 reads
Reports on the data and log file sizes and space used within files for each database on a servers. It also includes the free space on the drive where the file is located.
2016-03-10 (first published: 2015-07-23)
5,315 reads
This function is used to get the complete table lists are particular table and its last access datetime.
2016-03-07 (first published: 2014-11-03)
3,183 reads
2016-03-03
467 reads
This Script can be used to pick out a temporary table from tempDB
you might want to Check and drop the table before you create it just in case , but I Haven't included it here
2016-03-01 (first published: 2012-12-07)
1,799 reads
Following script retrieves the queries currently executing on the server.
2016-02-29 (first published: 2014-09-04)
3,328 reads
We can check for null values using count.
2016-02-26 (first published: 2016-02-16)
1,182 reads
SQL Agent job to cleanup all old text files on the errorlog directory.
2016-02-25 (first published: 2016-02-23)
455 reads
If you need to change multiple SQL Server Services accounts across your environment, Powershell can do that for you.
2016-02-24 (first published: 2016-02-19)
6,125 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...
Hello , I'm having an issue with a SQL Server VM that has 30...
Hi everyone My SSIS package does a bulk insert of csv files into a...
Can you run this code in any of your SQL Server 2019 databases without error?
CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc]
AS
SELECT Consumer_ID ,
Trend_Category ,
Bit_Trace
FROM NewWorldDB.dbo.MarketTrend;
GO See possible answers