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
5 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
5 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
5 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
3 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,900 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
14 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
8 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,286 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
5 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
19 reads
Low-code solutions often accelerate development and make tasks accessible to people who can’t or...
By Steve Jones
Often we find out about a problem reported by a customer after the incident...
Let’s face it, most of the time, you probably don’t want your SQL Server...
Many job schedulers (e.g., SQL Agent, Airflow, Azure Logic Apps) can report when a...
Comments posted to this topic are about the item The Table Backup
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
I run this code in SQL Server 2022. What happens?
BACKUP TABLE beercount TO DISK = 'beercount.bak'See possible answers