Tips

Putting the final touches on gauges with Report Builder 3.0

Even when your gauge is complete, there are still a few tweaks to be made in the name of data visualization. Learn how to add the right finishing touches with Report Builder 3.0. Continue Reading
Adding gauges to reports with Report Builder 3.0 for SQL Server

Report Builder 3.0 comes with several new data visualization features, including gauges for creating more effective reports with SQL Server Reporting Services. Continue Reading
Making sense of Parallel Data Warehouse for SQL Server 2008 R2

SQL Server 2008 R2 will be released in two new editions, one of which has been dubbed Parallel Data Warehouse. But should organizations care? Continue Reading
Common oversights with SQL Server security audits

Just because your SQL Server looks secure from the outside doesn't mean you are in the clear. Learn to dig deeper to find the hidden flaws just waiting to be exploited. Continue Reading
Combining result sets from multiple SQL Server queries

More than one operator can be used to bring multiple queries together for a single result set, but be aware that each one will provide a different result. Continue Reading

SQL Server replication: How it works and when to say no

Each form of SQL Server replication offers its own benefits, but sometimes the best option is to avoid replication altogether. Continue Reading
Top 5 SQL Server DBA tasks that are a waste of time

While some DBA tasks are less important than most, others can be completely pointless. Could you be wasting valuable time without even knowing it? Continue Reading
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