Third Party Backup Tools – Redgate SQL Backup
To continue my little blog series on SQL Server backups, any series would not be complete without a look at...
2010-04-15
2,916 reads
To continue my little blog series on SQL Server backups, any series would not be complete without a look at...
2010-04-15
2,916 reads
Aaron Nelson (Blog|@SQLvariant) is hosting this months #TSQL2sDay with the theme of reporting. My post looks at some of things...
2010-04-13
673 reads
This process might not be granular enough for some but there is a nice simple way of creating a role...
2010-04-12
36,704 reads
I didn’t post my professional goals for the year on my blog at the start of this year, my blog...
2010-04-08
678 reads
For reason's beyond the scope of this post I needed to uninstall a 64 bit version of SQL server standard...
2010-04-06
2,481 reads
My last few posts have been backup orientated, I have a post on Full Backup, a post on Transaction Log...
2010-04-04
1,311 reads
One of my aims at the start of the year was to improve my Powershell and scripting skills. I run...
2010-04-01
1,145 reads
I recently posted a couple of scripts that backup all databases on your SQL Server instance to disk with a...
2010-03-31
1,271 reads
Today I discovered, from a post on the forums and a follow up dig into BOL that sp_change_users_login is to...
2010-03-30
5,810 reads
I have seen many forum posts asking how do you schedule backups for SQL Express databases and the answers always...
2010-03-29
1,710 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