After enabling TDE take a backup of the transaction log, as the current transactions in the transactions logs do not get encrypted immediately.

If you are looking at conducting a migration to SQL Server from some other platforms (as you should be :)) then you need to look at the newly released Migration Assistant tools: Sybase New! Download SSMA 2005 for Sybase v4.0 - This release has many...

Download the attached "SQL Server 2008 ScreenSaver Setup.zip", it is highly recommended for all SQL DBA's.

The three tools that can help to detect and minimise the threat from SQL Injection attacks are: HP Scrawlr UrlScan version 3.0 Beta SQL Source Code Analysis Tool . For further information refer to the following security advisory note: ...

SQL Server 2008 Release Candidate 0 becomes available for customers starting June 10th. Although no new major features are introduced, Release Candidate 0 is an update to Community Technology Preview (CTP) 6 and includes several fixes. For the first time...

As much as possible, I do not recommend virtualisation of SQL Server or any other RDBMS system, due to the impact on performance, and the availability of other alternatives such as multiple-instances. However following is documentation from RC0 of SQL...

Today I just had a question from someone with regards to SQL Server Change Data Capture and database compatibility level. The questions was will CDC work with databases with compatibility level 80 or 90 on SQL Server 2008. And the answer is....... ...

REMIX08 registrations are now open for Sydney, 20 May and Melbourne, 22 May. REMIX08 will be packed with demos, Customer presentations and how-to’s for Web Developers and Designers, building next generation experiences through Silverlight . This year...

If you a heap (table without indexes) configured for page-level compression, pages receive page-level compression only in the following ways: Data is inserted by using the BULK INSERT syntax Data is inserted using INSERT INTO... WITH (TABLOCK...

Ever wondered whether filestream will be supported with replication? Well before I give the answer to that, let me just give you a brief background on FILESTREAM: Much of the data that is created every day is unstructured data, such as text documents...

The SQL Server Customer Advisory Team, Best Practices group just released four projects to CodePlex at https://www.codeplex.com/Release/ProjectReleases.aspx?ProjectName=SQLSrvAnalysisSrvcs&ReleaseId=11950 These projects are: · SQL Server...

The below was put together by a colleague at Microsoft - Olga Liakhovich, and this information can be useful to you folks out there who may be looking for ways to find out the version of Analysis Services you are running in your environment. Solutions...

Briefly, here are the new T-SQL programmability enhancements in SQL Server 2008: 1. Data Types a. New Date/time types (date, time, datetime2, datetimeoffset) b. New table types (i.e. CREATE TYPE myT AS table (a int, b varchar(100)) ) 2. SQL...

PerformancePoint server virtual labs on TECHNET Learn how to create dashboards end to end and use different data sources. Select the labs with PerformancePoint in the title. Link to more detail: http://www.microsoft.com/events/series/ technetoffice...

It has been a while since I have blogged something. This is because I have been involved with the Heroes Happen Here launch around Australia, well not really everywhere - at least Sydney and Perth - which is where I am writing this from. For more info...

In case you missed this. I just came to find out that we have recently released power tools for VSTS DB Edition 2008. http://www.microsoft.com/downloads/details.aspx?FamilyID=73ba5038-8e37-4c8e-812b-db14ede2c354&displaylang=en This release updates...

From - http://blogs.technet.com/dataplatforminsider/archive/2008/01/25/microsoft-sql-server-2008-roadmap-clarification.aspx "To continue in this spirit of open communication, we want to provide clarification on the roadmap for SQL Server 2008. Over...

Today the Fifth Cum ulative Update (CU) for SQL Server 2005 SP2 released. This CU is not released as a public download but can be requested through Microsoft Support or submit an online request form here . Following is the link to the KB article...

and.........this reason is the intelli sense capability over writing TSQL code, and yes it does work against your SQL Server 2005 database as well. So start using the SQL Server Management Studio from the November 2007 CTP of Katmai. As soon as you...

New Virtual Labs, Webcasts and Podcasts for SQL Server 2008 are available at the below link: http://www.microsoft.com/events/series/technetsqlserver2008.aspx?tab=overview Virtual Labs TechNet Virtual Lab: Administering Servers by Using Declarative...

Here is a direct link to the download on the Download Center. Yes, we have installers and media ISOs available. Along with x86, x64, and IA64 releases, we are also happy to present an Express version ! Start testing your application with SQL Server 2008...

I had a chance to attend a talk by Senior SQL Server PM about SQL Server 2008, and following were some of the key takeaways: The key tenants in SQL Server 2008 are: Trusted - provide mechanisms to secure data (such as database encryption), ensure...

The latest cumulative update for SQL Server 2005 post SP2 is: KB 939537 - Cumulative update package 3 for SQL Server 2005 Service Pack 2 - http://support.microsoft.com/kb/939537/en-us And for a regularly updated list of all the fixes for SQL Server...

Yesterday evening I attended the Sydney SQL Server SIG and at this meeting we had a special guest speaker from the USA - Mr Stephen Few. He presented about business intelligence from a data visualisation perspective. He talked about how BI solutions can...

While surfing the web (as you do) I came across the following new site (at least I never visited it before). It is: http://www.sqlcommunity.com Seems to have some good material on it, so the next time you are looking for something regarding SQL...