SQLJobVis

Risorse
Davide Mauri

Tool free per la visualizzazione dei Job di SQL Server che offre feature aggiuntive rispetto al tool nativo:

  • Failures
  • Long-running jobs
  • Multiple jobs running simultaneously
  • Zoomable rows and columns
  • Predefined filters and sorts
  • Tooltips for job runs, showing job name, start and end time, duration, etc.
  • Colour bars to indicate job-run clashes

http://www.sqlsoft.co.uk/sqljobvis.php

Pebble Reports

Risorse
Davide Mauri

Strumento per la creazione visuale di Report.

http://pebblereports.com/

Free, molto semplice da usare e con un ampio set di features:

- Tables, charts and crosstabs - Multiple sheets per report - Multiple data sources per report - Display table and chart side-by-side with same data - Conditional formatting without writing code - Full-featured graphical Query Builder; supports SQL Server and Oracle - Query builder supports editing join condition; supports building Where clause - Work directly on data (no “layout mode”) - Slice and dice data to discover trends - Drill down to see more detail - PDF, XLS and MHTML export - MHTML export compatible with Outlook and Microsoft Word - Email formatted reports as in-line HTML (as opposed to attachment) via Outlook or SMTP - On-report interactive sorting - Parameter prompting - Embed data in report, with ability to filter embedded data - Top N filter - Build complex filters with And/Or conditions - Apply style sheet - Expand All / Collapse All - Banded rows - Compact, stepped and block style display of row group headers - 16 different chart types - Charts consistent with Edward Tufte and Stephen Few principles - Performance and scalability that rivals some server-based reporting products - Calculated fields - Data displayed in controls (as opposed to paginated document) for quick browsing - Deploy report to Report Server directly - Save as RDL

Il più grosso sistema al mondo basato su SQL Server

Risorse
Gianluca Hotz

In questo articolo:

windowsteamblog.com/blogs/windowslive/archive/2009/12/22/a-peek-behind-the-scenes-at-hotmail.aspx

Arthur de Haan, responsabile dei Test e del System Engineering di Windows Live, fa una breve panoramica dell’architettura di Hotmail basata su SQL Server 2008.

Alcuni punti chiave:

  • We host well over 1.3 billion inboxes
  • Over 350 million people are actively using Hotmail on a monthly basis
  • We handle over 3 billion messages a day and filter out over 1 billion spam messages
  • We are growing storage at over 2 petabytes a month
  • We currently have over 155 petabytes of storage deployed (70% of storage is taken up with attachments, typically photos).