An update of my SQL Server “Bad Habits” seriesLast October, I started a series of blog posts over on sqlblog.com that highlighted some bad practices I observe from time to time. Earlier this year, I felt motivated to pick the series up again.
…
OTOlabs
Posts tagged with "sql server"
Mixing OLTP and reporting using indexed viewsI'm not a big fan of denormalizing, nor of repeating redundant redundant information in a database when those facts can already be derived from other information. A classic example of the latter is when I see questions on newsgroups, forums or StackOverflow that ask how they can update a table's rank column to reflect the current rank based on some other criteria in the table.
…
Helping people kick bad SQL Server habitsEarlier this week, I started a series of blog posts aimed at helping people kick their bad SQL Server habits.
…
New whitepaper on Resource Governor available
…
The cost of reinventing the wheelDevelopers often resort to solving a problem through brute force, discounting existing solutions due to cost, lack of feature set, or simply not knowing they exist. What can we learn from this?
…
Using a Mac in a Windows worldIf you've read any of my material on sqlblog.com or follow me on twitter, you have probably already painted a clear picture that I'm a Windows-based database guy; more recently, though, I have been branded a crazy Apple fanboy... and deservedly so. Here's my story...
…