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

<< Newer    Items 61 to 80 of 13149    Older >>
 

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 | 16,047 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 | 172 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 | 9,392 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 | 6,616 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 | 5,472 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 | 109 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 | 5,530 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 | 10,899 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 | 12,239 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 | 7,388 reads

Byte Me: A Mother of a Problem

Board games.  Read more...
By Bob Lang 2014/09/24 | Source: SQLServerCentral.com | Category: byte me
Rating: |  Discuss |   Briefcase | 345 reads

Free eBook: Defensive Database Programming

Resilient T-SQL code is code that is designed to last, and to be safely reused by others. The goal of defensive database programming, the goal of this book, is to help you to produce resilient T-SQL code that robustly and gracefully handles cases of unintended use, and is resilient to common changes to the database environment.  Read more...
By Press Release 2014/09/24 (first published: 2013/08/28) | Source: Red-Gate | Category: defensive programming
Rating: (not yet rated)  Rate this |   Briefcase | 36,453 reads

10 things I learned about rapidly scaling websites with Azure

Troy Hunt takes a look at a website whose traffic literally increased 60-fold overnight. Interesting stuff happens when scale changes that dramatically, so he decided to share a few things he learned.  Read more...
By Additional Articles 2014/09/24 | Source: Troy Hunt | Category: azure
Rating: (not yet rated)  Rate this |   Briefcase | 6,849 reads

Copy a database between servers with one command

This tool is a helper for your daily work to copy easily databases between Servers/instances and do all the necessary stuff for you.  Read more...
By Roland Hangg 2014/09/23 | Source: SQLServerCentral.com | Category: copy database script
Rating: |  Discuss |   Briefcase | 14,045 reads

Testing in Production

The Apple fall keynote recently didn't work as planned, and it seems as though their systems weren't tested well enough.  Read more...
By Steve Jones 2014/09/23 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 191 reads

Importing Excel Data into SQL Server Via SSIS: Questions You Were Too Shy to Ask

Retrieving data from Excel, and importing it into SQL Server hasn't the same appeal or glamour as, for example, performing heroics with ill-performing queries. This could be why one hesitates before asking questions about how to do it. Rob Sheldon calms your private doubts and fears by answering those embarrassing questions.  Read more...
By Additional Articles 2014/09/23 | Source: SimpleTalk | Category: integration services (ssis)
Rating: (not yet rated)  Rate this |   Briefcase | 9,719 reads

SQL Saturday #352 - Sydney

SQL Saturday is coming to Sydney, Australia on October 25, 2014. Join us down under for a free day of SQL Server training and networking. Register while space is available.  Read more...
By Press Release 2014/09/23 | Source: SQL Saturday | Category: events
Rating: (not yet rated)  Rate this |   Briefcase | 5,944 reads

Automate Yourself to a Coffee Break

A DBA should be working to automate their tasks, and find time to do things that are really important. Like keeping their coffee cup topped off :)  Read more...
By Steve Jones 2014/09/22 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 246 reads

Premature Optimisation

Learning how to tune a system is a bit of science and a bit of an art. Gail Shaw gives some guidelines on when you might want to tune and how to go about it so as not to unnecessarily undertake the effort.  Read more...
By Gail Shaw 2014/09/22 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 4,949 reads

Watson Freemium

IBM has released a free version of its Watson service to help people perform analytics on their data.  Read more...
By Steve Jones 2014/09/22 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 99 reads
<< Newer    Items 61 to 80 of 13149    Older >>