Yesterday afternoon I was invited over to Microsoft (Brisbane) for a function and I ran into Michael Redmond (Microsoft MCS). We got to chatting about the status of SQL Server and he mentioned that the February CTP had been announced for SQL Server 2008. Here is a link for those […]
Database Magic
49 posts
If you come across this fine error: It is likely because somehow, over time, you’ve installed many or multiple versions of SQL Server Compact Edition. This was, at times called different names such as SQL Server Anywhere and SQL Server 2005 Mobile Edition. To remedy the situation, it’s as easy […]
I recently had an email chat with Dr Greg Low (Microsoft Regional Director & Readify) during the week about the best naming conventions (best practices) for SQL Server (especially in the post-hungarian notiation, SQL 2K5 schema days). In fact, this is a topic being discussed (again) on the SQL Downunder […]
Today.. Polite SQL Server manners.. 1. Use a consistent naming convention Pretty obvious rule, this one.. Best to try and stick to a common SQL syntax too… 2. Indexes: use them Why, oh why does it take so long to query 100,000 rows? 3. Keep the […]