Browse by Tags
All Tags »
new features (RSS)
You may be thinking installing SQL Server 2008 Express Edition is easy, yes it is when you have simple terms of usage. No issues for version 2005 though, just keep in mind about SQL Server 2008 installation when Visual Studio 2008 is/isn't present? issues
Read More...
SQL Server Reporting Services has been introduced in 2000 version but not catched within the user environment until the Reporting Services 2005 has been rolled out. In this regard administering a Reporting Services installation requires that you know
Read More...
I'm sure that by now you are aware about the list of new features within SQL Server 2008 and recently I have had couple of emails from newbie DBA/users in SQL Server asking about any reference they can get on these new features, with a video. In this
Read More...
It is 1 year (first anniversary) that SQL Server 2008 Community Technology Preview is released, I have seen many good things and few peeves about this new version of SQL Server. Not to mention about largest conference is lined up for the users aka ' Tech-ed
Read More...
I'm not going to shoot any questions to Microsoft about RTM release for SQL Server 2008, as it was made it clear from The Data Platform Insider blog post as: Extract: "Over the coming months, customers and partners can look forward to significant product
Read More...
Have you ever seen or used the PowerShell? If so have you worked on PowerShell within SQL Server 2008, it has 2 kinds of snap-ins that are called as Powershell Provider and set of Cmdlets. The provider will enables the simple navigation mechanism similar
Read More...
To make better use of features and enhancement within Windows Server 2008 release and SQL Server 2008, where the ability to connect the Management Studio (SSMS 2008) at the server rather than running it locally. Buck Woody SQL Program Manager has given
Read More...
Simple, short and crisp - I would like to say about TSQL enhancements within SQL Server 2008. You may already aware about what's new and how best you can take advantage within your code, most of the Developers would agree about IntelliSense functionality
Read More...
Geography & Geometry has much significance in day to day life, within that as a data now you can manage within your Database using SQL Server 2008 new data type - spatial, this represents information about the physical location and shape of geometric
Read More...
If there is any performance issue within your queries then looking at query execution plan is the first step towards assessing the loss, you may be aware that execution plans of queries and queries on partitioned tables and indexes can be examined by
Read More...
Continuing from this SQL2008CTP blog post it seems there is a confusion on the SQL 2008 CTP downloads page The technet link 851664 refers that Evaluate Microsoft SQL Server 2008 today page was p ublished: November 12, 2007 and further after registering
Read More...
In continuing from the series of Change-Data-Capture tags on this site I have been testing through this CDC feature on my test environment, which has proved fruitful results (to some extent). But the in the real world scenario do you really need to log
Read More...
SQL Server 2008 Community Technology Preview (CTP) instalment 5 is ready to available for the users, I think this is the 3rd instalment since SQL 2008 is announced by Microsoft. The Application support team have been asking for a list of new/enhanced
Read More...