The Curious Engineer

All blogs / Databases

All things Data Related....

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

On this site I will be posting entries related to Data platform and analytics that I learn and believe could be valuable learning to others who want insight from their data

DatabasesTech news / industryMicrosoft blogsMSDN archive

’10’15’20’25
Posts
254 from 22 Sep 2007 to 24 Dec 2015
Posting
archived, read-only
Kind
personal blog
Feed
https://learn.microsoft.com/en-us/archive/blogs/sqlman/feed.xml

2015 7

  1. Merry Christmas and Happy New Year for 2016
  2. SQL Server 2016 - What's exciting?
  3. Sydney R user group Meet up: R at Microsoft (with David Smith, formerly Revolution Analytics)
  4. Few Azure Services went GA and we acquired a great visualization company - Datazen
  5. PowerBI Preview now available outside of the US
  6. Migration cookbook now available for the latest Azure SQL Database Update (V12)
  7. Start planning your upgrade to SQL Server 2014 - SQL Server 2005 is approaching end of its support...

2014 18

  1. Merry Christmas and Happy New Year for 2015
  2. SQL Server 2014 Upgrade Technical Guide now Available
  3. Gartner Recognizes Microsoft as a Leader, Positioned Furthest to the Right for Vision, in its Magic Quadrant for Operational Database Management Systems
  4. Azure Machine Learning Overview at Big Data Meetup
  5. PowerBI - Gain Insights using familarity of Excel and power of the cloud with Office 365
  6. Hoooooraay Ozure is live - Azure DCs in Australia are now available to be selected in Azure Portal
  7. SQL Saturday in Sydney, October 25th
  8. Teched 2014 - See you in Melbourne & Sydney at my session on Power BI
  9. Free ebook: Introducing Microsoft Azure HDInsight
  10. ebook: Database as a Service using Windows Azure Pack
  11. Now that SQL Server 2014 is out - wondering how you can leverage the power of In-Memory OLTP for your applications
  12. SQL Server 2014 sets world record breaking performance according to TPC benchmarks
  13. SQL Server 2014 Database as a Service Whitepaper
  14. SQL Server 2014 Essentials for Oracle DBAs
  15. SQL Server 2014 RTM today - Available 1st April 2014 (USA date)
  16. Power BI Training
  17. Quickest way to deploy a Microsoft BI environment based on SharePoint - in the Windows Azure cloud
  18. System Center Management Packs for SQL Server 2008 & 2012 Analysis Services

2013 21

  1. Best Wishes for the Festive Season and Happy New Year – may it light up with Power BI
  2. Perceptive Pixel (PPI) and Power BI
  3. Learn how Microsoft finance professionals use business intelligence
  4. Fusion-io: The Breakthrough Experience for SQL Server
  5. Start saving $$$ now, with the SQL Server Backup to Windows Azure Tool
  6. Cloud OS…for databases
  7. Teched Australia 2013 – Day One
  8. Partner Event: Dimension Data – See Microsoft Power BI in action
  9. Join the Free Big Data Webinar on 13th August 2013
  10. Free Master Data Management Seminar in Sydney – 2nd August 2013
  11. Videos: Microsoft BIG Data
  12. SQL Server 2012 SP1 Cumulative Update 4 Released!
  13. Rest “Azure-d” we’re coming Down Under!
  14. Sydney Event – Thursday 6th June 2013 - Learn how DP World gained real-time insight into their business using Mobile BI
  15. TechEd Australia 2013: Call for Topics is Live!
  16. Windows Azure Virtual Machines now available
  17. SQL Server 2000 Support Ending
  18. Big Data in Cloud with HDInsight Service Preview
  19. It’s a cloudy day in Sydney today – why not take this opportunity to learn about the Windows Azure Cloud
  20. Case Study on my two favorite technologies – Big Data & Xbox (Halo)
  21. Microsoft BI Leading in the Gartner’s BI Quadrant

