tag:blogger.com,1999:blog-47603469219606394982012-01-26T09:48:06.769+02:00Mitkohttp://www.blogger.com/profile/06708938184736986774noreply@blogger.comBlogger691100tag:blogger.com,1999:blog-4760346921960639498.post-60115469899933127812007-06-17T19:26:00.001+03:002007-06-17T19:31:04.542+03:00

Technorati YahooMyWeb del.icio.us Digg Furl Reddit Spurl Blinklist

Mitkohttp://www.blogger.com/profile/06708938184736986774noreply@blogger.com1tag:blogger.com,1999:blog-4760346921960639498.post-29450014122293814262007-04-06T13:56:00.000+02:002007-04-06T14:45:39.127+02:00

Ever wanted to convert the HTML content generated by the ASP.NET to WORD / DOC?Ever wanted to get rid of VIEWSTATE, FORM and other INPUT fields in ASP.NET?Ever wanted to get rid of Top of Form and Bottom of Form labels inside of the generated word document?Ever wanted to get rid of INPUT fields inside of the generated word document?The solution is simple and apsolutely FREE! Enjoy!C# Code:private

Mitkohttp://www.blogger.com/profile/06708938184736986774noreply@blogger.com0tag:blogger.com,1999:blog-4760346921960639498.post-42193518413341594972007-04-02T08:31:00.000+02:002007-04-02T08:40:53.974+02:00

Summary:The ten most egregious offenses against users. Web design disasters and HTML horrors are legion, though many usability atrocities are less common than they used to be.Since my first attempt in 1996, I have compiled many top-10 lists of the biggest mistakes in Web design. See links to all these lists at the bottom of this article. This article presents the highlights: the very worst

Mitkohttp://www.blogger.com/profile/06708938184736986774noreply@blogger.com0tag:blogger.com,1999:blog-4760346921960639498.post-88563373873922359432007-03-21T18:02:00.000+02:002007-03-22T11:32:39.920+02:00

Introduction String UDFs StrInsStrDelStrSeparateStrCHARINDEXStrREPLACEStrREVERSEIntroductionI would like to write the series of articles about useful User-Defined Functions grouped by the following categories:Date and Time User-Defined FunctionsMathematical User-Defined FunctionsMetadata User-Defined FunctionsSecurity User-Defined FunctionsString User-Defined FunctionsSystem User-Defined

Mitkohttp://www.blogger.com/profile/06708938184736986774noreply@blogger.com10tag:blogger.com,1999:blog-4760346921960639498.post-9730729851088409302007-03-21T18:01:00.000+02:002007-03-22T11:37:55.133+02:00

Introduction Mathematical UDFs Factorial PercentFrom PercentValue Degree Allocation Combination Introduction I would like to write the series of articles about useful User-Defined Functions grouped by the following categories: Date and Time User-Defined Functions Mathematical User-Defined Functions Metadata User-Defined Functions Security User-Defined Functions String User-Defined Functions

Mitkohttp://www.blogger.com/profile/06708938184736986774noreply@blogger.com0tag:blogger.com,1999:blog-4760346921960639498.post-49812082692185610882007-03-21T18:00:00.000+02:002007-03-22T11:38:50.480+02:00

Introduction Meta Data UDFs COL_LENGTH2 COL_ID INDEX_ID INDEX_COL2 ROW_COUNT Introduction I would like to write the series of articles about useful User-Defined Functions grouped by the following categories: Date and Time User-Defined Functions Mathematical User-Defined Functions Metadata User-Defined Functions Security User-Defined Functions String User-Defined Functions System User-Defined

Mitkohttp://www.blogger.com/profile/06708938184736986774noreply@blogger.com0tag:blogger.com,1999:blog-4760346921960639498.post-80308079655155489832007-03-21T17:58:00.000+02:002007-03-21T17:59:53.469+02:00

Introduction Date and Time UDFs DatePart TimePart GetWorkingDays AddWorkingDays FirstMonthDay LastMonthDay Introduction I would like to write the series of articles about useful User-Defined Functions grouped by the following categories: Date and Time User-Defined Functions Mathematical User-Defined Functions Metadata User-Defined Functions Security User-Defined Functions String User-Defined

Mitkohttp://www.blogger.com/profile/06708938184736986774noreply@blogger.com0tag:blogger.com,1999:blog-4760346921960639498.post-33648998513487662652007-03-21T17:57:00.000+02:002007-03-21T17:58:51.965+02:00

Introduction UDF examples Database creation date Date the object was created Get date part of datetime value Get time part of datetime value Get the number of working days between two dates Introduction SQL Server 2000 supports User-Defined Functions (UDFs) - one or more Transact-SQL statements that can be used to encapsulate code for reuse. User-defined functions cannot make a permanent

Mitkohttp://www.blogger.com/profile/06708938184736986774noreply@blogger.com0tag:blogger.com,1999:blog-4760346921960639498.post-2825886361830237442007-03-21T17:55:00.002+02:002007-03-21T17:56:15.785+02:00

