Obfuscation
Test data is critical to being sure your application works, but is production data ok to use in test environments?
2007-12-19
538 reads
Editorial
Data Ownership
Who owns the data that we generate ourselves? It's not as easy to answer that as you think.
2007-12-18
67 reads
Better Licensing
Licensing SQL Server used to be easy and could be again, though it is still better than licensing Oracle.
2007-12-17
258 reads
2007-12-17
162 reads
What Would You Do?
If someone acts suspicious at work, do you report them? What if it's the CIO? What if data security is involved?
2007-12-14
111 reads
Another Reason to Hate Ads
Malicious code embedded inside advertisements served on the web. What's next?
2007-12-13
78 reads
The Downside of Real Time
Everyone wants real time reporting, or do they? Steve Jones talks about some of the downsides of implementing such a system.
2007-12-12
141 reads
Do We Need a PK?
A primary key is a must for every table. Or is it? Steve Jones examines the question.
2007-12-11
492 reads
Software Teams
Building a team when you are developing software of any size is important and Steve Jones shares one of the most important things you need.
2012-10-31 (first published: 2007-12-10)
193 reads
Hipp, Hipp, Hooray
In an age where commercial interests seem to trump all, it's nice to see someone delivering content out there for free.
2007-12-10
157 reads
Blogs
Using AI to Build Semantic Models, Ontologies, and Fabric Data Agents
By James Serra
(This is the third post in a three-part series on how AI is changing...
SSMS Is Getting Smarter—and This Isn’t Just About Writing SQL
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
Yippee-Kai-Yay 2027 Summit in Denver
By Steve Jones
Next year the PASS Data Community Summit is in DENVER! and London, but Denver...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Helping an English Student with R
Comments posted to this topic are about the item Helping an English Student with...
Adding Bits I
Comments posted to this topic are about the item Adding Bits I
Question of the Day
Adding Bits I
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