weblogs.com.pk

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

Browse by Tags

All Tags » Databases
Showing page 1 of 2 (52 total posts)
  • Dotnet Core :: PostgreSQL

    Dotnet Core Series Dotnet Core Redis Clients -- ASP.NET Core Docker Registry Jenkins This Post Given, Dotnet Core can run on Linux; and in the series we have been exploring different aspects of having a Microservice based Containerized Dotnet Core application running on a Linux in Docker Containers. SQL ...
    Posted to Khurram Aziz (Weblog) by khurram on March 31, 2017
  • Redis Clients :: ASP.NET Core

    Redis Series Redis Redis Clients This Post Dotnet Core Series Dotnet Core This Post Docker Registry ...
    Posted to Khurram Aziz (Weblog) by khurram on March 19, 2017
  • Redis Clients

    Redis Series Redis This Post Redis Clients -- ASP.NET Core For the Redis clients; imagine we have an e-commerce platform having a Python based component that does some analysis to show which product or campaign / deal to show on the main page; these results are posted / updated into the Redis Server from where the Asp.Net ...
    Posted to Khurram Aziz (Weblog) by khurram on March 10, 2017
  • Redis

    Redis Series This Post Redis Clients Redis Clients -- ASP.NET Core REmote DIctionary; or Redis is an open source data structure server; its a key-value database and can be used as NoSQL database, cache and message broker. Its distinguishing feature is that we can store data structures such as strings, hashes, ...
    Posted to Khurram Aziz (Weblog) by khurram on March 7, 2017
  • Higher-level Constructs with ZooKeeper

    ZooKeeper Series ZooKeeper Higher-level Constructs with ZooKeeper Docker Swarm ZooKeeper provides a solid foundation to implement higher order functions required for “Clustering Applications” / Distributed Systems. In this post; we will implement “Barrier” that Distributed systems uses to block processing of a set of nodes ...
    Posted to Khurram Aziz (Weblog) by khurram on February 28, 2017
  • ZooKeeper

    ZooKeeper Series ZooKeeper Higher-level Constructs with ZooKeeper Docker Swarm Apache ZooKeeper is an open-source server which enables highly reliable distributed coordination. It helps us by providing a distributed synchronization service that can be used for maintaining configuration information, naming, group service and other ...
    Posted to Khurram Aziz (Weblog) by khurram on February 17, 2017
  • Bea goes to Oracle, MySQL goes to SUN

    Oracle to Acquire BEA Systems Sun to Acquire MySQL    Interesting move, specially at MYSQL end. 
    Posted to Adnan Siddiqi (Weblog) by kadnan on January 17, 2008
  • 5th CTP of Visual Studio Team System for Database Professional

    DataDude (Team System for Database Professional)' 5th CTP is released recently. It features Schema management (similar to SQL Enterprise or Management Studio) the difference is instead of working on some ''physical database'' it works on ''virtual database''; you can however import initial schema from ''physical database'' and can also ...
    Posted to Khurram Aziz (Weblog) by khurram on August 23, 2006
  • mySQL Profiler?

    I am looking for a tool for mySQL 4/5 servers having SQL Server Profiler like features; using which I can see in real time what SQL queries are being executed... I have used SQL Server Profiler to optimize database hits and some time reverse engg some apps and it works great for SQL Server; is there anything comparable for mySQL?
    Posted to Khurram Aziz (Weblog) by khurram on July 10, 2006
  • Unique Identity Across Multiple Tables

    This week had been a busy one; we had three deliverables; one internal app and two clients app. Due to training sessions; things get screwed up; it got hard to find the time…I was checking my timesheets; and wow! I have given about 50% extra time to the office this week <geez/> One of these three was solely my baby, I am lucky that it was ...
    Posted to Khurram Aziz (Weblog) by khurram on June 16, 2006
  • UnixOdbc

    I am planning a solution for a small ISP who needs a cheaper and straight forward billing system. Our solution contains FreeRadius running on Linux configured with UnixOdbc having a DSN of FreeTDS driver talking to SQL Server Express running on Windows. Front end app will be ASP.NET v2; our guess is that this solution’s TCO for the client and ...
    Posted to Khurram Aziz (Weblog) by khurram on June 1, 2006
  • Agile Documentation in Database Layer

    If you are maintaining a database; you might have adopted some mechanism to maintain notes; like what was changed; any discovery; documentation and sometime even queries performed so that things can be rolled back. In past; I have used .txt/.sql files, and then I started emailing the stuff to a separate folder (project wise) to recall the things ...
    Posted to Khurram Aziz (Weblog) by khurram on April 25, 2006
  • Information Management :: Historical Data

    Continuing the topic of information management; and how we should think about it as a developer; we basically need to consider two things that impacts our implementation approach. Maintaining historical data Making available the aggregated data In this post; I will discuss the first one; and will use an example of the telephone company’s ...
    Posted to Khurram Aziz (Weblog) by khurram on March 18, 2006
  • Information Management :: Establishing Measurement Plan

    Last weekend in a family get together; there was a discussion going on epidemic diseases; that eventually turns out the purity of food items being sold in market. One of my cousin has a farm and supplies milk to commercial local company; he was telling that how milk quality is measured. He told that earlier; density of the milk was used for the ...
    Posted to Khurram Aziz (Weblog) by khurram on March 16, 2006
  • Organizational Data Consumption

    Yesterday I posted about lack of proper data consumption in general in our local enterprises. A simplified view of one data consumption model presented here is shown below. As you can see; “Technical Activities” are important, as its feeding all the higher layers. We being software developers and/or system administrators play important ...
    Posted to Khurram Aziz (Weblog) by khurram on March 15, 2006
  • Information :: Done with gathering; what about conumption?

    We had been introducing automation at different points; with this; lot of data has been generated; which in past might have lost in those big registers archived in stores for rats; but now all that information in accessible. Thanks to the technologies; having gigs of data is routine in small to medium sized modern enterprises. Question is; ...
    Posted to Khurram Aziz (Weblog) by khurram on March 14, 2006
  • Access denied for user 'ODBC'@'localhost' (using password: NO)

    If you are receiving this error; and you happen to use PHP4 and mySQL 5; its due to the reason that mySQL client library being used is older. The simplest work-around is that you issue the following commands (I guess you need root level access; contact your ISP/Network Administrator for assistance) update mysql.user set password = ...
    Posted to Khurram Aziz (Weblog) by khurram on February 7, 2006
  • mySQL :: STRICT_TRANS_TABLE :: mySQL or SQL-Express

    I was free today; so I planned to upgrade mySQL database server, which is used by some our intranet applications at my workplace. I moved things to mySQL version 5. I dumped the databases; remove previous mySQL service; installed mySQL 5 in separate location. Recreated databases and users and imported the data. Earlier databases ...
    Posted to Khurram Aziz (Weblog) by khurram on January 14, 2006
  • mySQL engine is ridicules

    Consider a table Populations with fields, Country, City, Area, Population. In SQL Server (and I am sure in Oracle as well) you cannt execute query like select Country, City, sum(Population) from Populations group by Country order by Country, City You have to add City field in group by clause…But guess what in mySQL you can ...
    Posted to Khurram Aziz (Weblog) by khurram on December 31, 2005
  • Zombie Objects

    The one problem; that is very common in team projects is existence of “zombie objects”. I weblogged about how one can trace such objects with in database layer; but what about business layer? Here is one approach that we try to follow. We establish interfaces for data access layer; say IDBLayer, if there exists multiple client application; eg a ...
    Posted to Khurram Aziz (Weblog) by khurram on December 22, 2005
  • VistaDB 2.1 database for .NET has been released

    This 2.1 update includes over 60 improvements, including new support for .NET 2.0 and Visual Studio 2005. VistaDB is a small-footprint, embedded SQL database alternative to Jet/Access, MSDE and SQL Server Express 2005 that enables developers to build .NET 1.1 and .NET 2.0 applications. Features SQL-92 support, small 500KB embedded footprint, free ...
    Posted to Khurram Aziz (Weblog) by khurram on November 7, 2005
  • SQL Server Compare

    I am assigned a job in which I have to deal with multiple servers all running different variations of the product that we have built. For this I often need to compare and keep track of the differences, not only in applications but also in the databases that these app uses. I have tried to have a formalized change management system, but still ...
    Posted to Khurram Aziz (Weblog) by khurram on August 25, 2005
  • SQL Server 2005 :: Service Broker

    It’s glad to have a “Service Broker” in SQL 2005. At my present job; I developed a similar architecture, and it took considerable time to stabilize the system back then. Few weeks back when someone asked what the toughest problem I have solved is, I pinpointed that application. Now I am looking forward to use this new functionality instead.
    Posted to Khurram Aziz (Weblog) by khurram on August 1, 2005
  • Managed triggers can do wonders!

    Triggers, constraints and relationships are cool to implement business constraints in the data layer. Many people don’t bother to use them and try to implement business constraints in the application/business layer, but believe me, having them in database not only guarantee reliable data storage but also much easier manageability. Updating a thing ...
    Posted to Khurram Aziz (Weblog) by khurram on June 20, 2005
  • SQL Server Procedure Template

    From SharpCoders Wiki   create procedure dbo.SomeProcedure (         @inputParameter datatype = defaultvalue,         @outputParameter datatype output ) as --Dont send rows affected to client set nocount on; --Automatically rollback transactions on error set ...
    Posted to Khurram Aziz (Weblog) by khurram on June 4, 2005
  • 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
1 2 Next >
Powered by Community Server (Personal Edition), by Telligent Systems