The Schema Debate
There was quite a bit of debate over the use of schemas recently on the Internet. Steve Jones talks about some of the reasons why you might want a schema, and a few reasons why you might not.
2010-06-22
640 reads
Editorials
Making Your Career Go Further
Steve Jones comments on a few things that can help you, and are worth keeping in mind as you interact with people.
2010-06-21
251 reads
Moving to the Cloud
There has been a lot of talk about moving to cloud based computing, and cloud based services. Steve Jones comments on what this might mean today.
2010-06-21
314 reads
2010-06-18
265 reads
Selling Used Cars
Today we have a guest editorial from Andy Warren that looks at the value of experience.
2010-06-17
212 reads
Archive Backups
The need to archive data is becoming more and more important as data sizes grow. However when you choose to archive data, you might need to reconsider how your DR plan is structured.
2010-06-16
248 reads
Google FUD
A recent headline that Google is dumping Windows because of security issues sounds like FUD to Steve Jones.
2010-06-15
231 reads
A new IDE for SQL Server?
Microsoft have been cooking up something for Database Developers in Visual Studio 2010, and Phil Factor has decided it's high time he looked into it. It's not as odd as it sounds, and is actually rather promising, as Phil discovers.
2010-06-14
373 reads
Finding the Context
Will computers become better at finding context in situations and environments? Steve Jones comments.
2010-06-14
88 reads
Bad Database Design
A guest editorial from Andy Warren looks at a bad database design he recently ran across.
2010-06-11
1,299 reads
Blogs
Case Studies: Real-World Success Stories of FinOps Implementation
By HeyMo0sh
Learning any kind of theory is easy, but adapting FinOps and watching it rescue...
SQL Server Security: Always Encryption
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
SQL Server Security – TDE Encryption
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions
Comments posted to this topic are about the item The Problem Isn't Always Your...
Identity Defaults
Comments posted to this topic are about the item Identity Defaults
Question of the Day
Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers