Compare Table Contents Procedure

Compare the content of two tables for differences

Comparing and Synchronizing Two Folders with Azure

In this article, we will compare two folders using PowerShell, the command prompt and other tools.

PowerShell Solutions - Several tips for daily tasks

In this tip, we will talk about PowerShell and SQL Server Log and Data Files.

Comparing with NULL

Compare two tables for structure and layout

Compare the structure/layout of two tables within an instance of SQL Server (version 2012) and return non-matches.

RE: SQL Server Scripting and WMI

Hi Phill, I have thought about the dark side of the article myself... But, I also think that if Administration is done properly, which means Domain admins and SQL Admins are different entities that do not share domain passwords, (and of course passwords are changed regularly as part of the business operational tasks, which is […]

RE: Reading SQL 7.0 trace files in SQL 2000

We're being hammered by HIPAA on our side, and Profiler is the worst performing utility that comes with SQL Server that I've had experience with. We are looking at third party solutions. I believe the one we like the best at this time is SQL Guard which doesn't run on the box at all. It's […]

RE: Table Datatype with primary key

Hi Stefan,Are you creating the table from scratch? If so this should work just fine.CREATE TABLE TableName ([PrimaryKey] [int] IDENTITY (1, 1) NOT NULL, [ColumnName] [int] NOT NULL,    [ColumnName] [varchar(4)] NOT NULL) ON [PRIMARY]ALTER TABLE TableName WITH NOCHECK ADD CONSTRAINT   [PrimaryKey_TableName] PRIMARY KEY  CLUSTERED   ([PrimaryKey]) ON [PRIMARY]If the table already exists, just use the second bit.Why […]

Creating Installer w/ MSDE: Need to start server for OSQL

I have an installer package that installs MSDE, MDAC, etc for the client. I also need to run an SQL package to load the database. What I need to do is start the local MSDE so that I can run the following batch file:The OSQL will not run after the MSDE installation unless the PC […]

Check Transaction Log Before backup

Hello,the integrity of the data bases is controlled with the DBCC Checkdb command. Exists some form to control the transaction log integrity?Thanks