2012 23

  1. Long time since I blogged – lots has happened in the SQL Server World
  2. Microsoft Big Data Platform (HDInsight) in action
  3. Briefing: Mission Critical Confidence in the Enterprise
  4. Windows Azure Cloud Platform Poster
  5. Virtualise and Consolidate SQL Server with confidence on Windows Server 2012 Hyper-V
  6. New Public Previews of Hadoop for Windows and Windows Azure
  7. Technical Case Study: Klout implementation of Analysis Services over Hive (Big Data)
  8. SQL Server Technical Bootcamps for Service Providers
  9. Windows Server 2012 has released
  10. Selecting the right Self-Service BI Tool
  11. Big Data in my little head
  12. Teched Australia 2012: Session Catalog is live
  13. Free Ebooks from MS Press
  14. Step by Step: Setting up Linux ODBC driver for SQL Server
  15. Detailed SQL Server 2012 Upgrade Technical Guide Now Available
  16. Optimizing SQL Server 2012 and SharePoint for Private Cloud - Business Intelligence White Paper
  17. My SQL Saturday Presentation on the HP Database Consolidation Appliance (DBCA)
  18. What? You still think RAC is the answer for your high end database platform requirements even with SQL Server 2012 & SQL Azure now released! Time to think again
  19. Microsoft SQL Server 2012 is launching today, with evaluations available and general availability starting April 1.
  20. Reference Architecture for High Performance SQL Server
  21. Excite your CxOs and Senior management by providing Microsoft BI on thier iPads
  22. Try out Power View in the comfort of your PC
  23. Thinking about moving your database to the cloud

2011 35

  1. BigData! Hype or Reality?
  2. Upgrade Assistant for SQL Server 2012 now available
  3. Merry Christmas and Happy New Year
  4. SQL Server 2012 RC0 Available Now
  5. Have you registered for the Big Picture Event?
  6. Want to know more of our cool SQL Appliances??
  7. BI: Excel Services Data Refresh Flowchart
  8. Did someone say Pizza, Beer & some Denali Demos!!!
  9. See you at Teched Australia 2011
  10. Tips & Tricks: SharePoint 2010 Performance Point Services–Reporting Services report settings
  11. SQL Server Denali AlwaysOn–Q&A
  12. SQL Server “Denali” CTP3 Product Guide
  13. SQL Server Code Name “Denali” CTP3 available
  14. Whitepaper: Implementing SQL Server Parallel Data Warehouse using Kimball Approach
  15. SharePoint 2010 Service Pack 1 Now Available
  16. Analysis Services Report actions and SharePoint Integrated Mode Reports
  17. Tips & Tricks: YOU HAVE LOST ACCESS TO SQL SERVER. NOW WHAT?
  18. Whitepaper: SQL Server 2008 R2 Analysis Services Operations Guide
  19. PowerPivot in Action
  20. DW infrastructure made easier
  21. HPs Business Decision Appliance–Special Pricing for Australia
  22. Improve ETL performance in SSIS by introducing parallelism in the data flow of an SSIS package.
  23. Trip down Memory Lane
  24. SQL Server Private Cloud Simplified
  25. SQL Server Migration Assistant (SSMA) v5.0 released!
  26. New on Technet - BI Scenarios site
  27. SQL Server as a Service/ SQL Server Private Cloud Offering
  28. SQL Server Standard vs. Enterprise Edition
  29. Platform Power Briefings
  30. Kimball University Training in Sydney: Microsoft Data Warehouse in Depth
  31. FREE Webinar: Master Data Services
  32. SQL Server 2008 R2 Update for Developers Training Kit–Jan 2011
  33. Microsoft was ranked as a Leader in the 2011 BI Platforms Magic Quadrant
  34. Update: New SQL Server 2008 R2 Upgrade reference manual available
  35. Fill out Cloud BI Survey and win XBOX 360 with Kinect