General concepts There are no devices or segments in SQL Server 7.0 and SQL Server 2000, as there were in SQL Server 6.5. Now databases reside on operating-system files.There are three types of such files: primary secondary log Each database consists of at least two files: one is a primary data file (by default, with the .mdf extension) the other is log file (by default, with the .ldf extension).

Mitkohttp://www.blogger.com/profile/06708938184736986774noreply@blogger.com0tag:blogger.com,1999:blog-4760346921960639498.post-38903539298391637432007-03-21T17:55:00.001+02:002007-03-21T17:55:27.357+02:00

General concepts In this article, I want to show how you can improve the speed of your queries by choosing the proper indexes, what kinds of indexes MS SQL supports and what is the advantage and disadvantage of using indexes in particular situation. There are clustered and nonclustered indexes. A clustered index is a special type of index that reorders the way records in the table are physically

Mitkohttp://www.blogger.com/profile/06708938184736986774noreply@blogger.com0tag:blogger.com,1999:blog-4760346921960639498.post-85427228090876269172007-03-21T17:54:00.001+02:002007-03-21T17:54:39.829+02:00

It's not necessary to view the SQL Server transaction log, but if you are a DBA, it may be useful to resolve some problems. It may be useful for understanding the internal SQL Server architecture too. SQL Server 6.5 Every database contains the syslogs system table in SQL Server 6.5. This table contains the transaction log, and is used by SQL Server for recovery and roll forward. You cannot modify

Mitkohttp://www.blogger.com/profile/06708938184736986774noreply@blogger.com0tag:blogger.com,1999:blog-4760346921960639498.post-19913019918091728482007-03-21T17:52:00.000+02:002007-03-21T17:53:58.926+02:00

In this article, I want to show, how you can copy a single text or image value into or out of SQL Server by using the textcopy.exe utility. You can find this utility in the directory containing the standard SQL Server EXE files (C:\Mssql\Binn for SQL Server 6.5, by default and C:\Mssql7\Binn for SQL Server 7.0, by default). Textcopy.exe utility is not described in SQL Server Books Online, but you

Mitkohttp://www.blogger.com/profile/06708938184736986774noreply@blogger.com1tag:blogger.com,1999:blog-4760346921960639498.post-33252625438616444782007-03-21T17:49:00.000+02:002007-03-22T19:44:38.450+02:00

To get the total row count in a table, we usually use the following select statement:SELECT count(*) FROM table_nameThis query performs full table scan to get the row count. You can check it by setting SET SHOWPLAN ON for SQL Server 6.5 or SET SHOWPLAN_TEXT ON for SQL Server 7.0/2000. So, if the table is very big, it can take a lot of time. In this example, the tbTest table will be created and

Mitkohttp://www.blogger.com/profile/06708938184736986774noreply@blogger.com0tag:blogger.com,1999:blog-4760346921960639498.post-71736685315813969422007-03-21T17:46:00.000+02:002007-03-21T17:47:32.860+02:00

*****You can use the Usage-Based Optimization Wizard to optimize partition performance based on the history of queries previously sent to the cube.To run the Usage-Based Optimization Wizard run Analysis Manager, right-click the appropriate cube and choose 'Usage-Based Optimization', then complete the steps in the wizard. *****Try to separate the OLTP server with the OLAP server if these servers

Mitkohttp://www.blogger.com/profile/06708938184736986774noreply@blogger.com0tag:blogger.com,1999:blog-4760346921960639498.post-38649005762568302062007-03-21T17:45:00.000+02:002007-03-21T17:46:35.472+02:00

*****Set a reasonable size of your database.Because SQL Server 6.5 database cannot automatically grow, you should estimate how big the database will be. To estimate the reasonable database size, you should previous estimate the size of each table individually, and then add the values obtained. *****Set a reasonable size for the transaction log.Because SQL Server 6.5 transaction log cannot

Mitkohttp://www.blogger.com/profile/06708938184736986774noreply@blogger.com0tag:blogger.com,1999:blog-4760346921960639498.post-74035679721389341352007-03-21T17:44:00.000+02:002007-03-21T17:45:07.843+02:00

*****For the very large databases, use distributed partitioned views to partition tables horizontally across multiple servers.This is a new SQL Server 2000 feature, which is available when using SQL Server 2000 Enterprise Edition only. Due to distributed partitioned views, SQL Server 2000 now on the first place in the TPC-C tests. *****Use indexed views to increase the speed of your queries.The

Mitkohttp://www.blogger.com/profile/06708938184736986774noreply@blogger.com0tag:blogger.com,1999:blog-4760346921960639498.post-5331694078250867952007-03-21T17:43:00.000+02:002007-03-21T17:44:03.540+02:00

*****Use stored procedures instead of heavy-duty queries.This can reduce network traffic, because your client will send to server only stored procedure name (perhaps with some parameters) instead of large heavy-duty queries text. Stored procedures can be used to enhance security and conceal underlying data objects also. For example, you can give the users permission to execute the stored

