SQL Server 2008 Database Mirroring: It takes a licking but it keeps on ticking!
With apologies to Timex, I just wanted to relate a minor incident that happened with one of my mirrored databases...
2010-03-30
6,174 reads
Blog Posts
Stepping Stone Cert
A few of us have been deliberating and discussing the need for a bridge certification between the MCITP and MCM...
2010-03-30
1,539 reads
Indexes - where you cannot create them!
Indexes are the objects that DBA uses them everyday and maintaining them very often, during the maintenance routines. The main...
2010-03-29
3,703 reads
Notes from the Orlando Code Camp March 2010
I arrived about 7:15 and already quite a few people on hand. Registration was moved to inside this time, just...
2010-03-29
972 reads
Scheduling backups in SQL Server Express
I have seen many forum posts asking how do you schedule backups for SQL Express databases and the answers always...
2010-03-29
1,702 reads
Slipstream - Makes installs simple
I was recently working on building a test environment for myself while I was studying for the MCITP-Database Administration exams. ...
2010-03-29
1,567 reads
To Get Certified or Not Get Certified
I have noticed quite a bit of discussion recently about the merits of Microsoft certification. Some people (like me) think...
2010-03-29
930 reads
Using Custom Connection Colors in SSMS
One of the new features that was added to SQL Server Management Studio (SSMS) in SQL Server 2008, which was...
2010-03-29
3,969 reads
DBCC INPUTBUFFER vs fn_get_sql
Someone asked a question in the forums the other day and I realized it would make a pretty decent blog...
2010-03-28
8,772 reads
TempDB – Relocate the TempDB Database Files
I took control of a new server recently and noticed that Tempdb was not configured to best practice. It was...
2010-03-28
1,288 reads
Blogs
Why your data still can’t answer a simple question
Every organization I talk to has the same problem dressed up in different clothes....
T-SQL Tuesday #197 Invitation – An impactful session or two from a conference
By DataOnWheels
I am delighted to host this month’s T-SQL Tuesday invitation. If you are new...
Did You Really Name That Default?
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
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...
CMS server query & temp tables
I am annoyed. We have a CMS server that has hundreds of servers saved...
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...
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