Browse by Tags

All Tags » SQL Server (RSS)
Tue, Mar 24 2009 14:06

"Slacker DBs" Vs. Old-Guard DBs

A very interesting summary at Slashdot - "Slacker DBs" Vs. Old-Guard DBs on an InfoWorld article Test Center: Slacker databases break all the old rules I saw this problem from a different perspective in 2000 or so when I purchased my Palm Vx...
Posted by Tony | with no comments
Filed under: , ,
Thu, Jan 1 2009 19:32

Internals viewer for SQL Server

Internals viewer for SQL Server I always enjoy peeking under the covers. Hey, computer software covers. Get your mind out of the gutter. This blog posting mentions how to poke about under the covers of SQL Server. Similar to MDB Tools - A set of libraries...
Posted by Tony | with no comments
Filed under: , ,
Sat, Nov 1 2008 12:49

Yo momma jokes

SQL Server yo momma geek jokes on twitter You won't get these unless you know SQL Server.
Posted by Tony | with no comments
Filed under: ,
Wed, Aug 6 2008 17:52

SQL Server 2008 RTM

Microsoft Releases SQL Server 2008 It's downloadable via MSDN Subscriber Downloads and TechNet Subscriber Downloads.
Posted by Tony | with no comments
Filed under:
Fri, Jul 11 2008 16:43

Top Tips for Effective [SQL Server] Database Maintenance

"Several times a week I'm asked for advice on how to effectively maintain a production [SQL Server] database. Sometimes the questions come from DBAs who are implementing new solutions and want help fine-tuning maintenance practices to fit their...
Posted by Tony | with no comments
Filed under:
Sat, May 10 2008 22:56

Bug in ADO, SQL Server and latest OS SPs

On a computer that is running Windows Vista, Windows Server 2008, or Windows XP, an incorrect value is returned when an application queries the identity column value of a newly inserted row in various versions of SQL Server 2005 and of SQL Server 2000...
Posted by Tony | with no comments
Filed under: , ,
Sun, Jan 20 2008 16:54

SQL Server 2005 Best Practices Analyzer (January 2008)

"The SQL Server 2005 Best Practices Analyzer (BPA) gathers data from Microsoft Windows and SQL Server configuration settings. BPA uses a predefined list of SQL Server 2005 recommendations and best practices to determine if there are potential issues...
Posted by Tony | with no comments
Filed under: ,
Fri, Dec 14 2007 11:58

SQL Server White Papers: Migration from ... Microsoft Access to Microsoft SQL Server

SQL Server White Papers: Migration from Oracle Sybase, or Microsoft Access to Microsoft SQL Server
Posted by Tony | with no comments
Filed under: ,
Wed, Nov 7 2007 16:13

Access 2003 SP3 bug on bit data type field in a linked SQL Server table

We've been seeing reports of this in the newsgroups. Here's Microsoft's KB article: After you install Office 2003 SP3, you encounter various problems in an Access project when you work with a Bit data type column in a linked SQL Server table
Posted by Tony | with no comments
Filed under: , ,
Thu, Oct 18 2007 22:14

Optimizing Microsoft Office Access Applications Linked to SQL Server

Tom van Stiphout, fellow Access newsgroup denizen, alerted me to the following MSDN article: Optimizing Microsoft Office Access Applications Linked to SQL Server . A link was also added to the Access Performance FAQ . Note the following paragraph: "Developers...
Posted by Tony | with no comments
Filed under: ,
Tue, Jun 19 2007 12:56

Norton Antivirus strikes again - ODBC to SQL Server 2005

From a recent newgroup posting > I'm trying to link an Access 2003 project to a SQL 2005 database on a > network server. Everything seems to go okay until I select ODBC as the type > of source I want to link to and them nothing happens. If...
Posted by Tony | 4 comment(s)
Filed under: ,
Sat, May 26 2007 11:42

New version of SQL Server Migration Assistant for Access available for download

SQL Server Migration Assistant for Access 1.2 - Microsoft SQL Server Migration Assistant (SSMA) for Access is a tool for migrating databases from Microsoft Access to Microsoft SQL Server 2005. SSMA for Access converts Access database objects to SQL Server...
Posted by Tony | 2 comment(s)
Filed under: ,