Tags » SQL Server

How to find the collation of a database or all columns of a given table

-- DB Collation
SELECT DATABASEPROPERTYEX('AdventureWorks2014', 'Collation')
GO

select collation_name, * from sys.databases where name = 'AdventureWorks2014'


-- Table Collation
USE AdventureWorks2014 

SELECT name as ColumnName, collation_name
FROM sys.columns
WHERE OBJECT_ID IN (SELECT OBJECT_ID
FROM sys.objects
WHERE type = 'U'
AND name = 'DatabaseLog') -- Table Name
SQL Server

SQL SERVER - SSMS: Transaction Log Shipping Status Report

History has its own way to define now civilizations thrived. Most of the cities flourished in the river side and transporting lumber was one of the key activity. 698 more words

SQL Authority

SQL PASS Performance Virtual Chapter - Performance Palooza Post-Presentation

Whew, how’s that for a title?

Earlier today, I had the privilege of being invited to present my Every Byte Counts presentation, for the SQL PASS Perf. 279 more words

SQL Server

Two SQL Server Webcasts from MSSQLTips.com

I’ve done two SQL Server webcasts for my friends at MSSQLTips.com. One is regarding security best practices for deploying SQL Server databases in the cloud. As more and more customers are thinking of deploying databases in the cloud, security is one of their main concerns. 105 more words

SQL Server

Collation in SQL Server and fixing collation issues.

Collation refers to a set of rules that┬ádetermines how your data is sorted and compared. It’s very often important with regards to internazionalization, e.g. how do you sort japanese kanji? 523 more words

SQL SERVER