Create XML Files Out Of SQL Server With SSIS And FOR XML Syntax (blogs.lessthandot.com)

submitted by SQL_Menace(4890) 3 years, 2 months ago

Create XML Files Out Of SQL Server With SQL Server Integration Services And FOR XML Query Syntax read more...

add a comment |category: Database |Views: 28

tags: Database another

SQL Server 2008 Proximity Search With The Geography Data Type(blogs.lessthandot.com)

submitted by SQL_Menace(4890) 3 years, 3 months ago

Showing how you can use the geography data type in SQL Server 2008 to do zipcode proximity search, link to data is available as well as a link to 2000/2005 version read more...

add a comment |category: Database |Views: 67

tags: Database another

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

Key Feature list For All the Different Windows 7 Versions (blogs.lessthandot.com)

submitted by SQL_Menace(4890) 3 years, 3 months ago

Here are the key features for all the different windows 7 versions read more...

add a comment |category: Products |Views: 9

tags: another

Cool Way To Launch The Malicious Software Removal Tool(blogs.lessthandot.com)

submitted by SQL_Menace(4890) 3 years, 3 months ago

Did you know that you can run the Malicious Software Removal Tool from the run command or create a shortcut in 2 easy steps read more...

add a comment |category: Security |Views: 23

tags: Security 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

SQL Server Precision And Scale Problems(blogs.lessthandot.com)

submitted by SQL_Menace(4890) 3 years, 6 months ago

Many people are confused about SQL Server’s precision and scale. This is unfortunate because choosing the correct values for precision and scale is critically important when you perform math operations using the decimal/numeric data type read more...

add a comment |category: Database |Views: 194

tags: Database another

IDE Features In Visual Studio 2010(blogs.microsoft.co.il)

submitted by kolbis(660) 3 years, 6 months ago

Visual Studio 2010 has some cool features for the developers to allow rapid application development and basically allow the developers to be more productive. read more...

add a comment |category: Visual Studio |Views: 61

tags: VisualStudio another

XML Documentation File For Your .Net Project - It’s Important (dev102.com)

submitted by talisharon10(800) 3 years, 6 months ago

No comments appeared in the Visual Studio tooltip. On In this article, I am going to explain why it is so important to generate XML documentation file for each one of your .Net projects. read more...

2 comments |category: Visual Studio |Views: 344

tags: VisualStudio another

Troubleshooting blocking 101 on sql-server(blogs.lessthandot.com)

submitted by chrissie1(370) 3 years, 6 months ago

How to find out which process is blickong in SQL-server 2005 read more...

1 comment |category: Database |Views: 179

tags: Database another

An interview with Roy Osherove author of "The Art of Unit Testing"(blogs.lessthandot.com)

submitted by chrissie1(370) 3 years, 7 months ago

A short interview with Roy Osherove, author of a new book "The Art of Unit Testing" and known blogger, who works on Typemock Isolator. read more...

add a comment |category: Other |Views: 206

tags: another

VB.Net: Rhino Mocks and the AAA syntax(blogs.lessthandot.com)

submitted by chrissie1(370) 3 years, 7 months ago

About how to use the new AAA (Arrange, act, and Assert) syntax with VB.Net and the difference with the old syntax. read more...

add a comment |category: VB.NET |Views: 38

tags: VB.NET 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

LINQ to SQL queries involving strings cause SQL Server procedure cache(blogs.lessthandot.com)

submitted by SQL_Menace(4890) 3 years, 8 months ago

Be careful when using LINQ. If an application is using LINQ to SQL and the queries involve the use of strings that can be highly variable in length, the SQL Server procedure cache will become bloated with one version of the query for every possible string length read more...

add a comment |category: Linq |Views: 177

tags: LINQ Bug SQL Database Performance 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: ADO.NET Database another