Sql-Server

Rilasciato l’Update 2 del “SQL Server 2008 R2 Update for Developers Training Kit”, package dedicato a tutti coloro che usano SQL Server 2008 e vogliono fare un pò di training per usarlo al meglio:

http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=fffaad6a-0153-4d41-b289-a3ed1d637c0d 

Il contenuto è estramamente interessante:

• Presentations (15)
  • SQL Server 2008 R2 Update for Developers Overview Part I - SQL Server 2008 Review
  • SQL Server 2008 R2 Update for Developers Overview Part II - Introducing SQL Server 2008 R2
  • SQL Server 2008: Filestream
  • SQL Server 2008: Spatial
  • SQL Server 2008: T-SQL
  • SQL Server 2008: Date and Time Types
  • SQL Server 2008: SQLCLR
  • SQL Server 2008: Reporting Services
  • SQL Server 2008 R2: Introducing Application and Multi-Server Management with SQL Server 2008 R2 and Visual Studio 2010
  • SQL Server 2008 R2: Working with Data Tier Application Projects in Visual Studio 2010
  • SQL Server 2008 R2: Managing Change in Data Tier Application Projects with Visual Studio 2010 and SQL Server 2008 R2
  • SQL Server 2008 R2: Introducing SQL Server 2008 R2 StreamInsight
  • SQL Server 2008 R2: Querying Events in SQL Server 2008 R2 StreamInsight
  • SQL Server 2008 R2: Designing SQL Server 2008 R2 StreamInsight Event Models and Adapters
  • SQL Server 2008 R2: Installing, Deploying and Maintaining the SQL Server 2008 R2 StreamInsight Runtime Engine
• Demos (24)
  • SQL Server 2008: AdventureWorks Racing All-Up Demo
  • SQL Server 2008: Spatial Demo
  • SQL Server 2008: Spatial Types
  • SQL Server 2008: Introduction to Filestream
  • SQL Server 2008: SQL CLR Nullable Types
  • SQL Server 2008: Programming with Filestream
  • SQL Server 2008: Reporting Services Web Application Integration
  • SQL Server 2008: T-SQL Date and Time Support
  • SQL Server 2008: T-SQL Table-Valued Parameters
  • SQL Server 2008: T-SQL Row Constructors
  • SQL Server 2008: T-SQL Grouping Sets
  • SQL Server 2008: T-SQL Merge
  • SQL Server 2008 R2: Creating a Utility Control Point
  • SQL Server 2008 R2: Enrolling a Managed Instance
  • SQL Server 2008 R2: Creating Data-Tier Applications
  • SQL Server 2008 R2: Data-Tier Application Deployment
  • SQL Server 2008 R2: Managing Change in Data Tier Application Projects in Visual Studio 2010
  • SQL Server 2008 R2: Introducing SQL Server 2008 R2 StreamInsight
  • SQL Server 2008 R2: Querying Events in SQL Server 2008 R2 StreamInsight
  • SQL Server 2008 R2: Advanced SQL Server 2008 R2 StreamInsight Event Queries
  • SQL Server 2008 R2: Working with SQL Server 2008 R2 StreamInsight CTI Events and Advance Time Settings
  • SQL Server 2008 R2: Creating a SQL Server 2008 R2 StreamInsight Input Adpater
  • SQL Server 2008 R2: Choosing a SQL Server 2008 R2 StreamInsight Development Model
  • SQL Server 2008 R2: Using the SQL Server 2008 R2 StreamInsight Event Flow Debugger