2010 56

  1. Ebook: Common SQL Server Myths by Paul Randal
  2. Merry Christmas and Happy New Year Reporting Services Style :)
  3. Database Development Guidance Paper published by the Application Lifecycle Management Rangers
  4. Learn how Microsoft deployed SQL Server 2008 R2 Parallel Data Warehouse (PDW)
  5. Whitepaper: SQL Server High Availability Whitepaper by SQL CAT Team - Failure Is Not an Option: Zero Data Loss and High Availability
  6. Microsoft® SQL Server® code-named 'Denali' - Community Technology Preview 1 (CTP1)
  7. Getting Trained by the Father of Data Warehouse–Mr Bill Inmon
  8. Presenting at Sydney SQL Server User Group: Data Warehousing Trends, Microsoft's Data Warehouse Vision & New Solution Offerings
  9. When it rain it pours…well that saying definitely applies to the Windows/SQL Azure Cloud
  10. Busy with Data Warehousing
  11. Non SQL Related Blog: Configuring a Hyper-V VHD to be a boot option on notebook with Windows 7
  12. Whitepaper: SQL Server’s Price/Performance
  13. End User Guidance for MS based BI solutions
  14. SQL Server 2008 SP2 Now Available
  15. SQL Server High Availability: Technical Case Study
  16. PowerPivot SharePoint Integration Install Bug
  17. SQL Server Most Secure Database
  18. Learning and getting trained to be a SQL Server DBA
  19. Master Data Services Portal on MSDN
  20. SQL Azure Service Update 4
  21. Making developer edition of SQL Server act/look like Standard Edition
  22. Migrate from MySQL/Access to SQL Azure or SQL Server with ease!
  23. Administering the Cloud database using your browser–Silverlight style :)
  24. Master Data Services first cumulative update is now available!
  25. Master Data Services–Business Rule Activation error and its fix
  26. SQL Server 2008 R2 Best Practices Analyser
  27. SQL Server virtualisation improvements with SLAT in Intel and AMD
  28. Incorporating Reporting Services Reports in Word and PowerPoint
  29. Just like the fine Sydney weather today, some great announcements about our SQL Azure Cloud offering
  30. June 2010 Sydney SQL Server User Group: Come see my session on Master Data Services, details below
  31. Free Virtual - SQL Server 2008 Training for Oracle DBAs
  32. Its nearly that time of the year again–TECHED TECHED TECHED!!!
  33. SQL Server 2008 R2 and SQL Azure Whitepapers
  34. Video: What is Microsoft Business Intelligence?
  35. SQL Server 2008 R2 has RTMed
  36. Whitepaper: PowerPivot Planning and Deployment
  37. Master Data Services Training Videos
  38. FREE Online SQL Server 2008 R2 Training
  39. Database Mirroring large number of databases
  40. To BI or not to BI?
  41. Update for SQL Server 2008 Developer Training Kit – Now includes SQL Server 2008 R2 material
  42. SQL Server 2008 R2 Tour Downunder
  43. 5W1H of Master Data Services
  44. SQL Server 2008 R2: Multi Server Management Feature Survey
  45. SQL Server 2008: Upgrading to Standard/Enterprise Edition from Evaluation Edition
  46. The premier BI event you can't miss.
  47. Resource: Book on SAP integration with SQL Server
  48. Looking for a new way to browse the Web instead of just links
  49. Microsoft BI Video
  50. SQL Server Service Pack Roadmap
  51. Think you are a Excel Guru? Why don’t you check for yourself
  52. Time really flies when you have fun
  53. SQL Server Fast Track DW Seminar by HP
  54. TSQL Tips – Modifying text in rows
  55. Off Topic – but useful none the less – Win 7 Trick
  56. SQL Server Integration Services (SSIS) Best Practices

2009 49

  1. SQL Server 2008 Enterprise and DW Optimisations
  2. Really Scale with SQL Server 2008 R2
  3. SQL Server 2005 Users
  4. Want to try PowerPivot for Excel 2010, but don’t have access to Excel 2010
  5. PowerPivot (NOV CTP) for Excel 2010 (Beta) Now Available
  6. SQL Server 2008 R2 – November CTP now Available
  7. Top Tips for Effective Database Maintenance
  8. SQL Pass Announcements - New SQL Server 2008 R2 Editions
  9. Whitepaper: High Availability with SQL Server 2008
  10. Whitepaper: Consolidation Using SQL Server 2008
  11. Project Gemini has got an official name – PowerPivot for Excel 2010
  12. Want to take control of your SQL Server Environment?
  13. Application and Multi-Server Management features in SQL Server 2008 R2
  14. Achieving High Availability with SQL Server 2008
  15. Cumulative Update #7 for SQL Server 2008 RTM
  16. Looking to save money $$$ Want to Consolidate your SQL Server environment?
  17. Teched Australia 2009
  18. From the Ground to the Sky – SQL Azure Migration Wizard
  19. Running SQL Server 2008 on Windows 7 and Windows 2008 Server R2
  20. Teched Australia 2009 – Less than a month away
  21. SQL Server 2008 Clustering White Paper
  22. SQL Server 2008 Developer Training Kit
  23. Whitepaper: SQL Server 2008 Management Data Warehouse
  24. TSQL Script – Determining Default Database File & Log Path
  25. SQL Server consolidation / virtualization Presentation
  26. Happy EOFYS!!! Get Office 2007 for a Bargain Price!!!
  27. Are you thinking of implementing Oracle RAC? You might want to think again….
  28. Lower Your Database Costs with SQL Server Database Consolidation
  29. SQL Server 2008 Security Related Whitepapers
  30. Guest Failover Clustering now supported for virtualised SQL Server
  31. Converting Existing table from BLOB to Filestream
  32. Lots of SQL Server related announcements at Teched 2009 (USA)
  33. Little Off Topic - Augmented Reality & SQL Server
  34. Say good bye to performance issues in SQL Server 2008 with the aid of this whitepaper…
  35. SQL Server I/O for Thought
  36. SQL Server 2008 SP1 Released
  37. SQL Server Consolidation Resources
  38. Get Ready for Teched 2009
  39. Cumulative Update #4 for SQL Server 2008 RTM
  40. SQL Server 2008: Filestream Data & Delete Statement
  41. Reporting Services – Combining different datasets to be displayed in a single table in SSRS
  42. SQL Server 2005 Cumulative updates
  43. Download - SQL Server 2008 System View Poster!!!
  44. NEW!!! Sydney SQL Server User Group !!!
  45. Verifying if a connection to SQL Server is Encrypted
  46. How to measure SSIS component/transformation performance
  47. SQL Server CACHING & Performance Testing
  48. Microsoft is Positioned in the Leaders Quadrant by Leading Independent Research Firm
  49. Reporting Services Tip – Automating the creation of multiple charts

