Simple job script to cycle the SQL Log ever 24 hoursThe job is set to disabled as you should review any script that creates a job before enabling it on your server.
2006-03-06 (first published: 2004-10-29)
1,037 reads
The following runable script is a very simple way to track SPID's and PROCESS information (VERY BASIC) in a small target (Local) database.1. Creates a small database 1.1 must set MDF and LDF (File location information) specific to the drive and file folder locations for each server2. Sets All db options3. Creates single table to […]
2005-01-14 (first published: 2005-01-04)
228 reads
Simple script (alterable as needed) to verify existence of a file and execute a job if the return result = 1 (true)
2004-12-08 (first published: 2004-10-29)
141 reads
If you need to alter existing datatypes in the event of a SQL Server Datatype issue for capacity planning or conversion process this simple schema script may come in handy
2004-03-15
143 reads
Simple Procedure to rapidly rebuild a copy of Development TEST1 DB...Lovely and fast when Tard Developers have highlevels of access and you just need them out to restore / refresh a db...KILL KILL KILL !!! Remember to reset / resolve users and permissions after this is run. I use a DTS RUN statment with a […]
2003-12-18
182 reads
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Comments posted to this topic are about the item The New World Of AI...
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Security has long been a problem for me. Every time I think I understand...
What does this return on SQL Server 2025?
select bit_count(null)See possible answers