Some handy URL for SQL Maintenance

2 Handy SQL Scripts

USE master

    DB_NAME(dbid) as DBName,
    COUNT(dbid) as NumberOfConnections,
    loginame as LoginName
    dbid > 0
    dbid, loginame

The Tool that is love is SP_Blitz

Do need to do some SQL Maintenance, i have for you some handy URLs:

Azure AD Connect Adds Support for Windows Server 2016 and SQL 2016

If you’re a customer who uses Azure Active Directory Connect, you’ll want to know that Microsoft just released version 1.1.343.0, which adds support for Windows Server 2016 and SQL Server 2016 and fixes some bugs.

– Added support for installing Azure AD Connect on Windows Server 2016 standard or better.
– Added support for using SQL Server 2016 as the remote database for Azure AD Connect.
– Added support for managing AD FS 2016 using Azure AD Connect.

Fixed issues:
– Sometimes, installing Azure AD Connect fails because it is unable to create a local service account whose password meets the level of complexity specified by the organization’s password policy.
– Fixed an issue where join rules are not re-evaluated when an object in the connector space simultaneously becomes out-of-scope for one join rule and become in-scope for another. This can happen if you have two or more join rules whose join conditions are mutually exclusive.
– Fixed an issue where inbound synchronization rules (from Azure AD) which do not contain join rules are not processed if they have lower precedence values than those containing join rules.

Keeping WSUS Happy using PowerShell

Some time ago i found a great WSUS cleanup script. I used this at my demo lab and customer sites. WSUS need a little help Winking smile

  • Someone need to deny all patches that are superseeded, this does not happen automatically.
  • Someone needs to cleanup old content, computers, patches and such, this does not happen automatically.
  • Someone needs to care for the database, this does not happen automatically.


The script will do the following

Connect to a database

you might need to change this in the script.

#For Windows Internal Database, use $WSUSDB = ‘\\.\pipe\MICROSOFT##WID\tsql\query’
#For SQL Express, use $WSUSDB = ‘\\.\pipe\MSSQL$SQLEXPRESS\sql\query’

Get the Superseeded Updates

Here is the Posh that fixes that:

$SuperSeededUpdates = Get-WsusUpdate -Approval AnyExceptDeclined -Classification All -Status Any | Where-Object -Property UpdatesSupersedingThisUpdate -NE -Value ‘None’ -Verbose
$SuperSeededUpdates | Deny-WsusUpdate –Verbose

Cleanup WSUS

We run each step sepratly, however, you can change that and run everything in one line…

Cleanup the DB

Last part runs sqlcmd using a .SQL file from MSFT Gallery, and yes, you can download and install the PowerShell tools for SQL and use that instead. Most of your customers dont have thoose tools installed, so sqlcmd.exe it is


Skype for Business 2015 Planning Tool

The Skype for Business Team released Skype for Business 2015 Planning Tool. This tool asks you a series of questions about your organization and the features that you are interested in. The planning tool will then use your answers to recommend a topology based on the tested Skype for Business 2015 user model.
Your organization may have a different user model. If so, you should adjust the recommended topology as necessary to fit your organization’s needs.
What’s in the Planning Tool for Skype for Business 2015?

  • The Planning Tool now allow user to have up to 10 sites, including central site and disaster recovery site
  • The Planning Tool offers capacity guidance for Skype for Business Server 2015 new and updated features listed below.
  • You can answer the questions about these features in the Planning Tool, and then the suggested topology will contain information for those features, e.g hardware, network, DNS, certificate, IP, etc, according to the Skype for Business 2015 user model.
    • Persistent Chat
    • Archiving with Exchange integration
    • Mobility
    • Multi-view Video
    • SQL AlwaysOn
    • High Availability and Disaster Recovery
    • Office Web Apps
    • Exchange Mailbox
  • Skype for Business Server Planning Tool 2015 allows you to specify IPv6 IP addresses
  • Planning Tool identifies the IP conflicts across sites in the suggest topology. You can then choose to show or hide IP conflict in the topology
  • Planning Tool offers more user-friendly FQDN/IP/Port editing dialog
  • Planning Tool updates the suggested hardware requirements, DNS, and certificates with Skype for Business Server 2015 changes
  • Planning Tool updates the planning steps and deployment steps with Skype for Business Server 2015 changes
  • Planning Tool offers better support for accessibility requirements
  • Skype for Business Server Planning Tool 2015 offers improved export of Visio and Excel files. An exported Visio file matches the suggested topology diagram in the Planning Tool as well
  • Planning Tool no longer supports the following features:
    • Virtualized server design
    • Export the Planning Tool file to Topology Builder

Get it:


Exchange Administrator’s toolkit

There are lots of tools for Exchange Server available, you can find most of them at the Exchange Server Wiki (some of the tools listed are for previous versions of Exchange).

Here is a short selection from the vast collection available:

MAP Toolkit 8.0 Beta released

The MAP Toolkit team announced that MAP Toolkit 8.0 beta is available. MAP Toolkit 8.0 beta has rich feature set to plan and prepare your environment to adopt next wave of Microsoft products and cloud services. The MAP Toolkit has readiness assessments that range from desktop to cloud — Windows 8 to Windows Azure.

The MAP Toolkit 8.0 Beta program is open for general testing today and you need to register to download and try MAP Toolkit 8.0 beta in your environment as you prepare your IT infrastructure to evaluate and deploy the latest Microsoft products and cloud services.

MAP Toolkit 8.0 Beta is available for download here

MAP Toolkit 8.0 has completely revamped modern user interface, which provides easy and clear access to assessment scenarios supported in MAP Toolkit and assessment summaries and results. If you have used a prior version of the MAP Toolkit, you will find MAP Toolkit 8.0 much easier and simpler to navigate, find and run assessment scenarios you are interested and review the assessment results.


Following are some of the key assessment scenarios in the MAP Toolkit 8.0:

Windows Server 2012 Readiness

MAP 8.0 Beta assesses the readiness of your IT infrastructure for deploying Windows Server 2012. This assessment includes detailed and actionable recommendations indicating which machines meet Windows Server 2012 system requirements and which may need hardware updates. A comprehensive inventory of servers, operating systems, workloads, devices, and server roles is included to help in your planning efforts.

Windows 8 Readiness Assessment

MAP 8.0 Beta assesses the readiness of your IT environment for a Windows 8 deployment. This assessment evaluates your existing hardware against the recommended system requirements for Windows 8. It provides recommendations detailing which machines meet the requirements and which may need hardware upgrades.

Office 2013 and Office 365 Readiness Assessments

MAP 8.0 Beta assesses readiness for Office 2013 and provides an in-depth assessment of client desktops for upgrading or migration. It also offers support for Office 365 features such as web apps, Exchange Online, SharePoint Online, or full Office 365 client support.

Windows Azure Virtual Machines Migration Recommendation

MAP 8.0 Beta performs a comprehensive assessment of Windows Server and Linux machines to determine if a migration to Windows Azure Virtual Machines is possible. The toolkit then offers suggested changes to prepare the machines for migration. Key features help you reduce the operating costs of hosting on-premise servers as well as estimating the required size and monthly network and storage usage required to migrate on-premise Windows and Linux servers to Windows Azure Virtual Machines using the data from the environment.

Software usage assessment for Lync

MAP 8.0 Beta’s Lync Enterprise and Usage Tracking feature counts the number of Lync Enterprise/Plus users as well as device activities for determining the number of required client access licenses (CAL). For Lync 2010, MAP provides a server inventory and software usage by device and user for Lync Standard features. MAP’s updated Software Usage Tracking feature provides consistent software usage reports for key Microsoft products including Windows Server, SQL Server, System Center, Forefront Endpoint Protection (FEP), and Lync.

Starting today, beta program will be open for six weeks and will end on Dec 14th, 2012. You can participate in beta by downloading and running MAP Toolkit 8.0 beta in your environment.