Mitkohttp://www.blogger.com/profile/06708938184736986774noreply@blogger.com0tag:blogger.com,1999:blog-4760346921960639498.post-71684702047330402732007-03-21T17:42:00.002+02:002007-03-21T17:43:39.197+02:00

*****Avoid publishing unnecessary data.Try to restrict the amount of published data. This can results in good performance benefits, because SQL Server will publish only the amount of data required. This can reduce network traffic and boost the overall replication performance. *****Place the published database log and distribution database log on the separate disk drives.Because logging is more

Mitkohttp://www.blogger.com/profile/06708938184736986774noreply@blogger.com0tag:blogger.com,1999:blog-4760346921960639498.post-47102974810173441972007-03-21T17:42:00.001+02:002007-03-21T17:42:49.943+02:00

*****Try to perform backup at the local hard disk first, and copy backup file(s) to the tape later.When you perform backup, some SQL Server commands cannot be made, for example: during backup you cannot run ALTER DATABASE statement with either the ADD FILE or REMOVE FILE options, you cannot shrink database, you cannot run CREATE INDEX statement, you cannot make SELECT INTO, bulk load and so on.

Mitkohttp://www.blogger.com/profile/06708938184736986774noreply@blogger.com0tag:blogger.com,1999:blog-4760346921960639498.post-7631074780636613412007-03-21T17:41:00.002+02:002007-03-21T17:42:16.212+02:00

*****Try to restrict the queries result set by using the WHERE clause.This can results in good performance benefits, because SQL Server will return to client only particular rows, not all rows from the table(s). This can reduce network traffic and boost the overall performance of the query. *****Try to restrict the queries result set by returning only the particular columns from the table, not

Mitkohttp://www.blogger.com/profile/06708938184736986774noreply@blogger.com0tag:blogger.com,1999:blog-4760346921960639498.post-7159412664094074202007-03-21T17:41:00.001+02:002007-03-21T17:41:34.873+02:00

*****Normalize your tables to the third normal form.A table is in third normal form (3NF) if it is in second normal form (2NF) and if it does not contain transitive dependencies. In most cases, you should normalize your tables to the third normal form. The normalization is used to reduce the total amount of redundant data in the database. The less data there is, the less work SQL Server has to

Mitkohttp://www.blogger.com/profile/06708938184736986774noreply@blogger.com0tag:blogger.com,1999:blog-4760346921960639498.post-22261149196480261092007-03-21T17:39:00.002+02:002007-03-21T17:40:47.776+02:00

*****Set a reasonable size of your PAGEFILE.SYS file(s).Microsoft recommends that the Windows NT PAGEFILE.SYS file(s) be set to physical RAM + 12 MB for the initial size and physical RAM + half of physical RAM for the maximum size. Microsoft recommends that the Windows 2000 PAGEFILE.SYS file(s) be set to 1.5 times the amount of physical RAM.If you used additional SQL services such as Full-Text

Mitkohttp://www.blogger.com/profile/06708938184736986774noreply@blogger.com0tag:blogger.com,1999:blog-4760346921960639498.post-29297367360291372062007-03-21T17:39:00.001+02:002007-03-21T17:39:20.877+02:00

*****You can turn off the 'auto create statistics' database option.When this database option is set to true, statistics are automatically created on columns used in a predicate. By default, this database option is set to true. Because auto creation statistics results in some performance degradation, you can turn off this database option and create statistics manually during off-peak times by

Mitkohttp://www.blogger.com/profile/06708938184736986774noreply@blogger.com0tag:blogger.com,1999:blog-4760346921960639498.post-90725437266160728462007-03-21T17:38:00.001+02:002007-03-21T17:38:42.422+02:00

*****You can increase the 'min memory per query' option to improve the performance of queries that use hashing or sorting operations, if your SQL Server has a lot of memory available and there are many queries running concurrently on the server.The SQL Server will automatically allocate, at a minimum, the amount of memory set in this configuration setting. The default 'min memory per query'

Mitkohttp://www.blogger.com/profile/06708938184736986774noreply@blogger.com0tag:blogger.com,1999:blog-4760346921960639498.post-43820139068987536302007-03-21T17:37:00.002+02:002007-03-21T17:38:10.315+02:00

*****Set the virtual memory size to at least 3 times the physical memory installed in the computer, and set the SQL Server 'max server memory' server configuration option to half the virtual memory size setting (1.5 times the physical memory).Because working with full-text search is very resource expensive, you should have enough physical and virtual memory. *****Set the "Maximize Throughput for

Mitkohttp://www.blogger.com/profile/06708938184736986774noreply@blogger.com0tag:blogger.com,1999:blog-4760346921960639498.post-38588358120616093602007-03-21T17:37:00.001+02:002007-03-22T19:44:38.453+02:00

*****Set a reasonable size of your database.First of all, before database creation, you should estimate how big your database will be. To estimate the reasonable database size, you should estimate the size of each table individually, and then add the values obtained. See this link for more information: Estimating the Size of a Table *****Set a reasonable size for the transaction log.The general

