SQL Server Mentalist

Hi friends

I Just restored database Adventure works DB using SQL server 2012 , i found its more simpler and more informative and clearer than what we have in earlier version.

Already we are talking lot about SQL Server 2012 ,I am always thinking of this release that it is so powerful and so enriched with lots of must required features , My mind couldn’t stop me for posting about it .If you have missed any post on same then links are as follows ..

• BISQL # 95 – SQL Server 2012–What’s new Or Summary for future SQL server
• Developer Experience #1 – What’s new in SSIS ! No More NEW from Now !!
• Breakthrough Insight SQL Server 2012 , SQL Server Evolution 2000 – 2012
• New Features , SSDT Introduction and links
• Installation, Problem, Support and Help !
• Migrating to SQL Server 2012 Failover Clustering and Availability Groups

Following are key feature we can Discuss & observed in SQL server 2012-Restoration

• Source & Destination
• Easy Interface and additional Search Option
• Ease of use in Relocating and Replacing file
• More Info ,Verify Back Media and TimeLine 
• Hiding unnecessary and Very clear information
• Attractive Restoring Progress Bar
• Database Auto refresh and fast

Lets see how this features are look like while resorting Database

Source & Destination

Easy separation at first glance for Source and destination

Easy Interface and additional Search Option

Interface adaptability and we can search required file , I always think of this feature when its not there but now i am more happy !

More Info ,Verify Back Media and TimeLine

We have more crystal clear information wile restring back up with verify backup media and timeline option

Ease of use in Relocating and Replacing file

We can see in SQL server 2012 more enhanced option for relocating files.

Hiding unnecessary and Very clear information

Attractive Restoring Progress Bar

Ohhh !! is it ! Yes progress bar what we love always its there and more comprehensive and fast as also shown in following screen shot

Database Auto refresh and fast

We will have more post related to restoring and all on next post on SQL Server 2012

You may also interested in reading topics like

• MSBI #45 – SQL Server 2012 #1 – Now SQL Server ‘Denali’ is 2012 !
• BISQL # 51 : SQL Server Denali Feature # 2 – Sequence number –All Explanation !!
• BISQL # 53 : SQL Server Denali Feature # 3 – Always On (Concept ,Architecture)
• BISQL # 50 : SQL Server Denali Feature # 1- File Tables # 2 – Demo and Scripting
• BISQL # 49 : SQL Server Denali Feature # 1–File Tables #1 – Introduction & Theory

Hope you will like this post on Restore Database.

If you really like reading my blog and understood at least few thing then please don’t forget to subscribe my blog.

If you want daily link and analysis or interesting link go to following website which will give @ your inbox please subscribe our following link resource blog :

Link Resource Website

For More information related to BI World visit my Mentalist Blog

Link Resource Blog >> Daily Interesting links

SQL Server Mentalist >> SQL Learning Blog

Business Intelligence Mentalist >> BI World

Connect With me on

| Facebook |Twitter | LinkedIn| Google+ | Word Press | RSS |

Hi friends ,

In this article I am trying to provide you all new future and information  related SQL Server 2012 based on MSDN topics in which MS has all topics we with concept which is very well explained features.

My aim is to provide you SQL Server 2012 Summery future and maximum overview covering all topics which are Part of Release of SQL Server 2012.

I have already covered following topics on my BI blog as follows with there respective links if you have missed any :

• Developer Experience #1 – What’s new in SSIS ! No More NEW from Now !!
• Breakthrough Insight SQL Server 2012 , SQL Server Evolution 2000 – 2012
• New Features , SSDT Introduction and links
• Installation, Problem, Support and Help !
• Migrating to SQL Server 2012 Failover Clustering and Availability Groups

In this topics we are going to cover

• What new SQL Server 2012
• Install SQL Server 2012 from the Installation Wizard
• Editions and Components of SQL Server 2012
• What’s New in SQL Server Installation
• What’s New (Database Engine)
• What’s New (Analysis Services)
• What’s New (Integration Services)
• Introducing Data Quality Services
• What’s New (Master Data Services)
• What’s New (Replication)
• What’s New (Reporting Services)
• SQL Server 2012 – SSMS – @ First Glance

