Integration Services Security in SQL Server by Jeff Jones

Home > Blogs > Jeff Jones

Blogs for Jeff Jones

Integration Services Security in SQL Server by Jeff Jones

0 0

Defining security for SQL Server Integration Services (SSIS) is a bit complex. I want to focus on the security required by a developer to create and manage their own packages and people that are not SysAdmins but need to manage all packages.

Latest Blogs by Jeff Jones

Dynamic PIVOT by SQL Server Instructor Jeff Jones

0 0

Following are a couple of scripts. The first one generates a sum of orderqty by productid pivoted by the duedate year. The second one generate a sum and avg of orderqty by productid by the duedate year. This one must UNION two PIVOT queries into a single result set.

Renaming SQL Server

0 0

Here’s a T-SQL script you can use to rename your SQL Server after you have changed the computer name. This script will work if you are connected to the default instance or a named instance. After running the script, you must restart SQL Server for the action to complete.

Moving Logins Across Multiple SQL Servers

0 0

I wrote a set of SQL statements that creates a script of sp_addlogins to copy the passwords and SIDs across for SQL Server and another query that creates the same script for SQL Server 2005 using CREATE LOGIN.

Accessing Master Sysperfinfo Table in SQL Server

0 0

SQL Server statistics are available in a Master called sysperfinfo. Included is a SELECT statement that displays all the statistics as well as perform the necessary calculation to display ratio statistics correctly.

Moving DTS packages to a SQL Server 2005 Server by Jeff Jones

0 0

We have to do is build a very simple package that copies the rows from the dbo.sysdtspackages in SQL Server 2000 to SQL Server 2005. Define a new Integrations Services package, add a data flow to it.

SQL Server 2005 Displaying Object Owners

1 0

I wrote a query that will display the object owner for views and stored procedures whether it is owned by the schema owner (whoever that is) or is owned by an account other than the schema owner.

Workshops / Webinars

Project Management (PMP) for Executives – Introduction

0 41 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 40 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 30 0

Learn how to use Decision Trees and How to solve them with Risk Analysis in this PMP Project Management video by Steve Fullmer.

Understand the Mind to Become a Better Project Manager – February 18, 2015

0 49 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 63 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 291 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

0 419 0

Here's a video demonstration to give you some background for the Mobility Center "How do I configure it? How do I turn it on? How do I turn it off?"

Creating Users and Managing Passwords in Microsoft Office 365

0 280 2

In this Office 365 training video, instructor Spike Xavier demonstrates how to create users and manage passwords in Office 365.

Windows 10 Features and Navigation – December 1, 2015

0 59 1

In this video, 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 be released shortly in the future with Windows 10.