The Curious Engineer

All blogs / Databases

Zen and the Art of SQL Server Maintenance

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

A blog about SQL Server.

DatabasesDevOps / SRE / infrastructureTech news / industryMicrosoft blogsMSDN archive

’10’15’20’25
Posts
35 from 28 Dec 2007 to 26 Jan 2016
Posting
archived, read-only
Kind
personal blog
Feed
https://learn.microsoft.com/en-us/archive/blogs/mwilmot/feed.xml

2016 1

  1. New Video on Internet of Things (IoT) for Healthcare

2015 5

  1. Internet of Things (IoT) for Healthcare Using Arrow DragonBoard 410c
  2. Internet of Things (IoT) Overview
  3. Internet of Things (IoT) for Healthcare with Azure and Power BI
  4. Internet of Things (IoT) for Mining
  5. Healthcare IoT in Azure

2014 2

  1. Installing and Configuring PowerPivot, Power View, and the BI Semantic Model in Azure ( IAAS ) [@smithmattc]
  2. SQL Server 2014 New Features

2012 2

  1. SQL Server 2012 Power View
  2. SQLShorts: Installing and Configuring PowerPivot, Power View, and the BI Semantic Model ( BISM )

2011 2

  1. SQLShorts : AlwaysOn Availability Group Configuration for SQL 2012
  2. SQL Server 2012 Training Videos on Channel9.MSDN.COM

2010 3

  1. Recent MSDN/Channel 9 Posts
  2. Microsoft Assessment and Planning Toolkit Extender
  3. SQL Server 2008 Compression T/SQL Script

2009 6

  1. Windows Update Error 80072EE2
  2. Telerik
  3. SQL Server Resource Governor
  4. SQL Server Integration Services (SSIS) High Availability (some ideas I got from Steve Howard - MSFT PFE)
  5. SQL Server Reporting Services High Availability
  6. SQL Server 2000-2008 Security

2008 7

  1. Partitioned Tables and Indexes
  2. Virtual PC 2007 Console System Tray Problem Options.xml doesn't exist
  3. Terminal Services Configuration Settings for SQL Server Virtual Machine
  4. SharePoint and SSRS (Reporting Services) IIS Port Conflict
  5. Determine SQL Server Version
  6. AdventureWorks Sample Databases for SQL 2005
  7. Determine Space Used By a SQL Server Database with sp_SpaceUsed

2007 7

  1. VHD Resizer for Virtual Server or Virtual PC
  2. SQL Server 2008 (Katmai) New Features Overview
  3. Searching for a specific table name
  4. Searching the MetaData of a SQL Server Database, Stored Procedure Text
  5. SQL Server Unattended Install Script
  6. Disable and Enable Constraint Checking on SQL Server Tables
  7. Using SELECT INTO to create an on-the-fly IDENTITY Column