SQL Server

Memory Exception with SQL Server queries5 March 2017

Hi, I have tried to benchmark the SQl Server vs SQL Service InMemory tables vs. Redis, and got a weird error while intensively working with InMemory tables: System.Data.S…

SQL 2008 setup error: Rebuild the performance counters of a SQL Server 2005 or 2008 instance18 February 2011

It happens if you changed the language of your system using MUI. Here are the pills: http://www.sqldev.org/sql-server-setup--upgrade/error-on-install-performance-counter-…

SQL Server 2008 setup: Error "Restart Computer Failed"20 April 2010

When trying to install SQL Server 2008 I found that it requires me to restart computer even after I did it two times. It was really bad. However, there are kind people ar…

Note: scripting an MS SQL database with its data4 February 2010

Needed to script the MS SQL database including data. Strangely :-), but Microsoft did it well: http://blog.sqlauthority.com/2007/11/16/sql-server-2005-generate-script-wit…

Note: setting the SQL Server authentication mode from code22 January 2010

how can I set the authentication mode for a SQLServer from code? Change HKLM\Software\Microsoft\Microsoft SQL Server\ \MSSQLServer\LoginMode 1 = integrated only, 2-mixed …