• Hands-on Labs (13)
  • SQL Server 2008: How to build your first Web Application with SQL Server and ASP.NET
  • SQL Server 2008: Using Spatial Data in TSQL
  • SQL Server 2008: Using Spatial Data in Managed Code
  • SQL Server 2008: Using SQL CLR in SQL Server 2008
  • SQL Server 2008 R2: Introduction to PowerPivot
  • SQL Server 2008 R2: Introduction to Reporting Services Improvements
  • SQL Server 2008 R2: Introduction to StreamInsight and Complex Event Processing
  • SQL Server 2008 R2: Introduction to Data-tier Applications
  • SQL Server 2008 R2: Creating and Deploying a Data-Tier Application
  • SQL Server 2008 R2: Managing Change in Data-Tier Application Projects in Visual Studio 2010
  • SQL Server 2008 R2: Querying Events in SQL Server 2008 R2 StreamInsight using LINQ
  • SQL Server 2008 R2: Working with the SQL Server 2008 R2 StreamInsight Samples
  • SQL Server 2008 R2: Working with the SQL Server 2008 R2 StreamInsight Event Flow Debugger
• Videos (35)
  • SQL Server 2008 R2 Update for Developers Overview Part I - SQL Server 2008 Review
  • SQL Server 2008 R2 Update for Developers Overview Part II - Introducing SQL Server 2008 R2
  • Introducing SQL Server 2008 R2 StreamInsight
  • Demo: Real Time Analytics with SQL Server 2008 R2 StreamInsight
  • Introducing SQL Server 2008 R2 Application and Multi-Server Management
  • Introducing SQL Server 2008 R2 Reporting Services
  • Introduction To SQL Server 2008 R2 StreamInsight and Complex Event Processing
  • Introducing PowerPivot for Excel 2010 and SharePoint 2010
  • Presentation: Introducing Application and Multi-Server Management with SQL Server 2008 R2 and Visual Studio 2010
  • Demo: Creating a Utility Control Point
  • Demo: Enrolling a Managed Instance
  • Presentation: Working with Data Tier Application Projects in Visual Studio 2010
  • Demo: Creating Data-Tier Applications
  • Demo: Data-Tier Application Deployment
  • Presentation: Managing Change in Data Tier Application Projects with Visual Studio 2010 and SQL Server 2008 R2 (Part I)
  • Presentation: Managing Change in Data Tier Application Projects with Visual Studio 2010 and SQL Server 2008 R2 (Part II)
  • Demo: Managing Change in Data Tier Application Projects in Visual Studio 2010
  • Presentation: Introducing SQL Server 2008 R2 StreamInsight (Part I)
  • Presentation: Introducing SQL Server 2008 R2 StreamInsight (Part II)
  • Demo: Introducing SQL Server 2008 R2 StreamInsight
  • Presentation: Querying Events in SQL Server 2008 R2 StreamInsight (Part I)
  • Presentation: Querying Events in SQL Server 2008 R2 StreamInsight (Part II)
  • Demo: Querying SQL Server 2008 R2 StreamInsight Using LINQ
  • Presentation: Querying Events in SQL Server 2008 R2 StreamInsight (Part III)
  • Demo: Advanced SQL Server 2008 R2 StreamInsight Event Queries
  • Presentation: Designing SQL Server 2008 R2 StreamInsight Event Models and Adapters (Part I)
  • Presentation: Designing SQL Server 2008 R2 StreamInsight Event Models and Adapters (Part II)
  • Demo: Working with SQL Server 2008 R2 StreamInsight CTI Events and Advance Time Settings
  • Presentation: Designing SQL Server 2008 R2 StreamInsight Event Models and Adapters (Part III)
  • Demo: Creating a SQL Server 2008 R2 StreamInsight Input Adapter
  • Presentation: Installing, Deploying and Maintaining the SQL Server 2008 R2 StreamInsight Runtime Engine (Part I)
  • Presentation: Installing, Deploying and Maintaining the SQL Server 2008 R2 StreamInsight Runtime Engine (Part II)
  • Demo: Choosing a SQL Server 2008 R2 StreamInsight Development Model
  • Presentation: Installing, Deploying and Maintaining the SQL Server 2008 R2 StreamInsight Runtime Engine (Part III)
  • Demo: Using the SQL Server 2008 R2 StreamInsight Event Flow Debugger

SQL Server 2008 introduce il supporto al comando MERGE. Questo comando permette di specificare una tabella sorgente (source) ed una tabella destinazione (target o destination), modificando il contenuto della tabella destinazione con i dati della tabella sorgente.