2008 32

  1. Merry Christmas and a Happy New Year
  2. SQL Server 2005 SP3 has been Released
  3. Upgrading to SQL Server 2008 – Technical Reference Guide
  4. SQL Server 2005 Performance Troubleshooting Resources
  5. SQL Server Application and Multi-server Private CTP - Registration
  6. Driving Insight into your data stored on Oracle
  7. Scale Up Up and Away :)
  8. FREE: SQL Server 2008 Consolidation Seminar in Sydney and Brisbane next week
  9. SQL Server 2008 Video
  10. Microsoft SQL Server Virtualisation Support Policy Updated
  11. Report Builder 2.0 for Reporting Services 2008 has released
  12. Whitepaper: Running SQL Server 2008 in a Hyper-V Environment - Best Practices and Performance Recommendations - Released
  13. SQL Server 2008 Cumulative Update 1 is release
  14. I will be Presenting at Teched 2008 - Sydney, Australia
  15. Cumulative update package 9 for SQL Server 2005 Service Pack 2 Released
  16. SQL Server 2008 Transparent Database Encryption (TDE) Tip
  17. Version 4 of SQL Server Migration Assistant Tools have been released
  18. SQL Server 2008 Desktop Background and Screen Saver
  19. Tools to help write best practice code to protect against SQL Injection attack
  20. SQL Server 2008 Release Candidate 0 Releases on June 10
  21. SQL Server 2008 and Hyper-V Support
  22. In case you were wondering.....SQL Server 2008 Change Data Capture
  23. Remix 08
  24. SQL Server 2008 Compression feature and INSERTS
  25. SQL Server 2008 Replication & Filestream
  26. New Releases by the SQL Server CAT Team
  27. How to find Analysis Services Server Version
  28. TSQL New Features in SQL Server 2008
  29. Not SQL Related - but been working on some BI things lately so I thought I would share
  30. Heroes Happen Here
  31. Microsoft Visual Studio Team System 2008 Database Edition Power Tools
  32. SQL Server 2008 Roadmap Clarification & Heroes Unite {2008} Event Details

2007 13

  1. SQL Server 2005 Post SP2 Cumulative Update 5 is released
  2. One good reason to download and install November CTP of Katmai (especially lazy coders like me :))
  3. More Goodies on SQL Server 2008
  4. SQL Server 2008 November CTP has released!!!
  5. Finally Got around to something about SQL Server 2008
  6. SQL Server 2005 Post SP2 Cumulative Updates
  7. Something not quite SQL Related
  8. Great Resource for SQL Server Related Information
  9. Windows Server 2008 Rockin
  10. Pre-req for SQL Server Clustering Installation
  11. SQL Server Compact Edition v3.5 Management
  12. Watch Out Pt 1 - Ensure you utilise appropriate data types and use explicit CAST/CONVERT in queries
  13. Shri