Tips

Tips

• Password cracking tools for SQL Server

  When performing SQL Server penetration tests and security audits, there is one probe you must not miss: password cracking. Check out which tools – some free – to use.  Continue Reading

• Programming report generation with SQL Server Reporting Services 2008

  Learn the fundamentals of programmatic report rendering in SQL Server Reporting Services 2008 with examples of when you might use such functionality.  Continue Reading

• SQL Server high availability: Options and caveats

  DBAs have several techniques to choose from for ensuring SQL Server availability. Deciding on the right one for you is all about evaluating the costs versus the benefits.  Continue Reading

• Using traces in SQL Server Profiler

  A SQL Server Profiler trace can provide critical information on a problem query in a matter of seconds. Learn how – and when – to run the application.  Continue Reading

• Using DELETE and TRUNCATE TABLE statements to delete data in SQL Server

  Both statements can be used to delete SQL Server data, but some situations call for one over the other.  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

• Securing the server and database in SQL Server

  Hardening SQL Server at the database and server levels is crucial to a secure environment. Learn why in part two of our SQL Server security series.  Continue Reading

• Hardening the network and OS for SQL Server security

  To help prevent a major breach of your DBMS, it's important to secure all individual systems in an environment, including the network and operating system.  Continue Reading

• SQL Server security made simple and sensible

  The many layers of SQL Server security can be confusing. Learn to connect to SQL Server and retrieve data from databases, as well as the ins and outs of object ownership.  Continue Reading

• Speed up reports in SQL Server Reporting Services with caching

  Reporting Services' built-in caching feature can significantly speed up slow-running reports and improve overall performance for users -- but there are some limitations.  Continue Reading

• Data Transformation Services vs. SSIS: The key differences

  While SQL Server Integration Services 2008 is a major step up from the days of DTS, there are still some gotchas for developers to be aware of.  Continue Reading

• How SQL Server 2008 components impact SharePoint implementations

  SQL Server 2008 components such as the Database Engine or SSIS directly affect SharePoint implementations, but not all administrators understand how.  Continue Reading

• SQL language crash course (just enough to be dangerous)

  You can't get far in the SQL Server world if you don't speak the language. Check out the basics of SQL language with examples of common SQL Server queries.  Continue Reading

• Working with IntelliSense in SQL Server 2008 Management Studio

  IntelliSense in SQL Server 2008 Management Studio provides easy access to language elements when writing T-SQL queries. Knowing the basics can simplify coding in a big way.  Continue Reading

• Troubleshooting Distributed Transaction Coordinator errors in SQL Server

  Microsoft Distributed Transaction Coordinator enforces transactional consistency over multiple systems in SQL Server. Learn how to solve common errors and properly configure MSDTC.  Continue Reading