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

   Items 1 to 20 of 13251    Older >>
 

Data Mining Part 22: Analyze the Data Mining Data with Excel

This is the last article related to Data Mining in Excel. This last chapter will cover the Analyze section.  Read more...
By Daniel Calbimonte 2014/11/24 | Source: SQLServerCentral.com | Category: data
Rating: (not yet rated) |  Discuss |   Briefcase | 583 reads

The Salesforce Platform: The Return of the Citizen Programmer

The current popularity of the Salesforce software development platform has taken the industry by surprise. The current IT culture favours the esoteric, yet here is a development platform geared to the idea that anyone can use it: a populist language like BASIC. Does this threaten the careers of professional developers?  Read more...
By Additional Articles 2014/11/24 | Source: SimpleTalk | Category: salesforce
Rating: (not yet rated)  Rate this |   Briefcase | 2,796 reads

How Often Does Production Drift?

Database drift is the difference between two database schemas. Today Steve Jones discusses the concept and wonders how often it happens.  Read more...
By Steve Jones 2014/11/24 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 23 reads

What Counts for a DBA: Empathy

Louis Davidson on how he learned to empathize with his managers.  Read more...
By Louis Davidson (@drsql) 2014/11/24 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 37 reads

Generate SSRS reports from a SSIS Package

Learn how to invoke SSRS reports from an SSIS package after the data load is completed.  Read more...
By Ravindra Chhabria 2014/11/21 (first published: 2012/10/09) | Source: SQLServerCentral.com | Category: integration services (ssis)
Rating: |  Discuss |   Briefcase | 14,538 reads

Real World T-SQL Tricks

This week Steve Jones wonders if you're taking advantage of the changes in the T-SQL language.  Read more...
By Steve Jones 2014/11/21 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 230 reads

Questions About Using TSQL to Import Excel Data You Were Too Shy to Ask

It is easy to import Excel data into database tables via TSQL, using OLEDB, either by the OPENROWSET function or linking to the spreadsheet as a server. The problem is that there are certain things that aren't obvious that you need to know about.  Read more...
By Additional Articles 2014/11/21 | Source: SimpleTalk | Category: t-sql
Rating:  Rate this |   Briefcase | 6,265 reads

Distribution Database Migration

This article shows a step-by-step guide to move the distribution database to a new SQL Server instance.  Read more...
By Valerij Urban 2014/11/20 | Source: SQLServerCentral.com | Category: replication
Rating: |  Discuss |   Briefcase | 1,626 reads

Achievement Unlocked: Balance 0

Steve Jones completed a task this year that he's rarely completed in the past.  Read more...
By Steve Jones 2014/11/20 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 82 reads

Monitoring Azure SQL Database

Marcin Policht presents different methods that allow you to monitor the performance and characteristics of your PaaS databases, ensuring that they behave in a manner that matches your expectations.  Read more...
By Additional Articles 2014/11/20 | Source: Database Journal | Category: sql azure
Rating: (not yet rated)  Rate this |   Briefcase | 5,579 reads

The SQL Server Container

There's an interesting idea that exists for lightweight, application separation on a host that's different from virtualization. It's Docker, and Steve Jones talks about it today.  Read more...
By Steve Jones 2014/11/19 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 80 reads

Stairway to SQL Server Agent - Level 2: Job Steps and Subsystems

SQL Server Agent jobs are made up of a series of one or more Job Steps. A job step is assigned to a specific job subsystem, which identifies the kind of work the job step is going to perform. Each job step runs in a separate security context, although each job also has an owner that determines who can modify the job.  Read more...
By Richard Waymire 2014/11/19 | Source: SQLServerCentral.com | Category: sql agent
Rating: |  Discuss |   Briefcase | 6,267 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/11/19 (first published: 2013/08/14) | Source: Red-Gate | Category: transaction logs
Rating:  Rate this |   Briefcase | 43,767 reads

Where in the Application Should Data Validation be Done?

Whereabouts in the application should the business logic of data-validation checks be made? The advantages of a layered approach to validation that includes database constraints, would seem to outweigh the disadvantages.   Read more...
By Additional Articles 2014/11/19 | Source: SimpleTalk | Category: data validation
Rating: (not yet rated)  Rate this |   Briefcase | 7,832 reads

Data Mining Part 21: Excel and Data Mining,validation methods

This article is part of the lesson 18 to 20 related to SQL Server Data Mining with Excel.   Read more...
By Daniel Calbimonte 2014/11/18 | Source: SQLServerCentral.com | Category: excel
Rating: |  Discuss |   Briefcase | 2,233 reads

Removing Rows with the DELETE Statement in SQL Server

Greg Larsen explores how to remove rows from a SQL Server table using the DELETE statement.  Read more...
By Additional Articles 2014/11/18 | Source: Database Journal | Category: delete rows
Rating: (not yet rated)  Rate this |   Briefcase | 8,991 reads

MY Data

As we gather more and more data about individuals, not only does security become an issue, but also the morality of using the data.  Read more...
By Steve Jones 2014/11/18 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 80 reads

SQL Monitor Custom Metric: Possible Duplicate Indexes

When a table has multiple indexes defined on the same columns, it produces duplicate indexes that waste space and have a negative impact on performance. This metric measures the number of possible duplicate indexes per database above a set threshold. You can then consider dropping the indexes and reverse the change.  Read more...
By Press Release 2014/11/18 | Source: Red-Gate | Category: index
Rating: (not yet rated)  Rate this |   Briefcase | 5,491 reads

Continuous Learning

It pays to continuously learn more about your job. SQL Server is so large, it really is a lifelong effort to drive yourself forward to master more and more.  Read more...
By Steve Jones 2014/11/17 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 126 reads

SQL Overview VII - SSRS Reports and Subscriptions

In the next installment of his series on the SQL Overview toolkit, David Bird looks at the information collected about SSRS.  Read more...
By David Bird 2014/11/17 | Source: SQLServerCentral.com | Category: reporting services (ssrs)
Rating: |  Discuss |   Briefcase | 3,550 reads
   Items 1 to 20 of 13251    Older >>