Survival: How a Culture of Preparedness Can You and Your Family From Disasters
Picked up Survival: How a Culture of Preparedness from the local library on a whim without looking at anything except...
2009-09-03
591 reads
Blog Posts
Thoughts on the 24 hours of PASS
From all indications, the first 24 hours of PASS was a resounding success. Hundreds of attendees for each session, minimal...
2009-09-03
363 reads
Use the Best Tool for the Task - Part 2
Yesterday I posted about how Transact-SQL was better suited than SMO for gathering details about database files for a database...
2009-09-03
393 reads
Warming up Analysis Services with Preallocate
With Windows Server 2003 many people found that Analysis Services (SSAS) was slow to get going sometimes. So a preallocate...
2009-09-03
1,747 reads
24 Hours of PASS was an Adventure
On July 21, just a few short weeks ago, I got an e-mail from Rick Heiges, who is on the...
2009-09-02
656 reads
Article of the Week – SQL Server 2008 T-SQL Enhancements
I have been following this series of articles since the first article was published on SQLServerCentral. The author, Arshad Ali,...
2009-09-02
746 reads
Building a Better Blog
I had a great session for the 24 Hours of PASS on Building a Better Blog. Not sure how well...
2009-09-02
641 reads
Data Type Synonyms
Today on sql server central QOD. very interesting question on Data Type Synonyms...
http://www.sqlservercentral.com/questions/Programming/67390/
We can use the synonyms data type also...
2009-09-02
631 reads
Finally Migrating from SQL 2000
I suspect I’m not alone in that I’ve had SQL 2000 running for a long time with no problems and...
2009-09-02
421 reads
How practical is a netbook?
I’ve I was having lunch with another SQL Geek and we were talking about netbooks and how practical they are....
2009-09-02
1,447 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