7 Reasons Why Migrating Off SQL 2005 is a Good Idea

While end of support for SQL Server 2005 SP4 came on April 12th 2011, end of extended support for SQL Server 2005 happens on 12 April 2016. That means no help and no more hotfixes from Microsoft in regards to any data still living in SQL 2005 databases. Further details in regards to this can…

0

What You Should Consider When Upgrading to SQL Server 2014

Support for SQL Server 2005 comes to an end April 12 2016. Organizations should now start planning to upgrade their databases to SQL Server 2014. While it is SQL 2005 that is retiring, the reality is, there are still SQL Server 2000 databases that are still operational even though they have not been supported by Microsoft since 2013. In fact,…


Step-By-Step: Building a System Center Virtual Machine Manager Lab - Part 1

Curiosity has gotten the best of me recently and this time around System Center Virtual Machine Manager (SCVMM) has peaked my interest.  The following is a quick overview of what has been created thus far: Prerequisites A physical server with at minimum 8 (prefer 16) GBs of RAM.  This is above the minimum system requirements but…


Step-By-Step: Building A System Center Virtual Machine Manager Lab Part 1

*This post was authored by Garth Gorling. Correction of author is forthcoming Virtualization, and more specifically Hyper-V , is awesome.  While I am knowledgeable about Hyper-V, I'm always interested in learning more.  I'm interested in having separate, isolated networks.  I want users to be able to create VMS in one IP space but not another. …

1

Étape par Étape: Déploiment des Lync Services de Surveillances

Des modifications importantes ont été apportées à l’infrastructure de surveillance de Microsoft Lync Server 2013, à commencer par la suppression du rôle Serveur de surveillance qui est intégrer directement sur les Front-ends. Lync Server 2013 vous permet de surveiller deux différents types de données : les données d’enregistrement des détails des appels (CDR) et les…


Step-By-Step: Deploying Lync Server 2013 Monitoring

Recently, significant changes have come to the Microsoft Lync Server 2013 surveillance infrastructure. Starting with the removal of the monitoring server role that is directly integrate on the frontends. Lync Server 2013 allows you to monitor two different types of data: the data for registration of the details of the calls (CDR) and quality of…


Step-By-Step: Creating a SQL Server 2012 AlwaysOn Availability Group

One of the most talked about (and now frequently requested) feature in SQL Server 2012 is AlwaysOn Availability Groups. It brings SQL Server high availability and disaster recovery to a whole new level by allowing multiple copies of the database be highly available and potentially using them for read-only workloads and offloading management tasks such…


Further Innovations Defined in Windows Server 2012 R2

In numerous previous posts we at CANITPRO.NET have covered many facets of the upcoming new Windows Server 2012 R2 release.  From people centric innovation to enhancement in virtualization capabilities, Windows Server 2012 R2 will be a great addition to Microsoft’s vast ecosystem.  Recently, Microsoft’s Server and Cloud platform team made announcements of additional functionality that will be made available…

0

Step-By-Step: Backing Up SQL Databases to Azure

While delivering an CANITPRO Camp not to long ago, an IT administrator shared his story as to why he had decided to move his organization's SQL backup to the cloud.  It seemed that his predecessor was very diligent in switching the backup tapes every morning.  He insured backups were created daily, weekly and monthly as well and…


The “SQL Guy” Post # 30: How to Recover from a Lost SA Password in SQL Server 2012

Working at Microsoft provides many opportunities to receive pearls of wisdom from individuals at other parts of the organization.  Saleem Hakani sent along this little gem a few days ago and I wanted to share it with you.  It outlines how to recover an SA password if you forgot it – though you do need…

2