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

   Items 1 to 20 of 13099    Older >>
 

Synchronize Salesforce with SQL Server using SSIS

Easily synchronize live Salesforce data with SQL Server using the Salesforce SSIS DataFlow Tasks.   Read more...
By Eric Madariaga 2014/09/30 | Source: SQLServerCentral.com | Category: integers
Rating: |  Discuss |   Briefcase | 2,838 reads

Challenge Yourself

How do you grow your career? Steve Jones has a few ideas on what you can do to both improve your skills and build your brand.  Read more...
By Steve Jones 2014/09/30 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 81 reads

SQL Server 2008 R2 Build List

The list of builds for SQL Server 2008 R2 up to SP3.  Read more...
By Steve Jones 2014/09/30 (first published: 2010/05/25) | Source: SQLServerCentral.com | Category: sql server 2008 r2
Rating: |  Discuss |   Briefcase | 52,025 reads

Webinar: 7 Steps to Build a Database Deployment Pipeline

Join Red Gate’s Alex Yates and TeamCity for a free webinar this Thursday, October 2nd. In this practical demo, Alex will show you how to set up continuous delivery for your SQL databases using TeamCity, Red Gate’s SQL Automation Pack, and Octopus Deploy. Places are limited – register now.  Read more...
By Press Release 2014/09/30 | Source: Red-Gate | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 3,375 reads

Change All Computed Columns to Persisted in SQL Server

Aaron Bertrand recently answered a question from a user who wanted to convert all of their SQL Server computed columns to be persisted. This allows you to shift the SQL Server cost of performing the computation from query time to the time of the insert/update, at the cost of storage. In this tip, Aaron shows you how.  Read more...
By Additional Articles 2014/09/30 | Source: MSSQLTips.com | Category: change column
Rating: (not yet rated)  Rate this |   Briefcase | 3,436 reads

I am no Asimov

Rodney Landrum on finding the inspiration you need, somehow and from somewhere, to get yourself out of a tight corner.  Read more...
By Rodney Landrum 2014/09/29 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 70 reads

Database Checkups

It's important that you are watching your databases' health to be sure that you can make changes, as well as rollback patches when issues occur.  Read more...
By Steve Jones 2014/09/29 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 111 reads

Removing SQL Server Management Data Warehouse (Data Collector)

Learn how to remove the MDW from your SQL Server environment with the 2008, 2008 R2 and 2012 versions.  Read more...
By Bruno Silva 2014/09/29 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 1,971 reads

You Can Still Vote for PASS

If you couldn't vote last week or didn't get a ballot, you still can. Please go to www.sqlpass.org and learn more.  Read more...
By Steve Jones 2014/09/29 | Source: SQLServerCentral.com | Category: pass
Rating: |  Discuss |   Briefcase | 260 reads

Azure Diagnostics for Virtual Machines

Hosting a scalable application in Azure seems ideal, but what happens when things go wrong? Azure Cloud Services provide extensive diagnostics, and this feature has now been extended to Azure web sites and Azure Virtual Machines. You need to set up diagnostics on the VM, but once this is done, all your logs, traces and performance counters can be collected from many VMs in one place for easy management.   Read more...
By Additional Articles 2014/09/29 | Source: SimpleTalk | Category: azure
Rating: (not yet rated)  Rate this |   Briefcase | 3,975 reads

An Alternative (Better?) Method to UNPIVOT (SQL Spackle)

Normalizing or UNPIVOTing data may be improved by using this lesser known approach in SQL Server 2008 or later.  Read more...
By Dwain Camps 2014/09/26 (first published: 2012/08/02) | Source: SQLServerCentral.com | Category: cross apply values unpivot
Rating: |  Discuss |   Briefcase | 15,195 reads

Is SQL Server Mature?

This Friday Steve Jones is wondering if the SQL Server platform does the job well enough for most people, or are there holes that need to be filled with new features.   Read more...
By Steve Jones 2014/09/26 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 136 reads

Integrating Big Data into the Enterprise Data Warehouse

Big Data implementations are more than just lots of data. Of equal importance is the analytics software used to query the data. Analyzing business data using advanced analytics is common, especially in companies that already have an enterprise data warehouse. It is therefore only natural that your big data application must be integrated with the existing warehouse.  Read more...
By Additional Articles 2014/09/26 | Source: Database Journal | Category: big data
Rating: (not yet rated)  Rate this |   Briefcase | 7,414 reads

SQL Saturday #318 - Orlando

This is Orlando's 8th SQLSaturday and this year will be better than ever with more than 50 different speakers giving over 50 presentations - all for FREE. Sept 27, 2014.  Read more...
By Press Release 2014/09/26 | Source: SQLServerCentral.com | Category: sqlsaturday
Rating: (not yet rated)  Rate this |   Briefcase | 5,036 reads

#SQLPASS Election Interview with James Rowland-Jones

An interview with James Rowland-Jones in advance of the PASS election.  Read more...
By Press Release 2014/09/26 | Source: Other | Category: pass
Rating: (not yet rated)  Rate this |   Briefcase | 4,267 reads

The Value of Data

Data can be valuable, and there's a new book that compares the value of data today to that of oil in the previous century. Steve Jones has a few thoughts on why we should consider this to be the case.  Read more...
By Steve Jones 2014/09/25 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 92 reads

Monitoring Longest Running Transaction using SQL Server Agent Alerts

Step by Step guide to setup SQL Server Agent Alert for the proactive monitoring of Monitoring of Longest Running Transactions.  Read more...
Rating: |  Discuss |   Briefcase | 4,888 reads

Free PDF Booklet: 119 SQL Code Smells

Once you've done a number of SQL code-reviews, you'll be able to identify signs in the code that indicate all might not be well. These 'code smells' are coding styles that, while not bugs, suggest design problems with the code. In this PDF, Phil Factor's put together 119 of those code smells so you can see what to avoid and why.  Read more...
By Additional Articles 2014/09/25 | Source: SimpleTalk | Category: design
Rating:  Rate this |   Briefcase | 9,166 reads

SQL Saturday #333 - St. Louis, MO

SQL Saturday is coming to the St. Louis University Campus on Oct 11, 2014. SQL Saturday offers a full day of free SQL Server training and networking, some of the speakers at this event include Kathi Kellenberger, Stuart Ainsworth, and Abhishek Srivastava. If you're thinking of attending this event, please register while space is available.  Read more...
By Press Release 2014/09/25 (first published: 2014/09/05) | Source: SQL Saturday | Category: events
Rating: (not yet rated)  Rate this |   Briefcase | 10,650 reads

Level 1: What is "SQL Server AlwaysOn"?

Level 1 of the stairway looks at exactly what AO and FCI are  Read more...
By Perry Whittle 2014/09/24 | Source: SQLServerCentral.com | Category: fci
Rating: |  Discuss |   Briefcase | 6,326 reads
   Items 1 to 20 of 13099    Older >>