11 Jun '11 - 11:56 by Omar Al Zabir (updated)
Production Architecture for a SaaS web application built using ASP.NET and SQL Server that guarantees 99.99% availability and super performance
5 hrs ago by Mehdi Gholam (updated)
NoSql, JSON based, Document store database with compiled .net map functions and automatic hybrid bitmap indexing and LINQ query filters (now with standalone Server mode, Backup and Active Restore, Transactions, Server side queries, MonoDroid support)
yesterday by Shemeer NS (updated)
CAST(), CONVERT(), PARSE(), TRY_PARSE(), TRY_CONVERT(), FORMAT(), SQL Server Functions, SQL Server Functions that helps to convert date and time values to and from string literals and other date and time formats.
yesterday by Todd Sprang (updated)
This article explains how to create a general-purpose data-access library for creating dynamic queries using LINQ-to-Entities.
2 days ago by Peter Hancock (updated)
Using NAnt and CruiseControl.NET to continuously integrate database changes
2 days ago by dale.newman (updated)
Google your SQL.
2 days ago by Joffrey Brouillet (updated)
This is an alternative for "A set of ADO classes - version 2.20"
3 days ago by h_wiedey (updated)
Implementation of relative database constraints and permissioning using triggers and shadow tables.
5 days ago by Shemeer NS (updated)
SQL Server 2000, 2005, 2008, 2008 R2, 2012 Character String Data Types and Functions with Sample SQL Statements. Quick reference, Data Type Tables, Function Tables
12 May '13 - 11:48 by Shemeer NS (updated)
.NET Framework Cultures with Culture Specific Formats and Mapping with SQL Server Language. CultureInfo, DateFormat, Number Format, Currency Format, Percent Format, Infinity Format etc.
10 May '13 - 11:49 by Bishram (new)
Recruitment and selection process is a very important aspect in acquiring and managing talent in any organization. Typically, the process is owned by Human Resource Department.
12 Nov '10 - 22:41 by Vivek Johari (updated)
Stored Procedure in Sql server can be defined as the set of logically group of sql statement which are grouped to perform a specific task. This article will describe the Stored Procedure in Sql server and their benefits
16 hrs ago by Tharaka MTR (updated)
Recently I had to involve in a database migration task. I backed up the database and restored successfully in the new server. However when I access the database through the web site, database login didn’t work. The problem was even though the database user is included in the restored database; the l
2 days ago by Sebastian Solnica (updated)
In this post I will show you an interesting problem that we experienced when querying a SQL Server database with Dapper.
3 days ago by Gordon W Beeming (new)
Simply run the script and then every time SQL is restarted all your Identity columns will be reset to the latest available seed.
9 May '13 - 22:41 by Ivan Krivyakov (new)
Random notes on MDX filtering
9 May '13 - 9:33 by PRANAV SINGH (new)
Stored Procedure with sorting, paging, and filtering.
8 May '13 - 8:26 by snorkie (new)
This post is designed to help you understand how to use the EXISTS keyword in your SQL query environment.
7 May '13 - 19:18 by Basavaraj P Biradar (updated)
Difference between SET QUOTED_IDENTIFIERS ON and OFF settings.
7 May '13 - 19:11 by Basavaraj P Biradar (updated)
The new Merge statement in SQL Server 2008.
3 May '13 - 9:33 by Shahriar Iqbal Chowdhury/Galib (new)
Background In my last post I showed how to split a string in TSQL. Problem with that splitting is it can split a string if resultant split count is <=2, i.e. it can split only string like “a,b” or “first,last” or “java,c”. But while doing the parsing of string of
3 May '13 - 9:31 by Shahriar Iqbal Chowdhury/Galib (new)
Background When you see the your database in Suspect mode that a code red situation. Its not something that you face everyday. It can happen, however, most often due to faulty hardware or operational mistakes (like deleting a transaction log file). This post will show how to recover from suspect mod
16 Aug '11 - 16:04 by qadirv (updated)
Quick C# console application to Encrypt all your database stored procedure.
2 days ago by Pavan Thakur (new)
I had a requirement to create automatic date entries into Scheduler SQL table. Whenever a Schedule with RecurrenceRange was set with 'No EndDate', the dates will automatically get added from backend for next year through a job.
3 days ago by Manikandan Sekar (new)
Loading Data from Excel
4 days ago by Srinubabu Ravilla (new)
How to get SQL Server database connection string easily from Visual Studio
11 May '13 - 0:40 by Amey K Bhatkar (updated)
10 May '13 - 16:44 by Youqi Ma (new)
Using a controller to manage dynamic control form events and creation.
10 May '13 - 9:24 by ShajuAntony (new)
List out reports from Reprting Server.
10 May '13 - 4:16 by Sukant Shekhar (new)
Creation of random and unique code
8 May '13 - 17:42 by PratapReddyP (new)
Merge in SQL Server 2008.
8 May '13 - 0:45 by grandtree (updated)
Create a calendar by inputting month
7 May '13 - 19:09 by Basavaraj P Biradar (updated)
Difference between SQL Server Char and Varchar data type.