Interesting site with sql server (and other products) build numbers
For SQL Server a more detailed entry one is
Database Product installation FAQ updated for SQL Server 2016 CTP 2.3 and Polybase
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
“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:
- Build view to get information
create view justdave_dmvs as
SERVERPROPERTY (‘productlevel’) productlevel,
SERVERPROPERTY (‘edition’) edition,
from sys.schemas a,
and OBJECTPROPERTY(b.object_id, ‘IsMSShipped’) = 1
and b.name like ‘%dm_%’
and b.type in (‘V’, ‘TF’, ‘IF’)
2. BCP out to csv file
bcp “select * from justdave_dmvs” queryout 2008R2X1.csv -t, -c -S WIN-TOU50O0VHP8\SQL2008R2X1 -T
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!
Fixed by using a local account however there are more gotchas
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 22.214.171.1247.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.