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 2012/09/27 to 2012/10/04

Matrix Math in SQL

Relational Datbases have tables as data structures, not arrays. This makes it tricky and slow to do matrix operations, but it doesn't mean it is impossible to do. Joe gives the Celko Slant on how to go about doing Matrix Math in SQL.  Read more...
By Additional Articles 2012/10/04 | Source: SimpleTalk | Category: t-sql
Rating: (not yet rated)  Rate this |   Briefcase | 3,427 reads

CPU and Scheduler Performance Monitoring using SQL Server and Excel

This article will demonstrate a method of creating an Excel-based CPU/scheduler performance dashboard for SQL Server 2005+.  Read more...
By Derek Colley 2012/10/04 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 7,150 reads

SQLServerCentral Webinar Series #21 - Forgotten Rings & Other Monitoring Stories

Most common monitoring metrics are important and useful, especially over time, but they can fall short. How do you gather information to determine, for example, if you have buffer cache pressure? Register now for the free webinar. Wednesday, October 17 2012 4:00pm - 5:00pm BST  Read more...
By Press Release 2012/10/15 (first published: 2012/09/20) | Source: Red-Gate | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 5,110 reads

Improve Your Database Unit Testing Skills and Win Free Stuff

As the SQL Developer community grows to embrace the benefits of test-driven development for databases, so the importance of learning to do it properly increases. One way of learning effective TDD is by the use of code kata – short practice sessions that encourage test-first development in baby steps. I have a limited number of licences for SQL Test to give away free – just for practicing a bit of TDD and telling me about it.  Read more...
By Additional Articles 2012/10/10 (first published: 2012/09/19) | Source: Other | Category: test-driven development
Rating:  Rate this |   Briefcase | 5,500 reads

Control Flow Task Errors – Level 9 of the Stairway to Integration Services

Level 9 of the Stairway to Integration Services looks at control flow tasks and error handling.  Read more...
Rating: |  Discuss |   Briefcase | 9,183 reads

SQL in the City - Seattle 2012

Start the week in Seattle off with a free day of training on Nov 5, 2012 with SQL in the City. Grant Fritchey, Steve Jones and more will be talking SQL Server in the Pacific Northwest. Join us and debate and discuss SQL Server the Red Gate Way.  Read more...
By Press Release 2012/10/16 (first published: 2012/09/13) | Source: SQLServerCentral.com | Category: sql in the city
Rating:  Rate this |   Briefcase | 5,192 reads

Protecting the SQL Server Backup folder

I want to backup my SQL Server databases to a folder, but I want to minimize who has access to the folder. In other words, I want to make sure that members of the Windows Local Administrators group don't get to the backups without intentionally trying to bypass the security. How do I do that?   Read more...
By Additional Articles 2012/10/02 | Source: SQLServerCentral.com | Category: security
Rating: (not yet rated)  Rate this |   Briefcase | 2,928 reads

What a View

I need to create views? How many? Today? This article talks about a few issues with using views too extensively in your design.  Read more...
By John Esraelo 2012/10/02 | Source: SQLServerCentral.com | Category: views
Rating: |  Discuss |   Briefcase | 7,655 reads

Report Builder 3.0: Formatting the Elements in your Report

There is a lot that can be done to make basic tabular reports more readable, using Microsoft's free Report Builder. Rob Sheldon continues his exploration of the power of this tool by showing how to format various elements within reports  Read more...
By Additional Articles 2012/10/01 | Source: SimpleTalk | Category: report builder
Rating: (not yet rated)  Rate this |   Briefcase | 2,559 reads

Stairway to XML: Level 3 - Working with Typed XML

You can enforce the validation of an XML data type, variable or column by associating it with an XML Schema Collection. SQL Server validates a typed XML value against the rules defined in the schema collection so that INSERT or UPDATE operations will succeed only if the value being inserted or updated is valid as per the rules defined in the Schema Collection.  Read more...
By Rob Sheldon 2012/10/01 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 10,400 reads

Data Access Tracing in SQL Server 2012

Learn how to apply the tracing functionality in Microsoft data access technologies such as ADO.NET 2.0, MDAC 2.82, SQL Server Native Client, and the JDBC driver; and in the SQL Server network protocols and the Microsoft SQL Server database engine.  Read more...
By Additional Articles 2012/09/28 | Source: Microsoft MSDN | Category: tracing
Rating: (not yet rated)  Rate this |   Briefcase | 2,502 reads

A simple T-SQL statement to create a list of lookup values

In this article, we provide a simple way to get a comma delimited list from a table of entries without having to use a CURSOR or a WHILE loop to read through the table.  Read more...
By Suresh G. Kumar 2012/09/28 (first published: 2011/03/21) | Source: SQLServerCentral.com | Category: cursor
Rating: |  Discuss |   Briefcase | 33,176 reads

An Interview with Amazon Web Services

A short interview with Sundar Raghavan of Amazon Web Services about SQL Server and their support and offerings of cloud data services.  Read more...
By Press Release 2012/09/27 | Source: SQLServerCentral.com | Category: cloud computing
Rating: |  Discuss |   Briefcase | 1,485 reads

Repairing a Broken Log Shipping Plan From a Differential Backup

This article details how to reinitialise a Log Shipping scenario from a primary differential backup  Read more...
By Perry Whittle 2013/12/20 (first published: 2012/09/27) | Source: SQLServerCentral.com | Category: differential
Rating: |  Discuss |   Briefcase | 3,274 reads

SQL Database Management Survey

Win one of two $50 Amazon vouchers by entering our database management survey. We’re finding out more about how SQL database professionals are doing backup and recovery, using cloud services and more. Answer the short survey for a chance to win.  Read more...
By Press Release 2012/09/27 (first published: 2012/09/24) | Source: Red-Gate | Category: survey
Rating:  Rate this |   Briefcase | 2,544 reads

Ten Things I Wish I'd Known When I Started Using tSQLt and SQL Test

The tSQLt framework is a great way of writing unit tests in the same language as the one being tested, but there are some 'Gotchas' that can catch you out. Dave Green lists a few tips he wished he'd read beforehand.  Read more...
By Additional Articles 2012/09/27 | Source: SimpleTalk | Category: unit testing
Rating:  Rate this |   Briefcase | 2,589 reads

Temporary Tables in Oracle and SQL Server

Jonathan Lewis (Oracle Ace Director, OakTable Network) and Grant Fritchey (Microsoft SQL Server MVP) will host a live discussion on Oracle and SQL Server, this time in relation to temporary tables.  Read more...
By Press Release 2012/10/08 (first published: 2012/09/27) | Source: SQLServerCentral.com | Category: webinar
Rating:  Rate this |   Briefcase | 4,897 reads