Zen and the Art of SQL Server Maintenance

A blog about SQL Server.

New Video on Internet of Things (IoT) for Healthcare

  New Video on Internet of Things (IoT) for healthcare...

Date: 01/26/2016

Internet of Things (IoT) for Healthcare Using Arrow DragonBoard 410c

Internet of Things for Healthcare Using Arrow DragonBoard 410c...

Date: 12/30/2015

Internet of Things (IoT) Overview

https://channel9.msdn.com/Blogs/mwilmot/Internet-of-Things-IoT-Overview...

Date: 12/30/2015

Internet of Things (IoT) for Healthcare with Azure and Power BI

This link is a video that details how to simulate data for asthmatic patients with Visual Studio and...

Date: 11/14/2015

Internet of Things (IoT) for Mining

Here is a video on the Internet of Things by Microsoft/Avanade/Accenture for the mining industry. It...

Date: 11/13/2015

Healthcare IoT in Azure

Internet of Things (IoT) and Healthcare in Azure. Simulating several asthmatic patients monitored by...

Date: 11/13/2015

Installing and Configuring PowerPivot, Power View, and the BI Semantic Model in Azure ( IAAS ) [@smithmattc]

Just published a blog post on how to setup and configure Power Pivot in SharePoint on Azure IAAS by...

Date: 10/06/2014

SQL Server 2014 New Features

SQL 2014 New Features Mission Critical Memory-Optimized Tables Memory-optimized, integrated database...

Date: 05/02/2014

SQL Server 2012 Power View

Here is a post on one of the coolest BI features in SQL 2012. Power View !!! Leverages BI Semantic...

Date: 01/16/2012

SQLShorts: Installing and Configuring PowerPivot, Power View, and the BI Semantic Model ( BISM )

   ...

Date: 01/14/2012

SQLShorts : AlwaysOn Availability Group Configuration for SQL 2012

Here is a short video on SQL Server 2012 Availability Group Configuration:...

Date: 12/13/2011

SQL Server 2012 Training Videos on Channel9.MSDN.COM

  PowerPivot and Power View Lifecycle and BI Semantic Model (BISM) Overview...

Date: 12/10/2011

Recent MSDN/Channel 9 Posts

Here are some recent posts on MSDN you may be interested in that I have worked on: Presentation...

Date: 05/11/2010

Microsoft Assessment and Planning Toolkit Extender

I have written an extender to the Microsoft Assessment and Planning Toolkit here:...

Date: 02/17/2010

SQL Server 2008 Compression T/SQL Script

Here is a script that I wrote to try to see how SQL Server 2008 compression would work against all...

Date: 01/27/2010

Windows Update Error 80072EE2

I am getting a Windows Update Error:80072EE2 when I try to run Windows Update. These steps seemed to...

Date: 12/01/2009

Telerik

Been looking for some powerful software tools that I can produce rich .NET reports with WPF and...

Date: 11/08/2009

SQL Server Resource Governor

Here is a podcast on the SQL Server Resource Governor and some related sample code. Shows examples...

Date: 10/13/2009

SQL Server Integration Services (SSIS) High Availability (some ideas I got from Steve Howard - MSFT PFE)

Recently a topic came up on SSIS High Availability. This is not a typical SSIS configuration. Steve...

Date: 10/03/2009

SQL Server Reporting Services High Availability

https://technet.microsoft.com/en-us/library/bb522745.aspx

Date: 10/03/2009

SQL Server 2000-2008 Security

Here are some security features from SQL 2000-2008 that I find relevant to SQL Server Security:...

Date: 09/30/2009

Partitioned Tables and Indexes

Here is a good article on SQL Server 2005 Partitioned Tables and Indexes.

Date: 01/28/2008

Virtual PC 2007 Console System Tray Problem Options.xml doesn't exist

I have a common Virtual PC 2007 problem with dual monitors for my SQL VMs... when I most need to use...

Date: 01/17/2008

Terminal Services Configuration Settings for SQL Server Virtual Machine

Though this article is a bit outdated, it is helpful in setting up the Terminal Services settings...

Date: 01/11/2008

SharePoint and SSRS (Reporting Services) IIS Port Conflict

I have been having trouble installing SharePoint on the same Server as SQL 2005 due to port 80...

Date: 01/10/2008

Determine SQL Server Version

Here is a nice way to determine SQL Server Version Information aside from @@version: SELECT...

Date: 01/10/2008

AdventureWorks Sample Databases for SQL 2005

Here are the AdventureWorks Samples for SQL 2005 and 2008 . Here is a good pointer to the...

Date: 01/10/2008

Determine Space Used By a SQL Server Database with sp_SpaceUsed

Here is a nice link about how to determine space consumed by a SQL Server database for each table by...

Date: 01/07/2008

VHD Resizer for Virtual Server or Virtual PC

Found this tool that is good for VHD / Virtual Hard drive / Virtual Machine resizing. I have been...

Date: 12/29/2007

SQL Server 2008 (Katmai) New Features Overview

C:\Program Files\ProClarity\ProClarity Dashboard Server\Nice article on SQL 2008 (Katmai) New...

Date: 12/29/2007

Searching for a specific table name

Here is a way to search the Information_Schema to find all tables that have the letter 't' in them,...

Date: 12/29/2007

Searching the MetaData of a SQL Server Database, Stored Procedure Text

This has been a favorite stored procedure of mine to search the text of my stored procedures for...

Date: 12/29/2007

SQL Server Unattended Install Script

Here is a SQL Server Unattended Install Script I wrote last week... was nice to get it working...

Date: 12/28/2007

Disable and Enable Constraint Checking on SQL Server Tables

Found this script to disable/enable constraint checking here : SELECT 'ALTER TABLE ' +...

Date: 12/28/2007

Using SELECT INTO to create an on-the-fly IDENTITY Column

Here is a nifty way to add an IDENTITY column on the fly... select distinct id=IDENTITY (int, 1,1),...

Date: 12/28/2007