Get Rid of the Indexes
An idea that could save time and resources for backup and recovery in SQL Server.
2008-03-18
406 reads
Editorial
2008-03-17
263 reads
SQL Server Data Services
SQL Server isn’t used much for web-based applications, simply because the cheapest ISPs use Linux and Apache for their platform. There are ISPs that provide a .NET platform and SQL Server but it is at a cost. SSDS seems to be Microsoft’s latest attempt to break into the market for database-driven websites.
2008-03-17
181 reads
2008-03-16
48 reads
2008-03-14
152 reads
Scaling Out
Scaling out is hard to do with SQL Server, but why doesn't Microsoft build a better solution?
2008-03-13
305 reads
NCAs and NDAs
When accepting an offer of employment, what do you do about NCAs and NDAs that you might be asked to sign? Steve Jones offers some advice. (This editorial was originally published on Mar 12, 2008. It is being re-run as Steve is on holiday.)
2016-09-05 (first published: 2008-03-12)
310 reads
The Social Contract
How much of a contract for servicing SQL Server should we expect? Has Microsoft broken an implied contract with us?
2008-03-11
107 reads
The Daily Routine
Steve Jones compares his daily routine now to that of being a DBA. This editorial was originally published on Mar 10, 2008. It is being re-run as Steve is on holiday.
2012-12-27 (first published: 2008-03-10)
600 reads
Bad Meetings
A joint editorial this week from the Red Gate team looking back at the news of the week.
2008-03-10
65 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