How can I log all commands the clients are sending to database server? I wanna to "see" those commands to know how entity framework 4.0 is generating sqls and maybe try to change …

When your Database contains a EVENT of type DatabaseStart and you are able to crash the Database Engine during startup with your fabulous code. How would you fix the database to …

When i execute the following command I'm a little bit surprised of the result. select -12345678901234.0001 as TestVal, str( TestVal, 40, 2) as stringVal union all select -123456 …

Structure of Example table: Id, Integer (PK) Name, Varchar(100) Description, Text I need to know if exists difference in performance between: SELECT COUNT(*) FROM Example; an …

I think I found a bug in ADO.NET driver for SA 11. if I try to execute this code: DbCommand command = connection.CreateCommand(); command.CommandText = "select 'my ' + 'strin …

As suggested me Breck, I'm starting this thread for this question. That's my code: using System; using System.Data.Common; namespace SA11BUG { class Program { st …

What should I review (stored proc, view, select, etc) before migrate an database (with about 66gb) from ASA 9.0.2 to SQLA 11?

Can I use (in production) Mr. Paulley SA 11 dialect for NHibernate? I'm thinking starting using it, but in this blog post, he told that's beta. Are anyone using it?

While testing High Availability I want to simulate a failing primary server. Killing the process via task manager would work, but I just wanted a more elegant solution using plain …

Can I use High Availability of SQL Anywhere, with a single copy of db files, shared between server on a NAS? I need something like this to prevent hard failures with on downtime o …