MAP Toolkit 8.0 Beta is available for download here

Microsoft Assessment and Planning (MAP) Toolkit 7.0 Now Available

Get ready for Windows Server 2012 with the Microsoft Assessment and Planning (MAP) Toolkit 7.0. The latest version of the MAP Toolkit adds several new planning scenarios that help you build for the future with agility and focus while lowering the cost of delivering IT. Download MAP 7.0 and begin planning your server deployments today!

New capabilities allow you to:

· Understand your readiness to deploy Windows Server 2012 in your environment

· Determine Windows 8 readiness. For more info, see this blog post.

· Investigate how Windows Server and System Center can manage your heterogeneous environment through VMware migration and Linux server virtualization assessments

· Size your desktop virtualization needs for both Virtual Desktop Infrastructure (VDI) and session-based virtualization using Remote Desktop Services. For more information, see these blog posts.

· Ready your information platform for the cloud with the SQL Server 2012 discovery and migration assessment. For more info, see this blog post.

· Evaluate your licensing needs with usage tracking for Lync 2010, active users and devices, SQL Server 2012, and Windows Server 2012. For more information, see this blog post.

Download MAP 7.0 now from

VM Advanced ISO. Free Tools For Advanced Tasks

Kendrick Coleman has compiled a CD with FREE TOOLS for virtual machines within your VMware environment. All of the tools in this package were pooled together for performing advanced tasks to optimize performance, reclaim lost space, and clean up your virtual machine.


Without further ado here is what is packaged in VM Advanced v0.8 (510MB):

  • FoxitPortablePDF
  • 01 – P2V Clean-up
    • 01 – Resolution Resize
    • 02 – HP ProLiant Cleaner
    • 03 – Remove Non Present Devices
      04 – Rename Local Area Connection
    • 05 – Network Settings
    • 06 – Dell Cleanup
  • 02 – Hal Upgrade-Downgrade
    • 01 – HAL_Toggle <- UPDATED
  • 03 – Partition Alignment
    • 02 – mbrtools (only how-to is provided) <-REMOVED, Use UBERAlign
    • 04 – Paragon Alignment Tool 2.0 (free tool for limited time but cannot distribute within ISO) <-REMOVED, Use UBERAlign
  • 03 – VDI Performance
    • 01 – VM Check Partition Alignment
    • 02 – Aligning VMDK Partition For Template
    • 03 – Quest Desktop Optimizer
  • 04 – Reclaim Space
    • 01 – SDelete
  • 05 – Analysis
    • 01 – IOPS w/ IOmeter
    • 02 – LoadStorm
    • 03 – NetworkPerformance
      • 01-  iperf
      • 02 – PSTools <- New
  • 06 – SysprepFiles
    • 01 – vCenterSysprep
    • 02 – vCloudSysprep
  • 07 – Virtual Router
    • FreeSCO
  • 08 – Floppies
    • 01 – LSI_Logic_Parallel_WinXP_x86
    • 02 – Bus_LogicParallel_WinXP_x86

  • 09 – vSphere Client
  • 10 – Security
    • 01 – Angry IP Scanner
    • 02 – Blues Port Scanner
    • 03 – NetworkActiv PortScanner
    • 04 – PuTTY
    • 05 – HijackThis
  • 11 – SQL Native Client
    • 01 – SQL Native Client
  • 12 – ISO Creation <- New
    • 01 -Folder2Iso

Download Here:
VM Advanced v0.8 ISO

Microsoft Deployment Toolkit (MDT) 2012 – RTM

A couple of hours ago, Microsoft released MDT 2012

In contains numerous bug fixes as well as support for SCCM 2007 and SCCM 2012.

Improvements for All MDT Technologies

The MDT improvements that affect all MDT technologies, which are discussed in a subsequent section, are as follows:

  • Support for upgrading from previous versions of MDT
  • Integration with security and compliance templates generated by Microsoft Security Compliance Manager (SCM) version 2.0
  • Run Windows PowerShell™ scripts within an MDT task sequence
  • Create partitions to support best practice recommendations for deployment of BitLocker® Drive Encryption
  • Automatically configure participation in the Windows Customer Experience Improvement Program (CEIP) and Windows Error Reporting (WER)
  • Guidance that describes how to use Microsoft SQL Server® 2008 R2 with Service Pack 1 (SP1) for all database needs within MDT
Improvements for LTI Deployments

MDT includes the following improvements for LTI deployments:

  • Support for Windows 8 Consumer Preview and Windows Server 8 Beta. Note: The deployment of Windows Server 8 Beta roles and features using the Install Roles and Features task sequence action is not supported.
  • Support for the Windows Assessment and Deployment Kit (Windows ADK). Note: Currently, the Windows ADK is only supported for deploying Windows 8 Consumer Preview or Windows 7 in lab environments, not in production environments.

Windows ADK requires the Microsoft .NET Framework version 4.0. If not already installed, the Windows ADK installation installs the Microsoft .NET Framework version 4.0. For more information, see Introduction to the Windows Assessment and Deployment Kit.

  • Monitoring of LTI deployment process. MDT includes the new LTI monitoring feature that allows you to perform centralized monitoring of LTI deployments in the Monitoring node in the Deployment Workbench.
  • Deployment of Windows Recovery Environment (Windows RE). Windows RE helps users troubleshoot and recover from startup-related problems on their computers.
  • Deployment of Microsoft Diagnostics and Recovery Toolkit (DaRT).
  • Deployment to computers that use the Unified Extensible Firmware Interface (UEFI).
  • Deployment to computers that require the new globally unique identifier (GUID) Partition Table (GPT) format.
  • Deployment to virtual hard disks (VHDs) for native boot.
  • Support for Windows Thin PC.
  • Support for Windows Embedded POSReady 7.
  • Add local administrator accounts.
  • Deployment Wizard user experience improvements.
Improvements for Configuration Manager Deployments

MDT includes the following improvements for MDT deployments with Configuration Manager 2012 or Configuration Manager 2007 R3:

  • Support for System Center 2012 Configuration Manager. MDT includes support for System Center 2012 Configuration Manager for ZTI and UDI deployments
  • Support for new application model in Configuration Manager 2012.
  • Support for the user device affinity feature in Configuration Manager 2012.
  • Support for prestart command files.
  • Support for automatically starting a specific task sequence.
  • UDI Wizard user experience improvements.
  • The UDI Wizard has been completely revised to improve user experience.
  • UDI Wizard Designer user experience improvements.
  • The UDI Wizard Designer UI has been improved to make configuring the UDI Wizard even easier than previous versions.
  • Support for enabling BitLocker in UDI.
  • Support for MDT Replace Computer deployment scenario.
  • Localization of UDI Wizard.
  • Guidance for customizing UDI.
  • Upgrade tasks sequences created in Configuration Manager 2007 to Configuration Manager 2012.
  • Guidance for Configuration Manager 2007 R3.

Read more and download it from here 

Special thanks to Mikael Nystrom

RSA Authentication manager 7.1 Bug

RSA Authentication manager 7.1 has a nasty bug in it that I ran into recently. When running RSA Authentication Manager 7.1 on Windows it creates 1 or 2 .sql file every minute containing SQL Statements. They build up very quickly and are not removed by RSA by default. In time this could lead into serious issues like i.e. one or more of the RSA services might not be able to (re)start anymore!

clip_image001workarround until that time:
Short term solution:

· reboot the machine in safe mode

· rename the c:\windows\temp to c:\windows\temp_old

· create a fresh new c:\windows\temp

· reboot in normal mode

Long term solution:

· create a standard plain text cmd file named, for example, ‘cleanup.cmd’, and add to it the following lines: del c:/windows/temp/dbmgmt*.sql

· save the file

· launch windows scheduler and have the cmd file run once a day

You might also decide to apply 7.1 SP4. In SP4 the bug is Solved.