20 Jun 2025
MySQL って PIPES_AS_CONCAT デフォルトで OFF なのか…
SQL2016 では普通に文字列結合として標準化されてるじゃんね
1
1
6
520
2 Apr 2024
MySQL can do:
ALTER TABLE someTable ADD COLUMN someColumn INT AFTER anotherColumn;
But afaik it's not defined in any SQL standard (like SQL99, SQL2016, etc.).
1
58
14 Feb 2023
New SQL Server 2016 Security Updates:
sqlserverbuilds.blogspot.com…
13.0.7024.30 Security update for SQL2016 SP3 Azure Connect Feature Pack
13.0.6430.49 Security update for SQL2016 SP3 GDR
#SQLServer #SQLServer2016
1
7
226
23 Jun 2022
Public preview: Link feature in #Microsoft Azure SQL MI for SQL Server 2016 🚀
azure.microsoft.com/en-us/up…
#Azure #AzureSQL #SQL2016 #SQL2019 #SQL2022 #SQLServer #SQL #dba #AzureHybrid #AzOps
#AzureSynapse #SynapseInfluencers
2
14 Jun 2022
New SQL Server 2016 Security Updates:
sqlserverbuilds.blogspot.com…
13.0.7016.1 SU for SQL2016 SP3 Azure Connect Feature Pack
13.0.6419.1 SU for SQL2016 SP3 GDR
13.0.5893.48 SU for SQL2016 SP2 CU17
13.0.5108.50 SU for SQL2016 SP2 GDR
#SQLServer #SQLServer2016
4
23 Oct 2020
Curious - what is the ultimate objective? The stats blob binary *format* itself is implementation-specific; it may change, which is why it is undocumented. You probably already know this, but the histogram has also been exposed through a DMV since SQL2016: docs.microsoft.com/en-us/sql…
1
7 Jul 2020
This works too for SQL2016 SP1 & >
USE master;
GO
DBCC CLONEDATABASE(source, target);
GO
ALTER DATABASE target SET READ_WRITE WITH NO_WAIT;
Then backup and restore the target somewhere.
1
3
7 Mar 2020
Need to create 1000 tiny databases on 3 different servers for an experiment?
1..1000 | ForEach-Object { New-DbaDatabase -SqlInstance sql2017, sql2016, sql2012 }
2
14
52
7 Jan 2020
SQL2016でAlwaysOn構成にすると、フェールオバーするたびにユーザー不整合起こすんだけどそんなもんなの？
1
2
3 Jan 2020
MSSQL Server'da Backup Encryption Nasıl Yapılır ?
hakanhifzioglu.com/2019/08/1…
#sql #mssql #backup #encryption #sql2012 #sql2014 #sql2016 #sql2017 #sql2019
1
1
4 Dec 2019
I love Dbatools.io, my favourite: Test-DbaLastBackup -SqlInstance sql2016
Determines the last full backup for ALL databases, attempts to restore all databases then performs a DBCC CHECKDB. Once the test is complete, the test
restore will be dropped.
1
3
21 Oct 2019
@smartDataIncLtd Microsoft Certified Gold Partner has experience in ASP.NET, .NET 4.7, MVC 6.0, .NET Core, Azure services, N-Tier arch, N-Hibernate, C#, Visual Studio 2015/2017, LINQ, WCF, WPF, CSS3.0, HTML5, MS SQL2016, COSMOS DB,Telerik, DevExpress, PowerBI etc.
2
3 Oct 2019
1
1
21 Sep 2019
This is my recent discovery on TraceFlags specifically for perf config recommendations in #SQL2016 & #SQL2017 😎 support.microsoft.com/en-us/… #SQLServer
cc @SQLEspresso
1
1
4
9 Jul 2019
New SQL Server 2016 Security Updates:
sqlserverbuilds.blogspot.com…
13.0.5366.0 Security update for SQL2016 SP2 CU7 GDR
13.0.5101.9 Security update for SQL2016 SP2 GDR
13.0.4604.0 Security update for SQL2016 SP1 CU15 GDR
13.0.4259.0 Security update for SQL2016 SP1 GDR
2
24 Jun 2019
QUITO ¡Inscripciones Abiertas! Curso Oficial: Administering a SQL Database Infrastructure.
Para más información INGRESA AL SIGUIENTE LINK:goo.gl/9LRnE1
Capacítate💡 con Los #1.
#PartnerOfTheYear #CapacitacionesQuito #SQL2016 #Basededatso#Microsoft #BusinessIT 🏆
2
2
24 Jun 2019
You missed some of the exciting news for developers in #SQL2016, #SQL2017 or #SQL2019? Then join me now in my #dwx2019 session and catch up with your #SQLServer knowledge.
5
20 Jun 2019
Officially, I think SSISDB is not supported as part of an avialability group until SQL2016. If you patch this, you have to take SSISDB out of the AG first. SQL2016, there's a check in the patching process to get you to do just that. It's a PITA.
1
2
