ASP.NET Resource Refactoring(milkcarton.com)

submitted by akcoder(830) 4 years, 8 months ago

Easy macros to help i18n your ASPX pages read more...

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

tags: Macros ASPX DanMorphis ASP.NET VisualStudio another

Centralized Asynchronous Auditing across Instances and Servers with Se(sqlteam.com)

submitted by spirit1(3160) 4 years, 9 months ago

An example of Many-to-One application accross servers/instances of Service Broker, an addition to SQL Server 2005 that enables async work between instances read more...

add a comment |category: Database |Views: 13

tags: SqlServer2005 ServiceBroker Audit SQL 2005 another

Reading other people’s .NET code(3poundmass.wordpress.com)

submitted by wooyay(695) 4 years, 9 months ago

Places to find great examples of .NET code read more...

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

tags: Code .Net another

LINQ To Sql - Getting a Command Object from a Query(west-wind.com)

submitted by rstrahl(7226) 4 years, 9 months ago

LINQ to SQL is all about returning object from database queries, but sometimes it's actually useful to use good old DataReaders or DataTables - especially in ASP.NET applications that use DataBinding. Entities are objects and databinding requires Reflection which is very slow, compared to a DataReader. Luckily LINQ to SQL provides the abillity to retrieve a Sql Command object that can be used to return an alternate result set. read more...

add a comment |category: Database |Views: 13

tags: another

Converting between Win32 COLORREF and .NET Color(alteridem.net)

submitted by rprouse(1175) 4 years, 9 months ago

If you are ever rewriting an MFC/Win32 program in .NET, you need to be aware that you cannot convert directly between a COLORREF value and a .NET Color structure. The byte order is different and will need to be swapped. read more...

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

tags: Win32 MFC .Net C# SQL another

Linq to Sql: Extension Methods(chrisbrandsma.com)

submitted by cwbrandsma(1711) 4 years, 9 months ago

A brief discussion of the extension methods that get generated when a LINQ to SQL mapping is generated. read more...

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

tags: .net3.5 LinqToSql C#3.0 C# LINQ another

A job scheduler for SQL Server (Express)(dotnetpulse.blogspot.com)

submitted by adventurer(2244) 4 years, 9 months ago

SQLScheduler is a fully functional client/server application written in C# that allows administrators to schedule various SQL jobs for SQL Server Express and other versions of SQL Server. read more...

add a comment |category: Database |Views: 40

tags: SQLExpress SQL another

SQL SERVER - 2005 - Create Script to Copy Database Schema and All The (blog.sqlauthority.com)

submitted by pinaldave(9662) 4 years, 9 months ago

This is very simple but powerful. Explained with Images. read more...

6 comments |category: Database |Views: 193

tags: SQL SQLAuthority DBA pinaldave Database another

LINQ to SQL and Disconnected Entities Follow-up(west-wind.com)

submitted by rstrahl(7226) 4 years, 9 months ago

Several people have been flogging me for my LINQ and disconnected Entity post, so I thought I should follow up on the issues I've been having. First let me restate Entity issue I raised a couple of days ago, but let me present it in a simpler context with the Northwind database, so you can try... read more...

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

tags: LINQ SQL ADO.NET another

SQL Server: How to run a stored procedure at SQL Server start-up (weblogs.sqlteam.com)

submitted by spirit1(3160) 4 years, 9 months ago

This is acctually quite simple. There is 'startup' option that you can set to the procedure. Code included. read more...

add a comment |category: Database |Views: 17

tags: startup StoredProcedure SQLServer Database SQL another

SQL SERVER - 2005 - List All The Column With Specific Data Types(blog.sqlauthority.com)

submitted by pinaldave(9662) 4 years, 9 months ago

SQL Server 2005 has new datatype of VARCHAR(MAX), we decided to change all our TEXT datatype columns to VARCHAR(MAX). The reason to do that as TEXT datatype will be deprecated in future version of SQL Server and VARCHAR(MAX) is superior to TEXT datatype in features. We run following script to identify all the columns which are TEXT datatype and developer converts them to VARCHAR(MAX) ...see the script here read more...

add a comment |category: Database |Views: 10

tags: SQL varchar max pinaldave SQLAuthority another

SQL Server FAQ Interview Questions(dotnetguts.blogspot.com)

submitted by vermdivya(365) 4 years, 9 months ago

SQL Server FAQ Interview Questions * SQL Queries FAQ * FAQ on Indexes in SQL * FAQ on Data Types in SQL Server * FAQ on Joins in SQL Server * FAQ on Stored Procedure in SQL Server * FAQ on Trigger in SQL Server * FAQ on Lock in SQL Server * FAQ on View in SQL Server * FAQ on Transaction in SQL Server * SQL Server FAQ on Random Category * FAQ on Tools in SQL Server * FAQ on Permissions in SQL Server * FAQ on Administration in SQL Server read more...

add a comment |category: Other |Views: 84

tags: Interview SQL another

SQL Optimization Tips(dotnetguts.blogspot.com)

submitted by vermdivya(365) 4 years, 9 months ago

Tips and Tricks which should be used while dealing with SQL read more...

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

tags: Optimization SQL Tips another

LINQ to SQL and Dynamic Queries and Expressions?(west-wind.com)

submitted by rstrahl(7226) 4 years, 9 months ago

Continuing my experiments with LINQ in the middle tier I ran into another problem: Inability to make LINQ run any dynamic operations that are not defined explicitly in the LINQ to SQL import. For building a generic business framework that doesn't have concrete type references (to say a PK field) but dynamically needs to create SQL to query data. Even relatively simple things like retrieve a single record by primary key where primary key is dynamic not explicit is not easily accomplished without getting real low level into Lambda expression creation. read more...

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

tags: LINQ SQL another

SQL SERVER - UDF - Validate Integer Function(blog.sqlauthority.com)

submitted by pinaldave(9662) 4 years, 9 months ago

I received quite a good feedback about my post about SQL SERVER - Validate Field For DATE datatype using function ISDATE() One of the most interesting comment I received from my reader from Canada. I was suggested just like ISDATE() to write about ISNUMERIC() which can be used to validate numeric values. As per BOL: ISNUMERIC returns 1 when the input expression evaluates to a valid numeric data type; otherwise it returns 0. ISNUMERIC returns 1 for some characters that are not numbers, such as plus (+), minus (-), and valid currency symbols such as the dollar sign ($). Now this is issue with ISNUMERIC() function. It even suggest variable as numeric when it is not. I use following function to validate instead of ISNUMERIC() to validate if number is numeric or not. read more...

add a comment |category: Database |Views: 34

tags: SQL SQLAuthority pinaldave Database SQLServer another

LINQ to SQL and attaching Entities(west-wind.com)

submitted by rstrahl(7226) 4 years, 9 months ago

I have been experimenting with LINQ to SQL in the middle tier and have run into the apparently common issue of re-attaching entities to a DataContext in cross tier scenarios. Either the support re-attachment is not there or it is broken but either way it doesn't work which makes it pretty tough to use LINQ to SQL in the middle tier. read more...

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

tags: LINQ SQL another