E-Book Gallery for Microsoft Technologies
Hi guys, good morning !!! here is the list of cool FREE E-Books from Microsoft Press.
Continue reading →Category Archives: SQL Server 2012
Features Supported by the Editions of SQL Server 2012
Hi all, I ran into a nice article which has a 1 consolidated list of all the features of SQL Server 2012 Editions. You can check the details for your infrastructure and solution planning whether what you wanted/needed is supported in SQL Server 2012 or not. And if supported then which edition?
Continue reading →Behavior Changes to Analysis Services Features in SQL Server 2012
Hi all, I would like to draw your attention to the few modifications in SSAS behaviors in SQL 2012. The most important difference you will find is the “Cube Browser”. Yes, it’s totally changed. According to Microsoft “The cube browser control that let you drag and drop fields onto a PivotTable structure in Management Studio or in Cube Designer has been removed from the product. The control was an Office Web Control (OWC) component. OWC was deprecated by Office and is no longer available.”
Continue reading →SSRS Chart – Displaying % sign on Y axis + Displaying % sign on Data Labels
Hi guys, Today i would like to show you the little trick for your SSRS graphs. Issue: I am displaying values (percentage values) in my bar charts as “Data Labels”. But the “Y” axis of my bar char still displays value without the “%” sign. What I need: The bar chart should display the “%” value in Data Labels as well as on my Y axis. Simple try: When you format the Data Label to apply “%” sign by making it of type “Percentage” in “Series Label Properties” -> “Number” -> “Percentage”. It actually multiply the value by 100 and … Continue reading →
View is not showing newly added column in table
Hi all, This is for the people who still use “Select * From Table” in their SQL Views. I don’t know what is the reason that you are using this way to create your views, but you could be the victim of this scenario (see… what title says). Let me show you how you can solve this issue… in-case you come across one. When this happens?? You make changes in table which is the source of your view. Changes like modifying existing column definition, adding new columns or removing existing columns from table could cause this issue. Where can I … Continue reading →
Important Fact: Default Logging in SSIS which store log entries in SQL Server
Hi all, Few days back I have posted an article on “Default Logging in SSIS“. You can refer that here. In that article I have forgotten to mention a behavior of “enabling a default logging in SSIS package“. Let me show you what you need to know about this fact. Fact: When you enable a “Default Logging” with SQL Server in SSIS package, it does not create any table (i.e. dbo.sysssislog) or stored proc (i.e. dbo.sp_ssis_addlogentry) at the same time of setting-up in SSIS package. But when you run your package first time, these objects gets created automatically.
Continue reading →SQL Server 2012 Developer Training Kit
Hi All, I am so thrilled to see this content online for getting ourselves trained on SQL Server 2012. Find-out yourself about the contents of kit and downloads.
Continue reading →Singapore SQL User Group – Special Meet Up: “SQL Server for Private Cloud”
Hi Guys, Singapore SQL User Group is running a special meet up with Microsoft’s visiting speaker from U.S. Topic: SQL Server for Private Cloud Primary Focus: Many customers are deploying virtualized SQL Server in production environment. Join this session to find out about “SQL Server for Private Cloud“, a solution that is part of overall Microsoft Hybrid IT story. It will cover new features & functionalities of SQL Server 2012, System Center 2012, and Windows Server “8” that greatly enhance the capabilities of database applications running in Microsoft Private Cloud and the steps on putting this solution in your customer … Continue reading →