Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

   Items 1 to 20 of 13076    Older >>
 

Copy a database between servers with one command

This tool is a helper for your daily work to copy easily databases between Servers/instances and do all the necessary stuff for you.  Read more...
By Roland Hangg 2014/09/23 | Source: SQLServerCentral.com | Category: copy database script
Rating: |  Discuss |   Briefcase | 8,593 reads

Testing in Production

The Apple fall keynote recently didn't work as planned, and it seems as though their systems weren't tested well enough.  Read more...
By Steve Jones 2014/09/23 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 69 reads

Importing Excel Data into SQL Server Via SSIS: Questions You Were Too Shy to Ask

Retrieving data from Excel, and importing it into SQL Server hasn't the same appeal or glamour as, for example, performing heroics with ill-performing queries. This could be why one hesitates before asking questions about how to do it. Rob Sheldon calms your private doubts and fears by answering those embarrassing questions.  Read more...
By Additional Articles 2014/09/23 | Source: SimpleTalk | Category: ssis
Rating: (not yet rated)  Rate this |   Briefcase | 5,159 reads

SQL Saturday #352 - Sydney

SQL Saturday is coming to Sydney, Australia on October 25, 2014. Join us down under for a free day of SQL Server training and networking. Register while space is available.  Read more...
By Press Release 2014/09/23 | Source: SQL Saturday | Category: events
Rating: (not yet rated)  Rate this |   Briefcase | 2,783 reads

Automate Yourself to a Coffee Break

A DBA should be working to automate their tasks, and find time to do things that are really important. Like keeping their coffee cup topped off :)  Read more...
By Steve Jones 2014/09/22 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 146 reads

Premature Optimisation

Learning how to tune a system is a bit of science and a bit of an art. Gail Shaw gives some guidelines on when you might want to tune and how to go about it so as not to unnecessarily undertake the effort.  Read more...
By Gail Shaw 2014/09/22 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 3,739 reads

Watson Freemium

IBM has released a free version of its Watson service to help people perform analytics on their data.  Read more...
By Steve Jones 2014/09/22 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 50 reads

Prevent Confidential Data at the Application Layer from getting into SQL Server

In this tip Tim Smith looks at different approaches to stop confidential data from getting into the database.  Read more...
By Additional Articles 2014/09/22 | Source: MSSQLTips.com | Category: security
Rating: (not yet rated)  Rate this |   Briefcase | 4,728 reads

Hierarchies on Steroids #1: Convert an Adjacency List to Nested Sets

SQL Server MVP Jeff Moden shows us a new very high performance method to convert an "Adjacency List" to “Nested Sets” on a million node hierarchy in less than a minute and 100,000 nodes in just seconds. Not surprisingly, the "steroids" come in a bottle labeled "Tally Table".  Read more...
By Jeff Moden 2014/09/19 (first published: 2012/11/13) | Source: SQLServerCentral.com | Category: hierarchy
Rating: |  Discuss |   Briefcase | 13,846 reads

No Compelling Reason

Steve Jones wants to know if you have compelling reasons to upgrade or not upgrade this week.  Read more...
By Steve Jones 2014/09/19 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 80 reads

A TDD Journey: 3- Mocks vs. Stubs; Test Frameworks; Assertions; ReSharper Accelerators

Test-Driven Development (TDD) involves the repetition of a very short development cycle that begins with an initially-failing test that defines the required functionality, and ends with producing the minimum amount of code to pass that test, and finally refactoring the new code. Michael Sorens continues his introduction to TDD by implementing the first tests and introducing the topics of Test doubles; Test Runners, Constraints and Assertions.  Read more...
By Additional Articles 2014/09/19 | Source: SimpleTalk | Category: test driven development
Rating: (not yet rated)  Rate this |   Briefcase | 5,074 reads

The 10 (.5) Commandments for IT Professionals

A list of the commandments, or at least suggestions, that Simon Holzman sees as important for IT professionals.  Read more...
By Simon Holzman 2014/09/18 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 303 reads

Data Mining Part 17: Working with Reports

In this chapter, we will learn how to create Data Mining Reports using Reporting Services.  Read more...
By Daniel Calbimonte 2014/09/18 | Source: SQLServerCentral.com | Category: data mining
Rating: |  Discuss |   Briefcase | 2,712 reads

Azure Virtual Machines Part 0: A VM Primer

Mike Martin kicks off his series on Azure Virtual Machines with a primer, full of background and terms. To fully understand the Azure Virtual Machines offering, Mike explains how everything is connected and co-existing.   Read more...
By Additional Articles 2014/09/18 | Source: Just Azure | Category: azure
Rating:  Rate this |   Briefcase | 5,443 reads

Stairway to PowerPivot and DAX - Level 7: Function / Iterator Function Pairs: The DAX AVERAGE() and AVERAGEX() Functions

Business Intelligence architect, Analysis Services Maestro, and author Bill Pearson explores the DAX AVERAGE() and AVERAGEX() functions, comparing and contrasting the two. He then provides some hands-on exposure to the use of each, particularly in combination with other DAX functions, in generating arithmetic means within our PowerPivot model designs.  Read more...
By Bill Pearson 2014/09/17 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 1,624 reads

A Dearth of Comments

Steve Jones talks about one of the least favorite things for IT people: documentation. How much do you really need to do?  Read more...
By Steve Jones 2014/09/17 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 409 reads

Free eBook: SQL Server Transaction Log Management

When a SQL Server database is operating smoothly and performing well, there is no need to be particularly aware of the transaction log, beyond ensuring that every database has an appropriate backup regime and restore plan in place. When things go wrong, however, a DBA's reputation depends on a deeper understanding of the transaction log, both what it does, and how it works.  Read more...
By Press Release 2014/09/17 (first published: 2013/08/14) | Source: Red-Gate | Category: transaction logs
Rating:  Rate this |   Briefcase | 34,197 reads

The Mindset of the Enterprise DBA: Harnessing the Power of Automation

After you have done the necessary groundwork of standardising and centralising your database adminstration processes, you are now in a position to implement some effective automation of some of these processes. Which ones do you choose, and how do you set about automating these tasks?  Read more...
By Additional Articles 2014/09/17 | Source: SimpleTalk | Category: dba skills
Rating:  Rate this |   Briefcase | 6,888 reads

The Need for Auditing

Is C2 auditing widely used? Should it be more widely used? Steve Jones talks about the subject of auditing in today's editorial.  Read more...
By Steve Jones 2014/09/16 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 592 reads

The Ins and outs of In-Memory OLTP

As you may know, SQL Server is a very robust database, but SQL server has its performance bottlenecks. With the introduction of In-Line memory OLTP, there is a chance to get rid of the performance bottlenecks   Read more...
By Roy Ernest 2014/09/16 | Source: SQLServerCentral.com | Category: microsoft sql server
Rating: |  Discuss |   Briefcase | 4,807 reads
   Items 1 to 20 of 13076    Older >>