SQL Server
Drop all foreign key from all tables sql server
Drop all foreign key from all tables sql server DECLARE @SQL VARCHAR(MAX)='' …
SQL Server
Recent posts
View all
SQL Server
Drop all foreign key from all tables sql server
Drop all foreign key from all tables sql server DECLARE @SQL VARCHAR(MAX)='' SELECT @SQL = @SQL + 'ALTER TABLE ' + QUOTENAME(FK.TABL…
Read more
SQL Server
Get size of all tables in database
get-size-of-all-tables-in-database SELECT t.NAME AS TableName, s.Name AS SchemaName, p.rows, SUM(a.total_pages) * 8 AS TotalSpaceKB…
Read more
Asp.net C#
Generate Machine Key
Generate Machine Key http://www.eggheadcafe.com/articles/GenerateMachineKey/GenerateMachineKey.aspx
Read more
Asp.net C#
Encrypt & Decrypt a String in C#
Encrypt and decrypt data using a symmetric key in C#. Usage var str = "String to be encrypted"; var password = "p@SSword"; var st…
Read more
SQL Server
Check active connections and database users in sql server
Check active connections and database users in sql server SELECT DB_NAME(dbid) as DBName, COUNT(dbid) as NumberOfConnections, loginame…
Read more
Social Plugin