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

<< Newer    Items 21 to 40 of 13607    Older >>
 

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 | 6,254 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,239 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 | 78 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 | 37,810 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 | 8,636 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 | 4,757 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 | 5,483 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 | 528 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 | 5,393 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,235 reads

SQL Server Reporting Services Bookmarks and Document Maps

What are the SQL Server Reporting Services Document Map and Bookmark properties? How can they be used? Do they work for all rendering formats? Scott Murry answers these questions and more.  Read more...
By Additional Articles 2015/03/23 | Source: MSSQLTips.com | Category: ssrs
Rating: (not yet rated)  Rate this |   Briefcase | 6,392 reads

Microservices, SOA and Service Broker

If you want to implement a service-oriented architecture on Windows, Service Broker is still your best choice, argues Phil Factor.  Read more...
By Phil Factor 2015/03/23 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 54 reads

First Episodes

Today we have a guest editorial from Andy Warren where he looks back at how things have changed.  Read more...
By Andy Warren 2015/03/23 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 93 reads

Stairway to SQL PowerShell Level 1: SQL PowerShell Basics

What are PowerShell and SQL PowerShell and how do you use them? Level 1 of this Stairway will help you answer these questions, and start to show you why you might want to use this great tool.  Read more...
By Ben Miller 2015/03/20 (first published: 2012/08/08) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 36,569 reads

Common Mistakes

This week Steve Jones is wondering what the common mistakes that T-SQL developers make are.  Read more...
By Steve Jones 2015/03/20 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 263 reads

Azure Blob Storage Part 8: Blob Leases

In this article, Robin Shahan explains what Blob Leases are and how to use them, including code samples for calling the different methods available for managing Blob Leases.  Read more...
By Additional Articles 2015/03/20 | Source: Just Azure | Category: blob storage
Rating: (not yet rated)  Rate this |   Briefcase | 5,916 reads

Microsoft and R

R is an interesting language and one that might become more important to data professionals in the future. Microsoft is also making an investment here.  Read more...
By Steve Jones 2015/03/19 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 222 reads

Mail Fails with SQLCMD Error

I had a SQL Server job that kept failing with sqlcmd error and this describes how I resolved it.  Read more...
By Ramya Makam 2015/03/19 | Source: SQLServerCentral.com | Category: sqlcmd
Rating: |  Discuss |   Briefcase | 2,470 reads

How to get Database Design Horribly Wrong

Database Design is one of those tasks where you have to carefully get all the major aspects right. If you mess-up just one of these, it can all go horribly wrong. So what are these aspects that can ruin database design, and how can you get them right? Robert Sheldon explains.  Read more...
By Additional Articles 2015/03/19 | Source: SimpleTalk | Category: database design
Rating:  Rate this |   Briefcase | 12,360 reads

SQL Saturday #364 - Boston, MA

SQL Saturday is coming to Boston on April 18th 2015. Join us for a free day of SQL Server training and networking, and listen to great speakers like Grant Fritchey, Brent Ozar, and Andy Leonard. Register while space is available.  Read more...
By Press Release 2015/03/19 | Source: SQL Saturday | Category: events
Rating: (not yet rated)  Rate this |   Briefcase | 5,331 reads
<< Newer    Items 21 to 40 of 13607    Older >>