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 13154    Older >>
 

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 | 91 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 | 183 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 | 2,399 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/10/03 (first published: 2014/09/29) | Source: SQLServerCentral.com | Category: pass
Rating: |  Discuss |   Briefcase | 437 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 | 6,502 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 | 16,069 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,429 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,619 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,475 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,544 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,911 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,242 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,415 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,469 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,867 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,074 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
<< Newer    Items 61 to 80 of 13154    Older >>