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,708 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,712 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
974 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
4,001 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
932 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,298 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,786 reads
Making Sense of Replication Errors in Replication Monitor
Making Sense of Replication Errors in Replication Monitor If you've ever had to deal with errors in Replication Monitor, your first...
2010-03-27
12,097 reads
SQL Server Social Group a Fresh Perspective on User Group Meetings
The Cam river flows through Cambridge, England. At the center of the river you can see a punt (a type...
2010-03-27
478 reads
So you want to write a blog?
First, figure out what you want to write about. It should be something you have passion for. And it should...
2010-03-27
1,541 reads
Blogs
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Prep data for AI vs. Fabric Data Agent Instructions: What Goes Where?
By James Serra
Making Data AI-Ready, Part 3 (This is the final article in a three-part series...
Forums
Four Rules for Adding AI Without Breaking What Already Works
Comments posted to this topic are about the item Four Rules for Adding AI...
SQL Server 2025 section missing?
Hello, the title says it all. Is the SQL Server 2025 section missing?
A design question in a parent child relationship
I am not sure which is the best way to proceed. I have parent...
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers