Do you use the maintenance plans or hate them? Wish they would do more? Curious about how they work under the hood? Cmon, you gotta read this one! Trust us, it's not another "how-to" article! Well, maybe just a little bit!
2005-03-04 (first published: 2002-04-11)
34,089 reads
Andy Warren takes a look at SQLCompare, a tool that lets you compare two SQL databases and create a script to synchronize the differences.
2005-01-14 (first published: 2001-06-06)
16,283 reads
Andy starts a new series about Worst Practices - come find out why and read about the first one on his list - using Hungarian Notation for column names!
2004-12-03 (first published: 2001-10-09)
34,456 reads
2004-12-01
1,394 reads
2004-11-24
1,276 reads
Andy started a contest this summer to see who could develop a T-SQL method of keeping a bowling score. He's finally gotten around to the results after the damage from the hurricanes was cleaned up. See who won and see the code that does the trick.
2004-11-19
5,977 reads
2004-11-16
1,415 reads
Last week Andy launched a new series about Worst Practices by talking about why the Hungarian naming convention is bad for column names. This week he's at it again, declaring that the practice of having objects owned by anyone other than dbo is BAD! Agree or disagree, we think you'll enjoy reading this article and adding your thoughts to the discussion!
2004-11-12 (first published: 2002-09-12)
38,479 reads
2004-11-08
1,590 reads
2004-11-01
1,467 reads
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
By James Serra
Making Data AI-Ready, Part 3 (This is the final article in a three-part series...
Comments posted to this topic are about the item Four Rules for Adding AI...
Hello, the title says it all. Is the SQL Server 2025 section missing?
I am not sure which is the best way to proceed. I have parent...
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers