Build numbers site

Interesting site with sql server (and other products) build numbers

https://buildnumbers.wordpress.com/sqlserver/

For SQL Server a more detailed entry one is

http://sqlserverbuilds.blogspot.co.uk/


Database Product installation FAQ updated for SQL Server 2016 CTP 2.3 and Polybase

Database Product installation FAQ updated for SQL Server 2016 CTP 2.3 and Polybase

http://www.smooth1.co.uk/installs/dbinstalls.html#3.1.9


Connect items

Raised my first connect item – 1701396 for adding Application-period temporal tables and Bitemporal tables to SQL Server 2016! https://connect.microsoft.com/SQLServer/Feedback/Details/1701396

Just voted up the Connect item for fixing the disk label on SQL Server 2016 CTP releases – https://connect.microsoft.com/SQLServer/Feedback/Details/1640362


DB2 10.5 Fixpack 6 is out

DB2 10.5 Fixpack 6 is out

http://www-01.ibm.com/support/docview.wss?uid=swg24040522

“Fix Pack 6 does not contain new enhancements, and there were no changes to the existing functionality. This fix pack and future fix packs will deliver only APAR and security vulnerability fixes.”


Extracting DMV information from SQL Server

Extracting DMV information from SQL Server:

  1. Build view to get information

create view justdave_dmvs as
select
SERVERPROPERTY(‘productversion’) productversion,
SERVERPROPERTY (‘productlevel’) productlevel,
SERVERPROPERTY (‘edition’) edition,
REPLACE(REPLACE(REPLACE(@@VERSION, CHAR(13),”),CHAR(10),”),CHAR(9),”)serverversion,
b.name tabname,
c.name colname,
d.name typename,
c.precision,
c.scale
from sys.schemas a,
sys.all_objects b,
sys.all_columns c,
sys.types d
where a.name=’sys’
and a.schema_id=b.schema_id
and OBJECTPROPERTY(b.object_id, ‘IsMSShipped’) = 1
and b.name like ‘%dm_%’
and b.type in (‘V’, ‘TF’, ‘IF’)
and b.object_id=c.object_id
and c.system_type_id=d.system_type_id

2. BCP out to csv file

bcp “select * from justdave_dmvs” queryout 2008R2X1.csv -t, -c -S WIN-TOU50O0VHP8\SQL2008R2X1 -T


Issue with Windows 10 Insider and SQL Server 2016 CTP 2.2

With Windows 10 Insider and SQL Server 2016 CTP 2.2, do not just use your Windows Insider Account when installing SQL Server.

This may appear to work however it will break when using Replication!

http://www.smooth1.co.uk/mssql/repl_guide1/index.html

Fixed by using a local account however there are more gotchas

http://www.smooth1.co.uk/mssql/repl_guide2/index.html


SSMS July 2015 and SQL Server 2016 CTP 2.2 re-release issue

SQL Server 2016 CTP 2.2 (original release)

Microsoft SQL Server 2016 (CTP2.2) – 13.0.400.91 (X64)   Jul 16 2015 04:41:40   Copyright (c) Microsoft Corporation  Enterprise Evaluation Edition (64-bit) on Windows 10 Pro Insider Preview 6.3 <X64> (Build 10162: ) (Hypervisor)

SQL Server 2016 CTP 2.2 (2nd release)

Microsoft SQL Server 2016 (CTP2.2) – 13.0.407.1 (X64)   Jul 22 2015 21:19:11   Copyright (c) Microsoft Corporation  Enterprise Evaluation Edition (64-bit) on Windows 10 Pro Insider Preview 6.3 <X64> (Build 10162: ) (Hypervisor)

After installing the later the SSMS -> Tools -> Update recommends an upgrade to July 2015 preview

SSMS July 2015 preview fails to install as the database engine is too new!

0x81f40001 – A database engine with version 13.0.0.407.1 was found which is incompatible with this application being installed. Please uninstall the current database engine or upgrade it to version 13.0.400.91 and rerun this setup.

FYI SSMS July Preview used to be 33,093,472 bytes, now it is 33,109,984 bytes so it has changed as well.