An Interview With Kevin Kline About SQL In A Nutshell Third Edition(blogs.lessthandot.com)

submitted by dnk2007(765) 3 years, 3 months ago

An Interview With Kevin Kline About SQL In A Nutshell Third Edition. SQL In A Nutshell covers MySQL, PostgreSQL, Oracle and SQL server read more...

add a comment |category: Database |Views: 99

tags: Database another

SQL Server - Set based random numbers(blogs.lessthandot.com)

submitted by dnk2007(765) 3 years, 4 months ago

SQL Server - Set based random numbers The problem with the rand function occurs when you use set based operations. read more...

add a comment |category: Database |Views: 98

tags: Database another

The Ten Most Asked SQL Server Questions And Their Answers(blogs.lessthandot.com)

submitted by dnk2007(765) 3 years, 5 months ago

Then 10 most asked SQL Server Programming questions and their answer read more...

1 comment |category: Database |Views: 729

tags: Database another

An interview with Louis Davidson author of pro sql server 2008(blogs.lessthandot.com)

submitted by dnk2007(765) 3 years, 8 months ago

Pro SQL Server 2008 Relational Database Design and Implementation is one of those books that should be in the hands of every SQL Server developer. There are tons of SQL Server programming books around but none of them covers the fundamentals of a good SQL Server database, the design. If your design is ‘broken’ then it is a lot harder to fix it down the road, design is probably the number one reason people have all kinds of problems with their databases. read more...

add a comment |category: Database |Views: 118

tags: Database another

Send Action Queries to Your Database in Batches(blogs.lessthandot.com)

submitted by dnk2007(765) 3 years, 8 months ago

Coming from a database background, I should’ve known better. But, I didn’t. Recently I found myself needing to write a GUI wrapper for a new Address Standardization component we got at work. This was purchased in order to clean addresses for a variety of data processing tasks we do on the way into the database, allowing us to completely automate these processes, read more...

add a comment |category: ADO.NET |Views: 200

tags: Database ADO.NET another

Only In A Database Can You Get 1000% + Improvement By Changing A Few L(blogs.lessthandot.com)

submitted by dnk2007(765) 3 years, 9 months ago

Only In A Database Can You Get 1000% + Improvement By Changing A Few Lines Of Code read more...

add a comment |category: Database |Views: 624

tags: Database another

nHibernate performance against stored procedures(blogs.lessthandot.com)

submitted by dnk2007(765) 3 years, 10 months ago

A 5 part blogpost about the performance of a select statement done with ADO.Net using inline sql, and stored procedures (even some dynamic sql) and then nHibernate to get the same results. But this one has an alternate ending. read more...

6 comments |category: ADO.NET |Views: 515

tags: ADO.NET Database another

Danger in Design: Why bother with Architecture?(blogs.lessthandot.com)

submitted by dnk2007(765) 3 years, 10 months ago

Creativity is a wonderful thing. It’s also something different for each of us, which is why sometimes our perspectives on the world can produce conflicting ideas on what is the right way and the wrong way to do things. This is a very common facet of the IT world, in particular making computer software, solutions and services. read more...

1 comment |category: Architecture |Views: 278

tags: Architecture another

The Evolution of Systems Integration(blogs.lessthandot.com)

submitted by dnk2007(765) 3 years, 11 months ago

From Fax to SOA, a journey to success ? We’ve come a long way since the days of fax machines and typewriters - the objectives have remained pretty similar, and with each iteration of the solution we’ve found resolution to issues in the former, yet we continue to unveil new aspects of the objective that need addressing. Will we ever get to a perfect solution ? read more...

add a comment |category: Architecture |Views: 18

tags: Architecture another

SQL Server Programming Hacks(forum.lessthandot.com)

submitted by dnk2007(765) 3 years, 11 months ago

This is a collection of SQL hacks, right now there are 8 sections and between 70 and 80 hacks. read more...

add a comment |category: Database |Views: 611

tags: SQL Tips Database another