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

<< Newer    Items 41 to 60 of 12920    Older >>
 

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: integration services (ssis)
Rating:  Rate this |   Briefcase | 10,140 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,387 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 | 90 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 | 27,136 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 | 10,520 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,995 reads

Implementation of partition switching within SSIS

In the third part of a series on loading a partitioned data warehouse efficiently, we see how SSIS can be used to perform the ETL tasks.  Read more...
Rating: |  Discuss |   Briefcase | 3,272 reads

Not Good Enough For Government Work

The complexity of financial trading systems is too much for an amateur approach, as the losses of various Bitcoin exchanges show.  Read more...
By Phil Factor 2014/07/15 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 203 reads

Version Control as a Cloud Service

Robert Sheldon wonders if cloud-based version control still too risky for a service that must be secure, and risk-free?   Read more...
By Additional Articles 2014/07/15 | Source: SimpleTalk | Category: source control
Rating:  Rate this |   Briefcase | 10,083 reads

Infect Your Colleagues with the Learning Bug

Many of you are interested in learning more about SQL Server and improving your career. However can you extend that to your colleagues? Can you convince them to become better IT professionals? Andy Warren has some thoughts.  Read more...
By Andy Warren 2014/07/14 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 198 reads

Data Mining: Part 11 XMLA and the automation

In this lesson we will learn the basis about XMLA and we will execute the command line to create DM objects.  Read more...
By Daniel Calbimonte 2014/07/14 | Source: SQLServerCentral.com | Category: data mining
Rating: |  Discuss |   Briefcase | 1,739 reads

Back in the USSRS

After a period of abstinence, Rodney Landrum adjusts to life back in the USSRS.  Read more...
By Rodney Landrum 2014/07/14 | Source: SQLServerCentral.com | Category: ssrs
Rating: (not yet rated) |  Discuss |   Briefcase | 83 reads

SQL Server Analysis Server (SSAS) KeyColumn vs NameColumn vs ValueColumn

What is the difference between the KeyColumn, the NameColumn, and the ValueColumn for a dimension attribute in SQL Server Analysis Services? When should you use each one for a dimension attribute? Check out this tip to learn more.  Read more...
By Additional Articles 2014/07/14 | Source: MSSQLTips.com | Category: ssas
Rating: (not yet rated)  Rate this |   Briefcase | 8,862 reads

SQL Monitor Metric: Memory used by ad hoc queries running once

This metric measures the amount of memory used by the total number of ad hoc queries in the plan cache that have only run one time. This value is only accurate for the instant the query is run, and the value can change radically from one capture time to the next.  Read more...
By Press Release 2014/07/14 | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 8,718 reads

Single Quotation Marks in SQL

One of the common problems is dealing with apostrophes in T-SQL. This article examines the challenges of single quotation marks and ends with a short quiz.  Read more...
By Kenneth Fisher 2014/07/11 (first published: 2013/01/03) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 21,204 reads

Mudita: Joy in the success of others

It is only when you start to take genuine pleasure in other people's successes that you experience the true rewards of being in a leadership position.  Read more...
By David Poole 2014/07/11 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 86 reads

Do You Really Need to Tune Big Data Applications?

Big data applications are here to stay. The promise of this technology is the ability to quickly and easily analyze large amounts of data and derive from that analysis changes to customer-facing systems, hopefully at a reasonable cost. So, do these applications really need tuning?  Read more...
By Additional Articles 2014/07/11 | Source: Database Journal
Rating: (not yet rated)  Rate this |   Briefcase | 3,837 reads

Instant File Initialization

This article describes a way to speed up various file operations performed by SQL Server.  Read more...
Rating: |  Discuss |   Briefcase | 3,607 reads

Is It Time To Clear Out Those Quirky Functions?

Phil Factor ponders a cull of some of SQL Server's worst-behaving functions.  Read more...
By Phil Factor 2014/07/10 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 239 reads

The Mindset of the Enterprise DBA: Creating and Applying Standards to Our Work

Although many professions require judgement and skill, they also require the ability to do many repeated standard procedures in a consistent and methodical manner. For DBAs, standardization involves providing and following checklists, notes and instructions so that the results are predictable, correct and easy to maintain.  Read more...
By Additional Articles 2014/07/10 | Source: SimpleTalk | Category: standards
Rating:  Rate this |   Briefcase | 5,443 reads
<< Newer    Items 41 to 60 of 12920    Older >>