How to create a database on a network share
If for any reason you need to place the database on a network share and by default this option is off you can follow the way described below: A...
2015-10-12
4 reads
MS SQL Server 2014 Mirroring – thanks for being alive!
I decided to check if there is still database mirroring option in MS SQL Server 2014
Wow! It works!
MIrroring is still...
2015-10-08
589 reads
MS SQL Server 2014 Mirroring – thanks for being alive!
I decided to check if there is still database mirroring option in MS SQL Server 2014Wow! It works!However in the screenshot you see a message that new tables “in...
2015-10-08
4 reads
MS SQL Server 2014 Mirroring – thanks for being alive!
I decided to check if there is still database mirroring option in MS SQL Server 2014Wow! It works!However in the screenshot you see a message that new tables “in...
2015-10-08
1 reads
How to convert to Base64 and backwards via T-SQL
I want to share my way to convert a string to Base64 and back. Let me note that presented method...
2015-09-30
1,888 reads
How to convert to Base64 and backwards via T-SQL
I want to share my way to convert a string to Base64 and back. Let me note that presented method is not the fastest, but it has one important...
2015-09-30
13 reads
How to convert to Base64 and backwards via T-SQL
I want to share my way to convert a string to Base64 and back. Let me note that presented method is not the fastest, but it has one important...
2015-09-30
7 reads
SQL Server SSIS: ReplaceNull
One of widespread problems in SSIS packages is to replace NULL values with some specific value. Unfortunately, before it was...
2015-09-25
1,283 reads
SQL Server SSIS: ReplaceNull
One of widespread problems in SSIS packages is to replace NULL values with some specific value. Unfortunately, before it was not a simple task as Integration Services didn’t have...
2015-09-25
3 reads
SQL Server SSIS: ReplaceNull
One of widespread problems in SSIS packages is to replace NULL values with some specific value. Unfortunately, before it was not a simple task as Integration Services didn’t have...
2015-09-25
18 reads
Blogs
My 2024 in Data: Music
By Steve Jones
This is my last week of the year working (I guess I come back...
A New Word: Suente
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Side Projects
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
Forums
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Sql script replace and rearrange numbers
Hi everyone. I have this table and this information. (left side of the image)...