|
|
|
|
|
| | Total Hits: 11 | Today: 0 | Author: Oshtri Deka | Rating:  |
| | 
If your client has MS Excel installed, you can in few steps provide rather slick ad hoc solution which will do the job until you can provide something with more professional feel. Hey, I've done project where most of the reports are done this way and client prefers it. It's a Trade-off with capital T. Smile | :)... |
| | Total Hits: 11 | Today: 0 | Author: liron.levi | Rating: |
| |
I needed to convert the existing SQL server databases to SQLite databases as part of a DB migration program and did not find any decent free converter to do the job.
This is my attempt to solve the problem. I should warn you though that I did not have much time to test it on too many databases. In any case - the source code is very well documented and easy to understand, so if you do have a problem it should be relatively easy to fix. (Please send me the fixed source code. If you do so, I... |
| | Total Hits: 7 | Today: 0 | Author: CoperNick | Rating: |
| |
This article presents how to implement the functionality for presenting the so-called real-time data using ASP.NET and SQL Server. This functionality is realized by implementing Comet functionality in ASP.NET and connecting this with Query Notification from SQL Server.... |
| | Total Hits: 9 | Today: 0 | Author: Karthikeyan Anbarasan | Rating: |
| |
In this article we are going to see on how to use a FTP task in SSIS package to delete a local folder using FTP Task in SSIS packaging.
To follow my series of articles on SSIS packages refer to my profile for the links!!!... |
| | Total Hits: 1 | Today: 0 | Author: KarthikAnbarasan | Rating: |
| |
In this article we are going to see on how to use a FTP task in SSIS package to delete a local folder using FTP Task in SSIS packaging.
To follow my series of articles on SSIS packages refer to the below URL’s... |
| | Total Hits: 1 | Today: 0 | Author: Karthikeyan Anbarasan | Rating: |
| |
In this article we will see what a SQL Server Integration Services (SSIS) is; basic on why SSIS is used for, how to create a SSIS Package and how to debug the same.
SSIS is an ETL tool (Extract, Transform and Load) which is very much needed for the Data warehousing applications. Also SSIS is used to perform the operations like loading the data based on the need, performing different transformations on the data like doing calculation's (Sum, Average, etc.) and to define a workflow of how t... |
| | Total Hits: 15 | Today: 0 | Author: Vivek Johari | Rating: |
| |
Sometimes we need a column whose values can uniquely identifying the rows in the table. To achieve this purpose, this column should contains the unique values and it can’t contains the NULL or empty values. We can use this column in the “Where” clause of the Select statement to retrieve the data from the table quickly.... |
| | Total Hits: 32 | Today: 0 | Author: M.M.Al-Farooque Shubho | Rating: |
| |
We are in the process of optimizing an SQL Server database, and so far we have done lots of things. We applied indexing in our database tables and then re-factored the TSQL’s to optimize the data access routines. If you are wondering where we did all these and what are the things we have exactly done, take a look at the following articles in this series:
Top 10 steps to optimize data access in SQL Server. Part I (Use Indexing)... |
| | Total Hits: 112 | Today: 0 | Author: Jesper Lind and Scott Oveson | Rating: |
| |
This article steps through the process of implementing a plug-in viewer and integrating the viewer into Analysis Services. Provides stub code to enable viewer developers to quickly write a plug-in viewer into Analysis Services.... |
| | Total Hits: 177 | Today: 0 | Author: Muthusamy Anantha Kumar aka The MAK | Rating: |
| |
Part 1 and Part 2 of this series discussed Power Shell installation and simple SMO, WMI cmdlets. Part 3 covered how to script PowerShell and connect to SQL Server.
Part 4 explained how to use a PowerShell script to loop through the content of a file and connect to different servers. Part 5 examined creating a SQL Server database using PowerShell and SMO. Part 6 talked about backing up a SQL Server database using PowerShell and SMO. Part 7 illustrated how to list all of the objects in a da... |
| | Total Hits: 93 | Today: 0 | Author: novick software | Rating: |
| |
After the recent destruction of IIS based Web sites by the CodeRed and NIMBDA viruses, insuring security for Web applications has become everyone's job. This article gives a plan for recovering from virus attacks, securing the server and protecting from further attacks. It points the user directly resources that can speed the process. The outline of the plan is:
1. Recover from Infection or Rebuild
2. Install Operating System Upgrades and Patches
3. Verify that the system is... |
| | Total Hits: 202 | Today: 0 | Author: Ty Anderson | Rating: |
| |
In the past 12 months, Microsoft has released major versions of Visual Studio (Team System), SQL Server, Windows, SharePoint, and Office. Any one of these products alone would provide enough new features and development possibilities to keep me writing into next year (both code and articles!). Clearly it is a monumental year in Redmond and they aren't finished, as the release of Windows Server 2008 looms later this year.
Windows Server 2008 promises to be a boon to developers because it provi... |
| | Total Hits: 5609 | Today: 0 | | Rating: |
| |
This comprehensive collection of SQL Server database interview questions help you prepare for your interviews.... |
| | Total Hits: 3357 | Today: 0 | Author: Jesudas Chinnathampi | Rating: |
| |
This article is a continuation of the article "Inserting Images into SqlServer in ASP .NET". In this discussion, we will see, how to retreive an image from SqlServer database in ASP .NET. We need to take care of two aspects while displaying/retrieving .... |
| | Total Hits: 2625 | Today: 0 | Author: Jesudas Chinnathampi | Rating: |
| |
Read this article to know about, how to insert an image into a SqlServer database. You will also learn about the prerequistes for inserting an image into SqlServer. All aspects that need to take care in ASPX page and in database are discussed.............. |
| | Total Hits: 1 | Today: 0 | Author: Purushottam Rathore | Rating:  |
| |
In this article I am going to discuss how to resize a control using jquery.... |
| | Total Hits: 0 | Today: 0 | Author: Karthikanbarasan | Rating: |
| |
In this article we are going to see on how to use an Aggregate (Minimum) data flow transformation control in SSIS packaging. With this function operation we can get a number which is a minimum of a column. To start with this we should have the column to be of integer data type as specified in order to get the minimum. Let’s jump into to the example on how to use this control in real time.... |
| | Total Hits: 1 | Today: 0 | Author: Karthikanbarasan | Rating: |
| |
In this article we are going to see on how to use an Aggregate (COUNT) data flow transformation control in SSIS packaging. With this function operation we can get a Count on the number of rows necessary to get result in desired format. Let’s jump into to the example on how to use this control in real time.... |
| | Total Hits: 10 | Today: 0 | Author: Karthikeyan Anbarasan | Rating: |
| |
In this article we are going to see how to use a FTP task in SSIS package to create a remote folder using a FTP Task in SSIS packaging.
To follow my series of articles on SSIS packages refer to my profile for the links!!!... |
| | Total Hits: 3 | Today: 0 | Author: Karthikeyan Anbarasan | Rating: |
| |
In this article we are going to see on how to use a FTP task in SSIS package to Send a file. To follow my series of articles on SSIS packages refer to my profile for the links... |
|
|
|
|
|
|
|
|
|
|
|
|
|