Pre-built or Ad Hoc
Steve Jones talks about the ad hoc nature of some NoSQL databases and whether that's something that most users want.
2015-04-13
152 reads
Editorials
Kanban
Steve Jones talks about organizing and tracking work with kanban and how that might help you.
2015-04-07
327 reads
The Devil's in the Details
This week Steve Jones notes that the little details can sometimes have a big impact in your code.
2015-04-06
151 reads
Your Cloud Held Hostage – Could It Happen?
Today's guest editorial by Andy Warren is more of a movie plot than reality, but perhaps it's worth considering.
2015-04-06
136 reads
Large Chunks of Data
This Friday Steve Jones talks reporting. Specifically he wonders how long can a report be before it's just wasting space.
2015-04-03 (first published: 2010-09-17)
361 reads
2015-04-01
318 reads
Source Code Security
The code you use may contain security information. Be extra careful in this case, especially when you use encryption.
2015-03-31
154 reads
One Rule, Umpteen Constraints
Despite being deprecated for many years, Phil Factor explains why RULEs are still hanging on in there in SQL Server 2014.
2015-03-30
106 reads
Efficiency
This Friday Steve Jones asks about how you are tackling your career growth as you get older. Are you getting more efficient?
2015-03-26 (first published: 2010-10-22)
313 reads
Are There That Many GUIDs?
Steve Jones talks about a recent survey that showed more people use GUIDs as primary keys than identity values.
2015-03-24 (first published: 2010-10-12)
674 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