Simple way to find errors in SQL Server error log
In this tip we look at how to parse the SQL Server error log to only extract the errors and corresponding error messages.
2021-02-01
ssms
How to Check SQL Server Version When Service is Not Running
In this article we look at several ways to find the version of SQL Server that is installed when the SQL Server service is not running.
2021-01-12
SQL Server Management Studio Database Diagram Support Objects Cannot be Installed
In this article we look at how to resolve the error database diagram support objects cannot be installed because the database does not have a valid owner.
2021-01-01
Creating a SQL Code Snippet in SQL Prompt and SSMS
Phil Factor's "getting started" guide for turning all your trusted and most frequently used queries into SQL code snippets.
2020-11-12
Block user objects from being created in a master database
Introduction The Master database. Just in case that you are not familiar with this database, the Master database is used in SQL Server to store all the system information, instance-level settings, logon information, database file locations, etc. SQL Server can't run without access to a fully functional master database. It's highly recommended not to use […]
2020-11-10
3,916 reads
Adding Custom Stored Procedure Templates to SQL Server Management Studio and Visual Studio 2019
In this article we look at how to build a custom stored procedure template that can be used in either SSMS or Visual Studio for all new development.
2020-10-29
Top 5 SSMS Time Saving Tips
In this article we look at how you can use SSMS to filter objects, debug, drag and drop object names, add custom reports and use of operators for emails.
2020-10-15
How to Get Started with SQL Server Management Studio
Learn How to Get Started with SQL Server Management Studio with Brent Ozar.
2020-08-14
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.
2020-08-04
New release: SQL Change Automation 4.1
We’ve heard from users that they really care about static data and were missing the feature in the SQL Change Automation SSMS plugin. In v4.1, we’ve added support for the tracking of static data tables to the SSMS extension, alongside existing support in the VS extension. Maya Malakova has written a technical summary showing how to use this feature. Learn more about the release here.
2020-01-21
Blogs
The Redgate Seminar – Brisbane
By Steve Jones
On Thursday, May 2, we have the Redgate Seminar in Brisbane. I’ll be at...
Microsoft Fabric Training and Tutorials
By Brian Kelley
Microsoft Fabric is the new data offering in Microsoft Azure and there is a...
DBA and Developer: Allies or Adversaries?
By Rohit Garg
In the expansive landscape of software development, the relationship between Database Administrators (DBAs) and...
Forums
Report definition has an invalid target namespace
I'm hoping someone here has encountered this before and was able to fix it....
Query about GAC (Global Assembly Cache)
Hi everyone, So I have a SSIS package that performs some importing/exporting from MySQL...
How to check for data loss after rollback
Hello SSC, I am not a DBA,. I have some DBA knowledge, but my...
Question of the Day
Reporting Services Editions
In which editions of SQL Server 2022 can you run Reporting Services?
See possible answers