Proud To Be Pakistanis!
Welcome to weblogs.com.pk Sign in | Join | Help
in Search

Browse by Tags

All Tags » Databases
Showing page 2 of 2 (77 total posts)
  • mysqld-nt Has Thinner Memory Footprint

    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, ...
    Posted to Khurram Aziz (Weblog) by khurram on May 16, 2005
  • mySQL Takes More Memory

    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 ...
    Posted to Khurram Aziz (Weblog) by khurram on May 13, 2005
  • Sql.Net

    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 ...
    Posted to Khurram Aziz (Weblog) by khurram on April 25, 2005
  • SQL Server Reporting Services :: Queries Using Temporary Tables

    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 ...
    Posted to Khurram Aziz (Weblog) by khurram on April 16, 2005
  • mySQL :: Client does not support authentication protocol requested by server

    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 ...
    Posted to Khurram Aziz (Weblog) by khurram on March 26, 2005
  • Disconnected (ADODB) Recordset

    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 ...
    Posted to Khurram Aziz (Weblog) by khurram on March 19, 2005
  • Embedded Databases :: SharpHSQL :: Enhancing SharpHSQLReader to Support Data Binding

    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 ...
    Posted to Khurram Aziz (Weblog) by khurram on January 16, 2005
  • XPath Injection

    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 ...
    Posted to Khurram Aziz (Weblog) by khurram on January 4, 2005
  • The “Zombie” Modules

    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. ...
    Posted to Khurram Aziz (Weblog) by khurram on December 27, 2004
  • Oracle Introduces Oracle(r) Database 10g Release 2

    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 ...
    Posted to Khurram Aziz (Weblog) by khurram on December 8, 2004
  • How much testing is enough?

    Quarter a million automatic tests being run twice a week for SQL Server’s engine! Wow! That’s really something…
    Posted to Khurram Aziz (Weblog) by khurram on December 6, 2004
  • Changing The Sort Order

    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      ...
    Posted to Khurram Aziz (Weblog) by khurram on December 2, 2004
  • Don’t Issue Unplanned Queries, Especially In a Hurry

    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!
    Posted to Khurram Aziz (Weblog) by khurram on September 3, 2004
  • TSql: Count, Group By and Outer Join

    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 | ...
    Posted to Khurram Aziz (Weblog) by khurram on August 27, 2004
  • TSql Question: Count, Group By and Outer Join

    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 ...
    Posted to Khurram Aziz (Weblog) by khurram on August 26, 2004
  • Stinger: CLR integration in another commercial database engine

    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 ...
    Posted to Khurram Aziz (Weblog) by khurram on August 20, 2004
  • Executing character string with variable table name

    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 ...
    Posted to Khurram Aziz (Weblog) by khurram on August 18, 2004
  • SQL Server: Database Maintenance Routine

    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 ...
    Posted to Khurram Aziz (Weblog) by khurram on July 29, 2004
  • Will it be okay to talk about alpha and beta software?

    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.
    Posted to Khurram Aziz (Weblog) by khurram on June 13, 2004
  • TSql: Dropping leading zeroes

    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 ...
    Posted to Khurram Aziz (Weblog) by khurram on June 4, 2004
  • Televantage/SQL's Explicit Data Conversion

    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 ...
    Posted to Khurram Aziz (Weblog) by khurram on May 28, 2004
  • SqlAdvice.com

    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 ...
    Posted to Khurram Aziz (Weblog) by khurram on May 7, 2004
  • Error Handling In TSql

    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 ...
    Posted to Khurram Aziz (Weblog) by khurram on April 28, 2004
  • Parametric Queries

    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 * ...
    Posted to Khurram Aziz (Weblog) by khurram on April 16, 2004
  • TSql Wishes (Part 1)

    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 ...
    Posted to Khurram Aziz (Weblog) by khurram on April 8, 2004
  • Knowing Identity Value

    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 ...
    Posted to Khurram Aziz (Weblog) by khurram on April 3, 2004
  • Verifying Strings In TSql

    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 ...
    Posted to Khurram Aziz (Weblog) by khurram on March 25, 2004
Powered by Community Server (Personal Edition), by Telligent Systems