Determine Easter Sunday
Determine what day easter sunday will be based upon the year you pass the function
2016-04-25 (first published: 2016-03-30)
466 reads
Uncategorized
Who are connecting to database and disconnect ...
When you want gain exclusive access to database in order to restore database
2015-11-06 (first published: 2015-10-14)
1,934 reads
Move database files to another Drive
This script either generates or execute statements to SQL data and log files from C:\ to D:\
2015-07-01 (first published: 2015-06-03)
2,147 reads
Get Your Service Broker Messages in Order. Always.
Learn how you can guarantee the ordering of all messages in a Service Broker queue, regardless of conversations.
2015-04-01
3,129 reads
dbWarden - Purge old data
helps you manage dbWarden history.
No warranty given it will do what you expect, so test it !
2014-12-11 (first published: 2014-11-19)
1,003 reads
Regaining access to SQL server after changing the domain
If you changed your domain and have lost control over the SQL server or have been blocked from logging in , this article talks about it
2014-10-23
15,951 reads
PowerShell script to check last backup date for Databases
PowerShell script to check last full backup, transaction log backup date for SQL Server databases.
2014-09-02 (first published: 2014-08-22)
1,800 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)
680 reads
Adding Custom Reports to SQL Server Management Studio
In this tip, Koen Verbeeck explores how to apply business intelligence solutions to administrative tasks, specifically creating custom reports and adding them to SQL Server Management Studio.
2014-08-12
10,920 reads
2014-06-26
2,075 reads
Blogs
PASS Data Community Summit 2025 Slides and Code
By alevyinroc
Thank you for attending my PASS Summit 2025 session Answering the Auditor’s Call with...
Tech Conferences and Expanding Your View
By Brian Kelley
Tech conferences aren't just for networking and learning how to address a problem you're...
Managing subscribers, creating newsletters
By DataOnWheels
When I created the website on WordPress, I was expecting all the features I...
Forums
Getting the Schema for Tables
Comments posted to this topic are about the item Getting the Schema for Tables
An Unexciting Exciting Release
Comments posted to this topic are about the item An Unexciting Exciting Release
UNLOGGED Tables in PostgreSQL: When Speed Matters More Than Durability
Comments posted to this topic are about the item UNLOGGED Tables in PostgreSQL: When...
Question of the Day
Getting the Schema for Tables
What happens when I run this on SQL Server 2022 in the AdventureWorks2022 database?
SELECT OBJECT_DEFINITION (OBJECT_ID(N'Person.Person')) AS [Object Definition]; GOSee possible answers