Join us on May 2nd, as we discuss preparing for DDoS attacks, building resiliency, overcoming obstacles and key preparations to make now before ransomware attacks.
I'm using snapshot replication in SQL Server 7.0, and I discovered that the referential integrity defined on the source table is lost on the destination tables at the subscriber. I've selected the Include declared referential integrity on the...
I'm using SQL Server Profiler to trace application activity, but the Profiler logs aren't showing some commands that I know the application issued. Is Profiler reliable? Why is it missing commands...
My SQL Server Profiler doesn't seem to be correctly processing SQL:StmtCompleted events. SQL Server Books Online (BOL) says that SQL:StmtCompleted will capture SQL statements as they execute within the body of a stored procedure. However, my...
Log backups are an important part of a full database backup. SQL Server backs up the transaction log as part of a full backup to make the full backup transactionally consistent when the full backup is restored. Before you can back it up, the...
Deciding what type of user data should go into your filegroups can take some planning. To start, I recommend that the primary filegroup contain only one file (an .mdf) that contains only the system tables (sysobjects, sysindexes, sysusers, and so...