create jobs script for 2000 2005 or 2008
will create jobs script for backup or DR purposes to install on another server.
2012-01-18 (first published: 2011-12-15)
2,171 reads
Scripts
poor mans archival of backup files and tran logs to alternate location
This script will backup your files that have changed only. old files will not be copied just newer ones.
2012-01-17 (first published: 2011-09-20)
721 reads
Create bank holidays table
Do you know what happens if a holiday falls on a weekend? This script will help you.
2012-01-16 (first published: 2011-12-14)
3,089 reads
Who did what?
This select will show the last sql statement for every open session plus many helpfull information.
2012-01-13 (first published: 2008-03-04)
4,226 reads
Display row value as a TABLE column using SQL select statement
Display row value as a TABLE column using SQL select statement
2012-01-12 (first published: 2007-10-26)
4,734 reads
2012-01-11 (first published: 2008-04-16)
5,176 reads
Script foreign keys
Using this script you can create a list of sql commands for foreign keys manipulation.
2012-01-10 (first published: 2007-11-02)
5,432 reads
2012-01-09 (first published: 2007-11-13)
4,916 reads
2012-01-06 (first published: 2008-02-15)
7,316 reads
2012-01-05 (first published: 2011-12-09)
2,574 reads
Blogs
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Forums
Logic question in a WHERE clause using IIF?
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Execute as failure
Security has long been a problem for me. Every time I think I understand...
BIT_COUNT() V
Comments posted to this topic are about the item BIT_COUNT() V
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers