Here is a post on one of the coolest BI features in SQL 2012. Power View !!! Leverages BI Semantic Model (BISM). Very Cool! http://channel9.msdn.com/posts/SQLShorts-SQL-2012-Power-View-on-SharePoint-2010

    http://channel9.msdn.com/posts/SQLShorts-Installing-and-Configuring-PowerPivot-Power-View-and-the-BI-Semantic-Model--BISM-     This video covers the main issues that you face in installing PowerPivot and Power View on SharePoint...

Here is a short video on SQL Server 2012 Availability Group Configuration: http://channel9.msdn.com/posts/SQLShorts--AlwaysOn-Availability-Group-Configuration-for-SQL-2012

  PowerPivot and Power View Lifecycle and BI Semantic Model (BISM) Overview http://channel9.msdn.com/posts/SQL-Shorts-PowerPivot-and-Power-View-Lifecycle-and-BI-Semantic-Model-BISM-Overview AlwaysOn SQL 2012 http://channel9.msdn.com/Blogs/mwilmot...

Here are some recent posts on MSDN you may be interested in that I have worked on: Presentation Excellence http://channel9.msdn.com/posts/mwilmot/Presentation-Excellence/ Upgrading to SQL Server 2008 R2 http://channel9.msdn.com/posts/mwilmot/Upgrading...

I have written an extender to the Microsoft Assessment and Planning Toolkit here: http://dbspider.codeplex.com/ The project is a Microsoft Assessment and Planning Toolkit Extender that leverages: The Microsoft Assessment and Planning Toolkit (MAP) SQL...

Here is a script that I wrote to try to see how SQL Server 2008 compression would work against all tables in a given database. You can try to see how PAGE vs ROW compression works and if you want to try it out on your dev environment, you can uncomment...

I am getting a Windows Update Error:80072EE2 when I try to run Windows Update. These steps seemed to help me. I don’t recommend updating your registry, but I tried it with success….   1. Click Start, open All Programs, and then click Accessories...

Been looking for some powerful software tools that I can produce rich .NET reports with WPF and Silverlight for a codeplex project I am working on (more details to follow soon). Over the years I have leveraged Telerik for their ASP.NET components while...

Here is a podcast on the SQL Server Resource Governor and some related sample code. Shows examples of classifier functions, resource pools and groups, etc.. http://channel9.msdn.com/posts/mwilmot/SQL-Server-Resource-Governor/ Here is an overview of the...

Recently a topic came up on SSIS High Availability. This is not a typical SSIS configuration. Steve Howard (Microsoft PFE) has done a lot of work on this topic and has come up with some interesting ideas. I am going to try to pass on what I learned. It...

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

Here are some security features from SQL 2000-2008 that I find relevant to SQL Server Security: Transparent Data Encryption & External Key Management & Signed Modules Auditing User/Schema Separation Change Data Capture Policy Management DDL Triggers...

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

I have a common Virtual PC 2007 problem with dual monitors for my SQL VMs... when I most need to use my Virtual PC software, often the console goes insane when using a dual monitor, and though I can limp along by using Virtual PC from the system tray...

Though this article is a bit outdated, it is helpful in setting up the Terminal Services settings for a SQL Server VM: http://www.microsoft.com/technet/prodtechnol/win2kts/maintain/optimize/secw2kts.mspx

I have been having trouble installing SharePoint on the same Server as SQL 2005 due to port 80 conflicts. If you search on "SharePoint" in SQL BOL (Books On Line) there are some good links to configure both on the same machine. Here is some initial...

Here is a nice way to determine SQL Server Version Information aside from @@version: SELECT SERVERPROPERTY ( 'productversion' ), SERVERPROPERTY ( 'productlevel' ), SERVERPROPERTY ( 'edition' )

Here are the AdventureWorks Samples for SQL 2005 and 2008 . Here is a good pointer to the AdventureWorks Sample Databases overview for SQL 2005. I also found that there is a SqlRun_Tools.msi file under the setup disk ..\Tools\Setup that willl...

Here is a nice link about how to determine space consumed by a SQL Server database for each table by Nigel Rivett: and some other useful scripts :

Found this tool that is good for VHD / Virtual Hard drive / Virtual Machine resizing. I have been running SQL Server on a VM and the performace thus far is good. The December 2007 edition of SQL Server Magazine had some good articles about virtualizing...

C:\Program Files\ProClarity\ProClarity Dashboard Server\ Nice article on SQL 2008 (Katmai) New Features: http://blogs.mssqltips.com/blogs/chadboyd/archive/2007/10/15/katmai-sql-2008-the-list-of-new-features.aspx I have attached a PowerPoint file...

Here is a way to search the Information_Schema to find all tables that have the letter 't' in them, can be helpful to search the metadata of your database schema select * from INFORMATION_SCHEMA.columns where table_name like '%t%' order...

This has been a favorite stored procedure of mine to search the text of my stored procedures for certain phrases... really helpful as the number of stored procs you have grows quite a bit: -- xps '%procedure%' --search for the word 'procedure' in all...

Here is a SQL Server Unattended Install Script I wrote last week... was nice to get it working finally!!! ;the PIDKEY will show up in greyed out text boxes during a MANUAL Install... use this for the PIDKEY Parameter IF NECESSARY (probably not necessary...