Random Lottery Number Generator
This script will generate 5 lottery numbers plus one mega and you can set how many tickets and the range for the numbers for the different types of lotteries.
2019-04-27 (first published: 2016-07-13)
2,064 reads
Uncategorized
Brute Force data search tool
searches entire db for a string, number, or date, returns list of results
2016-05-02 (first published: 2016-04-20)
1,257 reads
Get Space on SQL hardrive
I was recently asked to monitor the Database size on the SQL server, and display the results in a report.
2016-05-05 (first published: 2016-04-16)
807 reads
Database File Move Etc
A stored procedure to generate database file moves along with Robocopy script and the attach / detach scripts
2016-04-20 (first published: 2016-04-04)
658 reads
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)
468 reads
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,940 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,231 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,140 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,006 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
16,062 reads
Blogs
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Forums
FARE Labs Pvt Ltd is a reliable laboratory for evaluating cosmetics and personal
A well-known laboratory with NABL certification, FARE LABS Pvt Ltd, provides thorough testing and...
Lots of FKs
Comments posted to this topic are about the item Lots of FKs
Real-time On-prem SQL Server Data in Excel – Over the Internet
Comments posted to this topic are about the item Real-time On-prem SQL Server Data...
Question of the Day
Lots of FKs
In SQL Server 2025, what are the most outgoing and incoming FK references a table can have?
See possible answers