Simple Talk is now part of the Redgate Community hub - find out why

Spoofing Popularity-A warning to Webmasters

0
0
In which Phil tries to warn you of the dangers of over-valuing Website-traffic Stats. A friend who runs a local history website in a rural area of England surprised me by saying that he values a single letter of interest or appreciation more highly than any amount of increased web-traffic on his site. He gave … Read more
0
0

Palindromic Transact SQL

0
0
Palindromes are words or phrases that read the same backwards and forwards. By the same token, Palindromic SQL executes just as well backwards and forwards A phrase such as … “Did I do, O God, did I as I said I’d do? Good, I did” “Marge lets Norah see Sharon’s telegram” “No, son, onanism’s a … Read more
0
0

I could do it in my sleep

0
0
Like many other programmers, I have adapted to a rather cat-like lifestyle of intense activity followed by relative languor. This coincides with the cyclic nature of the industry: Either there is too much work or too little. At the moment, there’s too much work, so I’m tending to work around twelve-hour days, often more. Of … Read more
0
0

Sir! My dog ate my database.

0
0
In asking various colleagues about the disasters or near disasters they have had with databases, I find to my astonishment that I am the only one who has ever, in a moment when my attention wandered, deleted a live database. It is odd, though, how products geared solely to mopping up from database disasters sell … Read more
0
0

Getting Stuff Into SQL Server

0
0
Often, Newbies to SQL Server are left feeling puzzled by the difficulty of ‘Getting stuff in and out’ of data tables. At first it does seem daunting, and I have to admit that I’m still a bit vague on some aspects myself. How, (or why) would one get image data in or out of a … Read more
0
0

A SQL Limerick

0
0
It wasn’t my idea at all. However someone set me the challenge of writing executable code that rhymed and scanned in the form of a limerick. Obviously, the easy trick is to just to write the limerick, assign it to a string and then do text substitution on that striing to convert it into SQL … Read more
0
0

Unreadable code

0
0
Producing unreadable Transact SQL is something of an art form. We all know that the best Transact SQL Style is to make everything elegant and obvious, with explanatory identifiers, liberal comments and deft formatting. It doesn’t always happen, for a number of reasons. One of the more subtle effects of acute caffein poisoning is to … Read more
0
0

How you log in to Simple Talk has changed

We now use Redgate ID (RGID). If you already have an RGID, we’ll try to match it to your account. If not, we’ll create one for you and connect it.

This won’t sign you up to anything or add you to any mailing lists. You can see our full privacy policy here.

Continue

Simple Talk now uses Redgate ID

If you already have a Redgate ID (RGID), sign in using your existing RGID credentials. If not, you can create one on the next screen.

This won’t sign you up to anything or add you to any mailing lists. You can see our full privacy policy here.

Continue