Look Beyond the First Result
As computer systems become more complex and dynamic, it's possible that the results we see might not be what we expect. Steve Jones talks about a situation with Orbitz.
2013-02-26
140 reads
As computer systems become more complex and dynamic, it's possible that the results we see might not be what we expect. Steve Jones talks about a situation with Orbitz.
2013-02-26
140 reads
Is there a sound technical reason why SQL Azure can't support extended properties?
2013-02-25
212 reads
Steve Jones talks a little about Oracle after speaking at an event devoted to that technology.
2013-02-25
217 reads
This week Steve Jones reminisces about the first software he used. He asks you what inspired you to start working with computers.
2013-02-22
128 reads
There are any number of small, annoying or tedious things in SQL Server and Steve Jones makes a case for getting them fixed. Today's editorial was originally published on Nov 11, 2008. It is being re-run as Steve is out of town.
2013-02-21
162 reads
Things on the ranch inspire Steve Jones in the rest of his life. He's one you might not have thought about. Today's editorial was originally published on Nov 3, 2008. It is being re-run as Steve is out of town.
2013-02-20 (first published: 2008-11-03)
231 reads
It is late evening. Something is wrong with a database. You narrow down the possibilities, getting more frustrated and puzzled. Stay calm. Check the inputs systematically. No! The data going into that table is right, but when you then read it in the table, it's wrong. Why did I stop believing in the supernatural? Then it hits you. Every time it comes as a surprise. They're using triggers. (This editorial was originally published on Nov 10, 2008)
2013-02-19 (first published: 2008-11-10)
659 reads
Our desktop OSes have evolved to support group accounts, but much of the ecosystems around them do not and many mobile and tablet devices do not. Why don't they?
2013-02-13
99 reads
There are a lot of regulations around data in the medical field. Most of the exceed HIPAA, but end up causing confusion and problems. Steve Jones thinks simplication is important if our technology systems are to support future regulations.
2013-02-11
111 reads
This week Steve Jones notices some good advice from Brent Ozar and the fastest query in your database.
2013-02-11
235 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