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/12 to 2012/09/19

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,478 reads

SQL in the City - San Francisco 2012

The city by the bay welcomes Steve Jones, Grant Fritchey and more for a day of debate, discussion and learning about SQL Server. It's free. Just register and join us.  Read more...
By Press Release 2012/09/19 (first published: 2012/08/29) | Source: SQLServerCentral.com | Category: sql in the city
Rating: (not yet rated)  Rate this |   Briefcase | 2,923 reads

Stairway to T-SQL DML Level 11: How to Delete Rows from a Table

You may have data in a database that was inserted into a table by mistake, or you may have data in your tables that is no longer of value. In either case, when you have unwanted data in a table you need a way to remove it. The DELETE statement can be used to eliminate data in a table that is no longer needed. In this article you will see the different ways to use the DELETE statement to identify and remove unwanted data from your SQL Server tables.  Read more...
By Gregory Larsen 2012/09/19 | Category: stairway series
Rating: |  Discuss |   Briefcase | 9,672 reads

Fuzzy-String Search: Find misspelled information with T-SQL

An optimized Damerau-Levenshtein Distance (DLD) algorithm for "fuzzy" string matching in Transact-SQL 2000-2008  Read more...
By Thomas Keller 2014/01/10 (first published: 2012/09/18) | Source: SQLServerCentral.com | Category: fuzzy match
Rating: |  Discuss |   Briefcase | 23,321 reads

Run an Oracle package from SQL Server Integration Services

If you want to run an Oracle Package and then execute a web service, copy files or folders, a sequence of tasks, you may need to use SQL Server Integration Services (SSIS).  Read more...
By Additional Articles 2012/09/18 | Source: MSSQLTips.com | Category: oracle
Rating: (not yet rated)  Rate this |   Briefcase | 1,712 reads

SQL Server 2012: Migrating BLOBs to FILETABLEs

Learn about this new feature in SQL Server 2012 and how to move your binary data.  Read more...
By Additional Articles 2012/09/18 | Source: MSDN Communities | Category: filetable
Rating: (not yet rated)  Rate this |   Briefcase | 2,333 reads

SQL in the City - Austin 2012

A free day of training in Austin, TX with Grant Fritchey, Steve Jones and a few others. Join us to learn about SQL Server and how you can more efficiently work in your job every day.  Read more...
By Press Release 2012/09/18 (first published: 2012/08/27) | Source: SQLServerCentral.com | Category: events
Rating: (not yet rated)  Rate this |   Briefcase | 2,771 reads

TSQL Challenge 82 - Find elements that uniquely make up a group

The challenge is to find the Tax Code based on Price. Each sales amount is uniquely made up by the sum of one or more prices. Based on this you should assign the tax code to each price.   Read more...
By Jacob Sebastian 2012/09/17 | Source: SQLServerCentral.com | Category: t-sql challenges
Rating: |  Discuss |   Briefcase | 1,174 reads

Never update systems tables directly - a study in Agent job scheduling

It is often recommended that system tables should not be updated directly. Presenting a case in point built around nightly job configuration in order to demonstrate the possible issues with updating system tables directly.  Read more...
By Nakul Vachhrajani 2012/09/17 | Source: SQLServerCentral.com | Category: sql server agent
Rating: |  Discuss |   Briefcase | 4,280 reads

SQL in the City - New York 2012

Come join Grant Fritchey, Steve Jones and others for a free day of training in New York City on Sept 28, 2012.  Read more...
By Press Release 2012/09/17 (first published: 2012/08/23) | Source: SQLServerCentral.com | Category: events
Rating: (not yet rated)  Rate this |   Briefcase | 2,749 reads

Distributed Computing - Hybrid Systems Considerations

When the Cloud was new, it was often presented as an 'all or nothing' solution. Nowadays, the canny Systems Architect will exploit the best advantages of 'cloud' distributed computing in the right place, and use in-house services where most appropriate. So what are the issues that govern these architectural decisions?  Read more...
By Additional Articles 2012/09/17 | Source: SimpleTalk | Category: cloud computing
Rating:  Rate this |   Briefcase | 1,484 reads

