|
Written by Administrator
|
|
Friday, 27 February 2009 22:34 |
The February 2009 tips include the following: Clustering, Common Language Runtime (CLR), Database Administration, Database Design, Full Text Search, JOINing Tables, Performance Tuning, Replication, Reporting Services, Security, SQL Server 2008, Surface Area Configuration Manager and T-SQL. Clustering Common Language Runtime (CLR)Database AdministrationDatabase DesignFull Text SearchJOINing TablesPerformance TuningPowerShellReplicationReporting ServicesSecuritySQL Server 2008Surface Area Configuration ManagerT-SQL | | | Additional Tips | BI / Reporting / SSIS / DTS Tip | How to know what Reporting Services reports are being used
SQL Server Reporting Services is a great tool to give your users access to commonly run reports. There is still the effort of developing the reports, but with parameter driven reports you can give your end users a lot of power very quickly without much d... | Development Tip | Using Views to Simplify Data Access in SQL Server
One challenge that just about everyone is faced with is ever changing database schemas. From the onset of a project the database schema might be perfect on day one, but as the application evolves and the business needs change database table structures ha... | DBA Tip | Auditing Windows Groups from SQL Server
Managing database security should be part of every DBAs job. With SQL Server you have the ability to use either SQL Server and Windows or Windows only security. The advantage of using Windows security for your SQL Servers is that you can take advantage ... | Professional Development Tip | SQL Server 2005 New Features Interview Questions
Staying up on the latest SQL Server technologies is a huge benefit to employers. Many seek only the best and brightest to build solutions for the organization. The general premise is the more knowledgeable their team is the more opportunities the organi... |
|
|
MS SQL Server 