Mitkohttp://www.blogger.com/profile/06708938184736986774noreply@blogger.com0tag:blogger.com,1999:blog-4760346921960639498.post-23241439771682455332007-03-21T17:36:00.000+02:002007-03-22T19:44:38.455+02:00

*****Consider creating index on column(s) frequently used in the WHERE, ORDER BY, and GROUP BY clauses.These column(s) are best candidates for index creating. You should analyze your queries very attentively to avoid creating not useful indexes. *****Keep your indexes as narrow as possible.Because each index take up disk space try to minimize the index key's size to avoid using superfluous disk

Mitkohttp://www.blogger.com/profile/06708938184736986774noreply@blogger.com0tag:blogger.com,1999:blog-4760346921960639498.post-56955270727028045912007-03-21T17:35:00.002+02:002007-03-22T19:44:38.467+02:00

*****Avoid using DTS if it is possible to use Transact-SQL distributed query such as a SELECT INTO statement to transfer data.Using Transact-SQL is the fastest method to move data between SQL Server tables, so try to use Transact-SQL statements to move data whenever possible. *****Try to use BULK INSERT statement instead of bcp or DTS to load data into SQL Server from the text file.The BULK

Mitkohttp://www.blogger.com/profile/06708938184736986774noreply@blogger.com0tag:blogger.com,1999:blog-4760346921960639498.post-26573424862392297802007-03-21T17:35:00.001+02:002007-03-21T17:35:38.624+02:00

*****Try to avoid using SQL Server cursors, whenever possible.SQL Server cursors can results in some performance degradation in comparison with select statements. Try to use correlated subquery or derived tables, if you need to perform row-by-row operations. *****Do not forget to close SQL Server cursor when its result set is not needed.To close SQL Server cursor, you can use CLOSE {cursor_name}

Mitkohttp://www.blogger.com/profile/06708938184736986774noreply@blogger.com0tag:blogger.com,1999:blog-4760346921960639498.post-4795845584086730612007-03-21T17:34:00.001+02:002007-03-21T17:34:55.248+02:00

*****Use nonlogged bulk copy whenever possible.The nonlogged bulk copy is much faster than logged one, but to use it you must provide all the following conditions:1. The database option 'select into/bulkcopy' is set to true.2. The target table is not being replicated.3. The TABLOCK hint is specified.4. The target table has no indexes, or if the table has indexes, it is empty when the bulk copy

Mitkohttp://www.blogger.com/profile/06708938184736986774noreply@blogger.com0tag:blogger.com,1999:blog-4760346921960639498.post-42177760693192558652007-03-21T17:33:00.000+02:002007-03-21T17:34:20.657+02:00

*****Try to perform backup to the local hard disk first, and copy backup file(s) to the tape later.When you perform backup, some SQL Server commands cannot be made, for example: during backup you cannot run ALTER DATABASE statement with either the ADD FILE or REMOVE FILE options, you cannot shrink database, you cannot run CREATE INDEX statement and so on. So, to decrease the backup operation's

Mitkohttp://www.blogger.com/profile/06708938184736986774noreply@blogger.com0tag:blogger.com,1999:blog-4760346921960639498.post-39296168377145649612007-03-21T17:31:00.000+02:002007-03-21T17:32:51.510+02:00

*****Use stored procedures instead of passing ANSI-compliant SQL to the database.This can reduce network traffic because your client will send to server only stored procedure name (perhaps with some parameters) instead of large heavy-duty queries text. Stored procedures can be used to enhance security and conceal underlying data objects also. For example, you can give the users permission to

Mitkohttp://www.blogger.com/profile/06708938184736986774noreply@blogger.com0tag:blogger.com,1999:blog-4760346921960639498.post-9969325847828873552007-03-21T10:51:00.000+02:002007-03-21T11:08:19.543+02:00

This is one of two articles about error handling in SQL Server. This articlegives you recommendations for how you should implement error handling when youwrite storedprocedures, including when you call them from ADO. The other article, Error Handling in SQL Server – I,gives a deeper description of the idiosyncrasies with error handling in SQL Serverand ADO. That article is in some sense part one

Mitkohttp://www.blogger.com/profile/06708938184736986774noreply@blogger.com0tag:blogger.com,1999:blog-4760346921960639498.post-37908649396091031782007-03-21T10:30:00.000+02:002007-03-22T19:57:48.625+02:00

This is one of two articles about error handling in SQL Server. This articlefocuses on how SQL Server – and to some extent ADO – behave when an erroroccurs. The other article, Implementing Error Handling with Stored Procedures, gives advice for how you shouldcheck for errors when you write stored procedures. Logically, this article ispart one, and Implementing... is part two. However, you can

Mitkohttp://www.blogger.com/profile/06708938184736986774noreply@blogger.com0tag:blogger.com,1999:blog-4760346921960639498.post-49376457749069728002007-03-20T16:57:00.000+02:002007-03-22T20:00:44.299+02:00