Install SQL Server 2012 from the Installation Wizard

For installation we can see topic : Install SQL Server 2012 from the Installation Wizard (Setup) in which we have detailed steps to install SQL Server 2012

Also We have installation topics such as:

• Install SQL Server 2012 from the Command Prompt.
• Install SQL Server 2012 Using a Configuration File
• Install SQL Server 2012 Using SysPrep
• Create a New SQL Server Failover Cluster (Setup).
• Upgrade to SQL Server 2012 Using the Installation Wizard (Setup)

Editions and Components of SQL Server 2012

On this topic what are the different editions of SQL Server accommodate the unique performance, runtime, and price requirements of organizations and individuals explained nicely :Editions and Components of SQL Server 2012

SQL Server Components

• SQL Server Database Engine
• Analysis Services
• Integration Services
• Reporting Services
• Master Data Services

This list is somewhat same but inner content has more but powerful difference.

Management tools List
• SQL Server Management Studio
• SQL Server Configuration Manager
• SQL Server Profiler
• Database Engine Tuning Advisor
• Data Quality Client
• SQL Server Data Tools
• Connectivity Components SSDT – SQL Server Data Tools is key holder for now we have already discuss on my BI Blog

New Lets focus on compressive changes from MSDN :

What’s New in SQL Server Installation

What’s New in SQL Server Installation : In this topics we have list of changes related to installation such as Datacenter Edition,Business Intelligence edition,Enterprise Editions,Microsoft Sync Framework,SQL Server Data Tools ,Data Quality Services,Server Core Installation,SMB file share is a supported storage option . Click on topic header for View.

What’s New (Database Engine)

What’s New (Database Engine) : This is most important change in which we have various interesting topics such as

• Availability Enhancements (Database Engine) : High availability features
• Manageability Enhancements (Database Engine) :Tools and monitoring features
• Programmability Enhancements (Database Engine)
• Scalability and Performance Enhancements (Database Engine)
• Security Enhancements (Database Engine)
• Resource Governor Enhancements (Database Engine)
• Microsoft.SqlServer.Dac and Microsoft.SqlServer.Dac.Extensions 

From above all topic you can decide weightage of this page

What’s New (Analysis Services)

What’s New (Analysis Services) : This is also extended and bigger change by introducing and placing new and old features to form  Robust Architecture for development .

Lots of link are there in this page also following are some key topics for same

• Server Instance and Server Monitoring
• Tabular Modeling
• Multidimensional Modeling
• PowerPivot for Excel
• PowerPivot for SharePoint
• Programmability
• Design Tools

What’s New (Integration Services)

What’s New (Integration Services) : Way we look @ SSIS is now very different and easy now in SQL server 2012 w.r.t SSIS

The following list to find new features and enhancements by area:

• Deployment
• Management and Troubleshooting
• Development Enhancements
• Performance
• Data Quality
• Access to Samples and Tutorials

Introducing Data Quality Services

Introducing Data Quality Services : The data-quality solution provided by Data Quality Services (DQS) enables a data steward or IT professional to maintain the quality of their data and ensure that the data is suited for its business usageIn this topic we have
• The Business Need for DQS
• Answering the Need with DQS
• A Knowledge-Driven Solution
• DQS Components
• Data Quality Functionality in Integration Services and Master Data Services

What’s New (Master Data Services)

What’s New (Master Data Services) : Around more than 10+ feature such as Use Excel to Manage Master Data,Match Data before Loading,New Model Deployment Tools,SharePoint Integration Introduced,Security Simplified and Installation is Part of SQL Server with many more topics ..

What’s New (Replication)

What’s New (Replication) : In this release of SQL Server introduces several new features and improvements to replication such as Replication Support for AlwaysOn Availability Groups ,Replication Extended Events and many more

What’s New (Reporting Services)

