SQL Server 2008 - Cheat Sheet - One Page PDF Download(blog.sqlauthority.com)

submitted by pinaldave(9662) 3 years, 7 months ago

Very frequently I have been asked to create a page, post or article where in one page all the important concepts of SQL Server are covered. SQL Server 2008 is very large subject and can not be even covered 1000 of pages. In daily life of DBA there are few commands very frequently used and for novice developers it is good to keep all the important SQL Script and SQL Statements handy. I have attempted to create cheat sheet for SQL Server 2008 most important commands. User can print this in one A4 size page and keep along with them. This can be used in interviews where T-SQL scripts are being asked. Let me know your opinion and if you find this useful. Bookmark it for future use. read more...

2 comments |category: Database |Views: 912

tags: SQLAuthority SQL2K8 pinaldave sqlserver2008 Database another

SSMS Tools PACK 1.1 - now with SSMS 2008 support(weblogs.sqlteam.com)

submitted by spirit1(3160) 3 years, 7 months ago

With this new version you can use it for SQL Server Management Studio 2008 and SQL Server Management Studio 2008 Express. Plus some extra features. read more...

add a comment |category: Database |Views: 240

tags: SQLServer 2008 Database 2005 another

Regular Expressions In MS SQL Server using CLR(anastasiosyal.com)

submitted by ccook(320) 3 years, 7 months ago

In this post I'll show just how easy it is to make your SQL Server 2005 database support Regular Expressions through what is known as SQL CLR read more...

add a comment |category: Database |Views: 18

tags: Database another

Working With Linq's Expression Trees Visually(blog.wekeroad.com)

submitted by adminjew(1490) 3 years, 8 months ago

I've been working a lot with LINQ over the last few months, trying to approach it sanely with respect to SubSonic. It's not that it's terribly difficult to understand - it can simply be overwhelming at times with how much is in there. And whenever you think you know it, you realize that not only were you wrong, you weren't even in the same universe. read more...

add a comment |category: Linq |Views: 28

tags: LINQ another

Unit testing and PInvoking pt. 2(blog.mendeltsiebenga.com)

submitted by Mendelt(110) 3 years, 8 months ago

Part two in a series of blogposts describing how to unit test code that uses PInvoke calls. read more...

add a comment |category: Unit Testing |Views: 2

tags: Testing another

Dynamically Create a Zip File Your Users Can Then Download(beckelman.net)

submitted by beckelmw(2755) 3 years, 8 months ago

I recently had a requirement to allow users to select a group of files and then dynamically create a zip file on the server of the selected files that they could then download. read more...

add a comment |category: ASP.NET |Views: 355

tags: ASP.NET another

Collection.IsNullOrEmpty(blog.freakcode.com)

submitted by niik(365) 3 years, 8 months ago

A great highly reusable utility method that increases your code readability. Do you love String.IsNullOrEmpty? Well, this is exactly the same but for collections read more...

add a comment |category: Tips & Tricks |Views: 51

tags: Tips another

Efficient XML processing(geekswithblogs.net)

submitted by elroydsilva(100) 3 years, 8 months ago

This post describes both, a conventional as well as a different (and probably better) way of processing XML tags. read more...

add a comment |category: Tips & Tricks |Views: 11

tags: Tips another

Use caution with anonymous types and other new C# language features - (codebetter.com)

submitted by redcap(420) 3 years, 8 months ago

I think Microsoft is making a huge mistake by leaning so heavily on anonymous types as API parameters, particularly in the ASP.NET MVC Framework.  Not only does this make the APIs in the system ugly and error-prone, but it's not intuitive, and there is no intellisense for it because the API is untyped (typed as object) in the case where an anonymous type is expected.  I think we should stick with named types and named methods wherever possible.  I currently don't see a problem with lamda's if they give an advantage over regular arguments. I'm very cautious about automatically using new, unproven language features before we fully understand how they will affect the usability and maintainability of code.  Note:  we have NO track record for the maintainability of these new language features, and they were developed specifically for LINQ, so using them outside of that context is suspect, in my opinion. read more...

add a comment |category: Architecture |Views: 14

tags: Architecture another

Hasing big files in style(alexandre-gomes.com)

submitted by imacoder(140) 3 years, 8 months ago

Describes how to hash big files including progress support. Useful when it takes too long to complete. read more...

add a comment |category: C# |Views: 9

tags: C# another

Displaying time in relative format(nirandas.com)

submitted by crpietschmann(11.3k) 3 years, 8 months ago

Many websites specially forum sites display time relative to the current time as “3 Hours 25 Minutes ago”, “30 Seconds ago” etc. In this post I will show a method using which we can convert datetime into descriptive relative time string. read more...

add a comment |category: CLR |Views: 16

tags: DateTime CLR another

ProMesh.NET v2.0 RC1 is (finally) out(blog.activa.be)

submitted by activa(2340) 3 years, 8 months ago

After months of writing documentation, the first release candidate of ProMesh.NET v2.0 has been released in the wild. ProMesh.NET is a powerful MVC framework for .NET 2.0 that has been around for a long time, but today it finally reached another important milestone. read more...

add a comment |category: Open Source |Views: 281

tags: ProMesh ASPNETMVC ProMesh.NET OpenSource MVC another

Tutorial: How to Get a List of Available Network Interfaces(insidercoding.com)

submitted by mwhouser(210) 3 years, 8 months ago

This article describes how to get a list of network connections and their status (up/down, IP address, etc.). read more...

add a comment |category: C++ |Views: 36

tags: C++ another

Render ASP.NET Control as String(stevesmithblog.com)

submitted by ssmith(1160) 3 years, 8 months ago

Some simple tips and a handy extension method for rendering any ASP.NET control as a string, which can then be passed via a web service to an AJAX call. read more...

add a comment |category: ASP.NET |Views: 327

tags: ASP.NET another

Get A List Of Installed Applications Using LINQ And C#(onedotnetway.com)

submitted by deepakkapoor(430) 3 years, 8 months ago

To get a list of installed applications we need to look into registry. Microsoft.Win32 namespace contains objects which can be used to work with Windows Registry. In this post I will show you some code where I use the power of LINQ to retrieve and display a list of all applications installed on a machine. read more...

add a comment |category: Linq |Views: 38

tags: LINQ another

Free Data Structures and Algorithms book(dotnetslackers.com)

submitted by jamesewelch(2275) 3 years, 8 months ago

This book written by Granville Barnett and Luca Del Tongo is part of an effort to provide all developers with a core understanding of algorithms that operate on various common, and uncommon data structures. Data Structures and Algorithms: Annotated Reference with Examples is completely free! read more...

add a comment |category: Products |Views: 30

tags: Algorithms Structures data free Book another