One can discuss, whether web-generators are useful or not. On the one hand, they don’t challenge our creativity, but on the other hand they make our life easier and save our precious time. However, it doesn’t matter really. What matters is that we use them if we have to solve some problem quickly and efficiently. We’ve taken a look at the most useful online-generators for web-development and

Mitkohttp://www.blogger.com/profile/06708938184736986774noreply@blogger.com0tag:blogger.com,1999:blog-4760346921960639498.post-81902118941959706522007-03-20T15:18:00.000+02:002007-03-22T20:15:10.524+02:00

Apollo is the code name for a cross-operating system runtime being developed by Adobe that allows developers to leverage their existing web development skills (Flash, Flex, HTML, JavaScript, Ajax) to build and deploy rich Internet applications (RIAs) to the desktop. Apollo enables developers to create applications that combine the benefits of web applications – network and user connectivity

Mitkohttp://www.blogger.com/profile/06708938184736986774noreply@blogger.com0tag:blogger.com,1999:blog-4760346921960639498.post-8266506452201064982007-03-18T20:57:00.000+02:002007-03-22T19:57:38.647+02:00

When using DTS, if you have a choice, use the native OLE DB provider instead of the ODBC provider when importing and exporting data, as it provides better performance [7.0, 2000]*****ActiveX scripts, within DTS packages, slow down data importation, transformation, and exportation. If possible, try to avoid using ActiveX scripts when creating DTS packages. [7.0, 2000]*****If you choose to use

Mitkohttp://www.blogger.com/profile/06708938184736986774noreply@blogger.com0tag:blogger.com,1999:blog-4760346921960639498.post-88180431964703596452007-03-18T20:47:00.000+02:002007-03-22T19:55:57.587+02:00

Deadlocking occurs when two user processes have locks on separate objects and each process is trying to acquire a lock on the object that the other process has. When this happens, SQL Server ends the deadlock by automatically choosing one and aborting the process, allowing the other process to continue. The aborted transaction is rolled back and an error message is sent to the user of the aborted

Mitkohttp://www.blogger.com/profile/06708938184736986774noreply@blogger.com0tag:blogger.com,1999:blog-4760346921960639498.post-35341714003187065942007-03-18T20:26:00.000+02:002007-03-22T19:57:32.294+02:00

SQLServer is an increasingly important platform for business operations. Dropping transactions or losing data is unacceptable and carries a potentially unacceptable cost to the business. TimeData® integrates seamlessly with SQLServer to protect data and ensure application availability effectively, simply, and affordably.As TimeData captures SQLServer data changes, it identifies checkpoints and

Mitkohttp://www.blogger.com/profile/06708938184736986774noreply@blogger.com0tag:blogger.com,1999:blog-4760346921960639498.post-63629049344517144822007-03-18T20:13:00.000+02:002007-03-18T20:26:35.474+02:00

You can code a SQL SELECT statement in a number of ways to get the same results, but some versions of the same query may perform better than others. In this article we will look at ways to exploit this.Here is a query that I cut-and-pasted straight out of SQL 7 Books Online. The query runs in the Northwind database and is designed to pull out the maximum unit price for each order in the

Mitkohttp://www.blogger.com/profile/06708938184736986774noreply@blogger.com0tag:blogger.com,1999:blog-4760346921960639498.post-68336625704936753562007-03-18T19:19:00.000+02:002007-03-22T19:55:02.341+02:00

Express Agent from Vale Software lets you create and schedule jobs to backup SQL Server databases and run SQL batches and stored procedures in seconds. E-mail notification can be configured so you get notified when your jobs run, succeed or fail. You can fully schedule hourly, daily, weekly and monthly jobs - exactly the same as in the full version of SQL Server. As seen in SQL Server Magazine &

Mitkohttp://www.blogger.com/profile/06708938184736986774noreply@blogger.com0tag:blogger.com,1999:blog-4760346921960639498.post-83976840573412713892007-03-18T19:13:00.000+02:002007-03-18T19:15:58.379+02:00

SQL Documentor from Vale Software is designed to help all SQL & MSDE developers by quickly and effectively generating complete documentation detailing your databases. Suitable for Windows 95,98,Me, NT, 2000, XP and 2003. Cost: $49.99Main Features:The output is completely customisable to show only the things you want to see. It shows the tables, column names, data types and sizes, default

Mitkohttp://www.blogger.com/profile/06708938184736986774noreply@blogger.com0tag:blogger.com,1999:blog-4760346921960639498.post-11469000369275457752007-03-18T19:02:00.000+02:002007-03-22T20:07:15.149+02:00

SQL Multiple Instance Manager from Vale Software easily allows you to create scheduled jobs and run scripts in multiple SQL instances. It can create and distribute jobs (backups, other TSQL etc.) to thousands of instances throughout multiple global sites while reporting back on job progress.SQL Multiple Instance Manager comes in two parts, the management centre software is suitable for Windows

Mitkohttp://www.blogger.com/profile/06708938184736986774noreply@blogger.com0tag:blogger.com,1999:blog-4760346921960639498.post-12348082437626635262007-03-18T18:56:00.000+02:002007-03-22T19:59:41.206+02:00

Order Internet SQL Hosting from Vale Software securely over the internet:50 Mb MSSQL Hosting - $48.00 per year - click here to purchase100 Mb MSSQL Hosting - $75.00 per year - click here to purchase250 Mb MSSQL Hosting - $105.00 per year - click here to purchaseIf you require more than 250Mb of space then email us for a great deal.The SQL Transaction log is automatically set to take up 20% of

Mitkohttp://www.blogger.com/profile/06708938184736986774noreply@blogger.com0tag:blogger.com,1999:blog-4760346921960639498.post-82866903786041454912007-03-15T17:37:00.000+02:002007-03-22T19:58:40.938+02:00

Many developers mistakenly believe that any error inside a transaction will make the transaction fail and automatically rollback. However, this is true only for fatal errors, such as most errors with severity equal to 16 or higher. The commonest runtime error - for example duplicate primary keys, violation of unique constraints and foreign key relationship - aren't fatal and therefore won't

Mitkohttp://www.blogger.com/profile/06708938184736986774noreply@blogger.com55tag:blogger.com,1999:blog-4760346921960639498.post-69959486830266576122007-03-15T10:08:00.000+02:002007-03-15T10:37:03.563+02:00

Gaia Ajax Widgets is an Ajax library which is far easier to use, way easier to extend and consumes A LOT less bandwidth than most other Ajax libraries including ASP.NET Ajax. It comes with a free (as in free beer) version and a free (as in freedom, Source Code distro) version though is still a commercial library living of license earnings. The company creating Gaia is called Frost Innovation and

Mitkohttp://www.blogger.com/profile/06708938184736986774noreply@blogger.com0tag:blogger.com,1999:blog-4760346921960639498.post-2261503221627239392007-03-14T20:05:00.000+02:002007-03-14T20:14:49.039+02:00

There are times that you have to think outside the box to get your designs to work. I've been working on a set of server controls that handle view/add/edit capabilities on a n-tiered vertical table set. You feed the primary control a Category, point it at DataSets containing the schema and the values, and tell it what natural key to use to select the values to be displayed. As you get deeper into

Mitkohttp://www.blogger.com/profile/06708938184736986774noreply@blogger.com0tag:blogger.com,1999:blog-4760346921960639498.post-6603195669426221582007-03-14T17:19:00.000+02:002007-03-22T19:53:39.557+02:00

Mitkohttp://www.blogger.com/profile/06708938184736986774noreply@blogger.com0tag:blogger.com,1999:blog-4760346921960639498.post-84965742455674500082007-03-14T16:04:00.000+02:002007-03-22T19:51:32.660+02:00

I found this beautiful winter poem and thought it might be a comfort to you.It was to me, and it's very well written. ENJOY! "WINTER" a lovely poem by Abigail Elizabeth McIntyreShit!It's cold!

Mitkohttp://www.blogger.com/profile/06708938184736986774noreply@blogger.com1tag:blogger.com,1999:blog-4760346921960639498.post-2107935623059611512007-03-14T11:02:00.000+02:002007-03-22T20:17:15.373+02:00

Better Designer Tools for Better End-User ExperiencesMicrosoft Expression takes your creative possibilities to a new level. The professional design tools and innovative technologies in Expression give you the flexibility and freedom to bring your vision to reality—whether you are designing standards-based Web sites, rich user experiences on the desktop, or managing digital assets and content.

Mitkohttp://www.blogger.com/profile/06708938184736986774noreply@blogger.com0tag:blogger.com,1999:blog-4760346921960639498.post-6474729337421377832007-03-14T09:41:00.000+02:002007-03-14T09:44:37.089+02:00

The following mottoes (mostly in Latin) are taken from various sources printed before the year 1600: Paradin's Devises (1591), Simeoni's Purtratures (1591), Willet's Emblemata (1592), Giovio's Imprese (1585), Domenichi's Devises (1585), and Whitney's Emblemes (1586). This is by no means the complete list of mottoes given in those works, but

Mitkohttp://www.blogger.com/profile/06708938184736986774noreply@blogger.com0tag:blogger.com,1999:blog-4760346921960639498.post-17936911261990286292007-03-14T09:35:00.000+02:002007-03-22T20:11:32.843+02:00

The following mottoes (mostly in Latin) are taken from various sources printed before the year 1600: Paradin's Devises (1591), Simeoni's Purtratures (1591), Willet's Emblemata (1592), Giovio's Imprese (1585), Domenichi's Devises (1585), and Whitney's Emblemes (1586). This is by no means the complete list of mottoes given in those works, but

Mitkohttp://www.blogger.com/profile/06708938184736986774noreply@blogger.com0tag:blogger.com,1999:blog-4760346921960639498.post-30231017696967625682007-03-14T09:17:00.000+02:002007-03-22T20:03:04.446+02:00

By Ivan Uzunov BlogCreating thumbnails with .NET is really simple task. You have to call only one method Image.GetThumbnailImage(). The problem is that the quality of the created image is really poor. So I’ve started googling around and the result is this GenerateImageThumbnail() function: public static void GenerateImageThumbnail(Stream streamImage, string sThumbnailImagePath, int nMaxWidth,

Mitkohttp://www.blogger.com/profile/06708938184736986774noreply@blogger.com2tag:blogger.com,1999:blog-4760346921960639498.post-89891894863013609492007-03-13T21:04:00.000+02:002007-03-22T19:56:30.592+02:00

* Why pay more for less? Don't fall for higher prices!GoDaddy.com® Shared Hosting - the smart choice for most individuals and small businesses. Go Daddy is the affordable, reliable place to host your site - with no ad banners or pop-ups. And unlike the competition, there's no set-up fee and no annual commitment required. But don't just take our word for it... see for yourself!99% Uptime Guarantee

Mitkohttp://www.blogger.com/profile/06708938184736986774noreply@blogger.com1tag:blogger.com,1999:blog-4760346921960639498.post-54794342600333345592007-03-12T19:55:00.000+02:002007-03-22T20:05:04.865+02:00

Using Ajax for the sake of Ajax.Sure Ajax is cool, and developers love to play with cool technology, but Ajax is a tool, not a toy. A lot of Ajax isn’t seriously needed to improve usability but rather experiments in what Ajax can do or trying to fit Ajax somewhere where it isn’t needed.Breaking the back buttonThe back button is a great feature of the standard web site user interface.

Mitkohttp://www.blogger.com/profile/06708938184736986774noreply@blogger.com0tag:blogger.com,1999:blog-4760346921960639498.post-68249616304991662542007-03-12T19:22:00.000+02:002007-03-22T20:01:47.355+02:00

Enterprises trying to improve business unit productivity and the reuse of IT assets continue to struggle. IT organizations have achieved some success by attacking these challenges with Service Oriented Architecture (SOA), but in most cases have still only exposed small portions of the overall IT service portfolio. Much of this struggle has been to deliver a "just enough" SOA to the business

Mitkohttp://www.blogger.com/profile/06708938184736986774noreply@blogger.com1tag:blogger.com,1999:blog-4760346921960639498.post-45819991916504621832007-03-11T21:04:00.000+02:002007-03-22T20:02:12.160+02:00

When it comes to software development, Google's Adam Bosworth has a need for speed.In a talk entitled "Physics, Speed and Psychology: What Works and What Doesn't in Software, and Why," Bosworth, a vice president at Google, discussed why technologies such as AJAX (Asynchronous JavaScript and XML), PDAs and natural language failed to catch on in the past but are successful today. Bosworth spoke at

Mitkohttp://www.blogger.com/profile/06708938184736986774noreply@blogger.com0tag:blogger.com,1999:blog-4760346921960639498.post-2685298547430934332007-03-10T13:03:00.000+02:002007-03-22T20:05:19.322+02:00

The DiscountASP.NET ASP.NET hosting platform supports AJAX hosting and you can deploy your AJAX powered web applications!ASP.NET AJAX (formerly called ATLAS) is a free framework for building rich interactive, cross-browser web applications. This Microsoft technology integrates cross-browser client script libraries with the ASP.NET 2.0 framework.ASP.NET AJAX makes it possible to take advantage of

Mitkohttp://www.blogger.com/profile/06708938184736986774noreply@blogger.com2tag:blogger.com,1999:blog-4760346921960639498.post-48552230462820784292007-03-09T19:28:00.000+02:002007-03-22T20:04:33.555+02:00

NEW!!! Online mapThe first version of BG Topo Maps for Magellan GPS receivers was releised. The map is compatible with Explorist, Meridian and Sporttrack series. The data is based on BG Topo Maps 2.11 - Roads, Railroads, Streets, Trails, Hydrography, Shoreline, Country border, Farwaters, and more than 12 000 searchable POIs. The data for Relef and Landcover will be added in next versions.Download

Mitkohttp://www.blogger.com/profile/06708938184736986774noreply@blogger.com0tag:blogger.com,1999:blog-4760346921960639498.post-92180706013905071222007-03-09T10:54:00.000+02:002007-03-22T20:12:33.965+02:00

By Omar Al ZabirWhen others see Pageflakes, the first question they ask me is: "Why did you not use Protopage or Dojo library? Why Atlas?" Microsoft Atlas (renamed to ASP.NET AJAX) is a very promising AJAX framework. They are putting a lot of effort on it, making lots of reusable components that can really save you a lot of time and give your web application a complete face lift at reasonably low

Mitkohttp://www.blogger.com/profile/06708938184736986774noreply@blogger.com0tag:blogger.com,1999:blog-4760346921960639498.post-16331558102704924412007-03-07T10:26:00.000+02:002007-03-22T20:11:56.982+02:00

These are all abbreviations for specific phrases commonly used in informal written computer correspondence, online forums and boards, and online gaming. Following is a list of some common acronyms and their meanings:AFAIC As far as I'm concernedAFAIK As far as I knowAFK Away from keyboardBRB Be right backBTDT Been there, done thatBTW By the wayBUAG Butt-ugly ASCII graphicC/C Comments and

Mitkohttp://www.blogger.com/profile/06708938184736986774noreply@blogger.com1tag:blogger.com,1999:blog-4760346921960639498.post-10599035025728753872007-03-06T12:22:00.000+02:002007-03-22T19:55:35.838+02:00

Authentication modules are the most exploited pieces in a web application. We look at ten good practices that ensure your authentication system is safe against an attack.1. Use an external authentication service provider like LDAP if it fits into your architecture. It’s simpler to reuse a tried and tested authentication system than writing your own from scratch.2. Use SSL to transmit all

Mitkohttp://www.blogger.com/profile/06708938184736986774noreply@blogger.com1tag:blogger.com,1999:blog-4760346921960639498.post-87393207229641421902007-03-06T12:02:00.000+02:002007-03-22T20:01:02.171+02:00

Which is the best method for implementing the Forgot Password feature?1. Displaying the old password after asking a reminder question2. Displaying a new password after the reminder question3. Sending a temporary password by mail4. Sending a temporary link to a ‘Change Password’ page by mailAnswerThe answer to the quiz is 4) Sending a temporary link to a ‘Change Password’ page by mail.The

