2013-04-30
729 reads
2013-04-30
729 reads
While backup to the Cloud may be useful in terms of optimizing storage across the enterprise, for DBAs it remains essential that they retain fast, easy, access to the backup files. Azure Explorer is a free tool that might help.
2013-04-29
116 reads
There are many people trying to make the world better for others. Bono is one of them, with the elimination of hunger as his goal. He calls himself a "factivist" trying to use data to inspire others to join him.
2013-04-29
136 reads
Does vacation cause extra stress at your job before or after you leave? Steve Jones asks a poll question this Friday to see how you feel. This editorial was originally published on June 12, 2008. It is being re-run as Steve is traveling.
2013-04-26 (first published: 2008-06-13)
412 reads
Travel can be stressful and complicated. As much as computer systems have made things easier, when they fail, your trip can turn awful in a hurry.
2013-04-25
144 reads
Can you own data itself or patent it? There's a Supreme Court case dealing with this right now. Steve Jones notes that the outcome could affect our jobs as we deal with more and more data and laws to control data are enacted.
2013-04-24
124 reads
A billion transactions is a lot of activity on your database, however Steve Jones thinks more and more of us might see this on a regular basis. Microsoft's facilities group shows this to be the case.
2013-04-22
249 reads
A bad workman always blames his tools. So does the entire western media, it seems, as poor old Excel gets it in the neck for some appalling calculation errors in economic papers.
2013-04-22
257 reads
Are many people upgrading to SQL Server 2012? Is it worth the cost for your company for any existing instances? Steve Jones asks the question this week.
2013-04-19
447 reads
When someone asks for interview questions on the web, it seems many people are upset. But should they be? Steve Jones points out there are different sides to this.
2013-04-18
421 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