Wednesday, March 12, 2008

6th Annual Financial Services Developer Conference

I went to the 6th Annual Financial Services Developer Conference today in New York City. This year’s focus was on High Performance Computing (HPC). I must say that I have enjoyed this conference a lot. It seems that SQL Server is very prevalent on the street. The OLAP capabilities of SQL Server are making Sybase slowly disappear from Wall Street. Financial firms are doing some very interesting stuff; there is a hedge fund which records an earnings call, runs it through some voice stress analysis software and based on the outcome of that will short or long the stock. You should hear the stories of how financial firms handle IT, the innovation is happening in the financial markets. I also saw a couple of very cool WPF applications. Check out the demos from Lab49: http://www.lab49.com/insidethelab/demos
Visit http://www.financialdevelopers.com/ to download The Silverlight 2 Retail Financial Services Demonstrator

Financial Services Developer Conference

Carl Franklin from Dotnetrocks recorded a podcast at the event, this podcast was about concurrency and how to handle multi-core programming. You should definitely check it out when it becomes available on dotnetrocks. If you are interested about PLINQ and concurrent programming with .NET then visit this site: http://msdn2.microsoft.com/en-us/concurrency/default.aspx

Dotnetrocks Podcast Recording

Tomorrow there are three sessions at the same time that I want to attend
Software Engineering with VSTS
Parallelize you .Net applications with parallel extensions to the .NET framework.
Useful evolution: Programming the New features in SQL Server 2008.

I have my blackcrackberry with me so if you are attending the event tomorrow then send me an email at FirstName.LastName@dowjones.com and maybe we can discuss about this event during lunch.

Sunday, March 09, 2008

Links Of The Week 20080309

Here are the links for this week

Database
Podcast: SQL Down Under show 34 - Geoff Hiten - SQL Server Clustering and SANs
Feature synergy in SQL Server 2008
How It Works: SQLIOSim - Checksums
Change collation in tempdb
Query Optimization DMV du jour - sys.dm_exec_query_optimizer_info
Data Warehouse Scalability Features in SQL Server 2008
SQL Server 2008: Changes to enabling FILESTREAM from CTP-6 onwards
Appending Data Using SQL 2008 Filestream
SSDS is Microsoft's Amazon S3 competitor
Manageability Presentation from the SQL2K8 Launch

Non DB tech
Sun: We'll put Java on the iPhone (InfoWorld)
Filters for Google Reader
Hanselminutes Podcast 103 - Quetzal Bradley on Testing after Unit Tests and the Myth of Code Coverage
ASP.NET MVC Session at Mix08, TDD and MvcMockHelpers
Steve Souders asks: "How green is your web page?"
A Question of Programming Ethics
Why I Love Hackers
The Weekly Source Code 18 - Deep Zoom (Seadragon) Silverlight 2 MultiScaleImage Mouse Wheel Zooming and Panning Edition
Google Releases an API for Contacts

Mix08 Sessions
Adding Instant Messaging to Any Site
Keiji Kanazawa, Nikhil Kothari
http://msstudios.vo.llnwd.net/o21/mix08/08_WMVs/T03.wmv

Advanced Cross-Browser Layout with Internet Explorer 8
Scott Dickens
http://msstudios.vo.llnwd.net/o21/mix08/08_WMVs/CT07.wmv

Advanced Search Engine Optimization: Generating More Site Traffic from Search
Nathan Buggia
http://msstudios.vo.llnwd.net/o21/mix08/08_WMVs/BT03.wmv

Bringing Hosters and Developers Together with IIS7
Robert Cameron, Tito Leverette
http://msstudios.vo.llnwd.net/o21/mix08/08_WMVs/BT08.wmv

Building AOL's High Performance, Enterprise Wide Mail Application With Silverlight 2
Eric Hoffman, Marc Katchay, Stefan Gal
http://msstudios.vo.llnwd.net/o21/mix08/08_WMVs/BT01.wmv

Building Applications and Services with .NET Framework 3.5
Justin Smith
http://msstudios.vo.llnwd.net/o21/mix08/08_WMVs/T26.wmv

Building Great AJAX Applications from Scratch Using ASP.NET 3.5 and Visual Studio 2008
Brad Adams
http://msstudios.vo.llnwd.net/o21/mix08/08_WMVs/T34.wmv

Building Rich Internet Applications Using Microsoft Silverlight 2, Part 1
Joe Stegman, Mike Harsh
http://msstudios.vo.llnwd.net/o21/mix08/08_WMVs/CT01.wmv

Building Rich Internet Applications Using Microsoft Silverlight 2, Part 2
Joe Stegman, Mike Harsh
http://msstudios.vo.llnwd.net/o21/mix08/08_WMVs/CT02.wmv

Creating a RESTful API with Windows Communication Foundation
Haider Sabri, Paul Walker, Viphak Lay
http://msstudios.vo.llnwd.net/o21/mix08/08_WMVs/T01.wmv

Creating Better User Experiences: Design Methods
Dan Harrelson, Kim Lenox
http://msstudios.vo.llnwd.net/o21/mix08/08_WMVs/UX07.wmv

Creating Better User Experiences: Design Strategy
Dan Harrelson, Kim Lenox
http://msstudios.vo.llnwd.net/o21/mix08/08_WMVs/UX04.wmv

Creating Better User Experiences: Information Architecture
Dan Harrelson, Kim Lenox
http://msstudios.vo.llnwd.net/o21/mix08/08_WMVs/UX06.wmv

