SSIS 2012 Projects: Deployment Configurations and Monitoring
The Project Deployment Model introduced in SSIS 2012 speeds up the deployment of database projects in which there may be hundreds of SSIS packages per project. Not only that, but deployments can be configured differently for each environments such as test and staging, and there are now ways of monitoring the status and performance of packages and of versioning the SSIS Catalog.
Consolidating Again and Again and Again
This editorial was originally published on November 12, 2009. It is being re-run as Steve is on holiday. Virtualization is touted as a great way to save money, but it's a one time event. Once you've consolidated a server, you can't do it again. However consolidation isn't necessarily the same and Steve Jones tells us why.
Using SQL Server Stored Procedures in SSIS Data Flow Sources
A technique to deal with lack of metadata for stored procedures when used with SSIS.
Building an Automated Database Deployment Pipeline
Data and databases are historically ignored or given a low priority within the processes of ALM and DevOps. This situation needs to change and the primary point of the changes is within the database professional part of the team.
Data Mining Part 22: Analyze the Data Mining Data with Excel
This is the last article related to Data Mining in Excel. This last chapter will cover the Analyze section.
Data Mining Part 22: Analyze the Data Mining Data with Excel
This is the last article related to Data Mining in Excel. This last chapter will cover the Analyze section.
How Often Does Production Drift?
Database drift is the difference between two database schemas. Today Steve Jones discusses the concept and wonders how often it happens.
The Salesforce Platform: The Return of the Citizen Programmer
The current popularity of the Salesforce software development platform has taken the industry by surprise. The current IT culture favours the esoteric, yet here is a development platform geared to the idea that anyone can use it: a populist language like BASIC. Does this threaten the careers of professional developers?
Blogs
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Blue Sky Programming – The Optimism Trap
Many years ago, before I joined Oracle, I was working on a major modernisation...
Setting Up a Mac for Data Engineering and AI Work
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Alamat kantor BCA KCP Galuh Mas Telp:0817866887
WhatsApp:0817-866-887 Area Street Festival, Ruko No 1 & 1A, CBD, Jl. Galuh Mas Raya,...
Is Fabric a Reliable Service or a Ripped Resource?
Comments posted to this topic are about the item Is Fabric a Reliable Service...
Question of the Day
BIT_COUNT I
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37What is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 3;See possible answers