There's Something about SQL!

...SQL Server, BI and other Cool Technology... var sc_project=1839145; var sc_invisible=1; var sc_partition=17; var sc_security="180bc290";

Browse by Tags

Related Posts
  • Blog Post: Old MPS Reports Dismissed - New Version Ready!

    A new version of MPS Reports has been released late April, at the following link: Microsoft Product Support Reports http://www.microsoft.com/downloads/details.aspx?FamilyId=CEBF3C7C-7CA5-408F-88B7-F9C79B7306C0&displaylang=en Amongst the main differences: With the new MPS reports...
  • Blog Post: SQL Server 2008 Upgrade Technical Reference Guide

    The SQL Server 2008 Upgrade Technical Reference Guide is now Live and available to download. It is a 490-page white paper (hold on, do not get scared, you don't need to read it all :-)) which covers the essential phases and steps to upgrade existing instances of SQL Server 2000 and 2005 to SQL...
  • Blog Post: Reading User Group Meeting - 20th Nov

    For those which live or work close to Reading - there will be a UserGroup on the 20th Evening held in TVP - Microsoft Offices. Agenda: 6pm – 6:30 Registration and networking + Tea/Coffee with biscuits. Meet and greet. 6:30pm – 7 Round Table discussion - ALL Take stock and...
  • Blog Post: TechEd ItPro - SQL Server 2008 Resource Governor!

    Wow! Presenting at TechEd yesterday had been one of the best experiences of my life! Being in front of different customers, which work with SQL Server every day, and being able to share my experience on the field with the new great features included with SQL 2008 had been fantastic, and a great...
  • Blog Post: How to: Troubleshoot SQL Server 2008 Features

    This is a nice section in 2008 Books On Line which I just found and wanted to blog about - mainly for my reference so that I can quickly find it when needed ;-) I've found it whilst looking for recommendations to troubleshoot Resource Governor, but there are actually many other troubleshooting...
  • Blog Post: Try SQL 2008 online!

    http://www.sqlserverbeta.com/ allows today to get access to a FREE Microsoft SQL Server 2008 account . A great chance to play with real-world technology before it hits the mainstream - test it with your real-world data, with your own custom scenarios, while it's still under development. This is...
  • Blog Post: Whitepaper - Disk Partition Alignment Best Practices for SQL Server

    I've blogged some time ago about Microsoft recommendations for maximizing the performances of your disks subsystem for a SQL Server implementation : SQL Server - Speed up your Disks! http://blogs.technet.com/beatrice/archive/2008/06/09/sql-server-speed-up-your-disks.aspx Collection of...
  • Blog Post: Resource Governor Demos

    If you are looking for some demos to play and learn about Resource Governor, you should have a look to the SQL Server SQLOS team blog , which has posted a couple of interesting ones. 1) Anatomy of SQL Server 2008 Resource Governor CPU Demo http://blogs.technet.com/sqlos/archive/2007/12/14/part...
  • Blog Post: SQL Server 2005 SP3 is out!

    Service Pack 3 for Microsoft SQL Server 2005 (build number 9.00.4035 ) is now available and ready to download at http://www.microsoft.com/downloads/details.aspx?FamilyID=ae7387c3-348c-4faa-8ae5-949fdfbe59c4&displaylang=en . A complete List of the bugs that are fixed in SQL Server 2005 Service...
  • Blog Post: SQL Server 2008, Cumulative Updates and... Slipstream

    I've posted some time ago about Slipstream of Service Packs on SQL Server 2005 - which was and is still not available - so basically with 2005 it is not possible to have the Update/SP and the RTM included together in a single package. This was a feature which most administrators were looking forward...
  • Blog Post: SQL Server and Virtualization - can we help?

    Just discovered whilst at TechEd that Microsoft policies for SQL Server products that are running in a hardware virtualization environment are not much known as yet to the majority of the public. Therefore the PFE in me :-) wants to be sure that when you opt for virtualization you are in a safe...
  • Blog Post: Data and Backup Compression in SQL 2008 (Part 2)

    After my follow-up post about our SQL Server 2008 event in TVP , where I've presented about SQL Server 2008 Data and Backup compression (well, actually, I did made another last minute presentation on behalf of a friend on SQL 2008 Upgrade :-)), I've been asked to post my slide deck on SQL Server 2008...
  • Blog Post: SQL Server 2008: RTM slips to Q3

    The RTM date of SQL Server 2008 has slipped out to Q3 of this year. See this official blog post at The Data Platform Insider . Extract: "Over the coming months, customers and partners can look forward to significant product milestones for SQL Server. Microsoft is excited to deliver a feature...
  • Blog Post: SQL 2008 Readiness

    On the Microsoft website you can now find e-learning resources, webcasts and virtual labs to learn for free about the new features in SQL Server 2008. Don't miss this great free chance to learn about it! Links: E-learning Collection 6187: What's New in Microsoft SQL Server 2008 https...
  • Blog Post: Troubleshooting Performance Problems in SQL Server 2008

    A new great whitepaper to bookmark amongst your favourites: Troubleshooting Performance Problems in SQL Server 2008 http://msdn.microsoft.com/en-us/library/dd672789.aspx This documentation provides step-by-step guidelines for diagnosing and troubleshooting common performance problems by...
  • Blog Post: SQL Server Support, Failover Clustering and Virtualization

    On May 19th, Microsoft has updated the Support Policy for Microsoft SQL Server products that are running in a hardware virtualization environment , which you can find at the following link: http://support.microsoft.com/kb/956893/en-us The main update is related to guest failover clustering , therefore...
  • Blog Post: SQL 2008 OpsDay - Data and Backup Compression

    Hi all, Just wanted to thank all the attendees that participated to yesterday's event on SQL Server 2008 in TVP - Reading. We've received great feedback on the content of the day, and I really hope everybody went back home (for some of you I heard it was quite a long way) sure that SQL Server...
  • Blog Post: Resource Governor - How to get started?

    Here we are, as promised, with some rumblings on SQL Server 2008 Resource Governor . I've played a lot with the various options which this features provides, especially in preparation of my TechEd presentation last week! Did I ever mention how much I loved it :-)? Yeah, I guess too much already...
  • Blog Post: Download SQL Server 2008 SP1

    SQL Server 2008 SP1 final version has been released. It contains all the announced great new features that we were all looking forward to, especially the slipstream and uninstall ones, which could save a lot of time (and headhackes) at installation time. So just to recap, new features are...
  • Blog Post: Save the Date - SQLBits Cubed - 13th Sept!

    SQL Bits III registration is now open! As usual, registration is FREE but places are LIMITED ... So book yourself in as soon as you can and vote to choose between over 60 sessions! I have submitted the following titles: SQL Server 2008 Data & Backup Compression SQL Server 2008...
  • Blog Post: Data & Backup Compression (Part 3) - Tests, Numbers and Tuning Tips

    One of the most common question I've received regarding data and backup compression in SQL Server 2008 is related to achievable results in terms of performance and compressio-ratio on very large databases. I've just found some interesting data published by Unisys which you can review at: Microsoft...
  • Blog Post: FREE e-book: Introducing Microsoft SQL Server 2008

    A great opportunity to download (for FREE :-)) Introducing Microsoft SQL Server 2008 by Peter DeBetta, Greg Low, and Mark Whitehorn Learn about major new features in SQL Server 2008 including security, administration, and performance. Chapter 1: Security and Administration Chapter...
  • Blog Post: HEROES happen {here}

    Save the date: 19th March 2008 Location: Birmingham 4 tracks to experience the ground-breaking new products from Microsoft: Windows Server 2008, Visual Studio 2008 and SQL Server 2008. There will be breakout sessions, hands-on labs ready for you to work directly with the products, an Expo...
  • Blog Post: I'm at TechEd ItPro - Barcelona!

    This week I'm presenting on SQL Server 2008 Resource Governor @TechEd Barcelona http://www.microsoft.com/emea/teched2008/itpro ! My session is on Tuesday, 10:45 - 12:00 , make sure to come along if you want to learn about this cool new feature in SQL Server 2008 or if you simply have some questions...
  • Blog Post: SQL Server 2008 Service Pack 1 (SP1) CTP

    Just woke up ready to celebrate my birthday (do not try to ask a woman how old she is :-P) and discovered the CTP version of SQL Server 2008 Service Pack 1 (SP1) is now available. Hum, well, I will check it out but definitely not today I am afraid as I have other plans in mind... :-)! With this release...