 |
Embedding MSDE SQL Engine in a Visual Studios .Net Setup application
|
| Total Hit (1459) |
This document is a step by step description of adding SQL server to an Windows Application and embedding the MSDE engine into the application setup and installer program. By doing this you will automate the installation of the SQL server, the mounting of the datafiles and granting access to your app
....Read More |
Rating
 |
|
 |
Estimate the table size (Data + Index) for a given # of rows
|
| Total Hit (2464) |
Ever tried to estimate the table total size which include data and index in calculation ? Believe me its not easy job to estimate the size of a table for a give # of rows.
Here is the kool SP which does it for you. Full credit goes to Sharon Dooley for his excellent Job.
«code LangId=6»if exis
....Read More |
| Rating
|
|
|
|
|
|
Tutorial - Introduction to Microsoft.net
|
| Total Hit (9683) |
«a name=#L1»«/a»
«big»Introduction«/big»
This tutorial series is intended to initiate the reader into the world of .NET. I will try to cover most of the important .Net features. This tutorial will be useful for anyone with a programming background, especially for those who know VB.
There ar
....Read More |
Rating
 |
|
|
|
 |
Get list of installed ODBC drivers using ODBC API.
|
| Total Hit (7935) |
Here is a small code snippet to list all installed ODBC Drivers (name and attribute). On my machine I got the following output.
«code LangId=0»
SQL Server
UsageCount=3 : SQLLevel=1 : FileUsage=0 : DriverODBCVer=02.50 : ConnectFunctions=YYY : APILevel=2 : CPTimeout=60
--------------------------
....Read More |
| Rating
|
|
|
|
|
|
 |
How can I run Apache and IIS on the same Windows NT server?
|
| Total Hit (5647) |
I just installed ORACLE 9i on my Windows 2000 server (With IIS) and I noticed that Apache web server couldn't start so I was not able to run iSQL Plus. The reason was both IIS and Apache were trying to listen on port 80 and since IIS starts first it locks the port 80 so Apache couldn't listen on def
....Read More |
| Rating
|
|
|
|
Oracle's LogMiner - Part 1: Getting Started
|
| Total Hit (3229) |
Oracle's LogMiner utility has been around for several years now, and it originally appeared as a new feature (as opposed to being an improvement of something else). Each major release of Oracle typically ushers in a new set of features, some of which are actually useful and can make your job as a DB
....Read More |
| Rating
|
|
|
|
Search/Replace text in text, ntext datatype column
|
| Total Hit (3204) |
In SQL Server anything text longer than 8000 characters can be stored in TEXT or NTEXT datatype column but when you use TEXT or NTEXT datatype is not same as regular char, varchar, nchar or nvarchar datatype. You can not use string function like ltrim, rtrim, replace etc... Then how do you search an
....Read More |
| Rating
|
|
|
|
Very simple Encryption/Decryption code using VB
|
| Total Hit (5140) |
This code will show you how to encrypt/decrypt a string.
Copy/Paste the following code in your VB form and press F5 to run.
«code LangId=1»Const ENCRYPTION_KEY = "MySecreteKey123"
Private Sub Form_Load()
Dim txt As String, enctxt As String
txt = "Your password is : asd$223"
....Read More |
Rating
 |
|
|
|
|
|
Learning SQL Server 2005
|
| Total Hit (1046) |
Everyone wants to get ahead of the curve with SQL Server 2005, but many people don't have the time or desire to dig through a Google search. Steve Jones has gotten quite a few requests for resources, so here is a compiled list of some places that might help you get started.
....Read More |
| Rating
|
|
|
|
|
|
Writing Secure Transact-SQL
|
| Total Hit (753) |
There are plenty of good sources of information about how to deploy SQL Server in a secure fashion. However, these resources are often targeted at database administrators tasked with securing already developed applications. In addition, there is a rich body of information that discusses writing secu
....Read More |
| Rating
|
|
|
|
|
|
|
|
How to enable SSL encryption for SQL Server 2000
|
| Total Hit (2692) |
This step-by-step article demonstrates how to install a certificate on a computer that is running SQL Server 2000 by using Microsoft Management Console (MMC) and describes how to enable SSL Encryption at the server, or for specific clients.
«a href='http://support.microsoft.com/?id=316898'»http:/
....Read More |
| Rating
|
|
|
|
Case insensitive replace in .net
|
| Total Hit (12485) |
Sounds easy right.... but sometimes it can take your entire day how to do that using String Replace method. By default .Net string operations are case sensetive. In order to do case insensitive you need to use Strings.Replace method this is another replace method provided for VB programmers.
«co
....Read More |
Rating
 |
|
 |
Free - Query Analyzer for SQL Server with several Kool features
|
| Total Hit (1623) |
Query Analyzer Tool (QAT) functions similarly to the standard SQL Server Query Analyzer application. The main feature of QAT is that it allows you to view plans in a hierarchical tree and save them for future reference.
It is often the case that when you are analyzing the execution plans of a co
....Read More |
| Rating
|
|
|
|
How to find tablesize and estimated rows for all tables
|
| Total Hit (2768) |
Since there is no easy way using Enterprise Manager to know size and rows for all tables you need to write your own query. Run the following Query to see the result
«code LangId=6»USE Northwind
Go
SELECT a.Name
, SUM(b.RowCnt) EstRowCount
, SUM(b.Used) * 8 TableSize_KB
, (SU
....Read More |
Rating
 |
|
|
|
How to add/configure a new Linked server using T-SQL
|
| Total Hit (8595) |
Here is the T-SQL script to add linked server using sp_addlinkedserver SP. Once you add linked server you can add login using sp_addlinkedsrvlogin. By default current login is mapped with linked server means remote machine must have exact same login with same password in order to get access to the l
....Read More |
| Rating
|
|
|
|
How to start SQL Server Agent automatically when SQL Server starts.
|
| Total Hit (3575) |
When you install SQL Server by default SQL Server Agent Service is set to Start Manual mode and some times this can stop your scheduled jobs. Its also possible that you stop Agent and forget to turn it on.
This article will show you how to create a SP which can start SQL Server Agent service if i
....Read More |
| Rating
|
|
|
|
Automatically Upgrade Your .NET Applications On-the-Fly
|
| Total Hit (1253) |
Rich client, (or in .NET terminology, "Windows Forms") applications provide a great user experience in terms of functionality, usability, operating system and inter-application integration. Unfortunately, they have also suffered from a relatively high total cost of ownership compared to browser-base
....Read More |
| Rating
|
|
|
|
|
|
|
|
Custom Actions - Part 1
|
| Total Hit (2054) |
Custom Actions are deployment projects .NET programs written by your team that execute near the end of the installation process. You can use them to perform installation shores hard to implement with the existing features exposed by the setup project, in this order of ideas a custom action can insta
....Read More |
| Rating
|
|
|
|
Custom Actions - Part 2
|
| Total Hit (1980) |
Custom Actions are deployment projects .NET programs written by your team that execute near the end of the installation process. You can use them to perform installation shores hard to implement with the existing features exposed by the setup project, in this order of ideas a custom action can insta
....Read More |
| Rating
|
|
|
|
eBooks
|
| Total Hit (1915) |
«a href='ftp://ftp.netz.ru/Books/'»ftp://ftp.netz.ru/Books/«/a»
|
| Rating
|
|