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

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,737,242 DBAs, developers and SQL Server users

Rss
Headlines today   July 22, 2014

SQL-only ETL using a bulk insert into a temporary table (SQL Spackle)

This article demonstrates a method of importing a data file directly into a temporary table and selectively inserting data from the temporary table into a SQL Server table, all in a single set of SQL commands.  Read more...
By Stan Kulp 2014/07/22 | Source: SQLServerCentral.com | Category: bulk insert
Rating: |  Discuss |   Briefcase | 126 reads

Is Source Control Really That Boring?

The SSC team has put together a little quiz on database source control to go with Rob Richardson, Robert Sheldon, and Tony Davis' new book, SQL Server Source Control Basics. Do you daydream about source control... or daydream to avoid it?  Read more...
By Additional Articles 2014/07/22 | Source: SQLServerCentral.com | Category: survey
Rating: (not yet rated) |  Discuss |   Briefcase | 299 reads

Traits of a DBA - Part Two – The Personal Side of a DBA

A good DBA needs to have good technical skills but he also has to have good personal skills. In this article, Greg Larsen discusses the personal skills a DBA should have.  Read more...
By Additional Articles 2014/07/22 | Source: Database Journal | Category: dba basics
Rating: (not yet rated)  Rate this |   Briefcase | 441 reads
Previous headlines

Data Mining: Part 12 DMX for Data Mining

In this lesson we will learn the basics of DMX and create some samples.  Read more...
By Daniel Calbimonte 2014/07/21 | Source: SQLServerCentral.com | Category: data
Rating: |  Discuss |   Briefcase | 1,014 reads

13 Questions about SQL Server Data Types You were Too Shy to Ask

Although SQL Data Types seem to cause a lot of grief for database developers and can be tricky in their use, we seem to be expected to know all about them, and so it is embarrassing to ask questions about them in forums. Rob Sheldon continues in his mission to answer all those questions that we hesitate to ask.  Read more...
By Additional Articles 2014/07/21 | Source: SimpleTalk | Category: data types
Rating: (not yet rated)  Rate this |   Briefcase | 7,722 reads

SQL in the City: Save the Date

SQL in the City is coming back to London and Seattle in 2014. The London event will take place on October 24 (before Tech Ed Europe) and in Seattle on November 3 (before PASS Summit). Keep an eye on the event website and @redgate for updates.  Read more...
By Press Release 2014/07/21 | Source: SQL in the City | Category: events
Rating: (not yet rated)  Rate this |   Briefcase | 5,472 reads

Stairway to XML: Level 2 - The XML Data Type

Robert Sheldon describes SQL Server's XML Data Type, and shows that it is as easy to configure a variable, column, or parameter with the XML data type as configuring one of these objects with any other datatype  Read more...
By Rob Sheldon 2014/07/18 (first published: 2012/09/26) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 12,345 reads

Using PowerShell to Manage Windows Azure SQL Databases

Marcin Policht provides a comprehensive overview of Windows PowerShell’s capabilities in regard to managing SQL Databases (or, in general, cloud-resident resources).  Read more...
By Additional Articles 2014/07/18 | Source: Database Journal | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 1,666 reads

Convert Rows into Columns

Convert the rows of a SELECT statement into a predetermined number of columns.  Read more...
By M Patrick Dillon 2014/07/17 | Source: SQLServerCentral.com | Category: rows to columns
Rating: |  Discuss |   Briefcase | 11,198 reads

Developing a Custom SSIS Source Component

SSIS was designed to be extensible.Although you can create tasks that will take data from a wide variety of sources, transform the data is a number of ways and write the results a wide choice of destinations, using the components provided, there will always be occasions when you need to customise your own SSIS component.  Read more...
By Additional Articles 2014/07/17 | Source: SimpleTalk | Category: ssis
Rating:  Rate this |   Briefcase | 8,113 reads
 
Ask SQL Server Central



From the SQLServerCentral Blogs

Get SQL Server Info - Quick Tip & Script

There are a number of ways to collect basic information about SQL Server, its version, edition and other top-level properties.  What is...  Read more...
By Robert Pearl 2014/07/22 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 413 reads

Yes, Virginia, you can have too much white space.

When I was in college and taking programming classes (back in the days when “a T-Rex ate my 5.25 inch...  Read more...
By Kenneth Fisher 2014/07/22 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 125 reads
Question of the Day

Recovery Interval

By free mascot 2014/07/22 | Category: recovery interval
Rating: (not yet rated) |  Discuss |   Briefcase | 151 reads

Which of these are true about the recovery interval? (Select correct 2 options)

  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
vpriya132
455 609 SSChasing Mays  
2.
cruice
325 325 Old Hand  
3.
BWFC
313 884 SSC Eights!  
4.
Shakeel Ahmed Ansari
300 542 Mr or Mrs. 500  
5.
Koen Verbeeck
280 13252 SSChampion  
Latest forum posts