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
3 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
3 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
2 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,868 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
4 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
3 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,263 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
9 reads
In today's data-driven world, SQL (Structured Query Language) is a blazing-hot skill. It's your...
By Steve Jones
I leave tonight for Australia. I was in London 3 days ago, so this...
By Brian Kelley
As I look at the state of information technology today, I see one constant:...
Sample data: jan 10gb feb 15gb mar 16gb april 14gb(truncate data) may 18gb june...
Everybody (well almost) knows that if you want to learn the design patterns for...
How many table hints can I include in a query?
See possible answers