Knowledge Base
Search Results ...
Migrating DTS Packages to SSIS 2016
Migrating DTS packages to SSIS 2016 can be a daunting task, particularly for databases that have been heavily invested in SQL Server 2012 or SQL Server 2014. However, with careful planning and execution, the transition can be a smooth one. This blog aims t[.....]
Introduction to Azure SQL Database: First Impressions Note from the Data Whisperer
Greetings, fellow data enthusiasts, and welcome back to SQLSupport.org. I am the Data Whisperer, and today I am excited to share my first impressions of Azure SQL Database. As many of you are already aware, Azure SQL Database is a cloud-based relational da[.....]
SQL Server Wait Stats Interpretation for Performance Tuning
In the world of SQL Server, understanding wait statistics is crucial for effective performance tuning. SQL Server uses wait statistics to track the amount of time a thread has to wait before it can get the resources it needs to execute a task. This data is[.....]
Cross-Database Joins and Security Considerations
In today's data-driven world, information is often distributed across multiple databases. This increases the complexity of querying data, as you may need to retrieve information from more than one database at a time. In SQL, this is accomplished via cross-[.....]
Using SSIS Expressions for Dynamic Connection Strings
Welcome to another post on SQLSupport.org. Today, we will be discussing a fascinating topic: Using SSIS Expressions for Dynamic Connection Strings. SSIS (SQL Server Integration Services) is a powerful tool offered in SQL Server 2012 and SQL Server 2014 for[.....]
Dimensional Modeling in Financial Reporting Systems
The modern financial reporting systems are increasingly moving towards dimensional modeling. This design concept, which structures data into a form that is easy to understand and navigate, is becoming a vital tool in financial reporting systems. This blog[.....]
Avoiding Parameter Sniffing with Optimize For Unknown
Parameter sniffing is a common behavior in SQL Server 2012 and 2014, MySQL 5.6, DB2 10.5, and Azure SQL, where the SQL Server query optimizer uses the first-executed parameter value to estimate the cost and generate an execution plan. This is usually benef[.....]
Paginated SSRS Reports with Drill-through Navigation
In this blog post, we will explore the creation of paginated SQL Server Reporting Services (SSRS) reports with drill-through navigation. We will be focusing on SQL Server 2012 and 2014, MySQL 5.6, DB2 10.5, and Azure SQL. Paginated reports are optimized fo[.....]
Using PowerShell to Document SQL Server Inventory
Maintaining a comprehensive and up-to-date inventory of SQL Server databases is essential for effective management and monitoring of your database environment. Whether you're an administrator of a small database ecosystem or a DBA managing multiple databas[.....]
Building Incremental Load Logic in T-SQL
In this blog post, we will discuss a critical aspect of ETL (Extract, Transform, Load) process: the incremental load logic in T-SQL. Incremental load refers to the process of updating a data warehouse with new data from operational databases. The goal is t[.....]