More Layers - MP3
Less CIOs are reporting to CEOs this past year. Is that a problem? Steve Jones offers some comments.
More Layers - WMV
Less CIOs are reporting to CEOs this past year. Is that a problem? Steve Jones offers some comments.
Copyright at SQLServerCentral.com
Just to set the record straight, if you submit something you keep the copyright.
Designing an Entity Data Model
The Entity Framework is an exciting new technology being developed for ADO.NET. It allows developers to view data using a logical model instead of a physical model, offering more flexibility.
Solving the "Running Total" & "Ordinal Rank" Problems in SS 2k/2k5
Learn how to solve a couple of common T-SQL issues with MVP Jeff Moden.
SQL Server 2005: Intro to XQuery
Longtime SQL Server expert Michael Coles brings us the second part of his his introductory look at XML in SQL Server 2005 with a short examination of XQuery, the way in which you can write queries on XML data.
The January Car Update
The bimonthly update looks at a compressed air car, the X-Prize, daily rentals, and hybrid pickups.
theSystem
This is one in a series of articles dealing with Database Design following the design of a single system from start to finish.
The Data Stewardship Approach to Data Governance: Chapter 3
In this article I will settle down a little bit and share with you tools that I have used as part of the data governance trade.
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