Archive for the ‘SQL Server’ Category
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 ...
Posted in SQL Server | No Comments »
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. ...
Posted in SQL Server | No Comments »
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 ...
Posted in SQL Server | No Comments »
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 ...
Posted in SQL Server | No Comments »
Tuesday, December 27th, 2011
A new cloud based SAAS service for building Dashboard and website prototypes is now available at https://www.wireframes.org
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 ...
Posted in SQL Server | No Comments »
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 ...
Posted in SQL Server | No Comments »
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 ...
Posted in SQL Server | No Comments »
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 ...
Posted in SQL Server | No Comments »
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
, ...
Posted in SQL Server | No Comments »
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
Posted in SQL Server | No Comments »