Execute SSIS Package with SQLCMD and Parameters
In this article we walk through the steps of how to run an SSIS package using SQLCMD along with passing parameters to the SSIS package.
Free eBook: SQL Server Execution Plans, Third Edition
If a query is performing poorly, and you can't understand why, then that query's execution plan will tell you not only what data set is coming back, but also what SQL Server did, and in what order, to get that data. It will reveal how the data was retrieved, and from which tables and indexes, what types of joins were used, at what point filtering, sorting and aggregation occurred, and a whole lot more. These details will often highlight the likely source of any problem.
Sharing SQL Code Snippets with Coworkers, The World and Yourself
Louis Davidson explains how he manages and shares several different sources of SQL Prompt code snippets, in a single Snippet library, using Dropbox and source control.
Scheduling SQL Scripts Using Jenkins
Learn how a Jenkins server can be used to schedule SQL scripts to execute against SQL Server.
How To Install SSAS 2019
In this article we walk through the steps to install SQL Server Analysis Services for SQL Server 2019.
The case for SQL Server Agent 2.0
SQL Server Agent is heavily used by many organizations, but it hasn't changed much in years. This article speculates on some new features that might improve the scheduler.
Are your Oracle archived log files much too small?
Oracle sometimes generates smaller archived redo logs than you might expect based on the size of the online redo logs. In this article, Jonathan Lewis explains how Oracle uses online redo logs and why there might be a discrepancy in the archived log size.
Blogs
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Who Are You Doing It For?
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
Presenting Twice in May 2026
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
Forums
degree of parallelism
Team, I'm trying to figure out what will be the best recommendation to configure...
A Fun Computer Quote
Comments posted to this topic are about the item A Fun Computer Quote
AI Database Central
Comments posted to this topic are about the item AI Database Central
Question of the Day
A Fun Computer Quote
Which movie featured this quote?
"All programs have a desire to be useful."Happy April Fools! See possible answers