Author Archives: Vibhuti Singh

JQuery UI – Datepicker disabled selected dates

rx online

In this article we will see how to disabled the JQuery selected dates.

Used the below script to achieve the same, in below script i just disabled the last day of every month. Continue reading

637 total views, 1 views today

Tortoise SVN : Change / Re-Authenticate user

rx online

TortoiseSVN is an Apache™ Subversion (SVN)® client, implemented as a Windows shell extension. It’s intuitive and easy to use, since it doesn’t require the Subversion command line client to run. And it is free to use, even in a commercial environment. Simply the coolest Interface to (Sub)Version Control!

Continue reading

683 total views, no views today

IE11 Style Display Block issue

rx online

Recently Microsoft has improved the IE11 and it will now support most of the CSS howver in previous version IE has an intiligent to auto correct the styles error and inherit from parent.

For Eaxmple i come accross with one issue related with table row <tr> that to hide the same we were using style=”display:none” and to show the same back we  change the display to “block”. It worked till IE10 as per browser standard we have to use style=”display:table-row” not “display:block;” or inline Continue reading

670 total views, no views today

Automation Testing (Data Fill) via Excel using iMacros

rx online

In this article we will learn to fill the web form using Automation with just few line of code. No technical skill required nor automation certification to perform this automation testing.

To demonstrate this automation first we  need to install the iMacros Adons either in Mozilla, Chrome, IE. Continue reading

1,285 total views, 1 views today

Multi Sql Query Executer (Azure DB)

rx online

In this article we will see one of the application /  tool developed by me to run the SQL Query on multiple SQL Server different database at same time. Many time in our projects we found the situation that  we need to execute procedure or sql scripts at 5-10 database. Continue reading

2,010 total views, no views today

Access WindowsAzure Storage Account via Asp.net C#

rx online

In this article we will learn to access the window azure storage account. You will able to uploads the file to blob, delete the file from blob and get the list of files from blob. Microsoft Azure (formerly Windows Azure before March, 25th 2014) is a cloud computing platform and infrastructure, created by Microsoft, for building, deploying and managing applications and services through a global network of Microsoft-managed datacenters. It provides both PaaS and IaaS services and supports many different programming languages, tools and frameworks, including both Microsoft-specific and third-party software and systems Continue reading

1,237 total views, 1 views today

Window Azure SQL Clustered Index Problem Fix

rx online

Windows Azure SQL Database is SQL Server technology delivered as a service on the Windows Azure Platform. The cloud-based SQL Database solutions can provide many benefits, including rapid provisioning, cost-effective scalability, high availability, and reduced management overhead. SQL Database supports the same tooling and development practices used for on-premise SQL Server applications. Therefore, it should be a familiar experience for most developers. Continue reading

1,208 total views, no views today

Count No of records in all table using T-SQL

rx online

In this article we will learn to fetch the numbers of rows in your each table.

Some time in situations you are required just the count of the rows in each table, we can go with various approach like  using third party software, count manually 🙁 or write program in our preferred language.

But no need to worry to much… SQL is keeping all this information ready for you, you just need to call it.

sys.partitions" is the table in your SQL server which is maintaining all records count however it is very difficult to know the table since it is used the objectid instead of table name. So in this case we will join with sys.tables from were you will get the object id of table and then you get the desired results very easily.

Provided below are the sample queries for the same

SELECT sc.name +'.'+ ta.name TableName
 ,SUM(pa.rows) RowCnt
 FROM sys.tables ta
 INNER JOIN sys.partitions pa
 ON pa.OBJECT_ID = ta.OBJECT_ID
 INNER JOIN sys.schemas sc
 ON ta.schema_id = sc.schema_id
 WHERE ta.is_ms_shipped = 0 AND pa.index_id IN (1,0)
 GROUP BY sc.name,ta.name
 ORDER BY SUM(pa.rows) DESC

NOTE: This query in not compatible on Azure DB you can use below query on Azure Db

SELECT sc.name +'.'+ ta.name TableName
 ,SUM(pa.row_count) RowCnt
 FROM sys.tables ta
 INNER JOIN sys.dm_db_partition_stats pa
 ON pa.OBJECT_ID = ta.OBJECT_ID
 INNER JOIN sys.schemas sc
 ON ta.schema_id = sc.schema_id
 WHERE ta.is_ms_shipped = 0 AND pa.index_id IN (1,0)
 GROUP BY sc.name,ta.name
 ORDER BY SUM(pa.row_count) DESC

Hopes it is useful for you.

Don’t forget to leave your comments

1,776 total views, 1 views today

Category: SQL

Import Multiple Sheet to single DataSet C#

rx online

In this article we will learn to import the excel data from multiple sheet into .Net environment (Dataset)  from where you push data to SQL if required.

Also, i tried to handle the various file extension like xls, xlsx and xlsm (macros enabled excel file). Continue reading

1,601 total views, 4 views today

First Date and Last Date of Last Month using SQL

rx online

In this article we will see how to get the first and last date of past / last month. This is very helpful to generate the previous month reports. Continue reading

1,045 total views, 1 views today

Category: SQL