Click here to Skip to main content
Page 1 of 48
Page Size: 10 · 25 · 50


Tag filtered by:  DBA [x]
Article 13 May 2013   license: CPOL
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
Article 10 May 2013   license: CPOL
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.
Article 8 May 2013   license: Ms-PL
This is an alternative for "A set of ADO classes - version 2.20"
Catalog 7 May 2013   license: Commercial
dbForge Data Compare for MySQL is a tool to compare and synchronize data of MySQL databases. You can quickly analyze data differences in a well-designed user interface and synchronize comparison results in a convenient wizard with additional options.
Tip/Trick 7 May 2013   license: CPOL
Create a calendar by inputting month
Technical Blog 7 May 2013   license: CPOL
The new Merge statement in SQL Server 2008.
Article 6 May 2013   license: CPOL
This project creates a Visual Studio visualizer for entity framework queries, view edit and run the generated SQL.
Tip/Trick 6 May 2013   license: CPOL
This article explains how to calculate the Check Digit Vertical (CDV) and Horizontal (CDH) by Sql Server.
Technical Blog 5 May 2013   license: MIT
Using existing database in Windows Phone
Technical Blog 3 May 2013   license: CPOL
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
Technical Blog 2 May 2013   license: CPOL
[toc] Introduction Note to pedantic guys: yes Access is not a database engine, only the graphical front-end to Jet/ACE, but we’ll stand with this simplification. The sample application (Excel + VBA) and the SQL source code are available in this … Continue reading →
Tip/Trick 2 May 2013   license: CPOL
How to avoid the Cursor in Stored Procedures
Answer 1 May 2013   license: CPOL
Please try to use can use Open XML SDK:http://www.microsoft.com/en-us/download/details.aspx?id=30425[^].This way, you can support new XML-based Office formats (such as .DOCX, .XLSX), ECMA-376 standard, even if Office is not...
Catalog 30 Apr 2013   license: Shareware
LinqConnect is a LINQ to SQL compatible ORM solution with extended functionality, support for SQL Server, Oracle, MySQL, PostgreSQL, and SQLite, its own visual model designer, seamlessly integrating to Visual Studio, and SQL monitoring tool.
Article 29 Apr 2013   license: CPOL
One of the things that drew me to SQL Server 2012 was the FileTable feature. It seemed to be a great fit for my need, and to relatively easy to implement. Here’s my scenario, the solution I chose, the “gotchas” I ran into, and how I dealt with them.
Article 28 Apr 2013   license: CPOL
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)
Catalog 27 Apr 2013   license: Free For Personal Use
SQLServerBooster is an application for DBA or people that do programming around Microsoft SQL Server ® and need to make backups automatically, compress and send through FTP, Amazon S3 ®, Amazon Glacier ®, Windows Azure ® or network.
Question 26 Apr 2013   license: CPOL
My Company supplies the MS SQL Server 2005 Express database .mdf files with their solution. Which we attach at client's computers SQL server (Doesn't have the Management studio) on first run of the application software. Now my boss wants me to lock the database so that no one can even see the...
Answer 26 Apr 2013   license: CPOL
All you need is to set Authentication mode[^] to: SQL Server and Windows Authentication mode.How to change authentication mode? See this: How to: Change Server Authentication Mode[^].Please, read about: Security Considerations for a SQL Server Installation[^] too. Follow the related...
Answer 25 Apr 2013   license: CPOL
From what how you describe the problem you have to solve I would suggest you to check this product (http://www.docentric.com). Just download the trial and check the example app that ships with it. I think it offers exactly what you are looking for (a template based document generation).
Answer 22 Apr 2013   license: CPOL
[This is not an answer and should be removed — SA]i need to create a word document 1- i save the document with the file name in the textbox2- suppose i save the document name as ABC.docx3- now i want the final saved document to be saved as ABC_001_A.docx4- this all i need to do it in...
Tip/Trick 19 Apr 2013   license: CPOL
Automatic query execution at every instance startup.
Tip/Trick 18 Apr 2013   license: CPOL
To avail Danish language as a language breaker in full text search index option, it has to be enabled manually by adding a registry key for the Danish language.
Technical Blog 9 Apr 2013   license: CPOL
The idea is simple, everytime an outgoing link is clicked, we will load an XML file at the backend and pass the URL of the outgoing link or an associated unique ID (e.g. web trends ID in case we are using a web analytics software such as Web Trends) This will leave a stamp of [...]How to track outgo
Article 8 Apr 2013   license: CPOL
How to effectivley version your SQL Server databases using SQL Server Data Tools
Tip/Trick 4 Apr 2013   license: CPOL
The script helps to find out upcoming birthdays even when days cross a year.
Technical Blog 4 Apr 2013   license: CPOL
Oracle tables have no built-in mechanism for auto numbering. Instead, you must create a separate unique Sequence object and use it each time a record is inserted into the database.
Article 3 Apr 2013   license: CPOL
Explaining different ways to join tables
Article 3 Apr 2013   license: CPOL
How to configure database mail in SQL Server 2008
Article 2 Apr 2013   license: CPOL
This is the part 1 of a comparison on Data Access methods in the .NET environment.
Tip/Trick 1 Apr 2013   license: CPOL
Querying data from tables across multiple databases when we need data from all those tables in a single query.
Article 30 Mar 2013   license: CPOL
How to import data from a .mdf file to SQL Server and from SQL Server to Excel
Question 28 Mar 2013   license: CPOL
Hi sir. I am getting error message while connecting to System i Navigator. It displaying “the requested operation cannot be performed because the system connection was dropped”.. I searched lot in Google but cant able to find solution.. please guide me…
DBA
Article 28 Mar 2013   license: CPOL
How to execute multiple long running SQL Statement Asynchronously in smaller chunks
Question 26 Mar 2013   license: CPOL
HI my question?how to handle 2 phase commit in oracle and sql server??????????
DBA
Answer 26 Mar 2013   license: CPOL
You can do this, but:1) You can add reference to a property set that is unique. 2) As primary key, (A,B,C) is unique.3) If you want to add reference to (A,B), it has to be unique4) If (A,B) is unique thus a primary key candidate, why is (A,B,C) the primary key after all?I smell a...
DBA
Question 26 Mar 2013   license: CPOL
If you refer a composite primary key of a master table, you have to refer all the fields of the composite primary key.But how to partially refer the composite primary key in a child table? For example, if Table1 has primary key (A,B,C),how to create a foreign key in Table2 which will refer...
DBA
Catalog 21 Mar 2013   license: Fully Function Evaluation version
Aspose.Total for JasperReports is a suite of 4 unique JasperReports Exporters that allows you to export your JasperReports reports to Word, Excel, and PowerPoint documents. Moreover, it is also possible to add Barcodes to the exported documents using Aspose.Total for JasperReports.
Catalog 21 Mar 2013   license: Fully Function Evaluation version
Aspose.Cells for JasperReports allows exporting reports from JasperReports & JasperServer to MS Excel XLS format. It is written purely in Java and a single provided JAR file can easily be deployed on the machines running JasperReports or JasperServer
Catalog 21 Mar 2013   license: Fully Function Evaluation version
Aspose.BarCode for JasperReports allows developers to display high quality barcode labels on JasperReports that can be rendered further in BMP, JPG, GIF and PNG formats. It supports more than 25 barcode symbologies including Linear and 2D barcodes.
Catalog 21 Mar 2013   license: Fully Function Evaluation version
Aspose.BarCode for Reporting Services allows rendering of barcode images in SQL Server 2000, 2005 & 2008 Reporting Services. It supports 29+ linear (1D) and 2D barcode symbologies, DPI resolution settings and barcodes rendering into image formats.
Catalog 21 Mar 2013   license: Fully Function Evaluation version
Aspose.BarCode is a Java component for generation & recognition of 1D & 2D barcodes to support Java and web applications. Now it supports 29+ barcode symbologies and allows you to take image output in GIF, PNG, BMP & JPG formats.
Catalog 21 Mar 2013   license: Fully Function Evaluation version
Aspose.Words for JasperReports makes it possible exporting reports from JasperReports and JasperServer to DOC, DOCX, HTML, RTF, ODT and TXT formats. It is written in Java and the JAR file can be deployed on the machines running JasperReports or JasperServer.
Catalog 21 Mar 2013   license: Fully Function Evaluation version
Aspose.BarCode is a .NET component for generation and recognition of Linear and 2D barcodes on all kinds of .NET applications. It supports WPF with 29+ Barcode symbologies. It allows you to insert barcodes into PDF, Word & Excel and take image output in BMP, GIF, JPEG, PNG & WMF formats.
Catalog 21 Mar 2013   license: Fully Function Evaluation version
Aspose.Words for SharePoint allows converting documents within SharePoint applications and supports PDF, DOCX, DOC, RTF, MHT, XML, ODT, EPUB and XPS formats. You can use it with Windows SharePoint Services and Microsoft Office SharePoint Server 2007.
Catalog 21 Mar 2013   license: Fully Function Evaluation version
Aspose.Total is a suite of 11 powerful .NET components including Word, Excel, PowerPoint, Editor, Project, PDF, Flash, Charting, Email, Barcode creation, Ad hoc query generation, Recurrence patterns and Network protocols.
Catalog 21 Mar 2013   license: Fully Function Evaluation version
Aspose.Total for Reporting Services is a suite of 5 rendering extensions for SQL Server Reporting Services. Now developers can export their RDL reports to Word, Excel, PowerPoint and PDF documents. You can also add Barcodes to the exported documents.

Page 1 of 48
1 2 3 4 5 6 7 8 9 10


Advertise | Privacy | Mobile
Web01 | 2.6.130513.1 | Last Updated 13 May 2013
Copyright © CodeProject, 1999-2013
All Rights Reserved. Terms of Use
Layout: fixed | fluid