Mitkohttp://www.blogger.com/profile/06708938184736986774noreply@blogger.com0tag:blogger.com,1999:blog-4760346921960639498.post-17841574020969513152007-03-06T09:55:00.000+02:002007-03-22T20:04:08.391+02:00

Best Practices is a great and wonderful thing … that is if everyone working on the project adheres to them. In many of the sessions and usergroups I've been asked by many for the best or rather should I say better practices of coding while using SQL Server 2000. The views listed below are mine and I'am sure any SQL Server Guru might not argue it otherwise. Just thought of adding sections for

Mitkohttp://www.blogger.com/profile/06708938184736986774noreply@blogger.com0tag:blogger.com,1999:blog-4760346921960639498.post-57900490741613144542007-03-05T10:04:00.000+02:002007-03-05T10:11:29.674+02:00

We've tallied the top 10 SQL Server tips of 2005 according to your visits. While SQL Server 2005 introductions piqued your interest, it's tips on those nagging and troublesome administration basics that garnered the most attention. View the top 10 below or check out our complete tips collection.#1 - Restoring a database from another SQL ServerRestoring a database from another SQL Server is simple

Mitkohttp://www.blogger.com/profile/06708938184736986774noreply@blogger.com0tag:blogger.com,1999:blog-4760346921960639498.post-21454093991975765872007-03-05T09:38:00.000+02:002007-03-22T20:17:19.998+02:00

Ever wanted to test software in a sandbox environment? Wouldn't it be great to be able to test the new Microsoft .NET Framework 3.0 technologies immediately, without dedicating one or more computers to the project? Now you can, with Microsoft Virtual Labs.It's simple - no complex setup or installation is required to try out new features running in the Virtual Lab. You get a downloadable manual

Mitkohttp://www.blogger.com/profile/06708938184736986774noreply@blogger.com0tag:blogger.com,1999:blog-4760346921960639498.post-21359926354720187462007-03-05T09:31:00.000+02:002007-03-22T19:50:40.938+02:00

The .NET Framework 3.0 has officially been released! You can download the .NET Framework 3.0 components here:.NET Framework 3.0 Runtime ComponentsWindows SDK for Vista and the .NET Framework 3.0Visual Studio 2005 Extensions for .NET Framework 3.0 (Windows Workflow Foundation)Visual Studio 2005 Extensions for .NET Framework 3.0 (WCF & WPF), November 2006 CTPNote, if you are using Windows Vista the

Mitkohttp://www.blogger.com/profile/06708938184736986774noreply@blogger.com0tag:blogger.com,1999:blog-4760346921960639498.post-85362112160572024432007-03-02T17:26:00.000+02:002007-03-22T20:14:09.429+02:00

The following list of Project Managemen Systems could be very useful:http://www.aceproject.com/demo/server01/Login.asp?lang=http://www.dotproject.net/demo/index.php?m=projectshttp://www.epnethost.com/LiveDemo/Authentication.aspx?ReturnUrl=%2fLiveDemo%2fRequestList.aspxhttp://w3.functionfox.com/timefox/ http://www.project.net/http://www.autotask.com/http://www.projectinsight.net/Tour/More coming .

Mitkohttp://www.blogger.com/profile/06708938184736986774noreply@blogger.com1tag:blogger.com,1999:blog-4760346921960639498.post-48286303139016392242007-03-02T16:48:00.000+02:002007-03-22T20:01:15.167+02:00

I'd like to welcome all you guys that Internet sent over here.Do not hesitate to read & post any comments!Do not hesitate to contact me!Do not forget that I do look forward to your company!Make yourselves at home!Thanks!

Mitkohttp://www.blogger.com/profile/06708938184736986774noreply@blogger.com0