Too Much Data
These days more and more systems gather data all the time, but are we using that data? Steve Jones comments on the glut of information and some of the problems that creates.
2009-02-19
198 reads
These days more and more systems gather data all the time, but are we using that data? Steve Jones comments on the glut of information and some of the problems that creates.
2009-02-19
198 reads
Steve Jones takes a break today and gives you a fun reel of mistakes and bloopers.
2009-02-16
91 reads
Testing software is important, and the use of state models can help. This week Steve Jones talks about a new book that exposes software testing at Microsoft.
2009-02-16
133 reads
What type of leadership do you want in your company? Steve Jones asks who you want to help steward you through these tough economic times.
2009-02-13
100 reads
What does global warming have to do with BI? Steve Jones explains.
2009-02-12
225 reads
A tour of the new Red Gate Software offices from Steve Jones, looking at how a modern software company has set up it's space.
2009-02-11
208 reads
Trust is a big part of any DBA's job. But it seems that many people in society trust each other less and less all the time. Steve Jones has a few comments on this important subject.
2009-02-10
162 reads
Every DBA needs to give serious consideration to the level of antivirus/antispyware protection they need on their SQL Server instances, and to the performance implications of the strategy they choose.
2009-02-09
664 reads
Being a DBA demands that you keep up with the latest technology, and conferences are one of the best ways to do that. So, despite the fact that training budgets may be shrinking, I suggest you begin lobbying your manager to attend as many SQL Server events as you can. If you can't get your company to send you to a paid conference, then try to attend one of the free ones, on your own time.
2009-02-09
312 reads
Phil takes us through one of the best kept secrets of SSMS - Templates. Even for a 'plain-screen' man like Phil, Templates are an excellent tool, and a major reason to use SSMS.
2009-02-06
342 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