Creating Better User Experiences: Interaction Design
Dan Harrelson, Kim Lenox
http://msstudios.vo.llnwd.net/o21/mix08/08_WMVs/UX05.wmv

Creating Rich, Dynamic User Interfaces with Silverlight 2
Karen Corby
http://msstudios.vo.llnwd.net/o21/mix08/08_WMVs/T20.wmv

Design at Speed of Light
Cinthya Urasaki, Daniel Makoski, John Reid, Tim Wood, Zachary Jean Paradis
http://msstudios.vo.llnwd.net/o21/mix08/08_WMVs/PNL02.wmv

Developing Applications with Microsoft Virtual Earth
Chris Pendleton
http://msstudios.vo.llnwd.net/o21/mix08/08_WMVs/T17.wmv

Developing Applications Using the Model View Controller Pattern
Scott Hanselman
http://msstudios.vo.llnwd.net/o21/mix08/08_WMVs/T22.wmv

Developing Data Driven Applications Using ASP.NET Dynamic Data Controls
David Ebbo
http://msstudios.vo.llnwd.net/o21/mix08/08_WMVs/T24.wmv

Developing with Windows Live
Angus Logan
http://msstudios.vo.llnwd.net/o21/mix08/08_WMVs/T29.wmv

E-commerce Done Right
Gerard Johnson, Matthews Rechs, Nicholas Rockwell, Steve Nelson
http://msstudios.vo.llnwd.net/o21/mix08/08_WMVs/PNL12.wmv

Encoding Video for Microsoft Silverlight
Ben Waggoner
http://msstudios.vo.llnwd.net/o21/mix08/08_WMVs/BCT07.wmv

Everything You Need to Know about Diagnostics and Debugging on Microsoft Internet Information Services 7
Mai-lan Tomsen Bukovec
http://msstudios.vo.llnwd.net/o21/mix08/08_WMVs/T06.wmv

Exploring Moonlight: Novell's Implementation of Silverlight on Linux
Miguel de Icaza
http://msstudios.vo.llnwd.net/o21/mix08/08_WMVs/T31.wmv

From Flash to Silverlight: A Rosetta Stone
Rick Barazza
http://msstudios.vo.llnwd.net/o21/mix08/08_WMVs/T30.wmv

From Long Tail to Fuzzy Tale: Why "Fuzzy" Is the New Clear
David Armano
http://msstudios.vo.llnwd.net/o21/mix08/08_WMVs/UX02.wmv

Getting Clued In to Experience Management
Lou Carbone
http://msstudios.vo.llnwd.net/o21/mix08/08_WMVs/UX01.wmv

How Design Impacts the Bottom Line
Dave Blakely, David Watson, Jason Brush, Jimmy Kim, Luke Wroblewski, Will Tschumy
http://msstudios.vo.llnwd.net/o21/mix08/08_WMVs/PNL11.wmv

I Wanna Go Mobile!
Chad Stoller, David-Michael Davies, Derrick Oien, Eric Breitbard, George Linardos, Michael Platt
http://msstudios.vo.llnwd.net/o21/mix08/08_WMVs/PNL09.wmv

Integrating Media in Silverlight Applications
Ed Maia
http://msstudios.vo.llnwd.net/o21/mix08/08_WMVs/BCT05.wmv

Integrating Your Site With Internet Explorer 8
Jane Kim
http://msstudios.vo.llnwd.net/o21/mix08/08_WMVs/T21.wmv

Internationalizing XAML Applications in Windows Presentation Foundation and Microsoft Silverlight
Ken Azuma, Laurence Moroney, Ted Kitamura
http://msstudios.vo.llnwd.net/o21/mix08/08_WMVs/T15.wmv

Introducing SQL Server Data Services
Nigel Ellis
http://msstudios.vo.llnwd.net/o21/mix08/08_WMVs/BT05.wmv

Is Web 2.0 Sustainable? What business models will work?
Dave McClure, Don Dodge, Kimbal Musck, Robert Scoble, Ryan McIntyre
http://msstudios.vo.llnwd.net/o21/mix08/08_WMVs/PNL15.wmv

Keynote I
Dean Hachamovitch, Ray Ozzie, Scott Guthrie
http://msstudios.vo.llnwd.net/o21/mix08/08_WMVs/KYN0801.wmv

Keynote II
Guy Kawasaki, Steve Ballmer
http://msstudios.vo.llnwd.net/o21/mix08/08_WMVs/KYN0802.wmv

Making it Simple: Designer/Developer Workflow
Christian Schormann, Ken Azuma, Marcelo Marer, Mark Ligameri, Robby Ingebretsen, Robert Tuttle, Ryan Lane
http://msstudios.vo.llnwd.net/o21/mix08/08_WMVs/PNL01.wmv

Microsoft Expression Web: From Comp, to CSS, to Code!
Nishant Kothary, Tyler Simpson
http://msstudios.vo.llnwd.net/o21/mix08/08_WMVs/C04.wmv

Mobile Devices and Microsoft Silverlight: A Primer on the New Technology
Amit Chopra, David Kline
http://msstudios.vo.llnwd.net/o21/mix08/08_WMVs/T12.wmv

Monetization 101
Erynn Petersen
http://msstudios.vo.llnwd.net/o21/mix08/08_WMVs/BT07.wmv

