SQL Split String Function (STRING_SPLIT in 2016)
* originally published in our old blog in August 2011 - updated with SQL Server 2016 reference
As a SQL Server developer you...
2016-11-01
1,033 reads
SQL Split String Function (STRING_SPLIT in 2016)
* originally published in our old blog in August 2011 - updated with SQL Server 2016 reference
As a SQL Server developer you are often faced with the need to...
2016-11-01
23 reads
t-sql random string generator
Note: originally published in our old blog on December 2008.
CodeProjectThis is a simple stored procedure that you can use...
2016-10-31
5,289 reads
t-sql random string generator
Note: originally published in our old blog on December 2008.
CodeProject
This is a simple stored procedure that you can use to generate a random string. You can use it...
2016-10-31
14 reads
Distributed Databases - One Way Synchronization
Applies to: xSQL Data Compare v7.0.0 – v9.0.0
Business Need
A very common organization of the data infrastructure for big companies who operate...
2016-10-27
317 reads
Distributed Databases - One Way Synchronization
Applies to: xSQL Data Compare v7.0.0 – v9.0.0
Business Need
A very common organization of the data infrastructure for big companies who operate in many countries and use some type of...
2016-10-27
5 reads
Syncing QA data with Production
Applies to: xSQL Data Compare v7.0.0 - v9.0.0
Nowadays, Quality Assurance (QA) is a very important part of the development process for any...
2016-10-20
638 reads
Syncing QA data with Production
Applies to: xSQL Data Compare v7.0.0 and higher
WARNING: this article focuses on the data transfer / synchronization task and does not address operation security issues and sensitive data scrubbing /...
2016-10-20
48 reads
Columnstore Indexes in 2 minutes
The standard way of storing relational database tables on physical media is row based, that is, each row occupies a...
2016-10-18
216 reads
Columnstore Indexes in 2 minutes
The standard way of storing relational database tables on physical media is row based, that is, each row occupies a contiguous space. The term that is used for this...
2016-10-18
12 reads
Blogs
Accept the no and move on
By Brian Kelley
Here is a short emotional intelligence (EI) post for today, courtesy of Seth Godin....
Don’t Fight with AI
By Steve Jones
I was recently trying to handle a simple task with a few AI tools...
Narrow Task Decomposition in AI Pipeline Agents
A nightly load into sales_fact fails. Ask an orchestrating agent to break down the...
Forums
jdbc auth failing to sql from sap's cloud middleware CPI
hi , our business partner is asking s4 sap api's for receivable info and...
Searching for my own posts
I have a really stupid question... Is there an easy way to search for...
How to Work with On-Premises AI Models to Generate T-SQL Code
Comments posted to this topic are about the item How to Work with On-Premises...
Question of the Day
Escaping Strings
The STRING_ESCAPE() function requires 2 parameters in SQL Server 2025. The first is a string of text and the second is the type of escape rules being used. What are the options for the second parameter?
See possible answers