Welcome to weblogs.com.pk Sign in | Join | Help

Browse by Tags

All Tags » Databases   (RSS)

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
Posted by khurram | 0 Comments
Filed under:


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 know about Splunk; it captures, indexes and correlates real-time


TICK Series This Post Telegraf Time 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


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

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

Redis Clients :: ASP.NET Core

Redis Series Redis Redis Clients This Post Dotnet Core Series Dotnet Core This Post Docker Registry Jenkins Dotnet Core -- PostgreSQL In the “Redis Clients” post; we explored what it takes to use Redis and how it can be helpful in our applications. We
Posted by khurram | 0 Comments
Filed under: , ,

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


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

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”
Posted by khurram | 0 Comments


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
Posted by khurram | 0 Comments

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_count from sys . dm_db_partition_stats where index_id < 2 order by row_count desc
Posted by khurram | 0 Comments
Filed under: ,

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

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
Posted by khurram | 0 Comments
Filed under: ,

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
Posted by khurram | 0 Comments
Filed under: ,

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
Posted by khurram | 0 Comments
Filed under: ,
More Posts Next page »