New toys in SQL Server 2012
In this article we are going to look two new enhancements: the Insert snippet menu option and the surround with option.
2014-09-01 (first published: 2012-05-15)
18,732 reads
Daniel Calbimonte
- Skills: ssas, ssis, ssrs, Power BI, Azure
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,645 reads
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,603 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,881 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,991 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,961 reads
Sequences in SQL Server 2012
This article describes the sequence new feature used in SQL Server 2012
2012-04-13
9,443 reads
Bye Bye to the RAISERROR Function?
This article describes the use and advantages of the throw statement.
2012-04-03
2,724 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,447 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,939 reads
Blogs
Excellent article on securing msdb
By Brian Kelley
Fabiano Amorim has written an excellent article at Simple Talk on securing msdb. Here's...
T-SQL Tuesday #201: Temp Tables
By Steve Jones
This month we have a new host, which I am grateful for. So many...
When Do You Reach For A #temp Table?
I needed to do some research because there is more to #temp tables than...
Forums
jdbc auth failing to sql from sap's cloud middleware CPI
hi , our business partner is asking s4 sap api's for receivable info and...
Searching for my own posts
I have a really stupid question... Is there an easy way to search for...
How to Work with On-Premises AI Models to Generate T-SQL Code
Comments posted to this topic are about the item How to Work with On-Premises...
Question of the Day
Escaping Strings
The STRING_ESCAPE() function requires 2 parameters in SQL Server 2025. The first is a string of text and the second is the type of escape rules being used. What are the options for the second parameter?
See possible answers