SQL Server Code,Tips and Tricks, Performance Tuning

A blog about SQL Server, Books, Movies and life in general

Thursday, May 31, 2007

Sam Gentile Reviews RubyMicrosoft Essay By Martin Fowler

›
Martin Fowler asked Sam Gentile to review and contribute thoughts to his very important new essay RubyMicrosoft . This piece presents the vi...
Wednesday, May 30, 2007

Speed Up Performance And Slash Your Table Size By 90% By Using Bitwise Logic

›
You have all seen websites where you can pick a bunch of categories by selection a bunch of check boxes. usually what you do is store those ...
1 comment:

Blogging On sqlblog.com

›
Adam Machanic invited me to start blogging on sqlblog.com, I accepted and you can find posts from now on here and there. Of course you will ...
Tuesday, May 29, 2007

Check Your SQL For SQL Injection Vulnerabilities By Using These 15 Free SQL Injection Scanners

›
Memorial day is over, back to work. Your first task is to check for SQL Injections Securiry Hacks has listed 15 of them, that list is here: ...
1 comment:
Sunday, May 27, 2007

Top 10 .NET Framework Technologies to Learn in 2007. What do you think?

›
help.net list the following 10 .NET Framework Technologies to Learn in 2007 . What do you think? I think that you can not known all of these...
Thursday, May 24, 2007

Object Databases Suck RDMBS's Rock

›
Gavin King (Mr Hibernate) trashes what we call 'Object Databases'. This is excellent reading material and full of information why RD...
Wednesday, May 23, 2007

Book Review: Pro SQL Server 2005 Database Design and Optimization

›
Pro SQL Server 2005 Database Design and Optimization By Louis Davidson, Kevin Kline, Kurt Windisch ISBN: 1590595297 672 pp. Published: May 2...
Tuesday, May 22, 2007

Inconvenient Truth???

›
I wonder how many trees he killed with all that paper on his desk? He better have solar panels to power those 3 monitors! Notice how he does...
2 comments:
Sunday, May 20, 2007

It's Time For Violence: A song about Databases vs CodeMonkey

›
Since it is the weekend Here are 2 song for you, they both have something to do with programming. First song is Time For Violence A Song abo...
Wednesday, May 16, 2007

Interview with Adam Machanic Author Of Expert SQL Server 2005 Development

›
I am a big fan of Adam Machanic and the way he thinks about SQL server development. How may SQL developers unit test their procedures or use...
Tuesday, May 15, 2007

flickrvision

›
David Troy the person who brought you twittervision has done it again this time with flickr. Check out flickrvision Who needs animated des...
Monday, May 14, 2007

Google: A Girl's Best Friend

›
Type these searches into a Google search box she created she invented she discovered she debugged Look at what Google suggests.

Make Your Case Sensitive Searches 1000 Times Faster

›
I had an case sensitive update query that ran in about 9 minutes. Since it was a case sensitive query it did an index scan not an index seek...
4 comments:
Sunday, May 13, 2007

Great Programming Quote

›
"pasting code from the internet into production code is like chewing gum found in the street." None of use pasted straight into pr...
Thursday, May 10, 2007

Why Does OBJECTPROPERTY Have A TableIsFake Property?

›
You can run the following function (OBJECTPROPERTY(object_id, N'TableIsFake') ) on an object and it will return 1 if the table is fa...
‹
›
Home
View web version
Powered by Blogger.