SQL Server Team – SQL Server 2008 R2 Service Pack 2 Customer Technology Preview (CTP) Available–Updates and Downloads

May 15, 2012 1 comment

Hi Friends,

Some additional information and updates regarding SQL Server 2008 R2 from SQL Server Team blog.

Please  make note for this update and have look for more :

(You can click on any of link to direct redirection to actual SQL Server Team Blog )

image

image

image

To download the SQL Server 2008 R2 SP2 release please select from the links below:

Categories: Link, SQL

BISQL #96 – SQL Server 2012 – Restore Database Features and Simplicity

May 11, 2012 2 comments

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.

image

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 ..

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

image

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 !

image

More Info ,Verify Back Media and TimeLine

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

image

Ease of use in Relocating and Replacing file

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

image

Hiding unnecessary and Very clear information

image

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

image

Database Auto refresh and fast

image

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

    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 |

Categories: Link, Query, SQL

BISQL # 95 – SQL Server 2012–What’s new Or Summary for future SQL server

May 8, 2012 2 comments

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.

image

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 :

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:

    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

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:

    Introducing Data Quality 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

  7. 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

image

Second quick observation SQL server Version

image

Two Additional folder component for more research and better performance

image

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

Reference link

    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 |

Categories: Link, Query, SQL

BISQL # 94 – How to find tables which is not participating in Stored procedure table relationship

May 4, 2012 2 comments

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

    image 

    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 

    image_thumb5

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

      image

    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 |

    Categories: Link, Query, SQL

    List of Monthly post of MS BI,SQL & Link Blog – April 2012

    April 30, 2012 Leave a comment

    Hi Friends,

    I have started blogging back in late Feb 2011 , Now almost more that year and month ,Really happy to share , collect and explain knowledge in all way from my three blog.

    I always post summery of blog @ end month if any of my reader have missed any post .

    I am really getting nice response from LinkedIn also from my recent article on SQL server 2012 , connect me on (| F|T|L|G|W|R|) whichever is easy for you.

    Hope you will keep reading and sharing ..

    Following are link of my SQL Server Mentalist Blog 5 basic tutorial

    image_thumb532

    Following are link of BI Mentalist Blog

    image_thumb643

    Following are link of Link Resource i.e Link Mentalist Blog

    Some one has really said true words :

    “Achievement results from work realizing ambition.” — Adam Ant

    Categories: Link, SQL

    White paper – Migrating to SQL Server 2012 Failover Clustering and Availability Groups from Prior Clustering and Mirroring Deployments

    April 28, 2012 Leave a comment

    Hi friends ,

    Microsoft provided white paper on  Migrating to SQL Server 2012 Failover Clustering and Availability Groups from Prior Clustering and Mirroring Deployments

    Click here to Download white paper !!

    image

    Content of this while paper is as follows

    • Introduction
    • Migration Path to SQL Server 2012 AlwaysOn
    • Migration Without Intermediate Hardware   
    • Migration with Intermediate Hardware
    • Important Considerations
    • AlwaysOn Availability Groups and Windows Server Failover Clustering
    • Forced Quorum in AlwaysOn Availability Groups
    • Automatic Failovers and FCI
    • Client Connectivity Strategy During Migration
    • Client Connectivity in Migration Without Intermediate Hardware
    • Client Connectivity in Migration with Intermediate Hardware
    • Conclusion

      From MSDN content only :

      This paper provides guidance for customers who prior to SQL Server 2012 have deployed SQL Failover Clustering for local high availability and database mirroring for disaster recovery, and who want to migrate to SQL Server AlwaysOn. .

      It describes the corresponding SQL Server AlwaysOn scenario and the migration paths to SQL Server AlwaysOn.

      It also contains the important knowledge and considerations that you must know in order to successfully migrate to a HADR solution based on SQL Server AlwaysOn technology, which implements AlwaysOn Failover Cluster Instances for high availability and AlwaysOn Availability Groups for disaster recovery.

      imageIn this white paper there is diagrammatical explanation attracts us to read content and understand clearly.

     

     

     

    White paper Details :

    Writer: Cephas Lin (Microsoft)

    Contributors: Sanjay Mishra (Microsoft), David Smith (ServiceU Corporation), LeRoy Tuttle Jr. (Microsoft)

    Technical Reviewers: Prem Mishra (Microsoft), Mike Weiner (Microsoft), Steve Howard (Microsoft), Kun Cheng (Microsoft)

    Published: March 2012

    Applies to: Microsoft SQL Server 2012

    Hope you will read this white paper.

    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 |

    Categories: Link, SQL

    BISQL # 93 – How to find list of Stored procedure which does not depend on any table operation

    April 26, 2012 Leave a comment

    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

    image 

    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

    image

    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

    image

    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 |

    Categories: Link, Query, SQL
    Follow

    Get every new post delivered to your Inbox.

    Join 753 other followers