2014-09-25 (first published: 2010-12-23)
24,080 reads
Scripts
2014-09-23 (first published: 2010-02-17)
11,434 reads
List all permissions in all databases
This script will allow you get all the users and roles with permission on objects on all databases.
2014-09-18 (first published: 2009-03-05)
34,546 reads
Calendar Table by Month
Populate a calendar table with user set interval start and end datetime values.
2014-09-16 (first published: 2014-02-21)
2,060 reads
Calendar Table by Day
Populate a calendar table with user set interval start and end datetime values.
2014-09-15 (first published: 2014-02-21)
1,983 reads
2014-09-12 (first published: 2011-12-22)
3,229 reads
usp_TransposeNRows v2.0
Transpose N rows of a table (v2.0 allows user to specify the table's schema)
2014-09-10 (first published: 2010-01-29)
2,017 reads
Simple Crosstab Procedure with Power
Create crosstab queries as easily as MS Access with a lot more power.
2014-09-09 (first published: 2009-04-02)
4,445 reads
Virtual tally table function
An inline table-valued function (iTVF) that will produce a virtual tally table on-the-fly. The function creates a tally table of any size with user-defined lower and upper bounds.
2014-09-08 (first published: 2013-06-28)
2,219 reads
Calculate gregorian easter sunday using a table valued function
Calculate gregorian easter sunday using a table valued function.
2014-09-03 (first published: 2014-08-22)
674 reads
Blogs
SQL Training: Black Friday Deals Up to 75% Off
This Black Week, don't just get a discount—get ahead! Whether you're a total newbie...
When is the perfect moment to build a data strategy in a company?
The post When is the perfect moment to build a data strategy in a...
How to Run Databases on Kubernetes: An 8-Step Guide
In this step-by-step tutorial, learn how to run MySQL, PostgreSQL, MongoDB, and other stateful...
Forums
Rebuild Index Job on a Large DB
We have a db close to 3 tb and rebuilding/ reorganizing indexes weekly is...
Authentication Error 0x8009030c
Hi, I'm using a small database on SQL Server 2019 on Windows 10 Pro....
how to stop command prompt window from appearing when running PowerShell script?
Hi everyone I have a PowerShell script that is run by Execute Process Task...
Question of the Day
Renaming a Database
If I want to rename the OldSales database to ArchiveSales, how can I do this? (choose 2)
See possible answers