Triple Digits
Salaries for data professionals have risen quite a bit, according to the latest salary survey. That's good for those of us working with SQL Server.
2014-10-28
240 reads
Salaries for data professionals have risen quite a bit, according to the latest salary survey. That's good for those of us working with SQL Server.
2014-10-28
240 reads
Managers, look away now. Patrick Index wants to get something off his chest...
2014-10-27
359 reads
Over the years the page size in SQL Server has changed, growing larger to fit larger data sets. However not all functions have been modified to work with larger page sizes. Or even exceed them. Steve Jones wonders if it's time to increase the page size.
2014-10-23 (first published: 2010-02-11)
409 reads
Most people prefer to work with the platforms that they are familiar with, but there is always pressure to try new, exciting technologies when others have success. Steve Jones explores the idea of switching platforms.
2014-10-20
183 reads
What's the most important thing about your application? The code? The accuracy of its calculations? The layout of the reports? Steve Jones has another opinion.
2014-10-17 (first published: 2009-12-09)
224 reads
Who checks on those who manage our systems? Is there auditing in place for those accidental DBAs?
2014-10-16 (first published: 2009-12-03)
377 reads
Should we declare what we want installed and then have every instance configure itself? Steve Jones talks about the need to ensure we know what is running before we install rather than documenting it afterwards.
2014-10-13
140 reads
This week Steve wants to know if you'd have some issues when analyzing data and you've mistaken correlation for causation.
2014-10-10
198 reads
It seems as though Microsoft might be moving to a Continuous Delivery process for Windows 10. Steve Jones isn't sure that's a good thing, but it is interesting.
2014-10-09
105 reads
Data analysis can save money and resources, but it will certainly transform our world.
2014-10-06
107 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