There are many visualization tools available from different companies.
Microsoft always concentrates more on visualization tools because visual tools are going to play a major role in the future.
What is the use of visualization tools?
visualization tools to visualize and analyze the data in an easy way. In this digitized environment, we are producing data from different kinds of machines and gadgets which are not easy to process and understand. To understand those data, we need to process first and once we get proper format, then using visualization tools, we can able to understand.
Microsoft innovations are always awesome since those are very easy to learn and use. The most famous tool from Microsoft is office tools, in that Microsoft excel is the best which can be used from very basic users to advanced users.
In excel, Microsoft added a few more options in terms of visualization. Those options are,
Data is the most valuable asset in almost all the places.
Understanding the data is not easy for a layman. Visualization tools are playing a vital role to make the layman to understand about the data. Most of business decisions based on best data visualization.
This article speaks about simple visuals based on data about cancer statistics.
Just collected a few facts about the estimated number of new cancer cases in US 2015.
Ref: http://www.cancer.org/acs/groups/content/@editorial/documents/document/acspc-044552.pdf
Visualization tools always helping us to see the facts very clearly. I just converted the data to graphs by using simple and effective Microsoft Excel.
Estimated New Cases for Both Male and Female:
Estimated New cases for Male Vs Female:
This is just to help you understand the facts about cancer diseases.
Learning Steps:
Ease of access and easy life is now possible with On-premises and hybrid cloud technology with SQL Server 2016.
Save your time and cost on storages and get extra time to relax with this brand new stretch database concept within SQL Server 2016.
You can stretch your legs and relax and get a quick session on delivering your analytics against hot, warm & cold data. Stretch Database is the new concept, which allows you to stretch from on-prem to cloud easily. You can easily enable / disable data stretch, accessing data using stretch database, setup remote data archiving, basic concepts on enabling database/table and backup & restore for the stretch enabled databases.
Stretch DB also covers the concepts of Shallow & Deep backups. However, Deep backups are not supported with SQL Server 2016 CTP2.
You can download the latest CTP 3.2 from this link.
It is always a best practise to validate whether the logins & user exists before creating a new one in SQL Server. You can verify this by using the system tables (syslogins & sysusers). I have given below T-SQL queries to validate first and then create. To access any specific database, a login creation is a mandatory. If the login already exists, you can still verify it with syslogins and then create the user for any new databases.
–Check the logins first for the SQL Server
USE [master]
GO
SELECT name FROM sys.syslogins;
GO
SELECT name FROM sys.sysusers;
GO
–Check the users for any specific databases.
USE [AdventureWorks2012]
GO
SELECT name FROM sys.sysusers
GO
After reviewing the available logins & users for the SQL Server and specific databases, and according to your company policies in naming convention, you then can create users accordingly. But before that need to drop the user if exists with the below queries.
–IF EXISTS DROP USER & LOGINS for a SQL user named ServiceAct_App1
USE [AdventureWorks2012]
GO
IF EXISTS (SELECT name FROM sys.sysusers WHERE name = N’ServiceAct_App1′)
DROP USER ServiceAct_App1
GO
USE [master]
GO
IF EXISTS (SELECT name FROM sys.sysusers WHERE name = N’ServiceAct_App1′)
DROP USER ServiceAct_App1
GO
IF EXISTS (SELECT name FROM sys.syslogins WHERE name = N’ServiceAct_App1′)
DROP LOGIN ServiceAct_App1
GO
In here, I am creating login & user after dropping it with if exists statement.
–CREATE LOGIN, CREATE USER, ASSIGN ROLES for Applications – Service Account
USE [master]
GO
CREATE LOGIN [ServiceAct_App1] WITH PASSWORD=N’YSM2015′, DEFAULT_DATABASE=[AdventureWorks2012], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
GO
USE [AdventureWorks2012]
GO
CREATE USER [ServiceAct_App1] FOR LOGIN [ServiceAct_App1]
GO
ALTER ROLE [db_datareader] ADD MEMBER [ServiceAct_App1]
GO
USE [master]
GO
CREATE USER [ServiceAct_App1] FOR LOGIN [ServiceAct_App1]
GO
ALTER ROLE [db_datareader] ADD MEMBER [ServiceAct_App1]
GO
Quick and useful tips on using Resource Governor in your SQL Server environment. I have selected randomly on some of the Resource Governor related T-SQL queries that might be useful in your work environment.
–to view the resource governor configuration
SELECT * FROM sys.dm_resource_governor_configuration;
GO
— to view the resource governor workload groups
SELECT * FROM sys.dm_resource_governor_workload_groups
GO
— to view the resource governor resource pools
SELECT * FROM sys.dm_resource_governor_resource_pools
GO
–to reset the accumulated statistics about the resource governor usage
ALTER RESOURCE GOVERNOR RESET STATISTICS;
GO
–if you have more than one resource governor classifier function, you can use below statement to apply another function to take effect
ALTER RESOURCE GOVERNOR
WITH (CLASSIFIER_FUNCTION = dbo.AnotherClassifierFunction);
GO
ALTER RESOURCE GOVERNOR RECONFIGURE;
GO
–Code to Remove All Classifier Functions from the Resource Governor
ALTER RESOURCE GOVERNOR WITH (CLASSIFIER_FUNCTION = NULL);
GO
ALTER RESOURCE GOVERNOR RECONFIGURE;
GO
Microsoft keeps improving the SQL Server 2016 in every CTP version and the latest CTP 3.1 has been released and can be downloaded in this link.
SQL Server 2016 Technical documentation is available here.
As usual, the downloads are available both in ISO & CAB formats.
You can now easily enable & disable stretch database both in GUI via SSMS and also using T-SQL. Below screens provides you on each step involved in enabling the Stretch for the database.
You can easily disable stretched database using below T-SQL.
ALTER DATABASE DAGEOP_STRETCH2
SET REMOTE_DATA_ARCHIVE = OFF