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.
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.
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.
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.
Learn how a Jenkins server can be used to schedule SQL scripts to execute against SQL Server.
In this article we walk through the steps to install SQL Server Analysis Services for SQL Server 2019.
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.
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.
As more organizations are managing at least some part of their data in the cloud, estate monitoring can become more complex with a mix of on-prem and cloud-based instances. Grant Fritchey discusses why businesses might move to the cloud, why they might stay on-prem, and when a hybrid approach might be best.
Want to build a data analytics foundation that transforms raw data into valuable business...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
By Tim Mitchell
Earlier this month, I hosted the monthly T-SQL Tuesday invitation in which I asked,...
Comments posted to this topic are about the item New article
Comments posted to this topic are about the item Monitoring Azure Blob Storage
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers