14 Mar '13 - 7:16 by Shivprasad koirala (updated)
In this article I will discuss 5 features of SQL Server 2012 and the rest will be followed in other parts..
13 hrs ago by Moises Barba (updated)
The fifth incarnation of a dynamic and self-adaptive ORM library with full support for POCO objects, that doesn’t require any mapping or configuration files, and with support for natural SQL-like syntax in plain C#
13 hrs ago 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.
18 hrs ago by Moises Barba (updated)
Extending the Kerosene ORM library to include a dynamic and configuration-less Entity Framework built for POCO objects.
18 hrs ago by Moises Barba (updated)
An extension to the Kerosene ORM library that permits seamless database operations in WCF scenarios
23 hrs ago by Eric Lapouge (new)
An other way to export data from a SQL-Server to use them to call a web service
yesterday 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.
yesterday by Shemeer NS (new)
Utility for .NET Framework Cultures with Culture Specific Formats and Mapping with SQL Server Language. CultureInfo, DateFormat, Number Format, Currency Format, Percent Format, Infinity Format etc.
2 days 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)
4 days ago by Todd Sprang (updated)
This article explains how to create a general-purpose data-access library for creating dynamic queries using LINQ-to-Entities.
4 days ago by Peter Hancock (updated)
Using NAnt and CruiseControl.NET to continuously integrate database changes
4 Feb '11 - 1:58 by JasonShort (updated)
NOTE: This article was originally published on the VistaDB blog, but has been moved to this location permanently.Each of these items could be a blog post unto themselves, but I am going to try really hard to not be too verbose and just cover the core of the concept and why you need to do it.Data dri
3 days 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
4 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.
14 May '13 - 20:23 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
19 Nov '11 - 7:33 by Sangunni (updated)
Differences between a Stored Procedure and a function.
13 hrs ago by Amey K Bhatkar (updated)
The use of With (NoLock) hit with a simple example.
21 hrs ago by Aarti Meswania (updated)
Get duration between two dates in years, months, days, and hours using SQL Server.
yesterday by Shemeer NS (updated)
SQL Server culture mapping with .NET Framework.
4 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.
5 days ago by Manikandan Sekar (new)
Loading Data from Excel
14 May '13 - 6:58 by Srinubabu Ravilla (new)
How to get SQL Server database connection string easily from Visual Studio
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.
Product Showcase
Latest
News
Latest Discussions
Latest Best Picks
Submit an article or tip
Post your Blog
Latest 
Our Community