Adding new files to a log-shipped database (SQL Spackle)
Freshly minted MCM Wayne Sheffield fills a log shipping crack that could otherwise cause you to re-initialize your log shipping.
2024-10-11 (first published: 2013-06-06)
5,964 reads
Freshly minted MCM Wayne Sheffield fills a log shipping crack that could otherwise cause you to re-initialize your log shipping.
2024-10-11 (first published: 2013-06-06)
5,964 reads
Learn how to create a comma separated list of values in this short SQL Spackle article by Wayne Sheffield.
2024-08-09 (first published: 2011-01-12)
46,653 reads
Learn how to use the SQL Server Agent Alerting system to capture Availability Group related errors and to respond to them by running jobs.
The post Availability Group issues fixed...
2020-08-17 (first published: 2020-08-06)
976 reads
Learn how to use the SQL Server Agent Alerting system to capture Availability Group related errors and to respond to them by running jobs.
The post Availability Group issues fixed...
2020-08-06
379 reads
Learn how to use the SQL Server Agent Alerting system to capture Availability Group related errors and to respond to them by running jobs.
2020-08-06
79 reads
In this post, you will learn how to resolve the Kerberos Double-Hop issue and SSRS browser login when using Google Chrome to run SSRS reports.
The post Using Google Chrome...
2020-02-28 (first published: 2020-02-18)
9,862 reads
In this post, you will learn how to resolve the Kerberos Double-Hop issue and SSRS browser login when using Google Chrome to run SSRS reports.
The post Using Google Chrome...
2020-02-18
104 reads
In this post, you will learn how to resolve the Kerberos Double-Hop issue and SSRS browser login when using Google Chrome to run SSRS reports.
2020-02-18
76 reads
Are you a speaker in SQL Server topics? Come on out to Richmond, VA to speak to our user group. There are several topics that we are interested in...
2019-12-10
60 reads
Are you a speaker in SQL Server topics? Come on out to Richmond, VA to speak to our user group. There are several topics that we are interested in...
2019-12-10
62 reads
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
This week I was at PASS Data Community Summit in Seattle, and I attended...
By James Serra
(This is the third post in a three-part series on how AI is changing...
Comments posted to this topic are about the item Pay for Performance, which is...
Comments posted to this topic are about the item Helping an English Student with...
I have a table, dbo.bittest, where I am testing an application response. This has this structure:
CREATE TABLE [dbo].[BitTest] ( [insertdate] [datetime] NULL CONSTRAINT [DF__BitTest__insertd__300F11AC] DEFAULT (getdate()), [a] [bit] NULL ) ON [PRIMARY] GOMy application runs this code:
INSERT dbo.BitTest
(
insertdate,
a
)
VALUES
(DEFAULT, 'true')
GO
See possible answers