Connect to SQL Server
In this article we look at the different ways to connect to various SQL Server services using tools like SSMS, BCP, SQLCMD, PowerShell and more.
2021-02-12
ssms
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
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
4,057 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
Blogs
Learn Better: Pause to Review More
By Brian Kelley
If you want to learn better, pause more in your learning to intentionally review.
Azure SQL Managed Instance Next-Gen: Bring on the IOPS
By John
If you’ve used Azure SQL Managed Instance General Purpose, you know the drill: to...
SQL, MDX, DAX – the languages of data
By DataOnWheels
Ramblings of a retired data architect Let me start by saying that I have...
Forums
Two foreign keys to the same table. Can't cascade deletes.
Not sure if this is really a relational theory question but it seems about...
Connecting Power BI to SSAS and effective user not working
Hi everyone, Below is a consolidated summary of what we validated Architecture & data...
High Availability setup - has anyone seen this method?
Hi all, I recently moved to a new employer who have their HA setup...
Question of the Day
Encoding URLs
I have this data in a SQL Server 2025 table:
CREATE TABLE Response ( ResponseID INT NOT NULL CONSTRAINT ResponsePK PRIMARY KEY , ResponseVal VARBINARY(5000) ) GOIf I want to get a value from this table that I can add to a URL in a browser, which of these code items produces a result I can use? See possible answers