An Administrative Security Hole?
Is it a problem for SQL Server to have a backdoor that lets a Windows Administrator connect as a sysadmin? Steve Jones thinks so and gives a reason why this might be a problem.
2010-02-09
219 reads
Is it a problem for SQL Server to have a backdoor that lets a Windows Administrator connect as a sysadmin? Steve Jones thinks so and gives a reason why this might be a problem.
2010-02-09
219 reads
Tony Davis believes that it's time for a little more openness and democracy in the MVP award. In short, it's time to introduce community voting.
2010-02-08
156 reads
Today we have a guest editorial from Grant Fritchey that discusses the idea of rules based on certain types of measurements. Are they worth following? Or do we need to develop our own measures.
2010-02-08
399 reads
A guest editorial from Brad McGeHee today talks about maintenance plans and his new book.
2010-02-04
606 reads
A guest editorial today from Simon Galbraith, founder of Red Gate Software talking about SQL Search, a new product that was developed in an interesting way.
2010-02-03
390 reads
An interesting experiment at Red Gate, Coding By the Sea, produced results, and Steve Jones thinks this could be a great idea for other companies.
2010-02-02
182 reads
Steve Jones talks a little about disk alignment for your SQL Server instances. This is something that you might to check on your systems and see if you can improve performance.
2010-02-01
153 reads
With the release of an in-memory database from Sybase, is it time for SQL Server to join the fray?
2010-02-01
339 reads
This Friday's poll deals with security. Steve Jones asks how often you might rotate those encryption keys to ensure that your systems are secure.
2010-01-29
166 reads
Arrogance has no place in assessing threats and attempting to build security to mitigate them.
2010-01-28
134 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