The Curious Engineer

All blogs / Databases

Mat Stephen's Azure Data Services Blog

learn.microsoft.com/en-us/archive/blogs/mat_stephen

All things Azure Data Services (previously All things SQL Server). Complied by Matthew Stephen - Data Solutions Architect (Azure), Microsoft UK

DatabasesDistributed systems / cloudMicrosoft blogsMSDN archive

’05’10’15’20’25
Posts
165 from 7 Dec 2004 to 29 Dec 2018
Posting
archived, read-only
Kind
personal blog
Feed
https://learn.microsoft.com/en-us/archive/blogs/mat_stephen/feed.xml

2018 3

  1. Sharing Data with Azure
  2. PowerShell Scipt for generating events for Azure Event Hub
  3. Getting Started With R

2017 3

  1. Getting Started with Power BI
  2. Getting Started with Microsoft Azure AI
  3. I'm back, but I'm not who I used to be

2006 3

  1. SQL 2005 Metadata Samples Toolkit and whitepaper now available
  2. New Performance Troubleshooting Guide for SQL2005
  3. New SQL 2005 code samples available

2005 140

  1. Feature Pack for Microsoft SQL Server 2005 - November 2005
  2. Get the facts about deploying and using Microsoft® SQL Server 2005TM
  3. Slides from the SQL Server Launch in Birmingham UK
  4. TechNet Briefing: What's NEW in SQL 2005 - Analysis Services & Data Mining
  5. Its not SQL but it is amuzing
  6. Changing Job
  7. Microsoft .NET Data Provider for SAP
  8. UK SQL User Group Presents: "Concurrency in SQL Server 2005, Kalen Delaney Full Day Seminar: 18th Oct 2005."
  9. SQL Server 2005 Technical Overview blogcasts
  10. OLAP, Darwin and Evolution
  11. Database Mirroring won't make RTM
  12. SQL Server Integration Services Samples - Including Fuzzy Logic
  13. Bill Gates - A short chat with Microsoft's Chief Software Architect
  14. Getting to know SQL 2005 Service Broker
  15. SQL 2005: Making sense of the new Optimistic Concurrency Controls and the readers that block writers
  16. IT Forum - Barcelona 15th - 17th November
  17. SQL 2005 - UPSERT: In nature but not by name; but at last!
  18. Project REAL—Business Intelligence in Practice - great website!
  19. 64 Bit performance v 32 bit performance - some compelling evidence
  20. Upgrading a SQL Replication Topology
  21. Fame at last: Ten Useful Microsoft Blogs
  22. Blogcasts: SQL Server 2000 - Configuring System Monitor & Monitoring SQL Server performance & Configuring alerts
  23. Microsoft SQL Server Performance Top Tip: Degrees of Parallelism and a Degree of Uncertainty
  24. Reporting Services: Calling an aspx page from a report and passing a parameter
  25. Microsoft SQL Server 2005 Preview Software for UK customers
  26. SQL Server Reporting Services Report Packs - looking for suggestions
  27. Follow up on XPs and SQLiMail question from SQL Server™ 2005 Management and Admin TechNet evening 28/7/05
  28. Letter from America 2
  29. Letter from America 1
  30. New Microsoft SQL Server 2005 Upgrade Advisor - CTP June Refresh
  31. Get Ready for SQL Server 2005 with Free Microsoft E-Learning Courses.
  32. SQL Server Marketing present 'Escape from Yesterworld'
  33. Blogcast: Using SQL 2000 Profiler
  34. Serialising an ADOMD.net CellSet object
  35. SQL Server 2000 Analysis Services Cube Security
  36. Are you still using @@IDENTITY?
  37. How Do You Deploy SQL Server Reporting Services?
  38. SQL Server 2005 JDBC Driver Beta 1 Now Available
  39. Reporting Services: Two New (Free) Report Packs Released for Sharepoint and Axapta
  40. SQL Server 2005 Integration Services - Top Reference Site
  41. Blogcast: SQL Server 2000 - Using the Index Tuning Wizard
  42. UK SQL Server User group meeting 12TH July :: SQL Server 2005 The Home Stretch Euan Garden, Group Program
  43. TechEd Amsterdam: If you want to come and say hello, here's my schedule - and a cautionary note regarding Jay Walking here in Amsterdam
  44. Roger Sessions ObjectWatch: TechEd USA - his digest - insight from a true sage that can't be ignored
  45. Office Business Scorecards Accelerator – the ultimate marriage of business and intellgence. Another free application from Microsoft
  46. Microsoft SQL Server 2005 Analysis Services – Unified Dimensional Model (UDM). Can you get your head round it? If you do BI, you’ll need to!
  47. The QFE for SQL Server 2000 Reporting Services Service Pack 2 is now available.
  48. SQL Server Reporting Services: Custom colour in charts
  49. Business Intelligence (BI): The way it is, without the blah blah
  50. Cool new OVER Clause (Transact-SQL) in SQL Server 2005
  51. Follow up on Database snapshot performance question from SQL Server™ 2005 High Availability TechNet evening 21/6/05
  52. Querying and Reporting on Report Execution Log Data
  53. Follow up on Replication Columns question in my TechNet SQL 2005 presentation (14/6/05)
  54. Follow up on Witnesses question from SQL Server™ 2005 High Availability TechNet evening 21/6/05
  55. Blogcast: SQL Server 2000 Performance Demo 1-3 Managing indexes
  56. Blogcast: SQL Server 2000 Performance Demo 1-2 Analyzing an execution plan
  57. Blog cast SQL Server 2000 Performance Demo 1-1 Searching and browsing objects
  58. More follow up from my TechNet SQL 2005 presentation (14/6/05) - SMP boxes and database files
  59. Peer to peer demo code
  60. Peer to Peer replication demo code from SQL Server 2005 TechNet evening on the 14th June at our Reading office
  61. Steve Ballmer on Mendocino - video available
  62. London roadshow follow up: Selective execution of SQL Server Integration Service Tasks and Transforms
  63. Reporting Services: How to stop IE striping out leading spaces in report data values
  64. Blogcast: How to add a multicast transform to a SQL Server Integration Services package
  65. SQL 2005 Express to get Report Server and Workgroup edition to get Report Builder
  66. BUG: Not all memory is available when AWE is enabled on a computer that is running a 32-bit version of SQL Server 2000 SP4
  67. Blogcast: How to create a simple SQL Server Integration Services package
  68. SQL Server 2005 launch date anounced!
  69. Two SQL 2005 TechNet Evenings I'll be delivering in Reading, UK
  70. SQL Server TechCenter Launches
  71. SQL Server 2005 webcasts starting today and coming throughout June
  72. Keep up-to-date with knowledge base articles coming out of Microsoft
  73. SQL Server Reporting Services: How to do an aggregate, SUM(Field), and display it as a % of the total for a Table or Matrix column
  74. Processing XML Showplans Using SQLCLR in SQL Server 2005 - Make Use of the New XML Showplans
  75. Expanding the reach of the Maestro beta program
  76. Transfering Data Oracle Data To And From SQL Server
  77. SQL Server 2000 vs SQL Server 2005 Performance
  78. Blogcast: Solution Exporer inside SQL Server 2005 Management Studio
  79. Top Tip: How to use the same dimension twice on one fact table with SQL Server 2000 Analysis Services
  80. Blogcast: Introducing the Object Explorer in the new SQL Server 2005 Management Studio
  81. Blogcast: First Glimpse at SQL Server 2005 Management Studio
  82. Webcast with Proclarity
  83. Nice one Maestro - the next generation of the Business Scorecard Accelerator is now in beta 1
  84. Tell your boss you need to go to Tech Ed 2005 Europe (Amsterdam, 5-8 July, 4th for pre-conference seminars)
  85. SQL Server 2000 Service Pack 4 - baked and Ready to go
  86. Top Tip - Dynamic Database connections for SQL Server 2000 Reporting Services reports
  87. Become an Industry Insider and get published on TechNet
  88. Webcasts - Business Intelligence using SQL Server 2005
  89. Another Blog with an interesting fuzzy logic example using SQL Server Integration Services to process web server logs
  90. SQL Server Reporting Services: Secure reports, passing parameters and User!UserID
  91. Yankee Group identified a sharp rise in companies' assessment of Microsoft's security level
  92. Top Tip SQL Server Reporting Services fields cannot be used in headers or footers - work around
  93. SAP and Microsoft Create 'Mendocino' Product to integrate Office, Exchange and SAP
  94. SQL Server 2005 Integration Services - Migrating SQL Server 2000 DTS tasks
  95. SQL Server 2005 feature comparison by edition
  96. Download Microsoft SQL Server 2005 Express Edition: Community Technology Preview April 2005
  97. SP2 for Microsoft SQL Server Reporting Services is now ready for download
  98. Additional code samples based on the Business Intelligence Portal
  99. Want to hear the latest on SQL Server 2005 from the big cheese? Want to get a go-live-license for SQL Serever 2005 Express Edition?
  100. TechNet Roadshow Example code for Microsoft SQL Server 2005 Table partitioning
  101. Get SQL Server Analysis Services OLAP Online on your PDA Pocket PC
  102. Feature comparison: Microsoft SQL Server 2000 Reporting Services vs Business Objects Crystal Reports / Crystal Enterprise
  103. Microsoft SQL Server 2005 Educational Webcast Series on TechNet
  104. Microsoft SQL Server 2005 fuzzy logic in matching and grouping - how does it work in SQL Server Integration Services?
  105. Microsoft SQL Server 2005 Virtual Labs on MSDN
  106. UK Technical Roadshow – a few places left so hurry if you want one
  107. Two new free Microsoft SQL Server Reporting Services Report Packs released for IIS and Great Plains
  108. The Final Word in Microsoft SQL Server 2000 Backup, Restore and recovery
  109. First Microsoft-SAP Collaboration Brief from Microsoft on loading data from SAP BW into SQL Server Anlaysis Srevices
  110. Questions arising from TechNet Webcast: Business Intelligence on the Microsoft Platform 23rd March.
  111. Forthcoming UK Microsoft SQL Server Business Intelligence Webcasts.
  112. Microsoft SQL Server - Reporting Services Scripter - a free tool from sqldbatips.com
  113. Microsoft SQL Server 2005 Analysis Services – Unified Dimensional Model (UDM). Can you get your head round it? If you do BI, you’ll need to!
  114. Microsoft SQL Server 2005 - The Pricing, The Editions, and the Edition's Features
  115. Microsoft SQL Server Resource Kit tools - 'Free' with MSDN and TechNet
  116. Office Excel Add-in for Microsoft SQL Server Analysis Services – its free, its powerful and it could save you money!
  117. Office Business Scorecards Accelerator – the ultimate marriage of business and intellgence. Another free application from Microsoft
  118. Reporting Services : 21 Report packs released to the web for free download
  119. Its Sunbelieveable: Sun’s First Windows - Microsoft SQL Server SAP Benchmark and Certification
  120. SQL Server Performance Top Tip: SQL Server User Mode Scheduler (UMS) – understanding it can explain some odd performance
  121. Migrate your legacy Oracle databases to SQL Server - Tools you need to do the conversion
  122. Microsoft SQL Server Performance Top Tip: Degrees of Parallelism and a Degree of Uncertainty
  123. Blogcast - Creating a simple Microsoft SQL Server Reporting Services report using the Report Wizard
  124. SQL Server SP4 Beta is still Open
  125. Microsoft SQL Server Performance Top Tip: Multi Processor (SMP) sudden death syndrome.
  126. Microsoft SQL Server Performance Top Tip: Multi Processor (SMP) Box Doesn’t Use All It’s Processors
  127. I'm trying to find some detail on Patch management / deployment on a 4 SQL Server node cluster?
  128. Business Intelligence Portal Sample Application for Microsoft Office
  129. TechNet Webcast: Troubleshooting Microsoft SQL Server 2000 (Level 200) Friday, February 04, 2005 - 9:30 AM - 11:00 AM Pacific Time
  130. Microsoft SQL Server 64 bit links
  131. Using Microsoft SQL Server Reporting Services against SAP - and other Application Partners for Reporting Services
  132. Microsoft and SAP Deliver Integration of SAP NetWeaver and .NET with Visual Studio .NET 2003-Integrated Portal Development Kit for .NET (PDK)
  133. Convert Crystal Reports to SQL Server Reporting Services
  134. SQL Server Lock Escalation – Friend of Foe?
  135. SP I promised during TechNet Gig on SQL Performance which will identify blocking spid at top of blocking chain : sp_blocker_pss80
  136. CREATE proc track_waitstats & CREATE proc get_waitstats - useful code for diagnosing SQL 2000 performance
  137. Oracle RAC, Grid, IBM, and Microsoft: A Corporate Altercation or Religious Divergence
  138. SQL Server Health and History Tool (SQLH2)
  139. Catch the SQL Server 2005 Express, it’s the future and it’s free!
  140. Hitchhicker’s Guide to SQL Server Reporting Services author to present at IT Forum Highlights - Birmingham UK 13th Jan 05

