Blogs: SQL Server
How to Implement Expand All/Collapse All for Drill-Down in SSRS
While SSRS allows drill-down into individual groups in a Tablix, there is no built-in, direct support for an “expand all/collapse all” capability that would allow all groups to be simultaneously expanded or collapsed. No problem. We can create our own pretty easily. Here’s what it will do: The user will interact with two radio buttons. … Continue reading How to Implement Expand All/Collapse All for Drill-Down in SSRS
Working with Stepped and Block Format with SSRS
There are two ways you can format grouped data in a table data region in SSRS: You can use the stepped format or the block format. I’ll show you an example of each, how to create them, and then how to convert a group from one format to the other. I’ll also introduce group columns, … Continue reading Working with Stepped and Block Format with SSRS
Benefits in Migrating Your BI Solution to a Newer Version of SQL Server
In my experience, SQL Server is often one of the most least-upgraded components in an enterprise. You may think your company will never get off of Windows XP, but odds are you have several versions of SQL Server floating around, with no plans to upgrade them. After all, it’s often easier just to leave existing … Continue reading Benefits in Migrating Your BI Solution to a Newer Version of SQL Server
Three Tips on Choosing the Hardware for Your BI Solution
Many small- and medium-sized businesses choose to go with Business Intelligence (BI) solutions that are at least partly pre-built. That means that the biggest single factor in the system’s performance – the database schema – is often already decided and can’t readily be changed. The benefit of that approach is that you’re not paying for … Continue reading Three Tips on Choosing the Hardware for Your BI Solution
Are BI Solutions Compatible with Virtualization?
As more and more small-to-medium-sized businesses (SMBs) investigate and adopt Business Intelligence (BI) solutions, one question eventually gets asked: Can we virtualize this thing? Businesses are increasingly leveraging virtualization to reduce the number of physical servers they have to maintain, to provide better availability, to enable fault tolerance and disaster recovery, and much more. BI … Continue reading Are BI Solutions Compatible with Virtualization?
How to Get SSMS to Recognize an Existing Object (Refreshing Lists in SSMS)
Ever get this message in SQL Server Management Studio (SSMS) when you’re certain that the object exists? Then it proves you right when you go ahead and execute the command anyway? Why does SSMS complain that the object doesn’t exist when it obviously does? This happens because SSMS does not monitor database changes made in … Continue reading How to Get SSMS to Recognize an Existing Object (Refreshing Lists in SSMS)
Using SQL Server Analysis Services for poorly-performing BI Systems
No matter how well-designed and –build a business intelligence (BI) system is, it’s always possible that your workload will exceed its capabilities, and you’ll end up being dissatisfied with its performance. In those cases, what can you do? Your options depend a lot on the underlying database and analysis engine; for this article, we’ll assume … Continue reading Using SQL Server Analysis Services for poorly-performing BI Systems
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