Opportunities and Challenges in Mashing Up the Web
Aaron Fulkerson, Andi Gutmans, Michael Scherotter, Sam Ramji, Shawn Burke
http://msstudios.vo.llnwd.net/o21/mix08/08_WMVs/PNL13.wmv

Overview of Microsoft Ad Formats
Alam Ali
http://msstudios.vo.llnwd.net/o21/mix08/08_WMVs/C05.wmv

Partying with PHP on Microsoft Internet Information Services 7
Drew Robbins
http://msstudios.vo.llnwd.net/o21/mix08/08_WMVs/T27.wmv

Real World Design: Working with Silverlight and WPF in the Design Studio
Beau Ambur, Chip Aubry, Chris Bernard, Nathan Dunlap, Rich Weston
http://msstudios.vo.llnwd.net/o21/mix08/08_WMVs/PNL16.wmv

Real-World AJAX with ASP.NET
Nikhil Kothari
http://msstudios.vo.llnwd.net/o21/mix08/08_WMVs/T16.wmv

RESTful Data Services with the ADO.NET Data Services Framework
Pablo Castro
http://msstudios.vo.llnwd.net/o21/mix08/08_WMVs/T07.wmv

Silverlight and Advertising
Eric Schmidt
http://msstudios.vo.llnwd.net/o21/mix08/08_WMVs/BT06.wmv

Silverlight as a Gaming Platform
Joel Neubeck, Scott McAndrew
http://msstudios.vo.llnwd.net/o21/mix08/08_WMVs/CT03.wmv

Social Networks: Where Are They Taking Us?
David Morin, Garrett Camp, Guy Kawasaki, John Richards, Joseph Smarr, Marc Canter
http://msstudios.vo.llnwd.net/o21/mix08/08_WMVs/PNL08.wmv

The Back of the Napkin: Solving Design Problems (and Selling Your Solutions) with Pictures
Dan Roam
http://msstudios.vo.llnwd.net/o21/mix08/08_WMVs/UX03.wmv

The Business of Microsoft Silverlight
Danny Riddell
http://msstudios.vo.llnwd.net/o21/mix08/08_WMVs/B01.wmv

The Human Brain Relationship: Advanced and Adaptive User Interfaces
Ya'akov Greenshpan, Yochay Kiriaty
http://msstudios.vo.llnwd.net/o21/mix08/08_WMVs/CT04.wmv

The Open Question
Andi Gutmans, Miguel de Icaza, Mike Schroepfer, Sam Ramji
http://msstudios.vo.llnwd.net/o21/mix08/08_WMVs/PNL04.wmv

Tools and Applications for Publishers
Rishi Bal
http://msstudios.vo.llnwd.net/o21/mix08/08_WMVs/T18.wmv

Touch Me: Where Are Interfaces Going?
Chris Bernard, Dale Herigstad, Daniel Makoski, Dave Wolfe, Doug Cook, Yoshihiro Saito
http://msstudios.vo.llnwd.net/o21/mix08/08_WMVs/PNL10.wmv

Understanding Microsoft Partner Programs for Designers, Developers, and Agencies
Bill Vlandis, Hakan Soderbom
http://msstudios.vo.llnwd.net/o21/mix08/08_WMVs/BCT03.wmv

Using Microsoft Silverlight for Creating Rich Mobile User Experiences
Giorgio Sardo
http://msstudios.vo.llnwd.net/o21/mix08/08_WMVs/C02.wmv

Virgins, Spaceships and Hob-nailed Boots!
Paul Dawson
http://msstudios.vo.llnwd.net/o21/mix08/08_WMVs/C03.wmv

Web 2.0 and Beyond: What Is the Business Reality?
Bryan Biniak, Chris Saad, Frank Arrigo, Loic Le Meur, Tim Kendall
http://msstudios.vo.llnwd.net/o21/mix08/08_WMVs/PNL05.wmv

Welcome to Internet Explorer 8
Chris Wilson
http://msstudios.vo.llnwd.net/o21/mix08/08_WMVs/BCT08.wmv

What Is the face of the next Web?
Anthony Franco, Chris Bernard, Garrick Schmitt, Mark Kurtz, Paul Dain, Tjeerd Hoek
http://msstudios.vo.llnwd.net/o21/mix08/08_WMVs/PNL07.wmv

What's New in Windows Presentation Foundation 3.5
Rob Relyea
http://msstudios.vo.llnwd.net/o21/mix08/08_WMVs/T11.wmv

What's the Secret Formula?
Dan Harrelson, Daniel Makoski, Jensen Harris, Mike Schroepfer, Nishant Kothary
http://msstudios.vo.llnwd.net/o21/mix08/08_WMVs/PNL14.wmv

Windows Presentation Foundation Using Microsoft Visual Studio 2008
Mark Wilson-Thomas
http://msstudios.vo.llnwd.net/o21/mix08/08_WMVs/T02.wmv

Working with Data and Web Services in Microsoft Silverlight 2
Eugene Osovetsky
http://msstudios.vo.llnwd.net/o21/mix08/08_WMVs/T13.wmv



Non tech
Battle Plans [Pic]
History: From Moses to Hitler, Mike Tyson and Bill Clinton ( amazing pic )
Olympics clean up Chinese style: Inside Beijing's shocking death camp for cats [PICS]
Apple, Google... And then, You. [Pic]
Geek Flow Chart [Pic]
Fruits. Water. Action! (pics)

