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