TSQL Challenge 81 - Create a Game schedule generator in TSQL
This challenge is to generate a game scheduler based on the Teams given in a table.
2012-07-04
1,504 reads
Articles
Generating Non-uniform Random Numbers with SQL
Some FUNCTIONs to help generate non-uniform random numbers from uniform random numbers including Normal, Multinomial, etc.
2012-07-03
10,769 reads
Email Job Failures Report to DBA using PowerShell
MySQL introduced its own brand of job scheduling, called Events, in version 5.1. However, some Database Administrators (DBAs) feel that it isn't quite ready for prime time. This article presents a hybrid solution that uses MySQL Event Scheduling to manage the batch jobs and Windows PowerShell for the error handling.
2012-07-03
2,971 reads
Using a PowerShell Script to delete old files for SQL Server
Many clients are using custom stored procedures or third party tools to backup databases in production environments instead of using database maintenance plans. One of the things that you need to do is to maintain the number of backup files that exist on disk, so you don't run out of disk space. There are several techniques for deleting old files, but in this tip I show how this can be done using PowerShell.
2012-07-02
3,232 reads
SQL Server 2012 - New Service Broker Features
SQL Server 2012 came with bells and whistles for service broker, that give you plenty reasons to start using service broker in your applications.
2012-06-29
4,150 reads
Transaction Replication Publisher failover to Mirror
Transaction Replication Publisher failover/failback to mirror standby with automatic redirection of the subscriber and client application.
2012-06-28
2,822 reads
Introduction into handling errors in PowerShell for SQL Server tasks
PowerShell is becoming a great tool for managing SQL Server tasks, but like most tasks that are coded there is always the need for error handling to deal with the unknown. PowerShell has several options for handling and capturing error details and in this tip we will explain these options using PowerShell for SQL Server examples.
2012-06-28
3,684 reads
Simplified Restores with SQL Server 2012 Recovery Advisor
Occasionally, a DBA may need to restore a database from a multiple backup files that originated from multiple servers. This requirement might arise, for example, in a database-mirroring configuration, where backups may be from either of the servers.
2012-06-27
2,952 reads
The Lure of Simplicity in IT
A deceptively simple solution to a business re-engineering problem can beguile companies into selecting a compromise that doesn't actually meet all their needs. Simple is great, but not at the expense of functionality. Some IT solutions are complex because the problem is complex, but they can be made conceptually clearer.
2012-06-27
3,279 reads
9 Things to Do When You Inherit a Database
Some tips on what to do when you inherit a database that you've never worked on before
2012-06-26 (first published: 2009-06-22)
55,488 reads
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
Increase Deadlock Detection
Comments posted to this topic are about the item Increase Deadlock Detection
A Tool is Better than a Script
Comments posted to this topic are about the item A Tool is Better than...
Understanding Deadlock Victim Selection in SQL Server
Comments posted to this topic are about the item Understanding Deadlock Victim Selection in...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers