weblogs.com.pk

In my earlier post; where I blamed mySQL to has fatter memory footprints, I received very informative comments, and I quickly discovered that I need to tune mySQL first. I found out that mySqld-nt daemon should be used if one is interested to run mySQL as Windows Service. Here is the latest task manager screen shot of my machine, and Yes, ...

Dont beleive it? See it yourselves.... Both SQL Server and mySQL Server were hosting their default databases plus one database each for my application. At the time of snapshot; both servers were not handling any connections. You are seeing two sqlservr.exe; as I am running two instances of SQL Server Web Worker Process is taking more ...

Check out Sql.Net, it’s an open source, object based API for creating dynamic queries for SQL, Oracle and mySQL. I will consider it to incorporate into our home grown O/R mapper at our workplace which is no longer actively used anymore (CodeSmith rocks); but it was quite a fun coding for it J The good thing which attracted me to Sql.Net is a ...

Argh; SQL Server Reporting Services don’t support queries and/or stored procedures using temporary tables.   Reporting services is very scalable platform; one can implement custom data source provider; I think the above problem is specific to the SQL Server data source provider that is bundles with the SQL Reporting Services. One ...

If you are using pre 4.1 client (PHP 4.x) you might get an error ''Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL''   This happens due to the reason that mySQL 4.1+ has new authentication scheme which pre 4.1 clients dont support. Issueing the following statement reset ...

The good thing about .NET is its inter-operateability with older technologies; like COM. If you are stuck with old platforms (like me J) you may find this post useful. Here you will find how to use ADODB (The classic ADO) with .NET   ADODB expects integer (INT32) parameters for the connection type and command types. The ADODB’s ...

Data plays the centre role in today’s software. We are exposed to abstract data structures like arrays, stack, queues, linked lists, trees and maps etc, and then on the other hand we have relational, hierarchical and object database management systems. Usually such data management systems are “out of process” and most of our ...

Few years back we used to think how to keep our applications safe from SQL Injection exploits, now due to recent trend of using technologies around XML we also need to think how to keep our applications safe from XPath Injection exploits. Blind XPath Injection from Sanctum is one such report.   Abstract   This paper describes a Blind ...

Jahil has posted a nice intro to Zombie processes (that most of unix users come across in routine).   The same situation often occurs, in software development; especially in product development where different modules sometimes are re-written/replaced with new implementations and old code continue to exist in text as well as binary forms. ...

Oracle Introduces Oracle(r) Database 10g Release 2   Oracle Database 10g Release 2 will incorporate several new features to increase support for application developers. The new features will include:   The industry's first mainstream support for the W3C XML Query standard for access to XML data; Improved Microsoft Windows ...

Quarter a million automatic tests being run twice a week for SQL Server’s engine! Wow! That’s really something…

Waseem asked a question, for which I am proposing a tricky solution.   Hi SQL Experts;I am Facing a problem in my Project regarding  SQL Query, please help me to solve it.I have A table named ''Book''   BooK__________ |BooKID      ...

Just a piece of advice: Don’t login to your database when you don’t have enough time. If you are logged in, then never give any update/delete/insert/create/drop commands. I have just lost some data, I specified wrong month in the query L   Anyways it’s always a good practice that you plan well before issuing any command!

Earlier I asked a SQL query related question by presenting a scenario. We were having unexpected results with the query that had an outer join, group by and the count.   The actual problem was that we need the counts of all the Groups, if there is no user in particular Group, we should have zero against it, something like   User | ...

I have a question related with SQL Server. Consider the following TSql statements.   drop table #Fun_Groups; drop table #Fun_UsersGroup; create table #Fun_Groups (GroupName nvarchar(20)); create table #Fun_UsersGroup (UserID nvarchar(20), GroupName nvarchar(20));   insert into #Fun_Groups values ('User'); insert into ...

If .NET/CLR integration is important, and you are dying when Microsoft will release Yukon (SQL Server 2005), you will be glad that Yukon is not the single player of this game, IBM’s DB2 is going to do it, and many people believe they even will release their Stinger (DB2’s next version code name) even before Yukon.   ServerSide ...

This post is in response to an answer put on a mailing list. The person is interested to know how to create a stored procedure having Tsql statement with some variable table name, that’s passed to the stored procedure.   Here is the sample TSql code.     use northwind   create procedure ...

From Tara Duggan’s weblog http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx Over the past couple of weeks, I have posted various database maintenance stored procedures.  Here's a listing of them: ·         isp_DBCC_CHECKDB - perform integrity checks on all databases ...

Is it okay to use alpha and/or beta software and talk about them here? Can we talk about Yukon (SQL Server 2005) and/or Whidbey (Visual Studio 2005)?   I am dieing to use C# in SQL’s stored procedures. Is there anyone feeling the same? J I have plans to start using Yukon in some side-project.

At my job, a weird mistake happened few days back. We changed the template of the PIN codes that are randomly generated. A little tricky algorithm involved ends up concatenating multiple numbers to make a single value. In case the values being concatenated have less width, by mistake, zeroes were prefixed.  We ended up with numbers containing ...

My current employer gives consultancies in Computer Telephony (CT) applications, and I have experienced working with couple of hardware and software vendors of this field.   At one site, Artisoft’s Televantage Call Centre is running. Today they reported that all of a sudden, Televantage Clients (The software at agent station) started ...

SqlAdvice.com is a family of mailing lists that are focused on SQL (Structured Query Language) and the technologies that utilize SQL.  This includes (but doesn't limit) popular databases such as Microsoft SQL Server, Microsoft Access, Oracle.  As demand increases for alternative databases (such as MySql, DB2, Informix) then more focused ...

This post discusses about error handling methodologies in TSql, the native language of Microsoft’s SQL Server.   Error Handling is important in any application development. This applies in coding stored procedures with TSql. Stored procedures have an importance of their own, they not only give us extra bits of performance, but ...

People often ask how to execute parametric query to database engines, like SQL Server or Oracle. Consider the following sql.   select * from emp where ename=’SMITH’   They want to convert the hardcode SMITH in the query to the variable having some value in runtime. Many people use the following approach.   string sql=''select * ...

TSQL’s IN keyword has tremendous power; using it one can determine the given value matches any value in a sub query or list. For example;   select userid from users where accountindex in (14, 17);   I wish, that modern languages like Java/C# offers same kind of keyword that can ease many implementation scenarios.   I also wish, that ...

If you are involved in database application development, especially in Data Access Layer development, it is often required to know the value of the last inserted Identity Value (SQL Server equivalent of AutoNumber in Access)   Once I happen to see a very funny code doing this. It was an ASP3 application, coded in VBScript using ADO. The ...

One should always verify the inputs of the code; it applies to the SQL stored procedure. It was required to verify each character of the string passed to the SQL sproc. Here is the TSql snippet that I used to implement this requirement. --@@i is int, @PinCode is nvarchar(15)set @@i=1;while @@i <= datalength(@PinCode)--datalength ...