Browse by Tags
All Tags »
sql server (RSS)
While I was scrolling through the logins for a permission task, I found the login name such as ##MS_PolicyEventProcessingLogin## & ##MS_PolicySigningCertificate##, I was bit confused and perplexed to see what it is for? As usual searching in Books
Read More...
A new website about SQL Server 2008 is released by Microsoft development team, SQL Server 2008 Experience web site. Read more from Data_Platform_Insider blog post.
Read More...
First one in the series of SQL Server 2008 version, here it comes Cumulative Update package 1! What kind of fixtures are available in this CU1 package? Cumulative Update 1 contains hotfixes for the Microsoft SQL Server 2008 issues that have been fixed
Read More...
In continuation to the SQL Server 2005 - adhoc script to perform backup, restore and integrity checks/optimization jobs without Database Maintenance plans? blog and scripts by Ola Hallengren, I presume they are very useful for the DBAs who are looking
Read More...
If you remember about editions of SQL Server from 2000 onwards you will see Enterprise, Standard, Personal & Desktop Edition (MSDE) and when it comes to 2005 version Enterprise, Standard, Workgroup, Express & Express Advanced Services. So what's
Read More...
How many tools (new and enhanced) are available within SQL Server 2008 when you have a need to monitor the performance of queries that are executing/generated? The initial ones you remember is PROFILER and PERFMON (SYSMON) tools, even further few will
Read More...
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...
Its over 2 weeks that SQL Server 2008 RTM is released and no doubt in stating that many DBAs might have performed downloads from their MSDN/Technet subscription to install within their environment. Remember feature pack download for SQL Server 2005 couple
Read More...
In continuation to SQL Server 2008 installation when Visual Studio 2008 is/isn't present? post that you might be aware that one of the issues with the SQL Server installation was a dependency on Visual Studio 2008 SP1. Though it is not a complete show
Read More...
In continuation to the SQL2008-InstallationVows on Windows Server 2008 there was a brief notes on pre-requisite of Visual Studio 2008 Service Pack when you are trying to install the SQL setup. The release notes were bit confusing that you have got with
Read More...
After I knew about the SQL 2008 RTM release news I have blogged SQL2008RTM-official here and as usual I have attempted to download the setup media from Technet which took a while (3 hours) to download the file, due to the obvious reasons of MSDN/TEchnet
Read More...
Ok, SQL Server 2008 is RTM'd now and its time to change the section of this blog section as 'SQL Server 2008' without any tags! SQL Server 2008 - RC0/CTP (SSQA.net) to SQL Server 2008 (SSQA.net) Yes it is.
Read More...
Microsoft press announces that SQL Server 2008 is available for users and as per PressRelease : . ..announced the release to manufacturing of Microsoft SQL Server 2008, the new version of the company’s acclaimed data management and business intelligence
Read More...
When it comes to the data encryption within SQL Server 2008 you would think about Transparent data encryption (TDE) which is a new encryption feature. It sounds good that this is a high level security feature you can deploy to secure the data, and a catch
Read More...
Until SQL Server 2000 the sample databases or files are installed along with binaries & program files, since version 2005 this has been changed and they are available from Microsoft download site and SQL Server Reporting Services (SSRS) has no exclusion.
Read More...