2004 16

  1. The SQL Server Web Data Administrator enables you to easily manage your SQL Server data, wherever you are!
  2. Benchmark your SAN or disk subsystem IO throughput – with SQLIO, free to Microsoft SQL Server users
  3. 3rd Party Report Builders for SQL Server Reporting Services that don't require Visual Studio know how.
  4. MSDN Webcast: Identifying Application Performance Problems with SQL Server and Shadowfax (Level 400)
  5. MSDN Webcast: New Features in Reporting Services Service Pack 2 (Level 400)
  6. MSDN Webcast: Application Performance Tuning Using SQL Server Profiler 2005 (Level 200)
  7. TechNet Webcast: Migrating Oracle and UNIX Systems to SQL and Windows - Level: 200
  8. TechNet Webcast: A Technical Overview of SQL 2005 High Availability Features (Part 2 of 2) - Level: 200
  9. TechNet Webcast: A Technical Overview of SQL 2005 High Availability Features (Part 1 of 2) - Level: 200
  10. Microsoft Executive Circle Webcast: Improve TCO by Migrating your Siebel Applications to Microsoft SQL Server
  11. TechNet Webcast: SQL Server 2005 Technical Overview - Level: 200
  12. SQL Server can run your enterprise? Here's how to prove it
  13. SQL Server Security – you can’t do without it
  14. SQL Server High Availability – I have to talk about this so much I feel like a scratched record.
  15. SQL Server Accelerator for Business Intelligence (SSABI) - often unheard of and sometimes underestimated
  16. My Introduction to the Blogsphere - and my first useful tip for SAP enthusiasts