Digby Pool

A Short Hiatus

Time to rest our buns! We are taking a short hiatus during the rest of June from posting our regular Wednesday SQL posts. We are going to be in Nova Scotia for SQL Saturday, and then taking a week to focus on getting some work done for our clients and for the community. Some of you know what we are …

BlackList Stamp

Blacklist a Set of IPs

We talked about whitelisting IPs before, but what about the opposite, blacklisting IPs that may never access your SQL Server. Blacklisting them well enough that they can’t even go beyond the initial attempt to login. Sounds like fun! Oh No You Don’t! So, if you want more details about what a Blacklist vs. Whitelist is, go check out our other …

Trails

SQL F.A.D. – CSV List of Columns

I had a project once that was using change data capture (CDC) so we could minimize the data being sent to our data warehouse that was under development. Being who I am, I wanted a more dynamic way to generate the statements that would query the CDC tables, and then merge that data into the data warehouse. I wanted a …

SQL F.A.D. – Daily Identity Reset

Sometimes you have to do some things considered pretty strange in your SQL Server. This is one of those things. Another SQL Fast and Dirty tip! A few years ago I was working at a client, and all sorts of issues were coming up where the application wasn’t able to reset a counter in a table accurately enough by the …

Dirty Digby Dog!

SQL F.A.D. – Average Transactions Per Day

Sometimes you just want to get an idea of what’s going on with your SQL Server. You don’t need really accurate values, you just want a ballpark to be able to answer a question or make a decision. This is where SQL, Fast And Dirt (F.A.D.) can help. Average Transactions Per Day Let’s just get right to it: DECLARE @days …

Identity Removal

Men In Black are not the only ones that can remove an identity Identity columns are great. they help us to understand our data better, and can even help our queries to perform better. But what if you made a mistake when creating the table. What if someone else made a mistake? Whatever the reason, you ultimately want that aspect …