When you are using SSIS, there soon comes a time when you are confronted with having to do a tricky task such as searching for particular connection strings in all your SSIS packages, or checking the execution history of scheduled SSIS jobs. You can do this type of work effectively in T-SQL as Feodor Georgiev explains.
How to change the port number for connections to SQL Server.
A lot has been written about the potential performance benefits of SQL Server data compression; but hard performance data? Not so much.
Today Steve Jones talks about the conflicting demands of home and work and how you can reconcile the requirements of both.
In this tip we cover what CONTROL SERVER is, how to detect its use and a possible way to exploit this permission.
What happens to your indexes during normal database activity?
Is the cloud good for your career? Steve Jones thinks so, and gives you a few reasons you might want to learn more about it.
SQL Server 2012 brings new security enhancements, one of which is to create user defined server roles, which simplifies instance wide administration and helps to increase the security of the instance by letting you define different groups with different sets of permissions as per their role and responsibilities.
How to grant Windows privileges to the SQL Server's service account.
By Brian Kelley
I am guilty as charged. The quote was in reference to how people argue...
By Steve Jones
Learn how to tie a bowline knot. Practice in the dark. With one hand....
By HeyMo0sh
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...
Hi everyone I asked this earlier but the desired outcome is a bit different...
Hi, I have a SQL Server instance where users connect to via Windows Authentication,...
Comments posted to this topic are about the item Multiple Deployment Processes
I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?
See possible answers