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/08 to 2012/09/15

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,625 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,571 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 | 33,081 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 | 7,007 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,867 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,847 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,217 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 | 13,291 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,937 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,450 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,911 reads

Objects, Relationships, Systems, And Processes

What is the difference between an expert DBA and a Master DBA? This piece from William Talada talks about Objects, Relationships, Systems, and Processes and how they may relate to your job as a DBA.  Read more...
By William Talada 2012/09/11 | Source: SQLServerCentral.com | Category: philosophy
Rating: |  Discuss |   Briefcase | 2,492 reads

From Hairdresser to DBA – How to start a career in IT

In writing about his career change from hairdresser to DBA, Greg Lucas shares his experiences and offers advice for those looking to move into IT.  Read more...
By Greg M Lucas 2014/08/15 (first published: 2012/09/11) | Source: SQLServerCentral.com | Category: professional development
Rating: |  Discuss |   Briefcase | 16,425 reads

SQL in the City - Boston 2012

A free day of training in Boston on Oct 8, 2012. Come join Grant Fritchey, Steve Jones and more to talk about SQL Server and how you can work more efficiently.  Read more...
By Press Release 2012/09/21 (first published: 2012/09/11) | Source: SQLServerCentral.com | Category: sql in the city
Rating: (not yet rated)  Rate this |   Briefcase | 3,423 reads

SQL Saturday #169 - Denver

Come join Steve Jones, Glenn Berry, and other Denver area MVPs and speakers for a free day of training in Denver on Sept 22, 2012.  Read more...
By Press Release 2012/09/11 (first published: 2012/09/11) | Source: SQLServerCentral.com | Category: sql saturday
Rating: (not yet rated)  Rate this |   Briefcase | 1,943 reads

Meredith Ryan Chosen as the Exceptional DBA of 2012

Congratulations to Meredith Ryan for being chosen the Exceptional DBA of 2012.  Read more...
By Press Release 2012/09/10 | Source: SQLServerCentral.com | Category: exceptional dba
Rating: |  Discuss |   Briefcase | 2,171 reads

SQLskills training goes online worldwide (and free in September!)

SQLskills is recording their knowledge in conjunction with Pluralsight for you to view from the time and place of your choosing. And it's free in September. Read more to find out how you can get access.  Read more...
By Additional Articles 2012/09/10 (first published: 2012/09/05) | Source: SQLskills | Category: training
Rating: (not yet rated)  Rate this |   Briefcase | 6,162 reads

Fun with Outer Joins

Learn how an outer join works and how you can use it in your applications to find the results you need when matching data isn't in all your tables.  Read more...
By Kenneth Fisher 2014/01/17 (first published: 2012/09/10) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 22,118 reads

Gail Shaw's SQL Server Howlers

For the latest in our series of SQL Server Howlers, we asked Gail Shaw which common SQL Server mistakes and misunderstandings lead to tearful DBAs and plaintive cries for help on the forums.  Read more...
By Additional Articles 2012/09/10 | Source: SimpleTalk | Category: simple-talk series
Rating:  Rate this |   Briefcase | 3,314 reads

SQL Saturday #155 - Lima

SQL Saturday is exploding in South America, and Lima hosts it's event on Sept 22, 2012. Come join fellow data professionals and learn about SQL Server.  Read more...
By Press Release 2012/09/10 (first published: 2012/08/20) | Source: SQLServerCentral.com | Category: sql saturday
Rating: (not yet rated)  Rate this |   Briefcase | 1,725 reads