2016-02-26
172 reads
2016-02-26
172 reads
2016-02-25
172 reads
2016-02-23
156 reads
2016-02-22
144 reads
2016-02-22
349 reads
An explanation as to what Log Shipping is and why it's still a viable solution in 2016.
2016-02-18
596 reads
Passwords are always a challenge, but are bad passwords the users' fault? Steve Jones has a few thoughts.
2016-02-17
121 reads
Steve Jones talks version control, but from the production perspective.
2016-02-16
115 reads
Someone made a call to architect zero downtime for databases. Steve Jones isn't sure this is the best thing you could do.
2016-02-15
197 reads
There's a push to upgrade those SQL Server 2005 instances with support ending this April.
2016-02-12
143 reads
Recently, in an attempt to thwart leechers (1990s kids will know), I added some...
Once upon a time I had a series about some cool stuff in Snowflake:...
By Steve Jones
“Most overnight successes – in fact any significant successes – take at least 5...
Comments posted to this topic are about the item Why Successful SQL Server Backups...
Comments posted to this topic are about the item Adding Bits II
Comments posted to this topic are about the item An Unlimited Token Budget
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