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

   Items 1 to 20 of 12645    Older >>
 

XML Workshop : Utilizing Relational Data In XML Files

Have you received an XML file that must be migrated into a production database? Today’s workshop dives into an ad hoc method of processing relational datasets delivered in an XML file format.  Read more...
By Matthew Pettit 2014/04/24 | Source: SQLServerCentral.com | Category: xml
Rating: |  Discuss |   Briefcase | 2,155 reads

Prevent multiple users from running the same SQL Server stored procedure at the same time

There is a stored procedure that must be run by only one user at a time. In this tip, learn how to prevent multiple users from running the stored procedure at the same time.  Read more...
By Additional Articles 2014/04/24 | Source: MSSQLTips.com | Category: locking
Rating:  Rate this |   Briefcase | 2,796 reads

Good Practices for Software Development

We always want to follow the best, or at least good, practices for software development. However do you know what those are? Steve Jones notes there's at least one that isn't often followed.  Read more...
By Additional Articles 2014/04/24 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 72 reads

Stairway to Database Source Control Level 1: Setting Up For Database Source Control

The first level of this stairway introduces the basics of source control, some common technologies and technologies, and demonstrates how to start versioning a SQL Server database.  Read more...
By Dave Green 2014/04/23 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 2,880 reads

Open Source the MCM

The MCM certification program has been abandoned by Microsoft. Steve Jones thinks the material can still be useful for the community.  Read more...
By Steve Jones 2014/04/23 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 159 reads

Free eBook: Troubleshooting SQL Server: A Guide for the Accidental DBA

Three SQL Server MVPs (Jonathan Kehayias, Ted Krueger and Gail Shaw) provide fascinating insight into the most common SQL Server problems, why they occur, and how they can be diagnosed using tools such as Performance Monitor, Dynamic Management Views and server-side tracing. The focus is on practical solutions for removing root causes of these problems, rather than "papering over the cracks".  Read more...
By Press Release 2014/04/23 (first published: 2013/08/07) | Source: Red-Gate | Category: troubleshooting
Rating:  Rate this |   Briefcase | 18,760 reads

Database Normalization Basics

The task of Database Normalization doesn't have to be painful, especially if you follow Old Mother Celko's Normalization Heuristics.  Read more...
By Additional Articles 2014/04/23 | Source: SimpleTalk | Category: normalization
Rating: (not yet rated)  Rate this |   Briefcase | 3,684 reads

Partitioning Data in a Multi-tenant Data Warehouse Solution

Part two of our series looks at the partitioning strategy to separate customers' data, providing security and performance.  Read more...
By Sean Woehrle 2014/04/22 | Source: SQLServerCentral.com | Category: data warehousing
Rating: |  Discuss |   Briefcase | 3,276 reads

Open Call for Editorials

Steve Jones is putting out an open call for guest editorial pieces in the spring of 2014. If you're interested, read on.  Read more...
By Steve Jones 2014/04/22 (first published: 2014/02/27) | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 964 reads

Due Diligence

How can you perform due diligence on new employees? There are a variety of ways, but Steve Jones has an idea that might help you nudge a potential employer in the direction you want them to move.  Read more...
By Steve Jones 2014/04/22 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 94 reads

Microsoft Azure SQL Database Security - Firewall Configuration

Marcin Policht reviews security related challenges of Microsoft Azure Software as a Service-based SQL Database, focusing in particular on the SQL Server and database-level firewall access control functionality and methods that can be employed to implement it.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 1,920 reads

Consolidation Matters

Consolidating SQL Server instances is something Steve Jones has done in the past and he thinks we'll all do more of in the future.  Read more...
By Steve Jones 2014/04/21 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 69 reads

Automating Database Restores

This article describes a way to automatically restore multiple database backups from a directory.  Read more...
By Sujeet Singh 2014/04/21 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 4,325 reads

Running With The Red Queen

Trying to take the time to fix sub-par processes has some surprising parallels in nature.  Read more...
By Dave Convery 2014/04/21 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 64 reads

Monitoring SQL Server: An Interview with David Bick

Simple-Talk sat down with David Bick, a Red Gate Product Manager, to discuss his work on SQL Monitor and why passively monitoring SQL Server just doesn’t cut it anymore.  Read more...
By Additional Articles 2014/04/21 | Source: SimpleTalk | Category: interview
Rating:  Rate this |   Briefcase | 2,106 reads

SQL Saturday #308 - Houston, TX

SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. This event will be held May 10, 2014. Register while space is available.  Read more...
By Press Release 2014/04/21 | Source: SQL Saturday | Category: events
Rating:  Rate this |   Briefcase | 752 reads

Unexpected View Performance

Views that use implicit conversion to return result sets may use a different query plan than the statement executed in query analyzer.  Read more...
By Thom Bolin 2014/04/18 (first published: 2011/01/11) | Source: SQLServerCentral.com | Category: views
Rating: |  Discuss |   Briefcase | 12,828 reads

SQL Server Performance Tuning Using Wait Statistics: A Beginner's Guide

This beginner's guide to Wait Stats by Jonathan Kehayias and Erin Stellato is a free PDF download brought to you by SQL Skills and Simple-Talk.  Read more...
By Additional Articles 2014/04/18 | Source: SimpleTalk | Category: wait statistics
Rating:  Rate this |   Briefcase | 3,884 reads

Advice for Newcomers

If you could look back on your career, is there some advice you wish you had? Is there something you'd tell people considering your job as a career? Let us know this Friday.  Read more...
By Steve Jones 2014/04/18 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 121 reads

SQL Saturday #305: Dallas, BA Edition

Please join us on Saturday, May 3rd, 2014, as both business analysts and IT professionals come to learn and network with experts for the first SQLSaturday Business Analytics edition. Please register while space is available  Read more...
By Press Release 2014/04/18 | Source: SQL Saturday | Category: events
Rating: (not yet rated) |  Discuss |   Briefcase | 225 reads
   Items 1 to 20 of 12645    Older >>