Potranno essere eseguite operazioni DML multiple (INSERT/UPDATE/DELETE) in funzione delle condizioni logiche specificate nelle clausole del comando. SQL Server implementa tutte le caratteristiche del comando MERGE standard ANSI e aggiunge alcune importanti estensioni disponibili solo nel linguaggio T-SQL.

Rilasciato il Cumulative Update 10 per SQL Server 2008 RTM.

http://support.microsoft.com/kb/979064/en-us

Dopo l’installazione della Cumulative Update, la versione di SQL Server 2008 sarà la 10.00.1835.00.

Microsoft ha rilasciato il Cumulative Update 7 per SQL Server 2008 SP1, il cui numero di build è 2766.

http://support.microsoft.com/kb/979065/en-us

Rilasciato il Cumulative Update 8 per SQL Server 2005 SP3:

http://support.microsoft.com/kb/978915

Dopo l’installazione della Cumulative Update, la versione di SQL Server 2005 sarà la9.00.4285.

Non è prevista alcuna release della relativa Cumulative Update per SQL Server 2005 SP2, in quanto la versione SP2 il supporto alla stessa è terminato a Gennaio 2010.

Ultimo aggiornamento - Aprile 2009 - del Feature Pack di SQL Server 2008:

http://www.microsoft.com/downloads/details.aspx?familyid=B33D2C78-1059-4CE2-B80D-2343C099BCB4&displaylang=en

Questi i download disponibile tramite il Feature Pack:

• Microsoft ADOMD.NET
• Microsoft Analysis Management Objects
• Microsoft SQL Server 2008 Analysis Services 10.0 OLE DB Provider
• Microsoft SQL Server 2005 Backward Compatibility Components
• Microsoft SQL Server 2008 Command Line Utilities
• SQL Server Compact 3.5 SP1
• Microsoft Connector 1.0 for SAP BI
• Microsoft SQL Server 2008 Data Mining Add-ins for Microsoft Office 2007
• Microsoft SQL Server 2008 Datamining Viewer Controls
• Microsoft SQL Server 2005 Driver for PHP
• Microsoft Core XML Services (MSXML) 6.0
• Microsoft SQL Server 2005 JDBC Driver 1.2
• Microsoft SQL Server 2008 Management Objects
• Microsoft OLEDB Provider for DB2
• SQL Server Remote Blob Store
• Microsoft SQL Server 2008 Native Client
• Microsoft SQL Server 2008 Policies
• Microsoft Windows PowerShell Extensions for SQL Server
• Microsoft SQL Server 2008 Replication Management Objects
• Microsoft SQL Server 2008 Report Builder 2.0
• Microsoft SQL Server 2008 Reporting Services Add-in for Microsoft SharePoint Technologies
• Microsoft SQL Service Broker External Activator
• Microsoft SQL Server System CLR Types
• Microsoft SQLXML 4.0 SP1
• Microsoft Sync Framework
• Microsoft SQL Server 2008 Upgrade Advisor

Nell’articolo Recursive CTE and Bill Of Materials problem abbiamo largamente parlato delle tecnologie che SQL Server mette a disposizione per ottenere l’esplosione scalare di una distinta materiali, ossia per risolvere il problema noto come “The Bill Of Materials problem”.

Successivamente, nell’articolo Recursive CTEs and Bill Of Materials problem (part two: cyclic references) , per la stessa distinta materiali, abbiamo illustrato una soluzione in grado d’individuare riferimenti ciclici (nei dati) con prestazioni ragionevoli. Per rilevare i riferimenti ciclici abbiamo utilizzato una CTE ricorsiva in cui viene calcolato dinamicamente il path di ogni elemento. Nella SELECT ricorsiva abbiamo utilizzato il predicato LIKE per verificare che l’ID del sotto insieme (elemento) che si sta elaborando non sia già contenuto nel path composto con i riferimenti univoci (IDs) dei sotto insiemi (elementi) a livello superiore.