Choosing a Tabular or Multidimensional Modeling Experience in SQL Server 2012 Analysis Services

This white paper provides practical guidance to help BI professionals and decision makers decide whether SQL Server 2012 Analysis Services tabular or multidimensional modeling provides the best fit for your next BI solution.  Read more...
By Additional Articles 2012/09/14 | Source: Microsoft MSDN | Category: business intelligence
Rating: (not yet rated)  Rate this |   Briefcase | 2,553 reads

Red Gate Software announces speaker line up for US SQL in the City tour

SQL in the City is a free, full day training and networking event for database professionals. After the success of last year’s event, Red Gate has expanded the event to cover six cities from sea to shining sea, including: New York, Austin, San Francisco, Chicago, Boston, and Seattle.  Read more...
By Press Release 2012/09/14 (first published: 2012/08/21) | Source: Red-Gate | Category: red gate software
Rating: (not yet rated) |  Discuss |   Briefcase | 1,566 reads

Why doesn’t ISNUMERIC work correctly? (SQL Spackle)

Another in our series of articles to help you fill in the cracks in your knowledge with SQL Spackle. MVP Jeff Moden shows us how IsNumeric works and how you should use it.  Read more...
By Jeff Moden 2012/09/14 (first published: 2010/12/01) | Source: SQLServerCentral.com | Category: isnumeric()
Rating: |  Discuss |   Briefcase | 32,853 reads

Webinar: Temporary Tables in Oracle and SQL Server

Once again 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. Will they agree on some common ground? Or will it be an out and out argument? Either way, be prepared for a lively exchange that will not only entertain, but will teach you key concepts on Oracle and SQL Server.  Read more...
By Additional Articles 2012/10/10 (first published: 2012/09/13) | Source: Red-Gate | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 6,971 reads

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

The open-source Unit Test framework tSQLt is a great way of writing unit tests in the same language as the one being tested. In retrospect, after using tSQLt for a while, what are the 'gotchas'; those things that you'd have been better off knowing about before you get started? David Green lists a few tips he wished he'd read beforehand.  Read more...
By Additional Articles 2012/09/13 | Source: SimpleTalk | Category: tsqlt
Rating: (not yet rated)  Rate this |   Briefcase | 3,814 reads

SSC Clinic: Finding the rogue query

When you're getting spikes of high CPU, it's quite likely it's a rogue query. But how do you find out which query? Grant Fritchey explains, using SQL Monitor.  Read more...
By Grant Fritchey 2012/09/13 | Source: SQLServerCentral.com | Category: memory
Rating: |  Discuss |   Briefcase | 5,840 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,163 reads

Advanced SSIS Workflow Management – Level 8 of the Stairway to Integration Services

In Level 8 of the Stairway to SSIS we look at more advanced workflow management within a package.  Read more...
Rating: |  Discuss |   Briefcase | 12,366 reads

SQL Server Resources - A list

A great list of SQL Server resources that you can use to help you improve your knowledge or ask questions.  Read more...
By Brandie Tarvin 2012/09/12 | Source: Other | Category: career
Rating: (not yet rated)  Rate this |   Briefcase | 2,920 reads

SQL in the City - Chicago 2012

A free day of training in Chicago on Oct 5, 2012. Join Grant Fritchey, Steve Jones and more to discuss, debate, ask questions, and learn about how to better run your organizations SQL Servers.  Read more...
By Press Release 2012/09/20 (first published: 2012/08/30) | Source: SQLServerCentral.com | Category: sql in the city
Rating:  Rate this |   Briefcase | 3,394 reads

SQLSaturday #160 - Kalamazoo

SQL Saturday comes back to Michigan. Come see Jeff Moden and others talk SQL Server on Sept 22, 2012.  Read more...
By Press Release 2012/09/12 (first published: 2012/08/22) | Source: SQLServerCentral.com | Category: sql saturday
Rating:  Rate this |   Briefcase | 1,883 reads