Monthly Archives: July 2016

How Far Have You Traveled for a SQL Saturday?

Posted on July 29, 2016 by

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

Posted on July 29, 2016 by

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

Posted on July 28, 2016 by

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

Posted on July 28, 2016 by

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

Posted on July 27, 2016 by

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

Posted on July 26, 2016 by

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

Posted on July 26, 2016 by

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?

Posted on July 25, 2016 by

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

Posted on July 25, 2016 by

Row Level Security (RLS) is a great new feature in SQL Server 2016. It’s been in Azure SQL Databases for some time, but we now have it on premise. It’s easy to setup and use, and worth taking a look … Continue reading →

Posted in Blog | Tagged , , , ,

What’s Database Drift?

Posted on July 22, 2016 by

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