CriticalSites has announced two new security products

today CriticalSites has announced two new security products on their website, Total Account Controller (TAC) and Service Account Controller (SAC)

 

Total Account Controller (TAC)

As the size of your network grows it becomes impossible for your network administrator(s) to effectively manage all these machines manually as well as organize their passwords changes.
Since effective management of windows local accounts is critical to your company’s information and thus to the success of your business. CriticalSites Total Account Controller (TAC) is the solution to the simple and efficient management of local windows accounts.

 

Service Account Controller (SAC)

Everyday storage professionals are peppered with a hail of security warnings about imminent threats. Organizations don’t know what to work on first, and no one knows how secure they “REALLY” are until their security has been breached; by then it’s too late. It is almost impossible to quantify how secure your Network is.
What is needed is a Metric, something that can measure the relative vulnerability of your entire network against a benchmark you create. A consistent measuring stick empowers your organization to measure both its successes and its failures.
Most importantly, measuring against a standard allows your organization to continually minimize its risk by empowered incremental process improvements over time.
Service Account Controller through its “Risk Index” provides both the metric and the means by which to measure.

 

How to shrink your SQL Server Database

What if you have a huge SQL Server Database and you can’t deal with it because of its huge size in Gigabytes or even Terabytes like your website traffic or your archive databases, and you need to get them backed up, or get a copy of them for your development reasons. Whatever it would be, at some point you will need to copy or move this DB somewhere else.

so you would need to shrink both data and log files to make this an easier process, here is an example:

 

for the data file:

USE UserDB;
GO
DBCC SHRINKFILE (DataFile1, 7);
GO

this shrinks the size of the data file named DataFile1 in the UserDB database to 7MB, it doesn’t mean that it would force it to be 7MB or lose data, it means that it would shrink it to the minimum size it could be.

 

for the log file:

USE AdventureWorks;
GO
-- change the database recovery model to SIMPLE.
ALTER DATABASE AdventureWorks
SET RECOVERY SIMPLE;
GO
-- Shrink the truncated log file to 1 MB.
DBCC SHRINKFILE (AdventureWorks_Log, 1);
GO
-- Reset the database recovery model.
ALTER DATABASE AdventureWorks
SET RECOVERY FULL;
GO

this shrinks the log file in the AdventureWorks database to 1MB, to allow the DBCC SHRINKFILE command to shrink the file, the file is first truncated by setting the database recovery model to SIMPLE.

 

Read More:

DBCC SHRINKFILE (Transact-SQL)