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
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
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
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
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
I want to share my way to convert a string to Base64 and back. Let me note that presented method...
2015-09-30
1,887 reads
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
12 reads
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
One of widespread problems in SSIS packages is to replace NULL values with some specific value. Unfortunately, before it was...
2015-09-25
1,282 reads
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
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
17 reads
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
i see this in the definition of a linked server on our wh sql...
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
Comments posted to this topic are about the item Stairway to Snowflake Level 5...
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers