Denis Gobo's List: SQL

sqlblog.com/...dba-blunders.aspx - Preview

SQLServer SQL database microsoft gotcha programming DBA mishaps Job on 2008-05-16

sqlblog.com/...6653.aspx - Preview

SQLServer SQL database microsoft gotcha programming on 2008-05-16

Integration Services Data Types, because the naming is inconsistent between products

msdn.microsoft.com/...ms141036.aspx - Preview

SSIS SQLSERVER2005 SQLSERVER2008 on 2008-05-08

Question I answered long time ago

groups.google.com/...420f9e0b7c5d72a0 - Preview

mysql on 2008-05-06

sqlblog.com/...6311.aspx - Preview

programming database refactoring sql on 2008-04-21

sqlblog.com/...5991.aspx - Preview

Agile Interview Refactoring Scrum database sql sqlserver on 2008-04-02

sqlblog.com/...4209.aspx - Preview

sqlblog.com programming sql datababase on 2007-12-27

sqlservercode.blogspot.com/...rogrammers-part-3-general.html - Preview

programming career on 2007-12-27

sqlblog.com/...4199.aspx - Preview

programming career on 2007-12-27

sqlblog.com/...-sql-server-2000-and-2005.aspx - Preview

sqlserver SQLServer2000 SQLSERVER2005 hardware on 2007-12-21

sqlblog.com/...unt-the-battle-never-ends.aspx - Preview

database development performance sql on 2007-12-18

sqlblog.com/...6997.aspx - Preview

SQL database transactsql programming on 2008-05-28 and saved by 3 people

Microsoft Has Released Tools To Address SQL Injection Attacks

blogs.lessthandot.com/...has-released-tools-to-address- - Preview

SQL SQL Injection SQLInjection IIS Security ASP ASP.NET Database on 2008-06-25

Sometimes you want to know what the percentage is of null values in a table for a Column
Or you might want to know what the percentage of all values in a Column is grouped by value
You can get these answers by running the code below

blogs.lessthandot.com/...title-1 - Preview

sql database sqlserver sql server code programming on 2008-08-05

Only In A Database Can You Get 1000% + Improvement By Changing A Few Lines Of Code. In this case the query run time went from 24 hours+ to 36 seconds!!!

blogs.lessthandot.com/...database-can-you-get-1000-impr - Preview

programming SQL sqlserver database mssqlserver performance tuning performancetuning on 2008-08-18

Interview With Louis Davidson Author of Pro SQL Server 2008 Relational Database Design and Implementation

blogs.lessthandot.com/...with-louis-davidson-author-of- - Preview

sql database design interview programming howto sqlserver2008 on 2008-09-19

Troubleshooting Blocking 101 on SQL Server

blogs.lessthandot.com/...oting-blocking-101-on-sql-serv - Preview

lessthandot sql database sqlserver microsoft on 2008-11-19

SQL Server Precision And Scale Problems

blogs.lessthandot.com/...r-precision-and-scale-problems - Preview

programming SQL database sqlserver SQLSERVER2005 SQLSERVER2008 microsoft performance mssqlserver SQLServer2000 on 2008-11-25

A nice collection of puzzles. Some are harder than others so there is something for everyone. You can pic any language you want, you will see that there are solutions in Ruby, Python, Visual Basic, SQL, JavaScript, C++ and others

blogs.lessthandot.com/...ion-of-puzzles-for-programmers - Preview

programming puzzle puzzles javascript python ruby SQL on 2009-03-04 and saved by 3 people

blogs.lessthandot.com/...an-aggregated-column-s-related - Preview

SQL datababase sqlserver howto aggregates on 2009-07-24