All things Data Related....

On this site I will be posting entries related to Data platform and analytics that I learn and believe could be valuable learning to others who want insight from their data

Browse by Tags

Related Posts
  • Blog Post: SQL Server 2008 Security Related Whitepapers

    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 for the Application Developer http://msdn.microsoft...
  • Blog Post: SQL Server Standard vs. Enterprise Edition

    A question I often get asked by customers is which edition of SQL Server do I use? I then based on the workload, high availability/disaster recovery, scalability, BI and other requirements do walk the customer down to the decision. You can also work through this using the edition comparison tool on the...
  • Blog Post: SQL Server 2008 R2 Best Practices Analyser

    Yes the SQL Server best practices analyser is back and it can be used to analyse your SQL Server 2008 or 2008 R2 instances. The Microsoft SQL Server 2008 R2 BPA is a diagnostic tool that performs the following functions: Gathers information about a Server and a Microsoft SQL Server 2008 or 2008 R2 instance...
  • Blog Post: SQL Server 2008 SP1 Released

    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 of SQL Server: 10.00.2531 It is primarily a roll...
  • Blog Post: Whitepaper: High Availability with SQL Server 2008

    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 of downtime and data loss, and how to evaluate...
  • Blog Post: Upgrading to SQL Server 2008 – Technical Reference Guide

    Technorati Tags: SQL Server 2008 , Upgrade , Technical Reference Guide A common request from customers is for information about upgrading from SQL Server 2000/2005 to SQL Server 2008. In conjunction with Solid Quality Mentors, Microsoft has published a great technical reference guide covering most upgrade...
  • Blog Post: Whitepaper: SQL Server High Availability Whitepaper by SQL CAT Team - Failure Is Not an Option: Zero Data Loss and High Availability

      When it comes to financial transactions of customers and their money, it is absolutely imperative that none of these transactions is ever lost due to an IT system failure (or any other type of failure). This white paper shows you how to create a Microsoft SQL Server infrastructure that enables...
  • Blog Post: SQL Server 2008: Filestream Data & Delete Statement

    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? This is essentially because of SQL Server transaction...
  • Blog Post: Database Development Guidance Paper published by the Application Lifecycle Management Rangers

      Recently, on codeplex the Application Lifecycle Management Rangers from Microsoft have made available guidance on database development practices when using Visual Studio 2010 database projects. This practical guidance is focused on the following topics: Solution and Project Management Source Code...
  • Blog Post: SQL Server 2008 SP2 Now Available

    Microsoft is pleased to announce the availability of SQL Server 2008 Service Pack 2. Both the Service Pack and Feature Pack updates are now ready for download on the Microsoft Download Center.  Service Pack 2 for SQL Server 2008 includes new compatibility features with SQL Server 2008 R2, product...
  • Blog Post: Finally Got around to something about 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 business cotinuity (through improvements in mirroring...
  • Blog Post: SQL Server 2008 Enterprise and DW Optimisations

    One of the key areas for the SQL Server 2008 release is to be a scalable Data Warehousing platform. Many organisations have deployed it – with DW ranging from 1TB well into the 60-80TB. So what makes SQL Server 2008 Enterprise a better choice than SQL Server 2005 is due to the star join and few-outer...
  • Blog Post: SQL Server 2008 Clustering White Paper

    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 the paper, which is intended primarily for...
  • Blog Post: SQL Server 2008: Upgrading to Standard/Enterprise Edition from Evaluation Edition

    I often get asked about upgrading SQL Server 2008 Evaluation Edition to a retail edition such as Standard or Enterprise Edition. This is very well documented at the below SQL Server books online link: How to: Upgrade to a Different Edition of SQL Server 2008 (Setup) http://msdn.microsoft.com/en-us/library...
  • Blog Post: SQL Server 2008 November CTP has released!!!

    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 now :)
  • Blog Post: Teched Australia 2009

    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 attendees, during sessions, breaks, just about...
  • Blog Post: SQL Server 2008 Roadmap Clarification & Heroes Unite {2008} Event Details

    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 the coming months, customers and partners can look...
  • Blog Post: More Goodies on SQL Server 2008

    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 Management Framework (DMF) Policies ...
  • Blog Post: Download - SQL Server 2008 System View Poster!!!

    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 above URL.
  • Blog Post: Running SQL Server 2008 on Windows 7 and Windows 2008 Server R2

    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 2008 R2 http://support.microsoft.com/default.aspx...
  • Blog Post: SQL Server 2008 – Transparent Database Encryption (TDE)

    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 encrypted user databases to avoid exposure of intermediate...
  • Blog Post: Migrate from MySQL/Access to SQL Azure or SQL Server with ease!

    Microsoft announced today the release of the first version of SQL Server Migration Assistant (SSMA) for MySQL! Along with this release, Microsoft refreshed the existing SSMA family of products for Oracle, Sybase and Access with the latest v4.2 release. SQL Server Migration Assistant for MySQL is the...
  • Blog Post: Cumulative Update #7 for SQL Server 2008 RTM

    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 Servicing Model for SQL Server o...
  • Blog Post: Say good bye to performance issues in SQL Server 2008 with the aid of this whitepaper…

    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 Bottlenecks Slow-Running Queries Extended Events Data...
  • Blog Post: Cumulative Update #4 for SQL Server 2008 RTM

    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 Understanding...