Is Change Coming?
In the final Database Weekly of 2015, Steve Jones looks at a CIO's column on workplace change.
2015-12-28
126 reads
In the final Database Weekly of 2015, Steve Jones looks at a CIO's column on workplace change.
2015-12-28
126 reads
SQL Injection isn't special code. It consists of regular, valid T-SQL that is unexpected by the application. Steve Jones notes that using the principle of least privilege can help to limit the damage from SQL Injection if the application fails to properly check input.
2015-12-28 (first published: 2011-04-12)
633 reads
This Friday Steve Jones has a poll about which SQL Servers might impress you. Is there a company or installation that you think would really showcase the power and scalability of SQL Server?
2015-12-25 (first published: 2011-05-06)
511 reads
We all make mistakes, but it's important that we revise our code to correct them over time.
2015-12-24
133 reads
2015-12-23
216 reads
A new series of attacks were proven recently using music files to attach embedded systems in cars. Could this be another attack vector that we need to worry about?
2015-12-22 (first published: 2011-03-23)
595 reads
2015-12-21
343 reads
Today we have a guest editorial from Andy Warren. We still have many applications runnning under sysadmin accounts, often "sa". Why do people do this? Andy has a few thoughts on the subject.
2015-12-21 (first published: 2011-05-04)
542 reads
2015-12-17
238 reads
2015-12-15
227 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