Adoption
Are lots of people adopting SQL Server 2008? Should you be looking at it? Steve Jones has a few comments on what the new lifecycle of SQL Server might mean for DBAs and developers.
2009-03-04
296 reads
Are lots of people adopting SQL Server 2008? Should you be looking at it? Steve Jones has a few comments on what the new lifecycle of SQL Server might mean for DBAs and developers.
2009-03-04
296 reads
With all the bailouts being requested in the US, where is the money for DBAs who need it?
2009-03-03
210 reads
There has been a lot of news about cloud computing this past week, including an announcement about SQL Server.
2009-03-02
233 reads
Phil Factor muses on the power, and potential failings, of the relational database, and wonders if those responsible for its development should feel any guilt about the opportunities for abuse of the power that it affords.
2009-03-02
181 reads
DBAs tend to be very organized, and most of them don't want unnecessary objects on their systems. Is it worth cleaning up? Steve Jones asks the question this Friday.
2009-02-27
367 reads
In this month's energy update Steve Jones takes a look at more efficient building practices to increase energy efficiency.
2009-02-26
128 reads
Should IT charge other departments for the use of its resources? Is that good for the business? Steve Jones comments on what this could mean for SQL Server DBAs.
2009-02-25
193 reads
Backup verification is a vital part of a well-designed database maintenance plan and yet some DBAs neglect to do it. Brad McGehee ownders why.
2009-02-24
764 reads
In the Oracle world, great importance is attached to "instrumenting" your application code. However, it seems not to be an issue that is much discussed in SQL Server. Tony Davis wonders why...
2009-02-23
545 reads
SQL Server has grown from two editions in the v6.5 days to 7 with SQL Server 2008. Why are there so many editions? Steve Jones gives his thoughts.
2009-02-23
213 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