Tags » Microsoft SQL Server

Clean out all bad characters from a string.

I have a customer who is having a problem with a load. He is getting a fair number of bad characters including some unicode characters. The unicode characters in particular are making it so those values won’t go into a varchar column. 747 more words

Microsoft SQL Server

sql server 2012 sp2 cu5 is out

sql server 2012 sp2 cu5 is out – https://support.microsoft.com/en-us/kb/3037255

FIX: AlwaysOn availability groups are reported as NOT SYNCHRONIZING

https://support.microsoft.com/kb/3034679

FIX: Complex parallel query does not respond in SQL Server 2012… 222 more words

Microsoft SQL Server

0 to Speaker

Recently the last day to submit a session for the 2015 Pass Summit rolled around. I mention this because I actually submitted a session. This is the first time I’ve ever submitted something for the summit and only the third time I’ve submitted a session anywhere. 895 more words

Microsoft SQL Server

27th January 2015 Cardiff SQL Server Usergroup Questions.

Can you setup replication in SSDT?

How does non-overwrite work?

What editions is replication in?

https://msdn.microsoft.com/en-us/library/cc645993.aspx#Replication

Can you reduce service account DDL privileges for security, also capt?

Microsoft SQL Server

Parsing Microsoft SQL Profiler Trace XML using *DynamicXmlStream*

Appliedalgo.com - Grid Computing Democratized.

This article will show how compact syntax is extracting SQL statements from SQL Profiler Trace (Microsoft SQL Server) using Mahesh DyanmicXmlStream – which is *dynamic* ( 128 more words

SQL