Monthly Archives: July 2016

How Far Have You Traveled for a SQL Saturday?

A few of you might have seen the recent announcement from PASS about SQL Saturdays. I don’t like the decisions, especially the new 600 mile radius limitation for events on the same day (or consecutive weeks). Kevin Feasel performed an … Continue reading

Posted in Editorial | Tagged | 21 Comments

Failover

I saw a note from someone that had a database set up in a High Availability (HA) configuration for production. This person had received an 823 error on the primary server, but a failover hadn’t occurred. This wasn’t a critical … Continue reading

Posted in Editorial | Tagged

Quick Scalar Tables–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. This actually comes from Itzik Ben-Gan, by way of Kevin Feasel.  Kevin’s post is about CROSS APPLY, which is … Continue reading

Posted in Blog | Tagged , ,

Too Much Information for Sports

Many of us deal with lots of data and information, sometimes conflating the two when they are really separate things. Our jobs usually revolve around somehow  helping others to extract useful value from the data we store in some way. … Continue reading

Posted in Editorial | Tagged

Learning to Search

I’ve had my own domain for about 17 years now, and about 6 or 7 years I decided to move my email from GoDaddy to Google. There were a variety of reasons, but the bottom line was I got more … Continue reading

Posted in Editorial | Tagged , | 1 Comment

A Buggy Release

I definitely believe in a DevOps process, though a thoughtful, incremental one. I think this is the best way to develop software, whether you release every day or every year. Yes, you can implement DevOps and release once a year. … Continue reading

Posted in Editorial | Tagged , , | 3 Comments

Slimmer SQL Saturdays

I’ve had this idea for some time. It’s been bugging me, but I haven’t really been pressured to write, nor inspired. That changed a bit with the announcement of the rules change for SQL Saturdays, as well as a few … Continue reading

Posted in Blog | Tagged , , | 29 Comments

Where’s the Unit Testing?

I’ve been a proponent of Unit Testing, especially for databases. I’ve given presentations on the topic and advocate the use of techniques to verify your code works, especially over time when the complexity grows, new developers change code, and potentially … Continue reading

Posted in Editorial | Tagged , ,

Deploying Row Level Security with SQL Compare

SQL Compare is a core product from Redgate and I’ve got a series on some of the interesting things I’ve found. Download a trial today if you haven’t tried it. Row Level Security (RLS) is a great new feature in … Continue reading

Posted in Blog | Tagged , , , ,

What’s Database Drift?

The first time I heard someone mention drift at Redgate, it made sense to me. After all, in the context of the schema of your database, I can see the code “drifting” away from what you expect. Someone noticed this … Continue reading

Posted in Blog | Tagged , , | 4 Comments