How can we balance our need to monitor SQL Server performance and operational processes across hundreds of SQL Servers, but also save time by focusing on the highest priority issues?
2021-01-13
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
In this article we look at how we can use R and SQL Server to import lottery numbers from a PDF document into a SQL Server table.
2021-01-11
The SQL Server error log is a great source of information for DBAs for monitoring errors and the operation of the server. In this article, Greg Larsen explains the details and how to configure the SQL Server error log.
2021-01-08
In this article we look at PowerShell code you can use to import Excel data into SQL Server.
2021-01-05
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
In this tutorial we will cover common questions related to the SQL Server msdb database. This is one of the standard system databases that are part of every SQL Server installation. This tutorial will give you a better idea of what the msdb database...
2020-12-29
In this article we look at the SQL Server REPLACE function and show several examples of how this can be used to replace text values in strings.
2020-12-28
In this article we walk through the steps to install SQL Server Analysis Services for SQL Server 2019.
2020-12-22
In this article we look at a PowerShell script that can help you deploy database objects to multiple SQL Server instances.
2020-12-16
Reading tutorials is fine. Shipping something is better. If you are trying to break...
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Comments posted to this topic are about the item Liability for AI Errors
Hello , I would like to run a stored procedure on a secondary replica...
Comments posted to this topic are about the item Pro SQL Server Internals
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers