SQL Server – Query to find a column in every table in all tables

Source: http://blog.sqlauthority.com/2008/08/06/sql-server-query-to-find-column-from-all-tables-of-database/

 

USE AdventureWorks
GO
SELECT t.name AS table_name,
SCHEMA_NAME(schema_id) AS schema_name,
c.name AS column_name
FROM sys.tables AS t
INNER JOIN sys.columns c ON t.OBJECT_ID = c.OBJECT_ID
WHERE c.name LIKE ‚%EmployeeID%‘
ORDER BY schema_name, table_name;

Dedup-Tool Cross-Platform

Just found a handy little tool finding duplicate files on your storage. Works like a charme on my Ubuntu box – even to a poorly connected NAS (PowerLAN to cellar). Till now it saved me 6 GB of space on my NAS. Hopefully more to come.

http://xmodulo.com/dupeguru-deduplicate-files-linux.html

Should be read more often …

We trust you have received the usual lecture from the local System
Administrator. It usually boils down to these three things:

#1) Respect the privacy of others.
#2) Think before you type.
#3) With great power comes great responsibility.

SQL Server 2012 Availability Groups

Deploying AGs:

How to Set Up SQL Server 2012 Always On Availability Groups

Specials about user managment:

http://blogs.msdn.com/b/mvpawardprogram/archive/2012/07/16/contained-databases-in-sql-server-2012.aspx

http://blog.fumus.de/sql-server/contained-databasedie-eigenstndige-datenbank#Migration_von_Datenbanken_und_Benutzern_in_Contained_Databases

Lessons learned:

AlwaysOn Availability Groups Real-Life Lessons Learned (Video)

 

AV-Groups on VMware:

https://www.vmware.com/files/pdf/solutions/SQL_Server_on_VMware-Availability_and_Recovery_Options.pdf

 

Upgrading AlwaysOn Availability Group Replica Instances

https://msdn.microsoft.com/en-us/library/dn178483.aspx

pt>