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 (77 total posts)
  • Kibana: DevTools

    Elasticsearch Series  ELK This Post Beats Kibana allows us to work with Elasticsearch in most productive way. From the previous post; lets expose our Elasticsearch server and using its REST APIs; create an “index” and a document in there directly using CURL You will realize; its quite tedious to work with ...
    Posted to Khurram Aziz (Weblog) by khurram on June 1, 2019
  • ELK

    Time Series Databases Prometheus InfluxDB This Post Elasticsearch Series This Post Kibana: DevTools Beats If you ever managed a Linux server or developed application for it; you probably ...
    Posted to Khurram Aziz (Weblog) by khurram on May 18, 2019
  • InfluxDB

    TICK Series This Post TelegrafTime Series Databases Prometheus This Post ELK InfluxDB is another open source time series database and is written in Go language. It has no external dependency and its data model consists of several key-value pairs called the fieldset. Each point has a timestamp a value and fieldset. ...
    Posted to Khurram Aziz (Weblog) by khurram on June 22, 2018
  • Prometheus

    Prometheus Series This Post Swarm and Prometheus Swarm and Prometheus II Time Series Databases This Post InfluxDB ELK A time series is a series of data points indexed (or listed or graphed) in time order. Most commonly, a time series is a sequence taken at successive equally spaced points in ...
    Posted to Khurram Aziz (Weblog) by khurram on April 16, 2018
  • 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
  • Knowing the counts of table entries in SQL Server

    Here's the query to know the counts of the table entries in SQL Server select object_name(object_id), row_countfrom sys.dm_db_partition_statswhere index_id < 2order by row_count desc
    Posted to Khurram Aziz (Weblog) by khurram on February 28, 2013
  • Sharepoint and SQL Server Reporting Services

    SQL Server 2005 Reporting Services SP2 or later can be integrated with Sharepoint. Setting it up is bit tricky. http://msdn.microsoft.com/en-us/library/ee384252.aspx URL is must read to troubleshoot the issues. For me following worked Ensure only Windows Integrated Authentication is checked on http://server/ReportServer DisableLoopBackCheck ...
    Posted to Khurram Aziz (Weblog) by khurram on January 2, 2010
  • Disallowing Running the Stored Procedure in Parallel

    I wrote a stored procedure a while back; it manipulates the database of a legacy and proprietary application. Few assumptions were taken like the stored procedure will always get invoked by the job and job doesn't run in parallel. Few weeks back there was a requirement to let the user do that operation from the web on demand; which triggered the ...
    Posted to Khurram Aziz (Weblog) by khurram on October 20, 2009
  • Tsql : Update From / Self Join

    The other day I received a query on how to update rows in a table having from clause and self join needs to be used…I thought its interesting scenario and should document it for future references… Let me explain the problem with a scenario…Lets consider a table in which hierarchy is implemented using Parent / Child to self; something like create ...
    Posted to Khurram Aziz (Weblog) by khurram on October 8, 2009
  • Date Calculations in TSQL

    Sometime while implementing some date/time specific business logic; we need to do some processing on datetime data; e-g trimming away the time, knowing the start of month datetime value. Instead of converting the datetime data to string and then doing some string processing; we can use the SQL Server’ built in functions like dateadd and datediff ...
    Posted to Khurram Aziz (Weblog) by khurram on September 30, 2009
  • If-Else Like Behavior in Where Clause

    .csharpcode, .csharpcode pre { font-size: small; color: black; font-family: consolas, ''Courier New'', courier, monospace; background-color: #ffffff; /*white-space: pre;*/ } .csharpcode pre { margin: 0em; } .csharpcode .rem { color: #008000; } .csharpcode .kwrd { color: #0000ff; } .csharpcode .str { color: ...
    Posted to Khurram Aziz (Weblog) by khurram on September 28, 2009
  • 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
  • Knowing current SPROC name

    Instrumentation though usually a ''non-functional requirement''; but its considered to be critical especially in ''enterprise class application''. For this we usually need to know what is the current part of code being executing; against which we can log some info. Same applies to data-tier; thankfully TSQL has required functionaliy. This is ...
    Posted to Khurram Aziz (Weblog) by khurram on November 2, 2006
  • 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
  • TSQL :: Comparing multiple fields

    Sometimes you want to select from one list the items that exist (or don’t exist) in the second row; and for the comparison you want to use multiple rows. This is common in scenarios where you want to remove duplicate values. You might wish to write something like this in TSQL (This is just an example; not very practical one; but I guess it will ...
    Posted to Khurram Aziz (Weblog) by khurram on June 18, 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
  • Tsql :: Checksum

    Comparing Checksum is one of the straight forward techniques to know if two things are different or not, especially when you are comparing some vector quantities. SQL Server 2005’s TSQL has two new relevant functions in this regard, checksum() and checksum_agg() Consider a test table having some values. Using checksum() you can have a computed ...
    Posted to Khurram Aziz (Weblog) by khurram on May 16, 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
  • Can we use stored procedures in View?

    Well I have not gone through all the options yet; but I was able to did something that solved the problem at hand. The database at hand was exposed only through stored procedures; but one developer wanted to have a view; being new to Perl on Unix; he hasn’t yet explored how to execute stored procedures. He asked me to setup few views for him ...
    Posted to Khurram Aziz (Weblog) by khurram on March 21, 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
  • Passing Array To Stored Procedures

    There are some scenarios; where you want to pass array to stored procedure. In SQL 2000; it was not possible. Different work-around was presented; like passing values as string and then parsing them out; passing data as XML and then using MSXML OLE automation object in SQL Server (sp_OACreate/sp_OADestroy). Both have the pit falls; parsing ...
    Posted to Khurram Aziz (Weblog) by khurram on March 8, 2006
  • sysxlogins

    SQL Server 2000 had certain system tables; using them was not encouraged and neither were they documented publicly. However no one was stopping you to use it and people have used it to do different things. I myself have used few of them; and today I discovered a “breaking change” between SQL 2000 and SQL 2005 regarding sysxlogin. Technically ...
    Posted to Khurram Aziz (Weblog) by khurram on February 7, 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

    Using transactions in SQL Server is sometimes tricky. Here is today’s learned lesson. If you set xact_abort to on; you don’t need to rollback the transaction; it gets automatically rolled back in case of any error. One thing that can lead you to problems is; that transactions get rolled back when you close the connection. If you want to perform ...
    Posted to Khurram Aziz (Weblog) by khurram on January 23, 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
  • Reporting Services :: ReportServerUrl

    If you have configured SQL Services Reporting Services, and specifically has set ReportServerUrl in Report Manager’s configuration, you might get the following exception. The configuration file contains an element that is not valid. The ReportServerUrl element is not a configuration file element If this is the case; erase the value being set ...
    Posted to Khurram Aziz (Weblog) by khurram on January 3, 2006
  • Attaching/Detaching SQL database :: sp_ChangeObjectOwner

    If you detach your database and attach it to another SQL Server instance; chances are that same logins doesn’t exists. If there are some database objects in a database which are not owned by dbo but by some login which might not exists in the second server, you should change owner of such objects to dbo sp_changeobjectowner @objname = ...
    Posted to Khurram Aziz (Weblog) by khurram on January 2, 2006
  • To Indexed View Or Not?

    This year; we computerized the attendance system of our company. And as the year is ending; everyone is expecting a yearly attendance report. When system was made; it was not stressed test; and today; when I evaluated the report to see it will work when people will view it tomorrow; it didn’t work (as expected </smile>) The report is based ...
    Posted to Khurram Aziz (Weblog) by khurram on December 31, 2005
  • 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
  • SQL Server 2005 :: The First Impression

    I strongly recommend not configuring SQL Server 2005 Developer Edition and SQL Server 2005 Express on your development machine, unless you have lot of memory and system resources. Don’t install SQL Server 2005 Management Studio and SQL Server management Studio Express CTP on a single machine; you will get weird exception in SQL Server 2005 ...
    Posted to Khurram Aziz (Weblog) by khurram on December 29, 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
  • SQL Server 2005 Express :: Remote Desktop

    In last few posts, here and here; I had been complaining that I am not able to configure the SQL Server 2005 Express Edition on machines which are part of the active directory. Well; there was one stupid reason; I was doing that experiment in afternoon from my home machine. VWD/SQL Express were working fine on my home PC; because I was ...
    Posted to Khurram Aziz (Weblog) by khurram on November 30, 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:: Corrupt sysdepends can create problem in DTS

    SQL Server internally keeps tracks of database objects and their inter-dependencies. In routine operations; I guess this information is not being used; however if you Script your database (SQL-DMO API) this information is used to order the DML queries. The information of the database objects and their inter-decencies are stored in two special ...
    Posted to Khurram Aziz (Weblog) by khurram on September 9, 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
  • SQL Server Reporting Services :: Security Settings Not Working

    I love SQL Server Reporting Services. It’s very fine platform; has number of options for accessing reports; like web based portal; Sharepoint webparts; URLs and web services. Above this all; it provides extendibility at multiple points; like data providers; data rendering; report designing; report delivery and so forth.   Few weeks back; I ...
    Posted to Khurram Aziz (Weblog) by khurram on July 22, 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
  • Reporting Services :: Report Manager giving 401 after installing Service Pack 1 on Windows 2003

    Installing Service Pack 1 on the Windows 2003 box resulted problem in accessing Report Manager web site of SQL Server Reporting Services. We were having “The request failed with HTTP status 401: Unauthorized”   I checked logs of IIS, Report Manager and system’s event logs, but no use. Reporting Server web service was accessible just fine; ...
    Posted to Khurram Aziz (Weblog) by khurram on June 2, 2005
1 2 Next >
Powered by Community Server (Personal Edition), by Telligent Systems