Steps to clean up orphaned replication settings in SQL Server
Learn how to clean up your orphaned replication settings.
2012-07-05
3,518 reads
Articles
2012-07-04
1,443 reads
Indexes, Indexes, Indexes
This article has a description of an index utilization tool that Ron Johnson uses to analyze the effectiveness and use of indexes in a system.
2012-07-04 (first published: 2011-07-05)
19,316 reads
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
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,770 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
Blogs
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Understanding Fabric MCP
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
AWS RDS Aurora - our first approach
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Forums
BCA KCU SEMARANG Telpon/wa:0821°8168°291
BCA KCU SEMARANG Telpon/wa:0821°8168°291.Jl. Pemuda No.90-92, Kembangsari, Kec. Semarang Tengah, Kota Semarang, Jawa Tengah...
BCA Finance Bekasi Layanan Mobil TLP/WA 08216977749
KOMPLEK MEGA OFFICE PARK, Jl. Harapan Indah Boulevard No.8 blok P5, Medan Satria, Kecamatan...
Question of the Day
May the Fourth Be With You Fun
In honor of May the fourth and Star Wars (may the force be with you), finish this quote:
"Do, or do not. ..."See possible answers