Changing Table Schema – what goes behind the scenes – Part I
What happens behind the scenes when you alter a table schema? New author Alok Dwivedi dives deep into SQL Server to show us how things are affected.
Uptime = Downtime? (Database Weekly, Aug 3, 2009)
Does too much uptime mean that you might be at risk for downtime? Steve Jones examines this idea in today's editorial.
12 Essential Steps After Installing SQL Server
Rolling out SQL Servers is a key task for DBAs, this articles provides 12 essential post-installation steps.
Be a Craftsman
Is software engineering dead? Some well respected software developers have stated that, and one says we should be craftsman, not engineers.
Be a Craftsman
Is software engineering dead? Some well respected software developers have stated that, and one says we should be craftsman, not engineers.
Be a Craftsman
Is software engineering dead? Some well respected software developers have stated that, and one says we should be craftsman, not engineers.
Embedding Bing Maps in a Web Page
I was doing some maintenance on the SQLSaturday web site recently and one request kinda low on the list was...
Script to check that backup files still exist for SQL Server
You have configured your database backup jobs without any problems. The backups themselves seem to be working, but are the files still where you think they are? How do you know they have not been moved, or worse, deleted to free up some space on your server? And when would you find out that the files were no longer there?
Learn A Bit More
For this Friday's poll, Steve Jones talks about free training events and what their value is to you.
70-433 Or Bust: Working toward MCTS Microsoft SQL Server 2008 Database Development
The 70-433 will be my first Microsoft certification test. There are two main reasons why I've decided to take on this quest. The first reason is to "fill in the cracks." Even on fundamental topics I've found myself saying "oh
Blogs
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...
A Las Vegas Break
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
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