If you are new to a specific platform, you may not be familiar with how it differs from what you might be used to in SQL Server. A tool like Aqua Data Studio can help to streamline development across multiple database platforms, by simplifying...
In this tip we look at how to execute the same T-SQL command for multiple SQL Server databases and including additional options to control what is run.
In this tip we look at a T-SQL script that you can use to get the latest backup information for all of your SQL Server databases. In addition, there is a PowerShell option do this for multiple servers.
In this tip we look at some additional commands that you can use to manage cron jobs that you setup on Linux to manage SQL Server tasks and other tasks.
In this tip we look at different ways to copy data from one SQL Server to another and the performance impact of doing a push or pull of data between servers.
In this tip we show how you can create additional tables and add data on the fly when building reports using Report Builder for SQL Server Reporting Services.
In this tip we look at how to include fixed data sets to be included with a Microsoft database project when deploying the project to a database server.
In our quests to always be growing and improving, both personally and professionally, here are 10 reflection areas and example questions we have identified to help you determine possible improvement focus areas to take your performance to the next level.
In SQL Server 2019 there is a lot more automation built into the system allowing you to easily add sensitive data labels to columns, which will get pulled into audits by default.
