#sql2016

[catzeye-blog-blog-blog]

Cool office! #SQL2016 #azure #dba 👍 #goodfood (at Microsoft Partners Philippines)

[ccomptonnc]

Put commas in numbers

Numbers with commas in SQL Server 2012+

SELECT top 1 FORMAT(pkEmployee, N'N', C.culture) FROM [dbo].tableName

Numbers with commas in SQL Server 2008 R2 (versions <2012)

SELECT top 1 REPLACE(CONVERT(varchar(20), (CAST([pkEmployee] AS money)), 1), '.00', '') FROM [dbo].tableName

[sqljoker]

Tweeted

MCSA SQL 2016 Database Administration Training & Certification Package https://t.co/Oz8nGEM0BQ #sql2016

— SQL Joker (@sql_joker) May 31, 2019

[samtran-me]

CLR Integration: Bringing functionality and productivity to SQL Server

CLR Integration: Bringing functionality and productivity to SQL Server

If you’ve been following the recent developments for SQL Server, you’ve probably noticed Microsoft is not only bringing more and more features onto the platform but also increasingly encouraging developers to extend the base functionalities through integration with other programming languages including those outside the core .Net languages of C# and VB.Net.

In SQL2016, it was all R and data…

[stefanstranger]

RT @JimmyTheHarper: Possible increased unused disk space when running SCOM 2016 on SQL2016 - https://t.co/pqTvwle9DU #SCOM #OpsMgr #SysCtr

Possible increased unused disk space when running SCOM 2016 on SQL2016 - https://t.co/pqTvwle9DU #SCOM #OpsMgr #SysCtr

— Jimmy Harper (@JimmyTheHarper) July 18, 2017

from Twitter https://twitter.com/sstranger July 19, 2017 at 09:16AM via IFTTT

[dbareactions]

When I'm waiting for the SQL Server 2016 release date, pricing, and edition/feature list

[ajithmg]

Microsoft is bringing SQL Server to Linux  

http://techcrunch.com/2016/03/07/microsoft-is-bringing-sql-server-to-linux/

[sqljoker]

Tweeted

#SqlServerHelp - SQL2016 and VS 2015 (new QueryWindow => disconnected) https://t.co/l5i5f9fMRU via SSC

— SQL Joker (@sql_joker) October 18, 2017

[sqljoker]

Tweeted

#SqlServerHelp - Moving from SQL2014 AlwaysOn AG to SQL2016/2017 https://t.co/F7rAGv3R1h via SSC

— SQL Joker (@sql_joker) October 16, 2017

[sqljoker]

Tweeted

#SqlServerHelp - Analysis Services task throwing error when TargetServerVersion for project set to SQL2016 https://t.co/k0feMDxId6 via SSC

— SQL Joker (@sql_joker) October 13, 2017

[sqljoker]

Tweeted

🤓 -> Group Managed Service Accounts (gMSAs) in SQL2016 https://t.co/PI5XxoZpDd #SqlServer #Sql 🤓

— SQL Joker (@sql_joker) October 12, 2017

[sqljoker]

Tweeted

#SqlServerHelp - Group Managed Service Accounts (gMSAs) in SQL2016 https://t.co/9Xkk2gAiLE via SSC

— SQL Joker (@sql_joker) October 12, 2017

[sqljoker]

Tweeted

#SqlServerHelp - Weird OPENQUERY results sql2016 -> oracle 12c https://t.co/z1o2m2J8vY via SSC

— SQL Joker (@sql_joker) July 26, 2017

[sqljoker]

Tweeted

#SqlServerHelp - SQL2016 Servername\Replication https://t.co/OvqziQ3M4w via SSC

— SQL Joker (@sql_joker) July 20, 2017

[sqljoker]

Tweeted

#SqlServerHelp - Win 2016 Core and SQL2016 Ent - Server Configuration Manager - WMI error, Done mofcomp https://t.co/3zVlbWFJC4 via SSC

— SQL Joker (@sql_joker) June 9, 2017

[dbareactions]

When I find out CHECKDB still skips Hekaton tables in SQL Server 2016