Search
Monday, July 16, 2018

21

Jul

2017

TurboDNN

Author: ExWeeto

TurboDNN is part of a set of SQL scripts for improving the performance and stability of websites running on DNN Platform.

Comments (0) Number of views (629)
Read more

Categories: CMS, DNN, Database, MSSQL

Tags:

21

Mar

2016

DNN SQL Database Housekeeping

Checking table sizes and truncating log files

Author: ExWeeto

Here are some key methods for keeping your DNN database (MS SQL Server) tidy.

Comments (0) Number of views (1633)
Read more

Categories: CMS, DNN, Database, MSSQL

Tags:

3

Oct

2015

Manifesto for Agile Software Development

Author: ExWeeto

Here is the well-known "Agile Manifesto", adopted by many software developers, indicating the importance of individuals and interactions, working software, customer collaboration, and responding to change.

Comments (0) Number of views (1359)
Read more

Categories: Programming, CMS, Database

Tags:

5

Sep

2015

Copy a Table from One Database to Another on Different Clients

Author: Exweeto

I wanted to copy the contents of a table of links from one database to another. Both databases are hosted on the cloud-based hosting platform where I host all my sites; they are the backends of DNN instances. Problem is, while I can access my databases from my local machine using MS SQL Server Management Studio (SMS), and I can connect to each database concurrently, I could not find any way to use standard SQL commands to copy the content of a table in one database to an equivalent table in another; it came up with permissions problems no matter what I tried. Here is my solution; there are probably other solutions (e.g. export to CSV, import CSV), and some may be better, but this is how I did it!

Comments (0) Number of views (843)
Read more

Categories: Database, MSSQL

Tags:

“If I had eight hours to chop down a tree, I'd spend the first six of them sharpening my axe.”

Abraham Lincoln

Copyright 2018 by Exweeto Terms Of Use Privacy Statement