SQL UPDATE for VARCHAR, NVARCHAR and VARBINARY using WRITE Clause
In this tip we look at doing updates to SQL Server columns with data types of VARCHAR(MAX), NVARCHAR(MAX) and VARBINARY(MAX) and how to use the write clause for the update.
Douglas Correa is a database professional focused on performance tuning database, high-availability, and infrastructure. He has been working with SQL Server for more than ten years. He has performance-tuned databases ranging from 1 gigabyte to terabytes working with PowerShell, SQL Server and Oracle. He has certifications from Microsoft (MCSA SQL Server, MTA Network) and Oracle (OCE, OCA 11g).
How to setup and use a SQL Server Stretch Database
In this tip we look at the new stretch database feature in SQL Server. We look at how to configure and use this feature.
Customize SQL Operations Studio Dashboards
In this tip we look at how you can easily customize the SQL Operations Studio Dashboards at the database and server level.
Access Amazon Redshift data from SQL Server via a Linked Server
In this tip we look at how to create and use a linked server between Amazon Redshift and SQL Server.
Setting SQL Server Configuration Options with AWS RDS Parameter Groups
In this tip we take a look at how to setup server and database configuration options when using AWS RDS by using parameter groups.
PowerShell AWS Tools for Fast File Copy
Learn how to have a fast file copy with the PowerShell AWS tools.
Tighten SQL Server security with custom server and database roles
Check out this tip to learn how to limit DBA level access in SQL Server by building custom server and database roles.
SSIS Transformation Tasks Overview
SQL Server Integration Services is a powerful tool to create ETL solutions. In this tip we will cover different scenarios to give you an idea on how you can use some of the SSIS features.
Using Microsoft Query in Excel to Retreive SQL Server Data
Excel is an easy way to retrieve external data from SQL Server. In this tip we look at how to use Microsoft Query to filter the data.
Access MySQL data from SQL Server via a Linked Server
There are often times when you need to access data from MySQL from within SQL Server. You could export and import the data, but another option is to create a linked server from SQL Server to MySQL. In this tip we walk through how this can be done for MyS
SQL Server Replication Error – Cannot generate SSPI context
After setting up transactional replication via scripts, replication didn't work and showed the following error: Target principal name is incorrect. Cannot generate SSPI context. Read this tip to learn how to fix this issue.
Import Active Directory Data to a SQL Server Table
Active Directory has a lot of great information that can be used for other systems. Read this tip on how to import Active Directory data to SQL Server.
Using PowerShell to export Active Directory information
In this tip we look at how to export Active Directory data that can be used to populate a SQL table or other system.