Small Defination of Big Data?
Big data is BIG NEWS in Industry today. Big data is nothing but characteristics of data then bigness of data. Big data really implies different analytics, different data structures and different diversity to the analytics.
And diversity of application was never exists before which is driven by different variety of applications. Currently applications are dealing with this kind of data and ready to present analytics with it. Read more…
User Account Control (UAC) and SSRS
In SQL Server 2008 R2 Reporting Services people are facing error as “User ‘DomainName\UserName’ does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed”. I have seen people struggling with this Issue. Here is more light on how to fix this & get your SQL Reporting Services Report Server URL working. Read more…
Table Attributes Dependencies in Store Procedures with SQL Server 2012
Couple of days back I got an opportunity to migrate the existing Sybase ASE database (Adaptive Server Enterprise/15.0.2) to my favorite MS SQL Server 2012, to find out the feasibility of migration activity in near future.
Our team consists of Project Manager, Database architect and few of the senior guys we all concluded to just migrate the database objects from Sybase to SQL Server 2012, and along with the migration we need to find out dead objects in the existing database which is being carried so far. Here the dead objects means such tables, columns and views which are no more in use. Read more…
BIDS No More Exist in SQL Server 2012.
Once you will installed SQL Server 2012 you could not find the BIDS to develop SSAS/SSIS/SSRS application. BIDS will replace with SSDT i.e. SQL Server Data Tools.
Comparison of SQL Server 2012 Vs SQL Server 2008 R2. Read more…
Convert Number Value Into Words using SSRS
For Display Amount Value into Words with SQL Reporting Services 2008, we can implement the same with following two ways.
· Database Function
· Custom Assembly Read more…
How to achieve Parallelism in SSIS
SQL Server Integration Services (SSIS) allows parallel execution in two different ways
1) MaxConcurrentExecutables : It defines how many tasks (executables) can run simultaneously. It defaults to -1 which is translated to the number of processors plus 2. Please note that if your box has hyperthreading turned on, it is the logical processor rather than the physically present processor that is counted. Read more…
Add Visual Studio 2010 HTML5 Intelligence.
How to Add Visual Studio 2010 HTML5 Intelligence.
It’s the time to use the new technologies like HTML 5. Everyone of us knew about what this is and how easy now to generate some nice and rich UI without put much effort. No complex javascript, no silverlight or flash is required most of the time and many more advantages. There are plenty of changes in CSS too. So, I believe we should start using HTML 5 in our applications. Because almost all browsers are supporting it. Read more…
Implement appFabric caching service to build faster ASP.NET Applications with Windows Azure
Speed up Web Applications using the new Windows Azure AppFabric Caching service. This article will cover concepts, scenarios, and features of the Caching service through a sample code and demonstrations.
In a world where speed and scale are the key success metrics of any solution, they can’t be afterthoughts or retrofitted to application architecture. The Windows Azure AppFabric Caching service provides the necessary building blocks to simplify these challenges without having to learn about deploying and managing another tier in your application architecture. In a nutshell, the Caching service is the elastic memory that your application needs for increasing its performance and throughput by offloading the pressure from the data tier and the distributed state so that your application is able to easily scale out the compute tier. Read more…
Congratulation to Suhas Kudekar for his MCC 2012 Award..!!
Guys,
Suhas Kudekar is going to be active contributor on bi-bigdata, recently his contributions to Microsoft online technical communities have been recognized with the Microsoft Community Contributor Award 2012. Read more…
VertiPaq Engine Renamed as xVelocity in SQL Server 2012(Denali).
VertiPaq engine is currently only available to PowerPivot for Excel in SQL Server 2008 R2. After the amazing success of PowerPivot for Excel in the previous release of SQL Server 2008 R2 this engine moved to the server side with the same InMemory BI and compression and it’s called the VertiPaq Engine or the Analysis Services Tabular Mode. Data retrieval and calculations happen at a much faster rate as its entire database is in-memory.Vertipaq enables Excel to process hundreds of millions of rows with sub-second response times on desktop hardware. Read more…
BI Big Data Authors
Sandip Shinde
Manish Kaushik
Suhas Kudekar(MCC)
Umesh M Patil
YashwantOur Visitors
Big Data, Data Analytics and Data Science | BI-BIGDATA.com 