|
|
|
|
|
Total Hits: 3 | Today: 3
|
Author: Rich Dudley
|
Rating:
|
|
SQL Server 2005 introduced a radical upgrade to SQL Server 2000’s Data Transformation Services (DTS). The differences were so great that a new name was given to the tool—SQL Server Integration Services (SSIS). Whether or not you were a heavy user of DTS, SSIS can seem overwhelming when you first try to create a package. This book clears up the confusion and works you through a number of common scenarios to have you fluent in SSIS very quickly....
|
|
|
|
Total Hits: 2 | Today: 2
|
Author: Dan Griffin
|
Rating:
|
|
Passwords can be a big security and manageability headache for enterprise IT administrators. Users often create simple passwords or write their passwords down to make sure that they'll remember them. In addition, there are few secure and efficient procedures for resetting passwords. Knowing these limitations, how can you mitigate these types of security problems when remote users access your network? Seeing that many users write down their passwords, how would you make your company's password so...
|
|
|
|
Total Hits: 3 | Today: 3
|
Author: Steve Fox
|
Rating:
|
|
Office Business Applications (OBAs) are composite applications built using the services, tools, and servers that comprise the Microsoft® 2007 Office system. These applications integrate with line of business (LOB) systems such as SAP, PeopleSoft, and Microsoft Dynamics. The primary goal behind OBAs is to build on existing investments in LOB systems by bridging the gap that exists when employees don't have direct access to business data residing in the LOB system. As a result of this gap, many e...
|
|
|
|
Total Hits: 3 | Today: 3
|
Author: Brian Mains
|
Rating:
|
|
This article discusses how and when the objects within LINQ to SQL are created and instantiated, and how it maintains a list of the changes that need submitted to the database. It also discusses how this can be managed and some of the intricacies in LINQ with the help of source code. LINQ to SQL is an ORM tool that connects to SQL Server databases. It generates business objects to match a database's table structures, which are all centrally available through the DataContext class. The LINQ-to-SQ...
|
|
|
|
Total Hits: 1 | Today: 1
|
Author: Danilo Corallo
|
Rating:
|
|
For my last project, I've been using the latest free version of SQL Server, called SQL Server Express Edition, available here. I immediately noticed that the database scheduler was removed since the previous version. I found it really interesting creating my own SQL Agent. In this article, I'll show you how to create a generic scheduler that runs on a Windows Service. The scheduler will be able to accept pluggable actions that we can develop, later implementing a custom interface....
|
|
|
|
Total Hits: 1 | Today: 1
|
Author: johnnycantcode
|
Rating:
|
|
This utility will copy the schema and data from a normal SQL Server 2000/2005 database and export it to a SQL Server Compact Edition database. The tool supports version 3.1 or 3.5 of SQL Server Compact Edition. I was working on a mobile application and needed and easy way to manage the table relationships and indexes without having to resort to scripting. I was familiar with using SQL Server Management Studio so I decided that I would write a utility that converted a normal SQL Server database t...
|
|
|
|
Total Hits: 6 | Today: 1
|
Author: Anton Ponomarev
|
Rating:
|
|
Microsoft Report Viewer 2005 control does not support export to Microsoft Word formats by default, but following the steps outlined in this article, you will be able to get Report Viewer to generate reports in Microsoft Word formats (DOC, RTF, WordprocessingML and OOXML) when working in the local mode. I came across this issue while working on a project for one of my clients recently. The project initially relied on using Microsoft Report Viewer but later the client realized they needed reports ...
|
|
|
|
Total Hits: 3 | Today: 0
|
Author: Bean Software
|
Rating:
|
|
If you want to develop web sites with dynamic contents (eCommerce, bulletin boards, etc.), one of the options is to MS SQL Server to store, modify, and get your data. Data access to SQL Servers is provided in ASP.NET by ADO.NET. There are five steps in this area below....
|
|
|
|
Total Hits: 1 | Today: 0
|
Author: Bean Software
|
Rating:
|
|
Business development often requires analysis and data mining. Determining trends with which Customers and other stake holders deal with a business are of sole importance to the business. In fact, helping a businessman to grow his business has contributed a lot in rapid growth of IT industry. Microsoft SQL Server Reporting services provide a solution to those tasked in finding business trends. Briefly speaking:
1. Reporting services lets you create rich reports and format them based on your...
|
|
|
|
Total Hits: 2 | Today: 0
|
Author: Bean Software
|
Rating:
|
|
LINQ to SQL is an extension of LINQ that allows developers to write "queries" in your ASP.NET web application to retrieve and manipulate data from a SQL Server database. This gives the ability to access relational database objects as normal .Net objects. LINQ to SQL integrates SQL based schema definitions to the common language runtime (CLR) type system. This provides strong typing, syntax checking, intellisense over SQL objects, while retaining the expressive power of the relational model and t...
|
|
|
|
Total Hits: 4 | Today: 0
|
Author: Emil Lerch
|
Rating:
|
|
This is an updated version of the code posted by IPC2000. The following changes have been made:
* References to the enterprise library have been removed, allowing for more flexibility in specifying the connection string. Connection strings and verbosity can be specified on the command line.
* Output is more "spreadsheet friendly", using tab delimited output that can be copy/pasted into Excel
* Support for SQL 2005 has been introduced. Separation of user from schema in SQL 20...
|
|
|
|
Total Hits: 6 | Today: 0
|
Author: Zeeshan Jafar Hirani
|
Rating:
|
|
LINQ to SQL solves the mismatch between the object oriented and relational database world. In an application we deal in terms of our domain objects such as customer and orders. However, when it comes to saving these objects and solving the datatype mismatch between the programming and database world, it has traditionally been the developer's responsibility to write code to persist these objects to a database and handle the data type conversions....
|
|
|
|
|
|
