May 2008 - Posts
Ok, replication concepts and technology has been continuing since the olden days (version 70) within SQL Server journey. To talk about new features within SQLServer 2008 comapring to the previous versions, FILESTREAM where much of data is created every
Read More...
In most of the newsgroups and forums I have seen asking how to store/manage the image/video/documents/files within the SQL Server database. SQL Server 2008 version has addressed this issue by enabling the FILE STREAM feature that will integrate the data
Read More...
I have had annoying moment when I'm trying to restore the sample database AdventureWorks on the test database server that consists SQL Server 2008 CTP6 and previous to this I have tried bits and pieces on FILESTREAM, but it seems CTP6 has changed it all
Read More...
I have submitted the feedback: "Specify SQL Server services restart message when TEMPDB system database is moved to new path" on Microsoft Connect site to get a correct execution message, for instance when you perform the TEMPDB data & log file movement.
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...
Scalability is an important aspect in every application, a common achievement within OLTP environment and still applicable to OLAP (Anlaysis Services) environment. In any if the application or a cube or mining model may be unavailable for querying because
Read More...