Database
|
Recent Database Articles
SQL Pivot and Table AdapterThe Pivot operator in SQL Server 2005 is very useful for displaying a crosstab report. Using the DataGrid control, we can easily display a crosstab report in a Windows form. This article shows you how to do it without writing any code. ... Microsoft SQL Server | Friday, 30 January 2009 |
The Baker"s Dozen: 13 Comparisons Between Crystal Reports and SQL Server Reporting ServicesExplore how the rich reporting functionality in Crystal Reports XI and SQL Server Reporting Services 2005 works with common reporting requirements. Microsoft SQL Server | Friday, 30 January 2009 |
How to truncate log file in SQL Server 2005
General | Friday, 30 January 2009 |
SQL Server Reporting Services 2005 XML extensionsMicrosoft SQL Server Reporting Services (SSRS) has support for a plethora of data sources. Out of the box, its data modules, called data extensions, allow you to build reports from SQL Server and Oracle database, as well as any other database that comes with an OLE DB or ODBC prov... Microsoft SQL Server | Thursday, 29 January 2009 |
A scripted SQL query generation framework with IDE: SQLpp (v1.4)SQLpp The article ... General | Thursday, 29 January 2009 |
Using TRY...CATCH in Transact-SQLUsing TRY...CATCH in Transact-SQL General | Thursday, 29 January 2009 |
Maps Tables , Relation between Tables and Columns Info of a SQL Server DataBaseHaving the need to map the database tables at Runtime, columns and it relations, the basic is to know 4 properties about the tables: General | Monday, 26 January 2009 |
Generate Stored Procedure Wrapper Methods and Associated Wrapper ClassesIt is generally a good idea to create a wrapper method for every stored procedure that an application needs to call. Such methods can then be grouped into a single data access utility class. This approach improves type safety and portability. General | Sunday, 25 January 2009 |
Database VisualizationGeneral | Saturday, 24 January 2009 |
SQL SERVER - 2008 - Configure Database Mail - Send Email From SQL Databaseto Service Broker. Microsoft SQL Server | Friday, 23 January 2009 |
SQL Server report compress solution (Zip format)Microsoft SQL Server reporting service is the emerging technology in reporting services. As the reporting service is being shipped along with the MS SQL Server almost all .NET based projects use them. General | Friday, 23 January 2009 |
Managing Repetitive Jobs Without CursorsExplains a technique to eliminate the need to write your own cursors to accomplish common database administration tasks, such as running the DBCC (database consistency checker) routines to update index statistics or to run a backup of a database. Microsoft SQL Server | Thursday, 22 January 2009 |
Making ATL OLE DB Provider templates support updating of data - Part 1General | Thursday, 22 January 2009 |
Developing Abstract Functions for Accessing Stored ProceduresIf you are using an application which uses Stored Procedures to access and/or update all of its data, this is a technique that I like to use to minimize having parameter names in multiple places and which allows you to maintain this information much more easily. General | Wednesday, 21 January 2009 |
Using C#, OpenXML, and Microsoft SQL Server 2000 to create a multi-threaded Rules Engine WebserviceThis articles uses C#, OpenXML, and Microsoft SQL Server 2000 to create a multi-threaded Rules Engine Webservice. Microsoft SQL Server | Monday, 19 January 2009 |
Satisfy Your Users with ViewsThis 10-Minute Solution describes two ways of giving end users direct access to query a database using views. Microsoft SQL Server | Sunday, 18 January 2009 |
How to send SMS messages from C# using an SQL databaseIn this article I give you an example on how you can send SMS messages to wireless devices from C#.Net. I assume, that you are familiar with Visual Studio 2003 or 2005 and the basics of databases and the SQL language. The solution described here is an in-house solution. To use it ... General | Saturday, 17 January 2009 |
Grouping Sets in T-SQL (SQL Server 2008)This article discuss Grouping Sets in T-SQL. Grouping Sets is a new feature in T-SQL in SQL Server 2008. Microsoft SQL Server | Thursday, 15 January 2009 |
Some "Hints" for Mastering SQL TuningHelp your database optimize SQL queries by including hints in your SQL statements. Used correctly, hints can reduce the running time of your queries significantly. Microsoft SQL Server | Wednesday, 14 January 2009 |
Execute a Long-Running Workflow Using Persistence in Windows WFIf you"re experimenting with workflows it won"t be long before you find that you need to run a workflow that is too long to execute directly from memory. A workflow that needs hours—or even days—to conclude requires you to persist the workflow instance to an external medium so that the workflow can be continued later. Microsoft SQL Server | Tuesday, 13 January 2009 |
|
More in: MySQL, Microsoft SQL Server, Oracle, General |
|
Latest Articles
- AntiHisto
- Thumbnail images in PHP
- Online Dating Websites
- Hack to enforce the cache of an XmlDataSource to invalidate
- AutoSearch SELECT tag
- Nine ASP.NET Site Navigation Problem Solutions: Part 1
- Enhanced rich edit control
- CheckListBox based on ListBox that supports ReadOnly
- Introduction to COM - What It Is and How to Use It.
- Introduction to the Validation Application Block