StrataFrame Or CSLA.NET, Which Framework Would You Use?

If you would have to choose between StrataFrame or CSLA.NET, which one would you pick?
The team I am part of at work is trying to pick a framework for new development and they like these two the best. Are these two something you would pick or do you know a better one?

CSLA.NET: http://www.lhotka.net/cslanet/
StrataFrame: http://www.strataframe.net/

Also keep in mind that while CSLA.NET is free, StrataFrame is not.

Friday, March 07, 2008

Video: SQL Server Data Services and the Future of Data in the Cloud

Channel 9 has a 45 minute video with Dave Campbell about SQL Server Data Services. maybe this video will answer some of the question you might have about SQL Server Data Services



Watch it here: http://channel9.msdn.com/ShowPost.aspx?PostID=388698#388698

Wednesday, March 05, 2008

Microsoft Announces SQL Server Data Services

What is Microsoft SQL Server Data Services?
SQL Server Data Service (SSDS) is a highly scalable and cost-effective on-demand data storage and query processing web service. It is built on robust SQL Server technologies and helps guarantees a business-ready service level agreement covering high availability, performance and security features. Microsoft SSDS is accessible using standards based protocols (SOAP, REST) for quick provisioning of on-demand data-driven & mashup applications.

How does Microsoft SQL Server Data Services differ from traditional on premise relational SQL Server Database?
SQL Server Data Services is a storage and query processing utility providing mega scale, high availability, reliability, and geo-distributed data services in the Cloud. Customers use the service on-demand, with no up-front cost. It eliminates the initial investment in hardware and software and the on-going cost for storage administration, scale maintenance. Developers and Service providers can quickly run their on-demand applications with minimal infrastructure cost.

What can I do with SQL Server Data Services?
Customers can use SQL Server Data Services to store virtually any amount of data in the Cloud. They can query and modify data as required by the specific business scenarios. SQL Server Data Services support standards-based REST and SOAP interfaces designed to work with any Internet-development toolkit. The primary wire format is XML. Developers and service providers can quickly run on-demand applications with ease. The data has flexible schema which can be modified dynamically by the application. The data is provided with high availability and reliability virtually anywhere, anytime.

Rest of the FAQs here: http://www.microsoft.com/sql/dataservices/faq.mspx
Main SQL Server Data Services site here: http://www.microsoft.com/sql/dataservices/default.mspx

Wednesday, February 27, 2008

In SQL Server 2008 The CONVERT function is enhanced to allow conversions between binary and character hexadecimal values

SQL Server 2008 CTP 6 has enhanced the convert function when you do conversion between binary and character hexadecimal values
There are 3 styles:
Style 0 works the same as on 2005 it converts binary to varchar, if you have 0x64656E6973 then you will get 'denis'
Style 1 converts binary to varchar but the values stay the same, if you have 0x64656E6973 you will get '0x64656E6973'
Style 2 strips the 0x but leaves the rest of the values, if you have 0x64656E6973 you will get '64656E6973'

Try it out

When you run this


SELECT CONVERT(varbinary(5),'denis')

The output will be this 0x64656E6973. Now we can use that in the select statements below


SELECT CONVERT(varchar(18), 0x64656E6973, 0) AS 'Style 0' --denis
SELECT CONVERT(varchar(18), 0x64656E6973, 1) AS 'Style 1' --0x64656E6973
SELECT CONVERT(varchar(18), 0x64656E6973, 2) AS 'Style 2' --64656E6973


When you run the code above on SQL Server 2005 all 3 select statements return 'denis'

