Database Weekly - May 5, 2008
A look back at the news of the past week dealing with SQL Injection, slow SQL Server growth and two level security.
2008-05-05
58 reads
Editorial
Managing Disk Space
How often do you worry about your database size and free space? Steve Jones asks how you administer your SQL Server database space this Friday.
2008-05-02
1,108 reads
And You Thought You Had a Big Database
Steve Jones examines what big is these days and a few examples of what the largest database people in the world deal with.
2008-05-01
349 reads
Should I Buy a Kindle?
Steve Jones still thinks there is a lot of value in books, both fiction and non-fiction, but he's looking at e-Readers, specifically the Kindle from Amazon.
2008-04-30
268 reads
All Data Readers Are Evil
The DBA's Mantra: All data readers are evil. Steve Jones talks about a proposed corollary that might be appropriate to ensure security.
2008-04-29
191 reads
The Exceptional DBA: Soft Skills
If impeccable technical skills are a "given", what are the soft shills that will make you an Exceptional DBA rather than a competent DBA?
2008-04-28
1,498 reads
Easy or Hard
How should we build tools? Should they be easy to use? Or does it make sense to have some things hard to do so that only experienced used choose them. Steve Jones comments on usability and the implications of your choices.
2008-04-28
113 reads
Seeing Double
SQL Server allows some interesting index behavior and there's been some debate over whether it makes sense or not. This Friday Steve Jones asks if you have a reason for this.
2008-04-25
164 reads
2008-04-24
144 reads
The April Energy Update
The bimonthly update on energy news from Steve Jones, focusing mostly this month on wind power.
2008-04-23
121 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...
Layanan Resmi BCA KCP Tanggul Hub/Wa. 0817-819-444
Jl. PB.Sudirman No.40, Tekoan, Tanggul Kulon, Kec. Tanggul, Kabupaten Jember, Jawa Timur 68155
Layanan BCA KCP Jajag Hub/Wa. 0817-819-444
Jl. YOS Sudarso No.49, Dusun Kp. Baru, Jajag, Kec. Gambiran, Kabupaten Banyuwangi, Jawa Timur...
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