Archive for the ‘SQL Server’ Category

Increasing revenue with data dashboards

Wednesday, April 5th, 2017

Some people think of a data dashboard as nothing more than a pretty visual aid, but when properly used, the dashboard can be a key tool in increasing business revenue. By monitoring meaningful metrics and responding relevantly, you can boost your business and raise your revenue. Isn't that awesome? Select the KPIs to ...

Using SQL for Dashboard building

Sunday, April 2nd, 2017

From SQL Query to Analysis InfoCaptor is extremely versatile dashboard application. It started initially just as "SQL Dashboard". What do you mean by "SQL Dashboard"? This was the MVP (minimal viable product) for a Dashboard tool. The basic premise of the idea was that a developer can type any SQL query and produce the information. ...

Importance of visualizations and analytics for small business owners

Tuesday, March 28th, 2017

Small business owners are all about "Getting the biggest bang for the buck". We as small biz owners want everything to work efficiently and make sure no resources are wasted that includes human resources, time and money. The question now is "How do you make sure your operation is efficient?" Not by ...

Google acquisitions samples with vizualizations

Thursday, March 23rd, 2017

Google has acquired around 184 companies as of October 2015, with its largest acquisition being the purchase of Motorola Mobility, a mobile device manufacturing company, for $12.5 billion. Not all the acquisition figures are available but aggregating all the public known amounts, Google has spent atleast 28 billion USD on acquisitions. With ...

UI Mockup Tool – User interface wireframes

Tuesday, December 27th, 2011

A new cloud based SAAS service for building Dashboard and website prototypes is now available at MockupTiger is an amazingly simple and very powerful application and Remember, you have three options to use Mockuptiger Install on your PC and use as a personal application Host it on your domain or corporate network Forget installation ...

BI Documentor – Lineage Documentation for SQL Server

Wednesday, January 14th, 2009

How do you use it as BI Documentor? SQL Documentor can be used to generate Lineage Documentation for your databawarehouse and Business intelligence reporting. You can add your own SQL queries within SQL Documentor and then link it to detail or child level queries. This in turn can be drilled into another ...

Database Documentation Tool | SQL Doc Generator

Tuesday, December 30th, 2008

Overview: SQL Documentor for SQL server is a modest PDF and HTML document generator for your schema objects. You can document your tables, views, procedures, triggers, indexes with few clicks. It has a pre-built dashboard interface for easy browsing of your meta-data. Impress your clients by providing them with pixel perfect ...

SQL Server Documentor – Documentation and Dashboard tool

Friday, December 5th, 2008

Here is a sneak peek at the new SQL Server Documentation tool. This tool is extremely customizable by the end user. You can add your own meta-data queries, change existing queries, change the color formatting and has multiple uses. The interface is quite easy to understand. Connection Wizard In this window, you provide ...

Table Size in SQL Server | Find Rows and Disk space Usage

Wednesday, November 12th, 2008

There are two ways to get the table size Run the stored procedure exec sp_spaceused "Sales.ContactCreditCard" Now what if you needed to get a list of Top 20 Tables by number of rows or disk space? Use the following query SELECT t.schema_name+ ' - '+ t.table_name as schema_table , t.index_name , sum(t.used) as used_in_kb , sum(t.reserved) as reserved_in_kb , ...


Tuesday, October 21st, 2008

-- Identifies check constraints CREATE VIEW INFORMATION_SCHEMA.CHECK_CONSTRAINTS AS SELECT db_name() AS CONSTRAINT_CATALOG, schema_name(schema_id) AS CONSTRAINT_SCHEMA, name AS CONSTRAINT_NAME, convert(nvarchar(4000), definition) AS CHECK_CLAUSE FROM sys.check_constraints