T-SQL script to Backup database SQL Server with TimeStamp
The T-SQL script takes a full backup of all databases(System databases and user databases) in the format of DataaseName-YYYY-MM-DD-HH-MM-...
2022-01-18
41 reads
rajendragupta16
How to Change Always On availability group mode
This topic describes how to change the availability mode of an availability replica in an Always On availability group in SQL Server by usin
2022-01-17
12 reads
The SQL NULLIF function
NULLIF is a SQL function that is used to compare two columns. Use NULLIF to compare two columns and return NULL if they are equal to each ot
2022-01-17
17 reads
Troubleshoot SQL Server Backup Error Msg 3132, Level 16
This blog troubleshoots SQL Server Error Msg 3132, Level 16, State 1 while backing up SQL Database.
2022-01-17
32 reads
Troubleshoot SQL Server Backup Error Msg 3231, Level 16, State 1
When you are experiencing SQL Server Error Msg 3231, Level 16, State 1 while backing up SQL Database, it is important to troubleshoot the er
2022-01-17
469 reads
Troubleshoot SQL Server Error for backups–: Msg 3136, Level 16
Is it possible to use COPY_ONLY backup for restoring differential backups? No, if you try to do so, SQL Server raises error Msg 3136, Level
2022-01-17
53 reads
How to install PowerShell SQLServer module in a specific directory
Troubleshoot error - Install-Module: Administrator rights are required to install modules in 'C:Program FilesWindowsPowerShellModules.'
2022-01-13
47 reads
Troubleshoot PowerShell-No match was found for the specified search criteria,module FailoverClusters
Troubleshoot PowerShell-No match was found for the specified search criteria, module FailoverClusters
2022-01-13
42 reads
SQL Database Error - BACKUP LOG cannot be performed because there is no current database backup
SQL Database Error - BACKUP LOG cannot be performed because there is no current database backup
2022-01-12
24 reads
Troubleshoot “Database might contain bulk-logged changes that have not been backed up” in SQL Server
Troubleshoot “Database might contain bulk-logged changes that have not been backed up” in SQL Server
2022-01-12
130 reads
Blogs
Resetting on the AI hype train
By Brian Kelley
There's a great article from MIT Technology Review about resetting on the hype of...
A New Word: Etherness
By Steve Jones
etherness – n. the wistful feeling of looking around a gathering of loved ones,...
Vibe Coding a Login Tracking System
By Steve Jones
A customer was asking about tracking logins and logouts in Redgate Monitor. We don’t...
Forums
The Max PK Length
Comments posted to this topic are about the item The Max PK Length
My experience using the GitHub Copilot in SSMS 22
Comments posted to this topic are about the item My experience using the GitHub...
The Microsoft SQL Year in Review
Comments posted to this topic are about the item The Microsoft SQL Year in...
Question of the Day
The Max PK Length
If I create a multiple column Primary Key constraint, what is the most number of bytes I can include in the constraint?
See possible answers