Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
A blog about SQL Server.
New Video on Internet of Things (IoT) for healthcare...
Date: 01/26/2016
Internet of Things for Healthcare Using Arrow DragonBoard 410c...
Date: 12/30/2015
https://channel9.msdn.com/Blogs/mwilmot/Internet-of-Things-IoT-Overview...
Date: 12/30/2015
This link is a video that details how to simulate data for asthmatic patients with Visual Studio and...
Date: 11/14/2015
Here is a video on the Internet of Things by Microsoft/Avanade/Accenture for the mining industry. It...
Date: 11/13/2015
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 2014 New Features Mission Critical Memory-Optimized Tables Memory-optimized, integrated database...
Date: 05/02/2014
Here is a post on one of the coolest BI features in SQL 2012. Power View !!! Leverages BI Semantic...
Date: 01/16/2012
...
Date: 01/14/2012
Here is a short video on SQL Server 2012 Availability Group Configuration:...
Date: 12/13/2011
PowerPivot and Power View Lifecycle and BI Semantic Model (BISM) Overview...
Date: 12/10/2011
Here are some recent posts on MSDN you may be interested in that I have worked on: Presentation...
Date: 05/11/2010
I have written an extender to the Microsoft Assessment and Planning Toolkit here:...
Date: 02/17/2010
Here is a script that I wrote to try to see how SQL Server 2008 compression would work against all...
Date: 01/27/2010
I am getting a Windows Update Error:80072EE2 when I try to run Windows Update. These steps seemed to...
Date: 12/01/2009
Been looking for some powerful software tools that I can produce rich .NET reports with WPF and...
Date: 11/08/2009
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
https://technet.microsoft.com/en-us/library/bb522745.aspx
Date: 10/03/2009
Here are some security features from SQL 2000-2008 that I find relevant to SQL Server Security:...
Date: 09/30/2009
Here is a good article on SQL Server 2005 Partitioned Tables and Indexes.
Date: 01/28/2008
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
Though this article is a bit outdated, it is helpful in setting up the Terminal Services settings...
Date: 01/11/2008
I have been having trouble installing SharePoint on the same Server as SQL 2005 due to port 80...
Date: 01/10/2008
Here is a nice way to determine SQL Server Version Information aside from @@version: SELECT...
Date: 01/10/2008
Here are the AdventureWorks Samples for SQL 2005 and 2008 . Here is a good pointer to the...
Date: 01/10/2008
Here is a nice link about how to determine space consumed by a SQL Server database for each table by...
Date: 01/07/2008
Found this tool that is good for VHD / Virtual Hard drive / Virtual Machine resizing. I have been...
Date: 12/29/2007
C:\Program Files\ProClarity\ProClarity Dashboard Server\Nice article on SQL 2008 (Katmai) New...
Date: 12/29/2007
Here is a way to search the Information_Schema to find all tables that have the letter 't' in them,...
Date: 12/29/2007
This has been a favorite stored procedure of mine to search the text of my stored procedures for...
Date: 12/29/2007
Here is a SQL Server Unattended Install Script I wrote last week... was nice to get it working...
Date: 12/28/2007
Found this script to disable/enable constraint checking here : SELECT 'ALTER TABLE ' +...
Date: 12/28/2007
Here is a nifty way to add an IDENTITY column on the fly... select distinct id=IDENTITY (int, 1,1),...
Date: 12/28/2007