Welcome Microsoft Help Viewer 1.1
Hi All, With the installation of SQL Server 2012 RC0, you will also find integrated “Help Viewer 1.1“. This is pretty much like MSDN help. You can launch the Help viewer by following method.
Continue reading →Category Archives: General
Auto Generate (Some particular)Change Scripts in SSMS
Hi All, How are you doing? We all know that Change is a rule of life …. And pretty much that applied to SQL Server as well 
Yes, my point is to find out the changes we have done in current SQL Server so we can deliver into the next environment i.e. UAT/Test or Production etc. People follow lots of ways to find/generate change scripts for SQL objects for their creation and modifications. But I would like to draw your attention to a facility/functionality which is provided by MS SQL Server Management Studio by default. But by default this … Continue reading →
Create SQL scripts quickly using Template Browser – SQL Server 2012 RC0
Hi All, You can quickly create SQL scripts for SQL Server or Analysis Server using Template Browser. It does not cover all detailed scenarios, But it does cover all basic scenarios + you don’t have to worry about the script structure or any deprecated syntaxes etc.
Continue reading →Browse an SSAS Cube using Excel – Automatic Setup done by SQL Server Data Tools
Hi All, Most of us; who are working on SQL BI solutions are aware of connecting SSAS Cube using Excel (as client) for browsing. Because we know that how much the clients/financial users likes to work with Excel In SQL 2012 RC0, there is one handy-dandy quick-link which enables us to make this whole functionality ready-made in few seconds. Believe it or not, try the following: Open “SQL Server Data Tools” (This is new name assigned to Visual Studio IDE/BIDS in SQL Server 2012 RC0) Use MultiDimensionalProject & create a cube with any method you want. Process & Deploy … Continue reading →
Interesting changes in Database Design of SQL Server 2012
Hi All, I would start this topic with a small real incident happened with me. I worked on SQL 2008 for almost 2.5 years and then I mixed my work with SQL 2008 R2. Once we had some work in SQL 2005 – SSIS package. It was a minor modification by playing with few date columns. I tried to use DATE datatype unknowingly and ssis package was giving me error. I did not concentrate on the DATE datatype which I have used and rather I was searching here and there. And finally I recalled that DATE datatype is not available … Continue reading →
My article got selected as “Article of Week” on BIDN :)
Hi folks, I would like to share a joy with you all that one of my articles got selected as “Article of Week” in BIDN. BIDN is “BI Developer Network Community“. Visit http://bidn.com for awesome BI articles and tutorials, If you are hungry to learn things from tech experts like Brian Knight, Dustin Ryan, Mike Davis, Devin Knight and many more…
Continue reading →12th ‘BI Conference’ on February 11, 2012 in Pune
IBM, Capgemini experts will congregate to speak@Business Intelligence Conf (Feb 11, Pune). The Agenda of the BI is deliberated in such way that it gives realistic skills for Developers and Architects. It is a forum of BI Developers, Architects, Project Managers and Teams, IT Managers and Professionals, Analysts and Business Decision Makers imminent together to build their BI proficiency. Eavesdrop to the BI Expert Mukund Deshpande, AVP – Head BI/Analytics Business Unit, Persistent Systems speak on “Relevance of BIG Data technologies for the Enterprise” and know more about how Big Data can be used to derive intelligent insights and to … Continue reading →
Learn SharePoint Quickly and FREE
Hi all, please check-out FREE SharePoint tutorial Here: http://www.sharepointhosting.com/video_tutorials.html Following is the list of videos available. So if you find anything helpful, just hit the URL given above. SharePoint Tutorial – List: ——————————————————————————————————————————– Adding Documents to a SharePoint Site Create a new SharePoint Site Collection Administrator Add Links to a SharePoint List Add SharePoint Site to your Trusted Sites in Internet Explorer Add Users to a SharePoint Security Group
Continue reading →NEWS: Apple overtakes Hewlett-Packard to become No 1 PC maker: Canalys
Title says everything …. you can check more here: http://economictimes.indiatimes.com/tech/hardware/apple-overtakes-hewlett-packard-to-become-no-1-pc-maker-canalys/articleshow/11696305.cms Thanks, Khilit
Continue reading →SQL Server 2012 Virtual Launch Event & Sweepstakes too :)
Microsoft is going to host the SQL Server 2012 Virtual Launch Event (VLE) On March 7, 2012, in order to share the latest on SQL Server 2012 and the evolution of the Microsoft data platform. Check out the SQL Server Team Blog for more details: http://blogs.technet.com/b/dataplatforminsider/archive/2012/01/26/join-us-march-7-2012-for-the-virtual-launch-of-sql-server-2012.aspx To participate in VLE, you can register here: http://www.sqlserverlaunch.com/ww/Register Find more details of this event here: http://www.sqlserverlaunch.com/ww/Home Find out the full list of agenda on this event: http://www.sqlserverlaunch.com/ww/agenda Breakthrough Insights:
Continue reading →