What’s New (Reporting Services) : Now Reporting is different world in way of SQL server 2012 in which have most important as follows :

1. Power View
2. SharePoint Mode
3. Data Alerts
4. Report Server Projects in SQL Server Data Tools for Visual Studio 2010
5. Excel Renderer for Microsoft Excel 2007-2010 and Microsoft Excel 2003
6. Word Renderer for Microsoft Word 2007-2010 and Microsoft Word 2003


SQL Server 2012 – SSMS – @ First Glance

Now , following are my quick observation while using SSMS very first time in back ..

At SSMS start we can find change and updated logo i.e. Powered By Visual Studio

Second quick observation SQL server Version

Two Additional folder component for more research and better performance

We will have lot of post on above related to this topic in my upcoming post .

Reference link

• The SQL Server Management Studio Environment
• Features in SQL Server Management Studio
• Build Database Projects by Using SQL Server Management Studio
• Tool Windows in SQL Server Management Studio
• Understand SQL Server Management Studio Windows Management
• Administer Servers with SQL Server Management Studio
• User Assistance in SQL Server Management Studio
• Customize Menus and Shortcut Keys
• Property Pages in SQL Server Management Studio
• Introduction to SQL Server Management Studio for Business Intelligence
• Add an External Tool to the Tools Menu (SQL Server Management Studio)
• Configure Login Auditing (SQL Server Management Studio)
• Configure WMI to Show Server Status in SQL Server

You may also interested in reading topics like

• MSBI #45 – SQL Server 2012 #1 – Now SQL Server ‘Denali’ is 2012 !
• BISQL # 51 : SQL Server Denali Feature # 2 – Sequence number –All Explanation !!
• BISQL # 53 : SQL Server Denali Feature # 3 – Always On (Concept ,Architecture)
• BISQL # 50 : SQL Server Denali Feature # 1- File Tables # 2 – Demo and Scripting
• BISQL # 49 : SQL Server Denali Feature # 1–File Tables #1 – Introduction & Theory

Hope you will like this post on What’s new Or Summary for future SQL server .

If you really like reading my blog and understood at least few thing then please don’t forget to subscribe my blog.

If you want daily link and analysis or interesting link go to following website which will give @ your inbox please subscribe our following link resource blog :

Link Resource Website

For More information related to BI World visit my Mentalist Blog

Link Resource Blog >> Daily Interesting links

SQL Server Mentalist >> SQL Learning Blog

Business Intelligence Mentalist >> BI World

Connect With me on

| Facebook |Twitter | LinkedIn| Google+ | Word Press | RSS |

Hi Folks ,

Continuing from my last post ,In which we are finding various relationship with table and stored procedure

BISQL # 93 – How to find list of Stored procedure which does not depend on any table operation : In this post we have learn how to find stored procedure which is not participating and Stored procedure table relationship

Also to be in synch each other my one of previous article (How to establish / Find relationship between Table and stored Procedure in Database) in which we have already covered following points :

How to analyse all schema

How to analyse all Tables in Database

How to analyse all procedure

How to analyse all dependency Between Table and Stored Procedure

Establishing Relation Between Table and Stored Procedure

Final and Quick result script for Relationship of Table and Stored Procedure

In this article we are going to cover following problem statement

Problem : How to find tables which is not participating in Stored procedure table relationship

Lets do some querying to get expected result first on Adventure work DB

Following query will provide us list of all tables in given Database system

SELECT * FROM sys.tables

Which have following in output as 70 tables

 

Now lets fire query which we have already discuss : Final and Quick result script for Relationship of Table and Stored Procedure

SELECT DISTINCT
            p.name AS 'Stored Procedure' ,
            s.name AS 'Schema Name',
            t.name AS 'Table Name'
FROM        sys.sysdepends AS d
INNER JOIN    sys.procedures AS p 
ON            d.id = p.object_id
INNER JOIN    sys.tables AS t ON t.object_id = d.depid
INNER JOIN    sys.schemas AS s 
ON            t.schema_id = s.schema_id;

