Viewing 15 posts - 1,666 through 1,680 (of 3,658 total)
Steve Jones - SSC Editor (10/6/2013)
Jeff Moden (10/5/2013)
...
I guess that qualifies as a "rant", huh?
Yep, and I agree.
Ditto from me.
October 8, 2013 at 6:32 am
Jeff Moden (10/5/2013)
Heh... you have to trust me on this... You DON'T actually want them to do their own backups. 😉
Backups fine, restores...not so much
October 7, 2013 at 2:18 am
Full-text searching has always been something of a disappointment for me.
SSIS is one of those tools that when I come back to it I spend a week swearing at it...
October 1, 2013 at 3:15 pm
Encrypt your data backups.
Store the certificates used to encrypt your backups somewhere else but equally secure.
Limit access to both the certificates and the backups to a tightly and formally designed...
October 1, 2013 at 1:52 am
It's a harsh fact of life and a quick look down the list of fixes in the older versions of SQL Server reveal some quite nasty bugs.
There is inherrent complexity...
September 25, 2013 at 1:51 am
There's big by design and big by lack of design.
Big doesn't necessarily mean complex or difficult it really does depend on your use case. For example, the Microsoft Fastrack...
September 23, 2013 at 4:07 pm
@charles, exactly so.
One of the implementations of Soundex stored the soundex value of a holiday destinations in an indexed field.
When the customer entered a location the system would...
September 12, 2013 at 3:38 pm
The hardest part of TDD for me was the change in mind set I needed to make. Couple that to the difference between app development and db development and it...
September 12, 2013 at 1:21 pm
Don't put Soundex inside the difference function as Soundex comparison is implicit in the function.
select Difference(Soundex('Brighton'),Soundex('Bob')) -- Returns 4
select Difference('Brighton','Bob') --Returns 1
September 12, 2013 at 9:53 am
Take a look at http://ntz-develop.blogspot.co.uk/2011/03/phonetic-algorithms.html
The Rolls Royce solution is Metaphone3 which I believe is in the latest Apache SOLR.
I had planned a followup article based on the link above. ...
September 12, 2013 at 8:31 am
jimbobmcgee (9/12/2013)
See Char.IsLetter -- a generically useful, centrally maintained library method, robust enough to check for lower-case letters. 😉
Oh bugger, you can tell I don't do much .Net work!
September 12, 2013 at 6:56 am
Continuous integration is a no-brainer. JFDI.
Continuous deployment makes me nervous from a DBA perspective.
If a deployment means a change to a big table and replication is involved then it...
September 6, 2013 at 1:26 am
First, what the <insert your own expression here>?
My expression would be "Kalen Delaney".
Ada Lovelace - possibly the first ever computer programmer.
Grace Hopper "the mother of Cobol"
Frances Allen - Won a...
August 28, 2013 at 4:10 am
I saw a program about Bill Gates and comments made by (I think) an IBM exec was that he was a better engineer than the engineers in the room, he...
August 27, 2013 at 11:57 am
Don't forget ORM tools. Some of the complexity of what needs to be done either means complexity is pushed into the application or implemented using triggers.
August 23, 2013 at 12:31 pm
Viewing 15 posts - 1,666 through 1,680 (of 3,658 total)