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

   Items 1 to 20 of 12893    Older >>
 

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 | 321 reads

DevOps

The DevOps movement has Steve Jones excited.  Read more...
By Steve Jones 2014/07/22 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 52 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 | 359 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:  Rate this |   Briefcase | 1,006 reads

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

A IT Consultant for our Times

Phil Factor explains that being a consultant in the latest IT hot topic is a worthy role. Someone has to do it, and Phil explains why.  Read more...
By Phil Factor 2014/07/21 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 83 reads

Back from Sabbatical

After six weeks away, Steve Jones is back.  Read more...
By Steve Jones 2014/07/21 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 88 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:  Rate this |   Briefcase | 8,149 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,758 reads

What Is the Hardest Feature to Learn About SQL Server?

SQL Server is a complex product and many of us work with only a small part of the product. However many of us will have exposure to quite a few features inside of the platform. Today Andy Warren asks you if there is some feature that's harder than others.  Read more...
By Andy Warren 2014/07/18 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 214 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,361 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:  Rate this |   Briefcase | 1,713 reads

Access Disdain

Today Andy Warren looks back at his career with Access and why he doesn't see it as a tool to be avoided.  Read more...
By Andy Warren 2014/07/17 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 142 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,350 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,287 reads

Stairway to SQL Server Security Level 3: Principals and Securables

What is a SQL Server principal? And what does it get a permission on? In this stairway level, you’ll learn about the various principals that can be authorized through permissions to perform actions and access securable objects in the SQL Server instance.  Read more...
By Don Kiely 2014/07/16 | Source: SQLServerCentral.com | Category: stairway
Rating: |  Discuss |   Briefcase | 2,154 reads

One Size Does Not Fit All

Today we have a guest editorial from Derik Hammer that reminds us that there isn't one solution that will fit all your solutions.  Read more...
By Derik Hammer 2014/07/16 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 82 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/07/16 (first published: 2013/08/14) | Source: Red-Gate | Category: transaction logs
Rating: (not yet rated)  Rate this |   Briefcase | 26,198 reads

Automate Registering and Maintaining Servers in SQL Server Management Studio (SSMS)

This tip looks at how to use a control file that lists the structure to use within SSMS and a PowerShell script that will automatically maintain the list of registered servers within SSMS.   Read more...
By Additional Articles 2014/07/16 | Source: MSSQLTips.com | Category: automation
Rating: (not yet rated)  Rate this |   Briefcase | 9,373 reads

SQL Saturday #302 - Albany

SQL Saturday is coming to Albany, NY on July 26, 2014. This is a free full day of training and networking for SQL Server professionals. This event also features a paid-for precon session with Grant Fritchey on query performance tuning. The event is soon so register while space is available.   Read more...
By Press Release 2014/07/16 | Source: SQL Saturday | Category: sql saturday
Rating:  Rate this |   Briefcase | 7,357 reads
   Items 1 to 20 of 12893    Older >>