Category: SQLServer

  • List all database files in a SQL Server instance with Python and pyodbc

    For SQL Server management from Linux, I’ve used pymssql on Linux before, but realized lately that it is hard to configure with the heterogeneous environment I am in. So I am giving pyodbc a try. The install on Windows is simple. Listed below is some code that I put together quickly for some testing. It […]

  • SQL Server 2008 R2 unattended installation via configuration file

    I wrote about unattened install of SQL Server 2008 R2 here, where all parameters were entered on the command line directly. Another way, perhaps a better way, of automation is to put all parameters in a configuration file. Here is a sample: [sourcecode language=”text”] [SQLSERVER2008] ; Specifies a Setup work flow, like INSTALL, UNINSTALL, or […]

  • Unattended install of SQL Server 2008 R2

    I’ve written unattended / silent install before for SQL Server 2005. Unattended install is cool because you can automate things: it saves time and improves consistency. Here is something to get you started. I used the command below to: 1. Install SQL Server 2008 R2 default instance, including Replication and FullText search; 2. Install client […]

  • Testing Windows IO with SQLIO and SysBench

    To benchmark IO on Linux and MySQL transaction processing, SysBench is a popular choice that can do both. After poking around at the source code, it seems PostgreSQL and Oracle are also included for transaction processing testing if you have the proper header files, but I didn’t test those. To benchmark IO on Windows and […]

  • Different lingoes for bookmark lookup and why bookmark lookup can be costly

    In the past, when I read technical books, I tend to skim through them, looking for keywords and only read the part that is relevant at the moment, and move on. Sometimes I would make an attempt at finishing a whole book, but a few months or even years later, I haven’t even finished the […]