SQL Server Management Studio Connection to Integration Services Error Class Not Registered
In this article we look at some reasons why you cannot connect to SSIS using SQL Server Management Studio and how to solve the problem.
How Many Databases Can You Name?
There is a huge number of databases available. How many could you name? Create our list and then compare to our list of well over 100 databases!
Removing Extended Properties
With the new labeling and classificiation options in SQL Server, there might be a need to remove these labels before deploying the database.
Research on the Changing Workplace
The workplace is certainly changing with the COVID-19 pandemic. Steve shares a few learnings from Microsoft's work from home experiment.
Install SQL Server Integration Services in Visual Studio 2019
Learn the step by step process to install SQL Server 2019 Integration Services in Visual Studio as well as the history for the tool.
Tracking use of Deprecated SQL Server Features
Phil Factor explains how to use SQL Prompt, or SQL Change Automation, to detect use of deprecated SQL Server syntax, during development, and Dynamic Management Views and Extended Events to track its use on working databases.
Honorifics in the 21st century
As data professionals, we should understand how language and forms of address can impact our data model. In the 21st century, we should also learn how to communicate with colleagues in a respectful and professional manner.
Blogs
In Memory of Andrew Clarke, AKA Phil Factor
By Steve Jones
One of the parts of getting older that really sucks is I seem to...
Leading Through the Noise: Harnessing Data in the Age of Digital Overload
By Chris Yates
The New Leadership Frontier In today’s digital landscape, leaders are no longer just visionaries....
A New Word: Anderance
By Steve Jones
anderance – n. the awareness that your partner perceives the relationship from a totally...
Forums
taking the rcsi dive
Hi, we put together an extract that runs every 15 minutes against what i...
Parameter Sensitive Plan Optimization in SQL Server 2022
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization in...
Minimum Change Tracking Retention
Comments posted to this topic are about the item Minimum Change Tracking Retention
Question of the Day
Minimum Change Tracking Retention
If I am running this code:
ALTER DATABASE AdventureWorks2017 SET CHANGE_TRACKING = ON (CHANGE_RETENTION=xxx);What is the minimum amount of time I can set? See possible answers