Microsoft SQL Server 2008 R2 Launch Event Istanbul

Thomas Kejser in Session CEP with StreamInsight

eralper — Wed, 19 May 2010 14:47:01 GMT

Thomas Kejser in Session CEP with StreamInsight

Thomas Kejser during his session CEP with StreamInsight on Microsoft SQL Server 2008 R2

Mustafa Acungil Talking About Utilty Control Point UCP on SQL Server 2008 R2

eralper — Wed, 19 May 2010 14:44:32 GMT

Mustafa Acungil Talking About Utilty Control Point UCP on SQL Server 2008 R2

Mustafa Acungil is talking about Utilty Control Point (UCP) what is new with SQL Server 2008 R2 release for managing multiple SQL Server instances from one SQL Server.

Sedat Yogurcuoglu in Session SQL Server 2008 R2 Parallel Data Warehouse

eralper — Wed, 19 May 2010 14:41:12 GMT

Sedat Yogurcuoglu in Session SQL Server 2008 R2 Parallel Data Warehouse

Sedat Yoğurtçuoğlu during his session on SQL Server 2008 R2 Parallel Data Warehouse

Onder Yildirim in Session SQL Server Master Data Management

eralper — Wed, 19 May 2010 14:37:59 GMT

Onder Yildirim in Session SQL Server Master Data Management

Önder Yıldırım is in session on MS SQL Server 2008 R2 Master Data Management and Master Data Services (MDS)

Scenarios for Event Processing and CEP Target Scenarios

eralper — Wed, 19 May 2010 14:31:17 GMT

Scenarios for Event Processing and CEP Target Scenarios

Scenarios for Event Processing and CEP Target Scenarios

CEP stands for Complex Event Processing and deals with analysis of high number of events occuring simultaneously and continuously.

Microsoft targets CEP scenarios like Stock Markets, Web Analytics, Logistics, Sensor applications from Manufacturing sites, etc. with SQL Server 2008 R2 StreamInsight, CEP solution of Microsoft.

Potential Performance Bottlenecks in SQL Server 2008

eralper — Wed, 19 May 2010 14:26:11 GMT

Potential Performance Bottlenecks in SQL Server 2008

Potential Performance Bottlenecks in SQL Server 2008 can be seen in the below architecture

Generally the I/O devices is the bottleneck in many situations causing the performance problems on your SQL Server database instances.

In order to give customers cheaper hardware configurations and software configuration settings with better performance, Microsoft has SQL Server Fast Track to offer their customers.

SQL Server Fast Track solutions are tried and validated hardware configurations capable of giving pre-measured results for especially SQL Server Data Warehouse solutions.

With the release of MS SQL Server 2008 R2, Microsoft is preparing a new edition for their customers to have to best performance in their data warehouse applications.
This new SQL Server 2008 R2 Edition is Microsoft SQL Server 2008 R2 Parallel Data Warehouse.

Create Relationship Between Two Excel 2010 Sheets using Powerpivot

eralper — Wed, 19 May 2010 14:17:02 GMT

Create Relationship Between Two Excel 2010 Sheets using Powerpivot

How to Extract Data-tier Application using SSMS Utility Control Point

eralper — Wed, 19 May 2010 14:14:56 GMT

How to Extract Data-tier Application using SSMS Utility Control Point

SSMS Utility Configuration Steps

eralper — Wed, 19 May 2010 14:12:54 GMT

SSMS Utility Configuration Steps

Microsoft SQL Server Management Studio Utility Configuration Steps

Utility Explorer and Utility Control Point (UCP) are new tools with MS SQL Server 2008 R2 which enables SQL Server database administrators easily manage many instances of SQL Server from one control point which is basically a SQL Server 2008 R2 instance dashboard.

CEP Query Features in SQL Server 2008 R2 StreamInsight

eralper — Wed, 19 May 2010 14:08:49 GMT

CEP Query Features in SQL Server 2008 R2 StreamInsight

CEP Query Features in SQL Server 2008 R2 StreamInsight

CEP stands for Complex Event Processing and managed by StreamInsight in Microsft SQL Server 2008 R2

What is CEP - Complex Event Processing

eralper — Wed, 19 May 2010 14:04:28 GMT

What is CEP - Complex Event Processing

What is CEP - Complex Event Processing

Complex Event Processing (CEP) is the continuous and incremental processing of event streams from multiple sources based on declarative query and pattern specifications with near-zero latency.

CEP or Complex Event Processing is now a topic of Microsoft SQL Server 2008 R2 with the new StreamInsight feature.

SQL Server 2008 R2 Reporting Services Shared Datasets

eralper — Wed, 19 May 2010 13:40:49 GMT

SQL Server 2008 R2 Reporting Services Shared Datasets

SQL Server 2008 R2 Reporting Services Shared Datasets

You know it was possible to share data sources in SQL Server before SQL Server 2008 R2.
Now with Microsoft SQL Server 2008 R2 Reporting Services release, report developer can create shared datasets which enables developers to use these shared datasets in other Reporting Services reports later.

Using shared datasets will gain time and decrease the time required to create a new report.

Also power users who are foreign to database concepts can easily consume these datasets previously prepared and published for common use.

SQL Server 2008 R2 Reporting Services Report Part Gallery

eralper — Wed, 19 May 2010 13:35:22 GMT

SQL Server 2008 R2 Reporting Services Report Part Gallery

Report Part Gallery is a new enhancement in Reporting Services of Microsoft SQL Server 2008 R2 release.

SQL Server 2008 R2 Reporting Services has the ability of distinguishing parts and regions of Reporting Services reports and publishing these data and items regions for reuse of developers in other Reporting Services reports

These reusable report parts are published to Report Part Gallery and can be consumed within Report Builder 3.0 and Visual Studio Report Designer tools

Reporting Services Export Formats new with SQL Server 2008 R2

eralper — Wed, 19 May 2010 13:29:05 GMT

Reporting Services Export Formats new with SQL Server 2008 R2

Reporting Services Export Formats with new Microsoft SQL Server 2008 R2 enhancements:

XML
SQL Report Builder
HTML
Microsoft Word
Microsoft Excel
CSV
TIF
Acrobat PDF
ATOM

SQL Server 2008 R2 Reporting Services Visual Controls Gallery

eralper — Wed, 19 May 2010 13:22:29 GMT

SQL Server 2008 R2 Reporting Services Visual Controls Gallery

SQL Server 2008 R2 Reporting Services Visual Controls Gallery

With the release of SQL Server 2008 R2, BI developers have an enriched Reporting Services controls gallery with new controls like;
Sparklines
Data Bars
Indicators
Maps
and other controls like Gauges, Charts, etc.

SQL Reporting Services 2008 Maps Controls

eralper — Wed, 19 May 2010 13:18:26 GMT

SQL Reporting Services 2008 Maps Controls

MS SQL Server 2008 R2 Reporting Services Maps Controls add the maps as virtual reports into your Business Intelligence solutions.

SQL Server Reporting Services Maps controls on top of SQL Server 2008 Spatial features, adds the power of :
the sql spatial support
Virtual Earth and Bing Maps entegration
Entegration with own maps
And adding layers on top of maps features

SQL Server Reporting Services Indicators

eralper — Wed, 19 May 2010 13:13:04 GMT

SQL Server Reporting Services Indicators

SQL Server Reporting Services Indicators

Indicator control new with SQL Server Reporting Services.
Indicators are visual signs that shows the status of values and makes it easy to see the overall satus of a report for a user.

The SQL Server 2008 Reporting Services indicators are a group of indicators changing in shapes and icons that enables developers to choose the most suitable among them and use in their reports.

Report Design Tools with SQL Server 2008 R2

eralper — Wed, 19 May 2010 13:07:32 GMT

Report Design Tools with SQL Server 2008 R2

Report Design Tools with SQL Server 2008 R2

Visual Studio Report Designer and Report Builder 3.0 are the report design tools for SQL Server BI developers released with Microsoft SQL Server 2008 R2

SQL Reporting Services Sparklines and Data Bars

eralper — Wed, 19 May 2010 13:04:23 GMT

SQL Reporting Services Sparklines and Data Bars

SQL Reporting Services Sparklines and Data Bars

Sparklines and Data Bars as well as Indicators are new in-cell graphical charts and graphical controls new with Microsoft SQL Server 2008 R2

Simplified Create Table DDL Command on SQL Server 2008 R2 Parallel Datawarehouse

eralper — Wed, 19 May 2010 12:04:17 GMT

Simplified Create Table DDL Command on SQL Server 2008 R2 Parallel Datawarehouse

Simplified Create Table DDL Command on SQL Server 2008 R2 Parallel Datawarehouse

Pay attention to Distribute On table option which enables table to be distributed on different SQL Server 2008 R2 nodes within the SQL Server 2008 R2 Parallel DataWarehouse edition