It is all in Books On Line for CTP 6, it would have been nice if they also included the sys.dm_tran_commit_table dmv or the sys.dm_exec_trigger_stats dmv. I have no clue what the sys.dm_tran_commit_table dmv is supposed to do :-(

Thursday, February 21, 2008

46 New Dynamic Management Views In SQL Server 2008 CTP6

Remember the 33 new DMVs in SQL Server 2008 post? I was just poking around in SQL Server 2008  CTP6 and wanted to know if there were any new Dynamic Management Views since CTP5. There are 13 new DMVs in CTP6 and there are a total of 45 new Dynamic Management Views compared to SQL server 2005. The list of them is below, I think their names make clear what the dmv is supposed to do (or at least I think I know)




dm_audit_actions
dm_audit_class_type_map
dm_cdc_errors
dm_cdc_log_scan_sessions
dm_cryptographic_provider_algorithms
dm_cryptographic_provider_keys
dm_cryptographic_provider_properties
dm_cryptographic_provider_sessions
dm_database_encryption_keys
dm_db_mirroring_auto_page_repair
dm_db_mirroring_past_actions
dm_db_persisted_sku_features
dm_exec_procedure_stats
dm_exec_trigger_stats
dm_filestream_oob_handles
dm_filestream_oob_requests
dm_fts_fdhosts
dm_fts_index_keywords
dm_fts_index_keywords_by_document
dm_fts_outstanding_batches
dm_fts_parser
dm_os_dispatcher_pools
dm_os_dispatchers
dm_os_memory_brokers
dm_os_memory_node_access_stats
dm_os_memory_nodes
dm_os_nodes
dm_os_process_memory
dm_os_spinlock_stats
dm_os_sys_memory
dm_resource_governor_configuration
dm_resource_governor_resource_pools
dm_resource_governor_workload_groups
dm_server_audit_status
dm_sql_referenced_entities
dm_sql_referencing_entities
dm_tran_commit_table
dm_xe_map_values
dm_xe_object_columns
dm_xe_objects
dm_xe_packages
dm_xe_session_event_actions
dm_xe_session_events
dm_xe_session_object_columns
dm_xe_session_targets
dm_xe_sessions



The 13 DMVs listed below are new in CTP6



dm_audit_actions
dm_audit_class_type_map
dm_db_persisted_sku_features
dm_exec_procedure_stats
dm_exec_trigger_stats
dm_fts_fdhosts
dm_fts_index_keywords
dm_fts_index_keywords_by_document
dm_fts_outstanding_batches
dm_fts_parser
dm_os_dispatchers
dm_os_memory_node_access_stats
dm_server_audit_status



If you want to find out what the names of all the new DMVs are by running a query on your SQL Server 2008 box and you don't have a linked server to a SQL Server 2005 box then don't worry I have prepared the query below for you.


 
SELECT * FROM sysobjects
WHERE name LIKE 'dm_%'
AND name NOT IN('dm_os_hosts',
'dm_exec_cached_plan_dependent_objects',
'dm_os_memory_allocations',
'dm_os_loaded_modules',
'dm_db_task_space_usage',
'dm_os_memory_objects',
'dm_os_schedulers',
'dm_os_threads',
'dm_exec_requests',
'dm_db_missing_index_columns',
'dm_repl_tranhash',
'dm_qn_subscriptions',
'dm_db_session_space_usage',
'dm_exec_query_optimizer_info',
'dm_tran_top_version_generators',
'dm_os_waiting_tasks',
'dm_exec_background_job_queue',
'dm_exec_cursors',
'dm_db_missing_index_details',
'dm_clr_properties',
'dm_os_sublatches',
'dm_exec_query_memory_grants',
'dm_tran_current_snapshot',
'dm_io_virtual_file_stats',
'dm_exec_xml_handles',
'dm_os_wait_stats',
'dm_exec_text_query_plan',
'dm_broker_connections',
'dm_os_stacks',
'dm_os_ring_buffers',
'dm_db_missing_index_groups',
'dm_exec_cached_plans',
'dm_exec_sessions',
'dm_broker_forwarded_messages',
'dm_os_memory_clerks',
'dm_repl_articles',
'dm_fts_memory_buffers',
'dm_fts_index_population',
'dm_tran_current_transaction',
'dm_os_child_instances',
'dm_exec_connections',
'dm_exec_background_job_queue_stats',
'dm_fts_active_catalogs',
'dm_tran_database_transactions',
'dm_os_memory_cache_clock_hands',
'dm_repl_schemas',
'dm_db_mirroring_connections',
'dm_db_index_operational_stats',
'dm_db_partition_stats',
'dm_io_pending_io_requests',
'dm_os_memory_cache_entries',
'dm_os_virtual_address_dump',
'dm_tran_transactions_snapshot',
'dm_exec_query_plan',
'dm_os_memory_cache_hash_tables',
'dm_exec_query_stats',
'dm_clr_tasks',
'dm_os_worker_local_storage',
'dm_db_index_usage_stats',
'dm_db_index_physical_stats',
'dm_os_buffer_descriptors',
'dm_tran_active_snapshot_database_transactions',
'dm_tran_active_transactions',
'dm_db_file_space_usage',
'dm_broker_activated_tasks',
'dm_broker_queue_monitors',
'dm_os_memory_cache_counters',
'dm_tran_session_transactions',
'dm_clr_appdomains',
'dm_exec_sql_text',
'dm_os_memory_pools',
'dm_os_latch_stats',
'dm_io_backup_tapes',
'dm_fts_memory_pools',
'dm_os_sys_info',
'dm_tran_locks',
'dm_exec_query_transformation_stats',
'dm_exec_query_resource_semaphores',
'dm_repl_traninfo',
'dm_db_missing_index_group_stats',
'dm_fts_population_ranges',
'dm_os_performance_counters',
'dm_os_workers',
'dm_io_cluster_shared_drives',
'dm_os_tasks',
'dm_exec_plan_attributes',
'dm_tran_version_store',
'dm_os_cluster_nodes',
'dm_clr_loaded_assemblies')

Enjoy exploring these DMVs



 



 


Wednesday, February 20, 2008

Microsoft SQL Server 2008 Feature Pack CTP, February 2008

The Feature Pack is a collection of stand-alone install packages that provide additional value for SQL Server 2008. It includes the latest versions of:

Redistributable components for SQL Server 2008
Add-on providers for SQL Server 2008
Backward compatibility components for SQL Server 2008

Microsoft SQL Server 2008 Native Client
Microsoft SQL Server 2008 Native Client (SQL Native Client) is a single dynamic-link library (DLL) containing both the SQL OLE DB provider and SQL ODBC driver. It contains run-time support for applications using native-code APIs (ODBC, OLE DB and ADO) to connect to Microsoft SQL Server 2000, 2005, or 2008. SQL Native Client should be used to create new applications or enhance existing applications that need to take advantage of new SQL Server 2008 features. This redistributable installer for SQL Native Client installs the client components needed during run time to take advantage of new SQL Server 2008 features, and optionally installs the header files needed to develop an application that uses the SQL Native Client API.


Microsoft SQL Server 2005 Backward Compatibility Components
The SQL Server Backward Compatibility package includes the latest versions of Data Transformation Services 2000 runtime (DTS), SQL Distributed Management Objects (SQL-DMO), Decision Support Objects (DSO), and SQL Virtual Device Interface (SQLVDI). These versions have been updated for compatibility with both SQL Server 2005 and SQL Server 2008 and include all fixes shipped through SQL Server 2000 SP4 and SQL Server 2005 SP2.

Microsoft SQL Server 2008 Reporting Services Add-in for Microsoft SharePoint Technologies
Microsoft SQL Server 2008 Reporting Services Add-in for SharePoint Technologies allows you to take advantage of SQL Server 2008 report processing and management capabilities in SharePoint integrated mode. This version also includes data-driven subscriptions. The download provides a Report Viewer web part, web application pages, and support for using standard Windows SharePoint Services or Microsoft Office SharePoint Services.

Get it all here: http://www.microsoft.com/downloads/details.aspx?FamilyId=D68DE3C9-60A9-49C9-A28C-5C46BBC3356F&displaylang=en

SQL Server 2008 February CTP is now available for public download

SQL Server 2008 February CTP is finally here, this CTP is supposed to be feature complete.

Download the February CTP from the Download Center!

What's New in SQL Server 2008 February CTP?

Enter to win an Xbox in the SQL Server 2008 February CTP Bug Bash!

Monday, February 18, 2008

If Airplanes Were Made By Using Scrum/Agile

So I have been doing Scrum for a while now, I came across this video and thought it was hilarious. When you do Scrum you develop by using sprints, a sprint is usually between 2 and 4 weeks and at the end of the sprint you should have something working that you can show to the client/business unit

Watch the video



If someone is interested in a high level post about Scrum then leave a comment and I will post something next week

Sunday, February 17, 2008

Weekly Links 20080217

I decided to do a weekly links post with interesting SQL Server stuff, I also include a bunch of funny things at the bottom.

Technical Stuff:
Bob Beauchemin has two post that deal with Spatial Data: Using SQL Server 2008 spatial and the Virtual Earth map control - 1 and Using SQL Server 2008 spatial and the Virtual Earth map control - 2. The Spatial Data posts are more for people who do front end as well as back end development.
Two Interesting articles by the PSS SQL Server Engineers
How it Works: SQL Server Per Query Degree Of Parallelism Worker Count(s) and How It Works: SQL Server 2005 Connection and Task Assignments
Kalen Delany's Geek City: String Statistics post. My own Functions That Are Not Often Used: SIGN from sqlblog. Amdahl’s Law by Linchi Shea

If that is not enough for you there are also a bunch of SQL Server 2008 Webcasts available as well as a bunch of SQL Server 2008 Videos.

The non technical stuff:
Like Father Like Grandson
I had friends...
Pronounce this if you can
Peek into offices at LinkedIn, Flickr & Facebook

HTTP Endpoints deprecated In SQL Server 2008, Just Like Notification Services

Just like Notification Services HTTP Endpoints have been deprecated in SQL Server 2008. Bob Beauchemin's Blog has more info here: HTTP Endpoints to be deprecated in SQL Server 2008

Thursday, February 14, 2008

SQL Server 2008 Whitepapers

General
SQL Server 2008 Product Overview
Microsoft® SQL Server™ provides a policy-based system for managing one or more instances of SQL Server along with tools for performance monitoring, troubleshooting, and tuning that enable administrators to more efficiently manage their databases and SQL Server instances.
Focus: What's New
Audience: High-level

Business Intelligence
An Introduction to New Data Warehouse Scalability Features in SQL Server 2008
With the 2008 release, SQL Server makes a major advance in scalability for data warehousing. It meets the data warehouse needs of the largest enterprises more easily than ever. SQL Server 2008 provides a range of integrated products that enable you to build your data warehouse, and query and analyze its data. These include the SQL Server relational database system, Analysis Services, Integration Services, and Reporting Services. This paper introduces the new performance and manageability features for data warehousing across all these components. All these features contribute to improved scalability.
Audience: High-level

SQL Server 2008 Analysis Services Overview
Microsoft SQL Server 2008 Analysis Services builds on the value delivered with the significant investments in Analysis Services 2005 around scalability, advanced analytics and Microsoft Office interoperability. This paper covers a high-level look at the key Analysis Services features available in SQL Server 2008.
Audience: High-level

Predictive Analysis with SQL Server 2008
This 10-page paper explores the complete and intuitive set of data mining tools offered in Microsoft SQL Server 2008: Predictive Analysis for All Users, Insight at Every Step of the Data Lifecycle, and Data Mining Awareness in Every Application.
Audience: High-level

Business Intelligence in SQL Server 2008
This 10-page paper includes: Introduction, Unifying Data Storage and Access, Building and Managing Sophisticated BI Solutions, Extending the Reach of Your BI Solution, and Conclusion.Focus: Business Intelligence
Audience: High-level

SQL Server 2008 Reporting Services Whitepaper
This paper discusses how Microsoft SQL Server 2008 Reporting Services provides a complete server-based platform that is designed to support a wide variety of reporting needs including managed enterprise reporting, ad-hoc reporting, embedded reporting, and web based reporting to enable organizations to deliver relevant information where needed across the entire enterprise.Focus: Reporting Services
Audience: High-level

An Introduction to SQL Server 2008 Integration ServicesThis paper discusses the challenges that face businesses that rely on data integration technologies to provide meaningful, reliable information to maintain a competitive advantage in today’s business world. It discusses how SQL Server 2008 Integration Services (SSIS) can help Information Technology departments meet data integration requirements in their companies. Real-world scenarios are included.Focus: Integration Services
Audience: High-level Data Warehousing

Choosing SQL Server 2008 for Data Warehousing
This 10-page paper discusses: The State of Data Warehousing, The Realities of Data Warehousing Today, Putting the Technology Set Together, and Rounding It Out.Focus: Data Warehousing
Audience: High-level


Application Development/Data Programmability
Microsoft SQL Server 2008 and Microsoft Data Platform Development
This 10-page paper includes: Improved Productivity through ADO.NET Entity Framework, LINQ, and Visual Studio, Comprehensive Data Platform, and Scalable Data-Centric Solutions.
Focus: Developer Productivity
Audience: Technical

What's New for XML in SQL Server 2008?
A 16-page paper that discusses how Microsoft SQL Server 2008 builds on the extensive support for XML by extending support for XML schema validation and XQuery, and by enhancing the xml data type.
Focus: XML
Audience: Technical

Managing Unstructured Data with SQL Server 2008
This 11-page paper discusses how Microsoft SQL Server™ 2008 provides a flexible solution for storing unstructured data and combining it with relational data to build comprehensive solutions that encompass the full range of data across an organization.
Focus: Unstructured Data
Audience: Technical

SQL Server 2008: Delivering Location Intelligence with Spatial Data
This 10-page paper discusses how the new spatial support in Microsoft SQL Server™ 2008 can help you to make better decisions through visual analysis of location data that can be stored and manipulated in a SQL Server database.
Focus: Spatial Data
Audience: Mid-level

Online Transaction Processing/Data Management
SQL Server 2008 Security Overview for Database Administrators
SQL Server 2008 is secure by design, default, and deployment. Microsoft is committed to communicating information about threats, countermeasures, and security enhancements as necessary to keep your data as secure as possible. This paper covers some of the most important security features in SQL Server 2008. It tells you how, as an administrator, you can install SQL Server securely and keep it that way even as applications and users make use of the data stored within.
Focus: Security
Audience: Mid-level

Online Transaction Processing in SQL Server 2008
This 10-page paper includes: Introduction, Scale and Performance, High Availability, Security, and Manageability.
Focus: OLTP
Audience: High-level

SQL Server 2008 Manageability
This paper discusses how Microsoft SQL Server 2008 builds on the management capabilities of previous versions and provides a variety of tools and frameworks to help you manage your enterprise data environment.
Focus: Manageability
Audience: High-level

SQL Server 2008 Performance and Scale
This paper discusses how Microsoft SQL Server 2008 incorporates the tools and technologies that are necessary to implement relational databases, reporting systems, and data warehouses of enterprise scale, and provides optimal performance and responsiveness.
Focus: Scale and Performance
Audience: Mid-level

Server Consolidation
Server Consolidation with SQL Server 2008
This 10-page paper includes: Introduction, Flexibility, Manageability, Scalability and Performance, and Conclusion.
Focus: Server Consolidation
Audience: High-level

Thursday, February 07, 2008

SQL Server 2008: When Was The Server Last Started?

SQL Server 2008 has an additional column in the sys.dm_os_sys_info Dynamic Management View. The name of the column is sqlserver_start_time and it will be the time SQL Server was last restarted

SELECT sqlserver_start_time FROM sys.dm_os_sys_info

Review of Inside Microsoft SQL Server 2005 Query Tuning and Optimization

SQL performance tuning is probably one of those things you can do to really make a HUGE difference in performance. Let’s put this in perspective: take a typical application, if you can improve the performance by 100% then you really made a huge improvement. You can improve a SQL query by 1000% with 2 lines of code (sometimes all you have to do is take away a % sign). If you can make a query sargable so that the optimizer can do an index seek instead of an index scan your query might go from 12 seconds to 200 milliseconds. Now try doing that in an application, even if you change all the string concatenation to use a stringbuilder instead of creating new strings all the time you will not get such a drastic performance improvement. I am sure you get the point by now, let’s talk about the book.

Inside Microsoft SQL Server 2005: Query Tuning and Optimization is part 4 of the Inside Microsoft SQL Server 2005 series, it is written by Kalen Delaney and five other authors. There are 6 chapters in this book

1 A Performance Troubleshooting Methodology

This chapter explains some typical things that affect performance and also gives a troubleshooting overview


2 Tracing and Profiling

This chapter explains how to use the profiler and how to analyze traces. SQL Server’s built-in traces are also covered


3 Query Execution

This chapter gives a query processing and execution overview. It explains how to read plans and goes into a lot of detail about analyzing plans


4 Troubleshooting Query Performance

This chapter explains how to detect problems in plans, how to improve queries and some best practices


5 Plan Caching and Recompilation

This chapter goes into detail about plan caching and recompilation and how to troubleshoot plan cache issues


6 Concurrency Problems

The final chapter deals with concurrency (locking, blocking and deadlocking)



This is an excellent book for an intermediate/advanced developer. There is so much new stuff in SQL Server 2005 compared to 2000 to help you with tuning queries that you probably want to read each chapter several times. The Dynamic Management Views are a big help and this book shows you how to use them. Some other cool stuff in this book is the discussion of internal tables, undocumented DBCC commands and undocumented trace flags to discover information which could help you determine much faster what the cause of a performance problem might be.
Some pages are packed with so much information that you need to pause for a second and process all that info (I have read some pages two to three times in a row). You will also find out that there are more joins besides left, full and outer. Page 137 for example has a nice table with the three Physical Join Operators: Nested Loop Join, Hash Join and Merge Join. This table lists the characteristics for each of these joins.

If you are an intermediate to advanced developer then I highly recommend this book. I have interviewed Kalen a while back about this book and you can find that interview here
http://sqlservercode.blogspot.com/2007/10/interview-with-kalen-delaney-about.html

Wednesday, February 06, 2008

33 New Dynamic Management Views In SQL Server 2008

I was just poking around in SQL Server 2008 and wanted to know if there were any new Dynamic Management Views. There are a total of 33 new Dynamic Management Views. The list of them is below, I think their names make clear what the dmv is supposed to do (or at least I think I know)


dm_cdc_errors
dm_cdc_log_scan_sessions
dm_cryptographic_provider_algorithms
dm_cryptographic_provider_keys
dm_cryptographic_provider_properties
dm_cryptographic_provider_sessions
dm_database_encryption_keys
dm_db_mirroring_auto_page_repair
dm_db_mirroring_past_actions
dm_filestream_oob_handles
dm_filestream_oob_requests
dm_os_dispatcher_pools
dm_os_memory_brokers
dm_os_memory_nodes
dm_os_nodes
dm_os_process_memory
dm_os_spinlock_stats
dm_os_sys_memory
dm_resource_governor_configuration
dm_resource_governor_resource_pools
dm_resource_governor_workload_groups
dm_sql_referenced_entities
dm_sql_referencing_entities
dm_tran_commit_table
dm_xe_map_values
dm_xe_object_columns
dm_xe_objects
dm_xe_packages
dm_xe_session_event_actions
dm_xe_session_events
dm_xe_session_object_columns
dm_xe_session_targets
dm_xe_sessions



If you want to find out what the names of all the new DMVs are by running a query on your SQL Server 2008 box and you don't have a linked server to a SQL Server 2005 box then don't worry I have prepared the query below for you.



SELECT * FROM sysobjects
WHERE name LIKE 'dm_%'
AND name NOT IN('dm_os_hosts',
'dm_exec_cached_plan_dependent_objects',
'dm_os_memory_allocations',
'dm_os_loaded_modules',
'dm_db_task_space_usage',
'dm_os_memory_objects',
'dm_os_schedulers',
'dm_os_threads',
'dm_exec_requests',
'dm_db_missing_index_columns',
'dm_repl_tranhash',
'dm_qn_subscriptions',
'dm_db_session_space_usage',
'dm_exec_query_optimizer_info',
'dm_tran_top_version_generators',
'dm_os_waiting_tasks',
'dm_exec_background_job_queue',
'dm_exec_cursors',
'dm_db_missing_index_details',
'dm_clr_properties',
'dm_os_sublatches',
'dm_exec_query_memory_grants',
'dm_tran_current_snapshot',
'dm_io_virtual_file_stats',
'dm_exec_xml_handles',
'dm_os_wait_stats',
'dm_exec_text_query_plan',
'dm_broker_connections',
'dm_os_stacks',
'dm_os_ring_buffers',
'dm_db_missing_index_groups',
'dm_exec_cached_plans',
'dm_exec_sessions',
'dm_broker_forwarded_messages',
'dm_os_memory_clerks',
'dm_repl_articles',
'dm_fts_memory_buffers',
'dm_fts_index_population',
'dm_tran_current_transaction',
'dm_os_child_instances',
'dm_exec_connections',
'dm_exec_background_job_queue_stats',
'dm_fts_active_catalogs',
'dm_tran_database_transactions',
'dm_os_memory_cache_clock_hands',
'dm_repl_schemas',
'dm_db_mirroring_connections',
'dm_db_index_operational_stats',
'dm_db_partition_stats',
'dm_io_pending_io_requests',
'dm_os_memory_cache_entries',
'dm_os_virtual_address_dump',
'dm_tran_transactions_snapshot',
'dm_exec_query_plan',
'dm_os_memory_cache_hash_tables',
'dm_exec_query_stats',
'dm_clr_tasks',
'dm_os_worker_local_storage',
'dm_db_index_usage_stats',
'dm_db_index_physical_stats',
'dm_os_buffer_descriptors',
'dm_tran_active_snapshot_database_transactions',
'dm_tran_active_transactions',
'dm_db_file_space_usage',
'dm_broker_activated_tasks',
'dm_broker_queue_monitors',
'dm_os_memory_cache_counters',
'dm_tran_session_transactions',
'dm_clr_appdomains',
'dm_exec_sql_text',
'dm_os_memory_pools',
'dm_os_latch_stats',
'dm_io_backup_tapes',
'dm_fts_memory_pools',
'dm_os_sys_info',
'dm_tran_locks',
'dm_exec_query_transformation_stats',
'dm_exec_query_resource_semaphores',
'dm_repl_traninfo',
'dm_db_missing_index_group_stats',
'dm_fts_population_ranges',
'dm_os_performance_counters',
'dm_os_workers',
'dm_io_cluster_shared_drives',
'dm_os_tasks',
'dm_exec_plan_attributes',
'dm_tran_version_store',
'dm_os_cluster_nodes',
'dm_clr_loaded_assemblies')

Enjoy exploring these DMVs