Monthly Archives: September 2012

Full Text Search – CONTAINS

I’ve been working on a new presentation for full text search and brushing up on some of my T-SQL operators. Part of my talk goes into the CONTAINS operator, which is one of the full text search keywords you need … Continue reading

Posted in Blog | Tagged , , | 3 Comments

Outsourcing Security

Security is becoming more of an issue for many companies. Increased regulation, more scrutiny from the media, and customers that are more concerned about their data handling and privacy are forcing companies to spend more resources to ensure better security. However … Continue reading

Posted in Editorial | Tagged

Off to the Center of the Universe

“New York City…center of the universe..” – Rent I’m off to New York this morning for the start of the 2012 SQL in the City US Tour. It kicks off tomorrow in New York City. As this posts, I’ve just … Continue reading

Posted in Blog | Tagged , , , | 1 Comment

Pair Programming

I’ve never pair programmed, but I’m not sure I’d like it. As much as I like collaborating, I prefer alone time to work on problems, or think things through and experiment a bit on my own. I prefer brainstorming and … Continue reading

Posted in Editorial | Tagged | 1 Comment

Trade-offs

I’ve always told my managers that building software is a trade off. We can do things cheaply, or we can do them quickly, but we can rarely do both. We can certainly fail in both ways, and many people do, … Continue reading

Posted in Editorial | Tagged

Transferring Table Types

An interesting idea. I saw this question asked after I was playing with table types a bit. “Can you move a table type between schemas?” Suppose I had two schemas: CREATE SCHEMA OldSchema ; GO CREATE SCHEMA NewSchema ; GO … Continue reading

Posted in Blog | Tagged , ,

Rewrite the Coding Rules

Security is a problem in technology. Whether it’s technological misconfiguration, social engineering, or brute force attacks, we see a constant stream of headlines about security issues. The situation is not likely to change anytime soon as security isn’t seen as … Continue reading

Posted in Editorial | Tagged ,

Verify those Backups

It’s important that you backup your database. The most important thing you can do. However making backups isn’t enough: you need to verify those backups are good. A humorous short video from Grant Fritchey (b | t) and RedGate on … Continue reading

Posted in Blog | Tagged , , , | 1 Comment

Teammates

I loved the Terry Tate commercials as a young office worker. They were unveiled at the Super Bowl in 2003, when I was still managing a database team at Peoplesoft, with weekly issues occurring on our production systems. There were times I … Continue reading

Posted in Editorial | Tagged

Join Our Networking Dinner in Seattle

This is the third year that Andy Warren and myself are hosting a networking dinner in Seattle, just before the PASS Summit. If you are new to the Summit, or just interested in meeting some new people, we hope you’ll … Continue reading

Posted in Blog | Tagged , ,