Microsoft

How to get Microsoft Office 365 for your non profit organisation

November 5, 2013 Unipro2013main Featured Videos

This video webinar from Microsoft explains how a non-profit organisation can obtain the online Office 365 software suite for free.

Common SQL Server Ports and Protocols You Can Configure for Windows Firewall

October 16, 2013 Gidget Pryor Cisco, Cloudera, Featured, Professional Development, Project Management, Routing & Switching, Technology, Training in Business

Firewalls help protect the surface area of the SQL Server and prevent unauthorized access to resources. Listed below are some common SQL Server ports to configure for Windows Firewall.

Late Night with System Center Management

September 20, 2013 Brad Werner Cisco, Cloudera, Featured, Professional Development, Project Management, Routing & Switching, Technology, Training in Business

It’s 3:30 a.m. and your trusty mobile phone on your nightstand buzzes a hideous, nasty, telltale racket. You pick up the smartphone and squint in the darkness at the glowing message that informs you that one of the e-mail servers at work is down. As you’re about to dismiss the nasty-gram in your still-half-asleep daze (who would need e-mail at 3:30 in the morning?), you bolt up wide-eyed! You suddenly realize the server that’s down serves critical e-mail services for a team three time zones east of you. And, at 6:30 a.m. their time, a downed server spells near-immediate and definitely impending doom as the workforce at that facility is about to start their shift.

Ten Performance Monitor Counters to Analyze SQL Server Memory Pressure

July 12, 2013 Gidget Pryor Cisco, Cloudera, Featured, Professional Development, Project Management, Routing & Switching, Technology, Training in Business

Many experts agree that memory is the most important resource with regard to SQL Server performance. There are hundreds of performance counters, and therefore, it can be complex to figure out just what to monitor. Here are some suggestions in understanding whether memory pressure might be the performance problem with your SQL Server. You can use Performance Monitor to collect this data. You can also obtain the SQL Server specific counters using the Dynamic Management View (DMV) that is built into SQL Server. The DMV is an excellent and lightweight option for performance monitoring. You can use this syntax.

Locking, Blocking, and Deadlocks: What They Are and How They Work

July 2, 2013 Gidget Pryor Cisco, Cloudera, Featured, Professional Development, Project Management, Routing & Switching, Technology, Training in Business

There are a few terms that often are confused in SQL Server. These are locking, blocking, and deadlocks. These are all very different from each other.

Locking is a normal and desirable process. Blocking is also normal, but is less desirable. Deadlocking is not a normal process and is never desirable.