Whitepaper: SQL Server 2005 Physical Database Storage Design
Microsoft has released a whitepaper on SQL Server 2005 Physical Database Storage Design
(Microsoft Word document). It's 35 pages in length...
2006-06-15
2,055 reads
Brian Kelley
- Interests: Chess, Reading, Soccer (Football), Baseball, Animals, Theology
Distributing Database Connection Strings Using Active Directory Group Policy
I ran into Brian Knight today on the Expo floor here at TechEd.
It was good to catch up a bit...
2006-06-13
2,331 reads
TechEd - DATTLC01 : Troubleshooting Performance Problems in SQL Server 2005
It's
been a few years since I wrote my eBook on SQL Server performance monitoring
but I still keep a strong interest...
2006-06-12
1,582 reads
In Boston for TechEd
This will be my first ever TechEd and I'm looking forward to it. I was able to go to the...
2006-06-11
1,492 reads
Two things I wish they'd change about endpoints in SQL Server 2005
I've
been playing around with endpoints in SQL Server 2005 looking at how they can
be used to enhance security for SQL...
2006-05-27
2,146 reads
When It Takes Time...
Saw this from Jason Haley's Interesting Finds post for the morning of May 25, 2006:
Project Managing Latency or: How to...
2006-05-25
1,451 reads
Disaster Recovery and SQL Server, Part II
In a previous post, Disaster Recovery and SQL Server, Part I,
I pointed to the Microsoft Knowledge Base (KB) article which...
2006-05-24
1,501 reads
SQL Prompt
I downloaded and installed SQL Prompt from Red Gate this morning. If
you aren't aware, PromptSQL was bought by Red Gate...
2006-05-23
1,623 reads
Disaster Recovery and SQL Server, Part I
The last few weeks I've been working on disaster recovery procedures
for my organization. We review them at least yearly to...
2006-05-20
1,651 reads
Backing up virtual machines on VMware ESX Server
I know VMware and Virtual Server
technology is becoming more and more prevalent in organizations as both
packages can greatly reduce hardware...
2006-05-17
1,617 reads
Blogs
From SQL Saturday to Day of Data
By ReviewMyDB
A behind-the-scenes look at Day of Data Jacksonville 2026, the transition from SQL Saturday,...
PostgreSQL 18 Finally Makes BUFFERS the Default. Here Is Why That Matters
You run EXPLAIN ANALYZE on a slow query, stare at the plan, and something...
A New Word: La Guadière
By Steve Jones
la guadière – n. a glint of goodness you notice in something that you...
Forums
non ascii columns in a utf-8 .txt file
hi, we couldnt get our upstream data source developers to supply what is sometimes...
PolyBase Trace Flags
Are there any good articles on all the trace flags that are enabled on...
The Data Model Matters
Comments posted to this topic are about the item The Data Model Matters
Question of the Day
Running SQLCMD I
I run the SQLCMD utility as follows:
lcmd -S localhost -EI then type this (the 1> is the prompt):
1> select @@version goIf I hit enter, what happens? See possible answers