SQL Server – read only database status
This post describes how to return the database read-only status via T-SQL .
The system view – sys.databases returns a column called...
2012-02-17
1,107 reads
This post describes how to return the database read-only status via T-SQL .
The system view – sys.databases returns a column called...
2012-02-17
1,107 reads
A typical DBA day can include a mixture of Operational, Engineering and Architectural tasks. Whilst maintaining 100% database server availability...
2012-02-15
695 reads
This post discusses some methods in configuring the Powershell default start directory
By default , the installation process will add a value...
2012-02-10
1,804 reads
Part of managing the SQL Server environment , is maintaining the latest Service Packs remain within the Product Support data range.
The...
2012-02-09
1,122 reads
This message appears in the TDP SQL dsmsched file. It’s usually associated with low levels of contiguous memory
BackupVirtualDeviceSet::SetBufferParms: Request large...
2012-02-08
3,410 reads
This post explains how to list failed SQL Server Jobs , on multiple SQL Server Instances and output the results to...
2012-02-07 (first published: 2012-02-06)
2,289 reads
This post describes how to call to add an email attachment using Powershell.
In an earlier post - SQL Server – Send email...
2012-02-07
8,251 reads
This post explains how to list SQL Server Instances installed on the current server, using the Powershell Get-ItemProperty Cmdlet.
The Get-ItemProperty...
2012-02-04
2,584 reads
To copy a table from another SQL Server Instance is easy. Create a Linked Server on the destination server and...
2012-02-02
1,002 reads
This article explains how to send an email through Powershell.
Very useful if you have a requirement to automate your scripts...
2012-01-31
1,955 reads
By Steve Jones
redesis – n. a feeling of queasiness while offering someone advice, knowing they might...
By Steve Jones
The Solutions Engineers at Redgate recently released an Introduction to Redgate Flyway Autopilot course...
The other day I came across an interesting repo on github, KubeDiagrams. What this...
Hi there to all SQL gurus So, here is the scenario. I have a...
Guys, I am facing problems when running a backup routine JOB in SQL Server,...
1, Customer table [TBLMEMBER] 's structure CREATE TABLE [dbo].[TBLMEMBER]( [TRANNO] [int] IDENTITY(1,1) NOT NULL,...
What is the result of this query in SQL Server 2022+?
select bit_count('7')See possible answers