SearchSQLServer : Expert advice on database administration

Home | Login | contact us | Site Map | Privacy Policy

FAQ

Knowledge Base

Resources

About Site

News Categories

SearchSQLServer: Expert advice on database administration

Native string manipulation functions for SQL Server	(Tue, 09 Mar 2010)
Check out this list of custom functions for basic string manipulation – a great skill for any database professional.
More...

Backing up SharePoint-related SQL Server databases	(Thu, 04 Mar 2010)
Find out exactly which database backup and recovery models you'll need for a full backup and restore of a SharePoint-associated SQL Server database.
More...

Getting set up for multi-server management with SQL Server 2008 R2	(Wed, 03 Mar 2010)
One of SQL Server 2008 R2's most talked-about new features allows DBAs to monitor the performance of multiple instances with a single glance.
More...

SQL injection tools for automated testing	(Mon, 01 Mar 2010)
Manual testing for SQL injection requires a lot of effort with little guarantee that you'll find every vulnerability. Fortunately, there is a better way.
More...

Log shipping: Four tips to maintain RTO and RPO with SQL Server	(Thu, 25 Feb 2010)
It's not uncommon for DBAs to be lulled into a false sense of security by log shipping, without realizing the negative effects it could have on disaster recovery.
More...

Geospatial mapping made simple with Microsoft SQL Server	(Tue, 23 Feb 2010)
The new spatial and analytic mapping functionality in Microsoft Report Builder is a great way to generate more dynamic SSRS reports – once you know how to create them.
More...

Finalizing maps with Report Builder 3.0	(Tue, 23 Feb 2010)
Like an onion or parfait, maps in SQL Server Report Builder have many layers. Here you'll learn how to finish off a map by adding point and tile layers in your report.
More...

Adding a polygon layer to a map in Report Builder 3.0	(Tue, 23 Feb 2010)
The first step to putting a geospatial map in an SSRS report involves creating what's known as the polygon layer. This tip explains what that means and how to get started.
More...

Ten key changes with SQL Server 2008 R2	(Thu, 18 Feb 2010)
A lot's different in Microsoft's upcoming SQL Server release. Check out our list of the 10 most significant changes.
More...

The ultimate SQL Server security faux pas: Overlooked systems	(Wed, 10 Feb 2010)
Maintaining a secure environment means not only shoring up your highly visible systems, but also staying on top of the smaller installations that tend to slip through the cracks.
More...

main page | News Categories | Resources | FAQ

About Site | Privacy | Link Partners