Knowledge Base
Search Results ...
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[.....]
Developing SSIS Frameworks for Package Logging and Alerts
SQL Server Integration Services (SSIS) is a critical component in the Microsoft SQL Server 2012/2014 database suite, enabling the development of high-performance data integration and workflow solutions. A robust SSIS framework not only facilitates the exec[.....]
DB2 Identity Columns vs SQL Server Sequences
In the world of databases, the means of generating unique, sequential values can be crucial for various applications. Two such methods of generating these values are DB2 Identity Columns and SQL Server Sequences. This blog post will delve into each of thes[.....]
Auditing Access to Sensitive Tables with Triggers and SQL Audit
Securing access to sensitive data is a key priority for any organization. One way to ensure data security is by auditing access to sensitive tables. SQL Server 2012, SQL Server 2014, MySQL 5.6, DB2 10.5, and Azure SQL provide robust tools for auditing acce[.....]
Migrating SQL Server Workloads to Azure VMs (Pre-MI Era)
In recent years, the shift towards cloud computing has been rapidly gaining momentum and many companies are migrating their SQL Server workloads to Azure Virtual Machines (VMs). This transition can provide numerous benefits including cost savings, scalabil[.....]
Modern Disaster Recovery Testing in a Hybrid Cloud World
Welcome to our SQLSupport.org blog. Today, we will be discussing modern disaster recovery testing in the complex, hybrid cloud world. As IT environments evolve and become more complex, disaster recovery testing becomes even more critical to ensure business[.....]
PostgreSQL vs SQL Server for Medium-Scale Applications
In the world of database management, decisions about which database system to use can significantly impact the performance and efficiency of your applications. Today, we will focus our comparison on two big players in the industry: PostgreSQL and SQL Serve[.....]