Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
<< Previous headlines | Later headlines >>
SQLServerCentral.com Headlines from 2013/04/15 to 2013/04/22

Stay Backed Up by Monitoring Your Backup Process

Based on a linked server setup, you can check your SQL Server backups on multiple instances.  Read more...
By Willem Gossink 2013/04/22 | Source: SQLServerCentral.com | Category: monitor server
Rating: |  Discuss |   Briefcase | 3,756 reads

Diagnosing Common Database Ails

When a database starts showing signs of an illness, it's up to the DBA to get to the root of the problem, fast. Kat Hicks takes a look at the most common causes of database troubles, free tools that can help, and the misconceptions that get in the way.  Read more...
By Additional Articles 2013/04/22 | Source: SimpleTalk | Category: diagnostic
Rating: (not yet rated)  Rate this |   Briefcase | 3,989 reads

SQL Server 2008 R2 Build List

The list of builds for SQL Server 2008 R2 up to CU14 for SP1 and CU12 for SP2.  Read more...
By Steve Jones 2013/11/05 (first published: 2010/05/25) | Source: SQLServerCentral.com | Category: sql server 2008 r2
Rating: |  Discuss |   Briefcase | 50,515 reads

SQL Server Central Webinar Series #23: Safeguard your data offsite with SQL Backup Pro

You may already have a great backup and recovery plan. However, if something were to happen to your databases and you needed to restore from your backups, you’d want to be in control, with the ability to access a copy of those backups quickly, restoring them with minimal downtime and minimal fuss. In this session Grant Fritchey, SQL Server MVP, will discuss the key reasons why you need to have offsite backups, and the advantages of hosted storage. He’ll address some of the fears surrounding cloud backups, and show how offsite backup is made quick and easy with the new ‘backup to hosted storage’ features in SQL Backup Pro 7.3.   Read more...
By Press Release 2013/04/23 (first published: 2013/04/16) | Source: SQLServerCentral.com | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 2,411 reads

Comparison of Queries Written in T-SQL and SQL Server MDX

Beginning to learn and comprehend SQL Server Analysis Services (SSAS) MDX queries can be difficult after one has spent years writing queries in T-SQL. When trying to write SQL Server MDX queries, it's worth considering "How would I write this query in T-SQL?"   Read more...
By Additional Articles 2013/04/19 | Source: MSSQLTips.com | Category: t-sql
Rating:  Rate this |   Briefcase | 3,963 reads

Using Regular Expressions to Convert PL/SQL code to T-SQL

When converting Oracle PL/SQL to T-SQL, there are a number of ways to do this, but this article shows us how this can be done with regular expressions in Management Studio.  Read more...
By P. Praveena 2013/04/19 (first published: 2011/10/11) | Source: SQLServerCentral.com | Category: regular expressions
Rating: |  Discuss |   Briefcase | 9,483 reads

SQL Server 2012 Build List

A list of the builds of SQL Server 2012 through SP2.  Read more...
By Steve Jones 2013/04/18 (first published: 2012/04/17) | Source: SQLServerCentral.com | Category: sql server 2012
Rating: |  Discuss |   Briefcase | 11,795 reads

The Elusive Conditional WHERE Clause

What's this, a conditional WHERE clause that doesn't use dynamic SQL?  Read more...
By John Hick 2013/04/18 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 20,420 reads

Disaster Recovery in the Enterprise – Paying the Price to Avoid Extra Costs

Data Protection and Disaster Recovery (DR) are IT tasks that seldom get the same level of attention as development… until disaster strikes. Only if planning is adequate can an organisation be resilient in the face of unexpected problems. There are several steps that are needed to achieve an adequate DR process and the ability to restore business operations after a disaster.  Read more...
By Additional Articles 2013/04/18 | Source: SimpleTalk | Category: disaster recovery (dr)
Rating: (not yet rated)  Rate this |   Briefcase | 2,400 reads

Stairway to Transaction Log Management in SQL Server Level, 8: Optimizing Log Throughput

This level takes a deeper look at how log fragmentation can affect the performance of operations that need to read the log, such as log backups, or the crash recovery process.  Read more...
By Gail Shaw, Tony Davis 2013/04/17 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 5,129 reads

Configure SQL Server 2012 AlwaysOn Availability Groups Read-Only Routing using PowerShell

With SQL Server 2012 AlwaysOn Availability Groups, you can configure read-only routing and to automatically redirect the read-only workloads to a secondary replica after a failover. Can this be done using Windows PowerShell?  Read more...
By Additional Articles 2013/04/17 | Source: MSSQLTips.com | Category: alwayson
Rating:  Rate this |   Briefcase | 1,417 reads

The Cascading (CROSS) APPLY

An old trick nowadays but one which is still underused here on SSC is the cascading CROSS APPLY – where output from one CROSS APPLY is used as input for another.  Read more...
By Chris Morris 2013/04/16 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 14,280 reads

T-SQL Coding Style

When you write T-SQL code what kind of coding style do you use? Do you have a consistent way to comment and format your code? Does your organization provide standards for how you must code your T-SQL? Join Greg Larsen as he discusses some of the coding styles you should consider when writing your T-SQL scripts and stored procedures.  Read more...
By Additional Articles 2013/04/16 | Source: Database Journal | Category: t-sql
Rating:  Rate this |   Briefcase | 5,984 reads

Data mining introduction part 4: the Naïve Bayes algorithm

This chapter explains the Naïve Bayes algorithm. How does it works, what information is displayed.  Read more...
By Daniel Calbimonte 2013/04/15 | Source: SQLServerCentral.com | Category: data mining
Rating: |  Discuss |   Briefcase | 8,778 reads

Managing SQL Server Statistics

Accurate statistics about the data held in tables are used to provide the best execution strategy for SQL queries. but if the statistics don't accurately reflect the current contents of the table you'll get a poorly-performing query. How do you find out if statistics are correct, and what can you do if the automatic update of statistics isn't right for the way a table is used?  Read more...
By Additional Articles 2013/04/15 | Source: SimpleTalk | Category: statistics
Rating: (not yet rated)  Rate this |   Briefcase | 6,281 reads