Which shows output as in which stored procedure and which table have been used interns of table – Stored procedure relation 

Now here what our problem requirement is in which list of Table which are not dependent on stored procedure.

 

Which means only 6 tables are used by stored procedure !

We can clearly see n this output and output compare to just above script stored procedure does not contain any table in its definition which are in second output result.

Hope you will like this post on How to find tables which is not participating in Stored procedure table relationship.

If you really like reading my blog and understood at lest few thing then please don’t forget to subscribe my blog .

If you wan daily link and analysis or interesting link go to following website which will give @ your inbox please subscribe our following link resource blog

Where todays links are

Link Resource Website

For More information related to BI World visit my Mentalist Blog

Link Resource Blog >> Daily Interesting links

SQL Server Mentalist >> SQL Learning Blog

Business Intelligence Mentalist >> BI World

Connect With me on

| Facebook |Twitter | LinkedIn| Google+ | Word Press | RSS |

Hi Friends ,

Continuing from my last series of Code reviewing..

• BISQL # 90 – How to find Number of lines of Code in procedure or function

Reviewing and Updating in Existing Database with very less amount of time is really challenging task for all architects. Its not rocket science we have evolved from whatever we have in terms of resource , Knowledge and Research.We must always find way which will solve our current problem and save future time.Saving future time is most important aspect.

Now this all conversation i have shared because from my one of post in which i have explain how can Tables, Columns ,Procedures More readable and more easy and easy to maintain.

On my previous article (How to establish / Find relationship between Table and stored Procedure in Database) in which we have already covered following points :

How to analyse all schema

How to analyse all Tables in Database 

How to analyse all procedure

How to analyse all dependency Between Table and Stored Procedure

Establishing Relation Between  Table and Stored Procedure

Final and Quick result script for Relationship of Table and Stored Procedure

In this article we are going to cover following problem statement

Problem : How to find stored procedure which is not participating and Stored procedure table relationship

Lets do some querying to get expected result first on Adventure work DB

Following query will provide us Stored procedure in given system

SELECT * FROM Sys.procedures

Which have following in output as 9 stored procedure

 

Now lets fire query which we have already discuss : Final and Quick result script for Relationship of Table and Stored Procedure

SELECT DISTINCT
            p.name AS 'Stored Procedure' ,
            s.name AS 'Schema Name',
            t.name AS 'Table Name'
FROM        sys.sysdepends AS d
INNER JOIN    sys.procedures AS p 
ON            d.id = p.object_id
INNER JOIN    sys.tables AS t ON t.object_id = d.depid
INNER JOIN    sys.schemas AS s 
ON            t.schema_id = s.schema_id;

Which shows output as in which stored procedure which table have been used

Now here what our problem requirement is in which stored procedure we not using any of table

So following is Key query which answer to our problem statement

SELECT  name
FROM    sys.procedures
WHERE   object_id NOT IN (
        SELECT DISTINCT
                p.object_id
        FROM    sys.sysdepends d
INNER JOIN sys.procedures p ON d.id = p.object_id
INNER JOIN sys.tables t ON t.object_id = d.depid
INNER JOIN sys.schemas s ON t.schema_id = s.schema_id )

Which in output will provide list of SP which is not dependent on any table

We can clearly see this output and output compare to just above script stored procedure uspPrintError does not contain any table in its definition

Hope you will like this post on How to find list of Stored procedure which does not depend on any table operation.

If you really like reading my blog and understood at lest few thing then please don’t forget to subscribe my blog .

If you wan daily link and analysis or interesting link go to following website which will give @ your inbox please subscribe our following link resource blog

Where todays links are

Link Resource Website

For More information related to BI World visit my Mentalist Blog

Link Resource Blog >> Daily Interesting links

SQL Server Mentalist >> SQL Learning Blog

Business Intelligence Mentalist >> BI World

Connect With me on

| Facebook |Twitter | LinkedIn| Google+ | Word Press | RSS |