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

<< Newer    Items 21 to 40 of 13154    Older >>
 

Database Deployment Problems Survey

Red Gate is looking to build tools and features to help reduce the risk of database deployment. In order to achieve this, we need to get a better understanding of the most common deployment problems you are encountering when moving changes from development to production. Please help by filling in our two-page survey.  Read more...
By Additional Articles 2014/10/14 | Source: Red-Gate | Category: survey
Rating: (not yet rated)  Rate this |   Briefcase | 5,128 reads

Linked server creation to MySQL Server

Here is a step by step procedure to create a linked server to MySQL from SQL Server.  Read more...
By Vinayaka Gangadhar 2014/10/13 | Source: SQLServerCentral.com | Category: linked server
Rating: |  Discuss |   Briefcase | 2,639 reads

Fine Products for the Modern Drudge

As working hours in tech trend upwards, we look at some ways to make life easier.  Read more...
By Dave Convery 2014/10/13 | Source: SQLServerCentral.com | Category: career
Rating: (not yet rated) |  Discuss |   Briefcase | 93 reads

Document, then Install

Should we declare what we want installed and then have every instance configure itself? Steve Jones talks about the need to ensure we know what is running before we install rather than documenting it afterwards.  Read more...
By Steve Jones 2014/10/13 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 75 reads

Understanding How to Use the UPDATE Statement to Change Your Data

Greg Larsen shows you a number of different ways to use the UPDATE statement to modify the data in your SQL Server tables.  Read more...
By Additional Articles 2014/10/13 | Source: Database Journal | Category: update
Rating:  Rate this |   Briefcase | 7,879 reads

PASS Summit, Seattle, WA

Join the world's largest gathering of SQL Server and BI professionals in Seattle on November 4-7. PASS Summit is your conference – planned by and for the SQL Server community. Red Gate will be exhibiting, so drop by their booth and say hello. Register while space is available.  Read more...
By Press Release 2014/10/13 | Source: PASS | Category: events
Rating: (not yet rated)  Rate this |   Briefcase | 6,335 reads

Using the Konesans File Watcher Task in SSIS to Process Data Files

With the Konesans File Watcher Task for SSIS we can import files as soon as they arrive.  Read more...
By Orlando Colamatteo 2014/10/10 (first published: 2012/08/13) | Source: SQLServerCentral.com | Category: integration services (ssis)
Rating: |  Discuss |   Briefcase | 14,470 reads

Fun Data Analysis

This week Steve wants to know if you'd have some issues when analyzing data and you've mistaken correlation for causation.  Read more...
By Steve Jones 2014/10/10 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 130 reads

Compare SQL Server Performance of In-Memory vs Disk Tables

With the release of SQL Server 2014 there came a lot of new features, including “In-Memory OLTP”. One would assume that storing a table in memory would most definitely be faster than using the conventional disk-based table storage engine. But just how much faster is it?  Read more...
By Additional Articles 2014/10/10 | Source: MSSQLTips.com | Category: hekaton
Rating: (not yet rated)  Rate this |   Briefcase | 7,130 reads

Use SSIS to send emails

Send emails using SSIS and SQL Server instead of application-level code.  Read more...
By Joe Millay 2014/10/09 | Source: SQLServerCentral.com | Category: integration services (ssis)
Rating: |  Discuss |   Briefcase | 7,385 reads

Continuous Delivery for Windows?

It seems as though Microsoft might be moving to a Continuous Delivery process for Windows 10. Steve Jones isn't sure that's a good thing, but it is interesting.  Read more...
By Steve Jones 2014/10/09 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 69 reads

Deleting Files in the Cloud

The public perception is that, when something is deleted, it no longer exists. Often that's not really the case; the data you serve up to the cloud can be stored out there indefinitely, no matter how hard to try to delete it. Rob Sheldon investigates, and finds the cloud a worryingly public place.  Read more...
By Additional Articles 2014/10/09 | Source: SimpleTalk | Category: cloud computing
Rating: (not yet rated)  Rate this |   Briefcase | 7,017 reads

SQL Saturday #337 - Portland, OR

SQL Saturday is coming to Portland on November 1! Join us for a free day of SQL Server training and networking. Speakers at this event include Red Gate's Grant Fritchey, Kathi Kellenberger, Benjamin Nevarez, and more. There are also 3 paid-for pre-con sessions for this event. Register while space is available.  Read more...
By Press Release 2014/10/09 | Source: SQL Saturday | Category: events
Rating: (not yet rated)  Rate this |   Briefcase | 5,590 reads

Byte Me: Recruitment Drive

Innovative recruitment solutions available now!  Read more...
By Bob Lang 2014/10/08 | Source: SQLServerCentral.com | Category: byte me
Rating: (not yet rated) |  Discuss |   Briefcase | 389 reads

Data Mining Part 18: Excel and Data Mining

In this new article, we will introduce you to Microsoft Excel and Data Mining.  Read more...
By Daniel Calbimonte 2014/10/08 | Source: SQLServerCentral.com | Category: excel
Rating: |  Discuss |   Briefcase | 3,690 reads

Free eBook: SQL Server Execution Plans, Second Edition

Every day, out in the various online forums devoted to SQL Server, and on Twitter, the same types of questions come up repeatedly: Why is this query running slowly? Why is SQL Server ignoring my index? Why does this query run quickly sometimes and slowly at others? My response is the same in each case: have you looked at the execution plan?  Read more...
By Press Release 2014/10/08 (first published: 2013/07/30) | Source: Red-Gate | Category: execution plans
Rating:  Rate this |   Briefcase | 42,287 reads

Backup and Restore Strategies in SQL Server – Part 1

You need to set up backup and restore strategies to recover data or minimize the risk of data loss in case a failure happens. In this article series, Arshad Ali discusses backup and restore strategies in SQL Server.  Read more...
By Additional Articles 2014/10/08 | Source: Database Journal | Category: backup / restore
Rating:  Rate this |   Briefcase | 8,216 reads

Solving Kerberos Issues in SSRS When Running Beside IIS

When SSRS is running on a server with IIS, pass through Windows Authentication can be difficult to set up.  Read more...
By Ian Massi 2014/10/07 | Source: SQLServerCentral.com | Category: reporting services (ssrs)
Rating: |  Discuss |   Briefcase | 3,208 reads

Improving the Quality of SQL Server Database Connections in the Cloud

To access SQL Server from the client, you use TDS protocol over TCP. This is fine over reliable LANs but over the internet these connections are relatively slow and fragile. TDS is still used to connect to databases in the cloud, but you need to use a combination of the new features such as connection pools and idle connection resiliency to make applications faster and more reliable. Edward Elliott shows you how.  Read more...
By Additional Articles 2014/10/07 | Source: SimpleTalk | Category: tcp connection
Rating:  Rate this |   Briefcase | 6,375 reads

A T-SQL Code Testing Guide

Testing our database code is a fairly immature process for many of this, but perhaps we could build a guide that helps everyone learn to write better and more comprehensive tests.  Read more...
By Steve Jones 2014/10/07 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 291 reads
<< Newer    Items 21 to 40 of 13154    Older >>