Welcome to TechNet Blogs Sign in | Join | Help

Browse by Tags

All Tags » SQL Server 2008   (RSS)
This white paper describes the technologies available in SQL Server 2008 that can be used as part of a high-availability strategy to protect critical data. As well as describing the technologies in detail, the white paper also discusses the various causes Read More...
Many companies are considering or have already implemented consolidation of computing resources, including Microsoft SQL Server instances and databases, in their organization. A consolidation effort is a complex task that requires information, a detailed Read More...
Keep your system up to date with the most recent cumulative update package for SQL Server 2008 RTM. This package contains all of the SQL Server 2008 hotfixes that have been released since the initial release of SQL Server 2008 RTM. o Understanding Incremental Read More...
Just got back from sunny Gold Coast, with what I can say was a very successful Teched, at least from my perspective and the many attendees I talked to. I think the biggest thing this year at Teched were the HP mini Netbooks. They were widely used by all Read More...
The following knowledge base article describes the known issues when you install Microsoft SQL Server on a computer that is running Windows 7 or Windows Server 2008 R2 . List of known issues when you install SQL Server on Windows 7 or on Windows Server Read More...
This white paper complements the existing documentation on planning, implementation, and administration of a SQL Server 2008 failover cluster, which can be found in Microsoft SQL Server 2008 Books Online. There are links to relevant existing content throughout Read More...
Want some FREE training on the new developer features of SQL Server 2008? Download this developer training kit from - http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=e9c68e1b-1e0e-4299-b498-6ab3ca72a6d7 . This kit contains Read More...
A best practices whitepaper was recently released discussing the SQL Server 2008 Management Data Warehouse feature.   It can be accessed at: http://msdn.microsoft.com/en-us/library/dd939169.aspx Read More...
I was just conducting research for improvements in security in SQL Server 2008 and came across the below whitepapers which are great references if you are looking at improving security of your SQL Server environment.   Engine Separation of Duties Read More...
A new white paper on SQL Server 2008 performance troubleshooting is now available and linked from our Technical Articles node in the MSDN Library. This paper is about 100 pages and covers the following in depth: CPU Bottlenecks Memory Bottlenecks I/O Read More...
Service Pack 1 for SQL Server 2008 will be available today for customers. The Service pack is available via download at: http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=66ab3dbb-bf3e-4f46-9559-ccc6a4f9dc19     Version Read More...
Keep your system up to date with the most recent cumulative update package for SQL Server 2008 RTM. This package contains all of the SQL Server 2008 hotfixes that have been released since the initial release of SQL Server 2008. CU#4 KB Article: http://support.microsoft.com/kb/963036/en-us Read More...
When using Filestream data in SQL Server 2008, you may come across what seems like strange behaviour. This is when you issue a DELETE statement to delete the filestream data, it doesnt actually disappear from the file system. You may ask…why is this? Read More...
SQL Server 2008 System Views - Map just went live and is available for download at http://www.microsoft.com/downloads/details.aspx?FamilyID=531c53e7-8a2a-4375-8f2f-5d799aa67b5c&displaylang=en There is a 2005 version link in Related Downloads at the Read More...
Following are some tit bits about TDE in SQL Server 2008: Instant file initialization is disabled for all encrypted databases so page headers are in a known state and the file does not include stray bits off the disk Tempdb is encrypted if there are any Read More...
More Posts Next page »
 
Page view tracker