Scripts

Technical Article

Date Calendar

Code to create a handy date calendar cross-reference table with a ton of pre-populated, slice-and-dice data field variations to aid in complex date parameterization / selection criteria.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(53)

You rated this post out of 5. Change rating

2018-04-26 (first published: )

16,981 reads

Blogs

T-SQL Tuesday #202 Invitation: That One SQL Server Outage You’ll Never Forget

By

I am excited to host T-SQL Tuesday for the first time. I want to...

A Daily Report from Claude

By

Redgate had some Claude training recently, which I went through as my knowledge has...

A New Word: Gnossienne

By

gnossienne– n. the awareness that someone you’ve known for years still has a private...

Read the latest Blogs

Forums

"Click" your SQL Server into an MCP agent, with RBAC and full security

By polterguy

Hi guys and gals, I've created a system that automatically allows you to "generate"...

Demo Tracking Dropped Objects

By Artur Sanin

Comments posted to this topic are about the item Demo Tracking Dropped Objects

Randomly Selecting Columns and Rows from a Table or View

By Artur Sanin

Comments posted to this topic are about the item Randomly Selecting Columns and Rows...

Visit the forum

Question of the Day

Getting Database MaiL Profiles

If I want to return information about all Database Mail profiles on my instance from T-SQL, how can I do this?

See possible answers