Problem solve

SQL Server Database Compliance

• Eight ways that SQL Server developers hurt performance

  Application developers who access SQL Server can affect server performance without knowing it. Here are eight things SQL Server developers often do wrong.Continue Reading

• Speed up execution times in Microsoft SQL Azure

  Compare the time cost of database calls to SQL Azure versus calls to a local server and get recommendations for improving the speed of database calls to SQL Azure.Continue Reading

• Meet compliance requirements with improved database security practices

  Small but consistent changes are the trick to securing your SQL Server database and maintaining compliance with the latest industry rules and regulations.Continue Reading

• The fine line between not encrypting your databases and breach notification

  Neglecting to encrypt personal information in your SQL Server database can leave your organization vulnerable to certain compliance issues. Get the facts to keep you and your company protected.Continue Reading

• Sarbanes-Oxley compliance checklist: IT security and SQL audits

  If your SQL Server environment is not yet expected to meet Sarbanes-Oxley (SOX) Act compliance standards, it soon will be. In this tip, SQL Server expert Michelle Gutzait presents security practices, procedures and documentation that prepare you for...Continue Reading

• Security testing for compliance -- just how much do you need?

  Because of government demands, testing your databases and related SQL Server applications for security flaws is no longer simply on the IT wish list. But how much testing is really necessary? IT security specialist Kevin Beaver notes key systems to ...Continue Reading

• Logging for security compliance in SQL Server

  Logging for security compliance in SQL Server can be tricky. Recommendations come from all directions: vendors, auditors and lawyers. As a SQL Server administrator, it's your job to determine what's reasonable based on risk. Contributor Kevin Beaver...Continue Reading

• Find the size of every database

  This handy script will find the size of every database in SQL Server 2000 without using the sp_spaceused function.Continue Reading

• Alternate way to find database size

  Here's a quick SQL Server script that finds the size of the database and separates the log and data file sizes.Continue Reading

• Are you ready for a compliance audit?

  SOX, HIPAA, SB1386, EUDPA, GLBA. Are you ready?Continue Reading

• Script to kill all database processes

  Here is a script to silently kill all users connected to a SQL Server database.Continue Reading