11 Tips to Backup databases with SMO, VB, C# Powershell, Command lines
Sometimes we need to create backups using code. Sometimes we need to do it manually or automatically, programmatically using C#, VB, Powershell.
2012-08-14
7,653 reads
Daniel Calbimonte
- Skills: ssas, ssis, ssrs, Power BI, Azure
The User Defined Server Roles in SQL Server 2012
This article describes how to create user defined server roles and use stored procedures and queries related.
2012-05-25
4,606 reads
New features in SQL 2012, the contained database
This article describe the problems about the migration of the databases and logins and the new feature contained databases
2012-05-22
10,883 reads
Run SQL Server Scripts using C#
In this article I will run a SQL Server script to backup a database using C# in visual studio. For this purpose, I am going to use the sqlcmd.
2012-04-27
17,995 reads
Linked server to MySQL Server.
In this article, we are going to create a linked server to the MySQL Database.
Once finished that task, we will select, insert, update and delete some data using SQL Server.
2012-04-17
9,969 reads
Sequences in SQL Server 2012
This article describes the sequence new feature used in SQL Server 2012
2012-04-13
9,454 reads
Bye Bye to the RAISERROR Function?
This article describes the use and advantages of the throw statement.
2012-04-03
2,738 reads
How to create a database backup using visual studio
This article describes how to backup a database using a C# Windows Form.
2012-03-30
15,455 reads
A Demo of the Power of Powershell
This demo will show you the how powerfull is powershell. We will use cicles and the get-content command.
2012-03-22
9,944 reads
Blogs
Microsoft Fabric Data Agents: Bringing Structured and Unstructured Data Together
By James Serra
Most enterprise questions do not live neatly in one place. The numbers may be...
Keeping Redshift System Table History Past 7 Days with S3 Tables
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
Updating the Data API Builder
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
Forums
Parameter Sensitive Plan Optimization vs. Parameter Sniffing: What SQL Server Fixes and What It Doesn't
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization vs....
Hyperscale Replicas I
Comments posted to this topic are about the item Hyperscale Replicas I
The End of Summer
Comments posted to this topic are about the item The End of Summer
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers