Blogs: SQL Server
Data Warehouse or Business Intelligence BI Solution – or Both?
I’ve recently been working with a number of small- and medium-sized businesses that are preparing to jump aboard the decision support bandwagon. Several of them have been asking me questions that reveal the enormous amount of confusion in the decision support industry, such as, “do we need a data warehouse, or should we buy a … Continue reading Data Warehouse or Business Intelligence BI Solution – or Both?
Top 5 Selection Criteria for Packaged BI Systems
Small- to Medium-Sized Businesses (SMBs) enjoy a growing marketplace for packaged, SMB-focused business intelligence (BI) solutions. From all-in-one solutions that you host on your own server to Software as a Service (SaaS) cloud-based solutions that you just sign up for, the options grow every day. The lessons that huge enterprises have learned from BI over … Continue reading Top 5 Selection Criteria for Packaged BI Systems
Business Intelligence (BI) solution: SQL Server, Office, and SharePoint
Do you really need to buy a business intelligence solution in order to get business intelligence? Maybe not. If you’ve got more or less all of your data in the latest version of SQL Server, and you’re using the latest versions of Office and SharePoint, you’d be surprised what you can cobble together on your … Continue reading Business Intelligence (BI) solution: SQL Server, Office, and SharePoint
How to Use Values from Previous or Next Rows in a SQL Server Query
I recently came across a problem that required having to perform a calculation in a query that involved a value in the current row and a value in the previous row. The problem is that SQL queries perform operations on a row-by-row basis; accessing data on different rows at the same time requires the query … Continue reading How to Use Values from Previous or Next Rows in a SQL Server Query
Business Intelligence (BI) from the Cloud: Feasible or Fantasy?
As both Business Intelligence and Cloud Computing continue to be the marketing buzzwords of our day, it’s inevitable that the two would eventually come together. An increasing number of vendors are offering cloud-based business intelligence solutions, often targeting them squarely at the small- to medium-sized business (SMB). Whatever you think of “the cloud,” BI from … Continue reading Business Intelligence (BI) from the Cloud: Feasible or Fantasy?
SQL Server in Virtual Machines: Myth or Reality?
Can SQL Server live inside a virtual machine? Yes and no. There are certainly reasons to do so, such as the ease of constructing high-availability databases that don’t involve the complexity and expense of Windows Clustering (for example, using virtualization-based availability technologies from companies such as VMware and Marathon Technologies). Virtualization is the Great Consolidator … Continue reading SQL Server in Virtual Machines: Myth or Reality?
Alternating Row Colors in SSRS
Here is a simple report with alternating row colors; in this case, PaleGoldenRod and LightSteelBlue: In order to create alternating colors, we start by going to the Design tab and selecting the detail row in the tablix data region. Next, find the BackgroundColor property in the Properties Window (if you do not see the Properties … Continue reading Alternating Row Colors in SSRS
Project Management (PMP) for Executives – Introduction
Introduction Project Management (PMP) for Executives is a 9 part video training series developed by Steve Fullmer, PMP, MBA, MCT/CTT+, CDP. Steven has a global reputation as a project manager, chief technology officer, and computer systems innovator. He has authored more than 100 articles and a dozen courses in the fields of project management, productivity, business … Continue reading Project Management (PMP) for Executives – Introduction
Project Management (PMP) Leadership Skills in the 21st Century … Do you Know Your History? – November 10, 2017
The PMI Leadership triangle touts our need to develop our knowledge and application of leadership. Do you understand the leadership models of the 20th century? The 21st Century? Understanding your predecessors can assist to set your future course. On the matter of history, Mark Twain’s quote “History doesn’t repeat itself, but it does rhyme” is … Continue reading Project Management (PMP) Leadership Skills in the 21st Century … Do you Know Your History? – November 10, 2017
Principles of Decision Tree Design and Analysis in Project Management (PMP)
In this Project Management Professional (PMP) training video, learn how about Decision Trees and how to solve them with Risk Analysis. Existentialism conveys themes like the importance of choice, contingencies, and extreme situations. How do you choose when the decision is hard? (If the decision is easy, you just choose.) When the decision is hard, we … Continue reading Principles of Decision Tree Design and Analysis in Project Management (PMP)
Understand the Mind to Become a Better Project Manager – February 18, 2015
Our minds all work alike, at least biologically. Yet we are a diverse species with different motivations, opinions, perspectives, and directions. Do you understand how and why the human mind works? What makes you a great project manager? In this recording of our PMP training webinar from February 18, 2015, Steve Fullmer covers some of … Continue reading Understand the Mind to Become a Better Project Manager – February 18, 2015
Windows 10 Security – What’s New and Improved? – December 3, 2015
In this recording of our Windows 10 webinar from December 3, 2015 training, security expert Mike Danseglio presents the enhanced security features of SmartScreen, Defender and BitLocker in Windows 10 and new features such as Biometric Identification, Microsoft Passport, Device Guard and more.
Windows 10 Managing, Deploying and Configuring – December 2, 2015
In this recorded Windows 10 training webinar from December 2, 2015, Windows Server instructor Rick Trader presents the deployment and management of Windows 10 Enterprise and the new Provisioning capability in Windows 10. Learn how to manage Windows 10 deployments using System Center Configuration Manager, Mobile Device Management and Intune. Also included in his presentation … Continue reading Windows 10 Managing, Deploying and Configuring – December 2, 2015
A Simple Introduction to Cisco CML2
Mark Jacob, Cisco Instructor, presents an introduction to Cisco Modeling Labs 2.0 or CML2.0, an upgrade to Cisco’s VIRL Personal Edition. Mark demonstrates Terminal Emulator access to console, as well as console access from within the CML2.0 product. Hello, I’m Mark Jacob, a Cisco Instructor and Network Instructor at Interface Technical Training. I’ve been using … Continue reading A Simple Introduction to Cisco CML2
Creating Dynamic DNS in Network Environments
This content is from our CompTIA Network + Video Certification Training Course. Start training today! In this video, CompTIA Network + instructor Rick Trader teaches how to create Dynamic DNS zones in Network Environments. Video Transcription: Now that we’ve installed DNS, we’ve created our DNS zones, the next step is now, how do we produce those … Continue reading Creating Dynamic DNS in Network Environments
Cable Testers and How to Use them in Network Environments
This content is from our CompTIA Network + Video Certification Training Course. Start training today! In this video, CompTIA Network + instructor Rick Trader demonstrates how to use cable testers in network environments. Let’s look at some tools that we can use to test our different cables in our environment. Cable Testers Properly Wired Connectivity … Continue reading Cable Testers and How to Use them in Network Environments
