Microsoft White Paper – SQL Server 2016 and Windows Server 2016 Better Together

Home > Blogs > SQL Server

Blogs: SQL Server

Microsoft White Paper – SQL Server 2016 and Windows Server 2016 Better Together

0 0

SQL Server 2016 and Windows Server 2016 Better Together Technical white paper (April 2016) published by Microsoft “Microsoft is pushing the limits of hardware capabilities and bringing the latest enterprise technologies to market. Both products are offering improvements to availability and disaster recovery features, providing an unprecedented level of interoperability in a variety of environments.” … Continue reading Microsoft White Paper – SQL Server 2016 and Windows Server 2016 Better Together

SQL Server Blogs

How to Display the Elapsed Processing Time of a Report in SSRS

3 1

The amount of time it takes to process a report can be useful information for performance auditing. Although there isn’t a built-in field in SQL Server Reporting Services that holds the elapsed processing time, it’s easy to create this functionality using the ExecutionTime built-in field and the Now VB.Net function in SSRS. For instructor-led SQL … Continue reading How to Display the Elapsed Processing Time of a Report in SSRS

Microsoft Second Shot Exams Are On!

0 0

Plenty of IT professionals are looking to start or expand their certifications. If you’re interested in pursuing Microsoft certification, now is a great time! Microsoft periodically runs a Second Shot promotion. What it means is that if you don’t pass your first attempt at an exam, Microsoft gives you a free retake of that exam. … Continue reading Microsoft Second Shot Exams Are On!

Optional Parameters in SSRS

6 3

Let’s say you have a report, like a sales report that shows sales orders, and some people who run that report need it to show only the one sales order that they specify while others need to see all sales orders. In this article, I’ll show you how to create an optional parameter that allows … Continue reading Optional Parameters in SSRS

A Real-World Example of a Non-Correlated SELECT Subquery and Cross Join

0 2

I recently developed a solution to a problem that is a good example of a non-correlated subquery in a SELECT clause that can also be written as a cross join. I’ll describe the requirement, the data, and then the solution with a non-correlated subquery and another with a cross join. To keep my client and … Continue reading A Real-World Example of a Non-Correlated SELECT Subquery and Cross Join

Repeating and Freezing Column Headers in SSRS Tables

9 3

In this article I’ll show you how to configure a table tablix to both repeat column headers at the top of every page and freeze them while scrolling. While tablixes have properties for these things, they only work in matrix tablixes but not in tables. I’ll show you a way to accomplish these things using … Continue reading Repeating and Freezing Column Headers in SSRS Tables

How to Name Worksheets When Exporting SSRS reports to Excel

4 1

Let’s say we have the following report that shows total sales by product category by territory: When we export this report to Excel, we’d like each territory to appear in its own worksheet and each worksheet named after its territory: How do we make this work? Easy! 1) Put every group on its own page, … Continue reading How to Name Worksheets When Exporting SSRS reports to Excel

Workshops / Webinars

Project Management (PMP) for Executives – Introduction

1 70 0

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

0 90 2

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)

0 51 0

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

0 88 1

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

0 94 1

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

0 440 1

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

Videos You May Like

Configuring Windows Mobility Center and How to Turn it On and Off

1 1002 1

Video transcription Steve Fullmer: In our Windows training courses, we often share information about the Windows 8.1 Mobility Center. Mobility Center was introduced for mobile and laptop devices in Windows 7. It’s present and somewhat enhanced in Windows 8. Since we don’t have mobile devices in our classrooms, I decided to take a little bit … Continue reading Configuring Windows Mobility Center and How to Turn it On and Off

How to Configure Navigation in SharePoint Publishing Sites

0 1179 3

For more SharePoint training videos in this series, see: Part 1 – Using Navigation Controls in a Collaboration Site in SharePoint Part 2 – Using Navigation Controls in a Publishing Site in SharePoint Part 3 – Configuring SharePoint Navigation in a Publishing Site – Activating the Publishing Feature Part 4 – » How to Configure Navigation in … Continue reading How to Configure Navigation in SharePoint Publishing Sites

Windows 10 Features and Navigation – December 1, 2015

0 117 1

In this recorded Windows 10 webinar from December 1,2015, Windows Instructor Steve Fullmer presents the navigation and some of the new features associated with Windows 10 including Sysinternals Tools for Windows Client, Windows core concepts, exploring Process Explorer as well as some of the features that are not yet ready for prime time but will … Continue reading Windows 10 Features and Navigation – December 1, 2015