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

Obedience Training For Databases: Cascading Constraints

In which Phil Factor illustrates in TSQL how it is possible to use foreign key constraints to enforce data rules, and illustrates some surprising consequences of using cascading.  Read more...
By Phil Factor 2015/03/30 | Source: SQLServerCentral.com | Category: constraints
Rating: |  Discuss |   Briefcase | 2,674 reads

Identifying and Solving Index Scan Problems

When you're developing database applications, it pays to check for index scans in the SQL Server query plan cache. Once you've identified the queries, what next? Dennes Torres gives some preliminary guidelines on how to find out why these index scans are being chosen for these queries and how to make the queries run faster and more efficiently.  Read more...
By Additional Articles 2015/03/30 | Source: SimpleTalk | Category: query plan
Rating:  Rate this |   Briefcase | 8,240 reads

Software Engineering in Practice

Is there a need for apprenticeships in the data world? Should we consciously seek to view our first year as an apprenticeship? Should companies provide learning paths for new hires?  Read more...
By Steve Jones 2015/03/30 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 109 reads

One Rule, Umpteen Constraints

Despite being deprecated for many years, Phil Factor explains why RULEs are still hanging on in there in SQL Server 2014.  Read more...
By Phil Factor 2015/03/30 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 73 reads

Cumulative sum of previous rows

I had an update statement that took 3 minutes to run after this code change it took 6 seconds.  Read more...
By Ben Kubicek 2015/03/27 (first published: 2014/05/08) | Source: SQLServerCentral.com | Category: cumulative
Rating: |  Discuss |   Briefcase | 14,352 reads

SSMS or SSDT

The question this week deals with tools. Steve Jones is looking to see which tools are preferred by most database developers.  Read more...
By Steve Jones 2015/03/27 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 236 reads

Azure Blob Storage Part 9: Shared Access Signatures

In this article, Robin Shahan talks about security and how to control access to containers and blobs using shared access signatures (SAS) and stored access policies.   Read more...
By Additional Articles 2015/03/27 | Source: Just Azure | Category: blob storage
Rating: (not yet rated)  Rate this |   Briefcase | 6,892 reads

Efficiency

This Friday Steve Jones asks about how you are tackling your career growth as you get older. Are you getting more efficient?  Read more...
By Steve Jones 2015/03/26 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 293 reads

Unit Testing with SQL Server

Learn how to begin unit testing with tSQLt and SQL Server.   Read more...
By Alessandro Alpi 2015/03/26 | Source: SQLServerCentral.com | Category: unit testing
Rating: |  Discuss |   Briefcase | 5,260 reads

SQL Saturday #372 - Exeter, UK

SQL Saturday, organized by SQL South West, is coming to Exeter, England on April 25. This is sure to be a special event, and as always, offers a free day of training and networking. Register while space is available.  Read more...
By Press Release 2015/03/26 | Source: SQL Saturday | Category: events
Rating: (not yet rated)  Rate this |   Briefcase | 6,268 reads

Self-maintaining, Contiguous Effective Dates in Temporal Tables

'Temporal' tables contain facts that are valid for a period of time. When they are used for financial information they have to be very well constrained to prevent errors getting in and causing incorrect reporting. This makes them more difficult to maintain. Is it possible to have both the stringent constraints and simple CRUD operations? Well, yes. Dwain Camps patiently explains the whole process.  Read more...
By Additional Articles 2015/03/26 | Source: SimpleTalk | Category: temporary tables
Rating:  Rate this |   Briefcase | 8,003 reads

Stairway to AlwaysOn Level 6: Analyse & Deploy an AlwaysOn Availability Group

In level 6 of this stairway, we will look deeper into Availability Groups and how to set them up along with a Listener.  Read more...
By Perry Whittle 2015/03/25 | Source: SQLServerCentral.com | Category: stairway
Rating: |  Discuss |   Briefcase | 2,573 reads

Mastery – Repetition, Variations, and Depth

Today we have a guest editorial from Andy Warren. Andy look sat the ways in which we might solve problems and become better over time.  Read more...
By Andy Warren 2015/03/25 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 91 reads

Free eBook: SQL Server Backup and Restore

In this free eBook Shawn McGehee offers advice on query tuning, cutting stored procedures, and system process design and implementation for high availability. Discover how to perform backup and restore operations using SQL Server Management Studio (SSMS), basic T-SQL scripts and Red Gate's SQL Backup tool.  Read more...
By Press Release 2015/03/25 (first published: 2014/03/05) | Source: Red-Gate | Category: ebook
Rating: (not yet rated)  Rate this |   Briefcase | 39,206 reads

Exploding the Myths of Big Data

As big data application success stories (and failures) have appeared in the news and technical publications, several myths have emerged about big data. This article explores a few of the more significant myths, and how they may negatively affect your own big data implementation.  Read more...
By Additional Articles 2015/03/25 | Source: Database Journal | Category: big data
Rating: (not yet rated)  Rate this |   Briefcase | 10,490 reads

Identifying Start Dates not Aligned with End Dates on a Prior Row

When effective end dates don't align properly with effective start dates for subsequent rows, what are you to do?  Read more...
By Dwain Camps 2015/03/24 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 5,182 reads

Database source control workshop, Cambridge UK

Redgate is hosting a 1 day public workshop on April 22, 2015. This workshop will teach you how to put a database in source control, deploy a database from source control, and monitor database changes across development, testing, and production environments.  Read more...
By Press Release 2015/03/24 | Source: Red-Gate | Category: events
Rating: (not yet rated)  Rate this |   Briefcase | 6,423 reads

Are There That Many GUIDs?

Steve Jones talks about a recent survey that showed more people use GUIDs as primary keys than identity values.  Read more...
By Steve Jones 2015/03/24 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 551 reads

Integrating Database Lifecycle Management into Microsoft's Application Delivery Process

In order to automate the delivery of an application together with its database, you probably just need the extra database tools that allow you to continue with your current source control system and release management system by integrating the database into it. If you're using the Microsoft stack, then Redgate's tools can help with some of the difficult database parts of the process, as Jason Crease demonstrates.   Read more...
Rating:  Rate this |   Briefcase | 6,402 reads

SQL Cop and SQLServerCentral

Steve Jones runs the SQL Cop tests against the SQLServerCentral database and looks at the results.  Read more...
By Steve Jones 2015/03/23 | Source: SQLServerCentral.com | Category: sqlservercentral
Rating: |  Discuss |   Briefcase | 4,525 reads
<< Newer    Items 61 to 80 of 13657    Older >>