Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

<< Newer    Items 41 to 60 of 14988    Older >>

Stairway to U-SQL Level 6: U-SQL Indexes and Partition Schemes

Find out how to speed up your queries by indexing and partitioning data, U-SQL style.  Read more...
By Mike McQuillan 2016/08/10 | Source: | Category: u-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 983 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 2016/08/10 (first published: 2013/08/28) | Source: Redgate | Category: defensive programming
Rating: (not yet rated)  Rate this |   Briefcase | 76,091 reads

Stretch Database in SQL Server 2016 RTM

Tim Radney of SQLskills shows how the Stretch Database feature has evolved from its early CTP beginnings to the RTM version released earlier this month.  Read more...
By Additional Articles 2016/08/10 | Source: | Category: stretch database
Rating: (not yet rated)  Rate this |   Briefcase | 2,219 reads

Reclaiming Space After Column Data Type Change

A brief overview of how to reclaim storage space after altering the data type of a column.  Read more...
By David Fundakowski 2016/08/09 | Source: | Category: data type
Rating: |  Discuss |   Briefcase | 1,426 reads

Steps to change the server name for a SQL Server machine

In this tip Jugal Shah looks at the steps within SQL Server you need to follow if you change the physical server name for a standalone SQL Server.  Read more...
By Additional Articles 2016/08/09 | Source:
Rating: (not yet rated)  Rate this |   Briefcase | 4,463 reads

Data Overload

When do you have too much data? What do you do if you aren't actually using all of it?  Read more...
By Steve Jones 2016/08/09 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 70 reads

Backup Strategy in Azure SQL?

Everybody says that the backup process in Azure SQL is very easy. Is that true? In this new article, we will show how to do it.  Read more...
By Daniel Calbimonte 2016/08/08 | Source: | Category: restore
Rating: |  Discuss |   Briefcase | 620 reads

Clone, Sweet Clone: Database Provisioning Made Easy?

One of the difficulties of designing a completely different type of development tool such as SQL Clone is that you have to explain what it is for, but when its use is open-ended it can be exciting to see the novel uses that come out of the early-access program.  Read more...
By 2016/08/08 | Source: SimpleTalk | Category: sql clone
Rating: (not yet rated)  Rate this |   Briefcase | 3,187 reads

Security Shaming

This week Steve Jones looks at a new idea, rating the security of products publicly to try and shame vendors into more secure coding.  Read more...
By Steve Jones 2016/08/08 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 63 reads

Making Complex Table Changes

The complexity of tables makes modifying them over time a challenge, especially as data sizes grow.  Read more...
By Steve Jones 2016/08/08 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 45 reads


Too many failovers can cause problems, as can those that happen to often. Steve Jones says you need to consider whether you always need to failover in a sitaution.  Read more...
By Steve Jones 2016/08/05 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 75 reads


This article compares SELECT INTO and INSERT INTO under different scenarios, and the best approach preferred.  Read more...
By Ramya Makam 2016/08/05 (first published: 2015/06/09) | Source: | Category: performance and tuning
Rating: |  Discuss |   Briefcase | 16,828 reads

Adding Slicers to a Reporting Services Report

This article shows you how to create dynamic slicers from a data set in an SSRS report  Read more...
By Adam Aspin 2016/08/05 (first published: 2015/04/23) | Source: | Category: reporting services (ssrs)
Rating: |  Discuss |   Briefcase | 11,095 reads

Database Lifecycle Management: Deployment and Release

So often, the unexpected delays in delivering database code are more likely to happen after the developers initiate the release process. The necessary checks and tests can turn up surprises: The handover process can expose deficiencies. With good teamwork, planning and forethought, though, the process can be made almost painless.  Read more...
By Additional Articles 2016/08/05 | Source: SimpleTalk | Category: deployment
Rating:  Rate this |   Briefcase | 3,352 reads

Proper Storage and Handling of Personal Names

As database developers, we may need to rethink the way we store and handle personal names  Read more...
By Tung 2016/08/04 | Source: | Category: database design
Rating: |  Discuss |   Briefcase | 1,852 reads

SQL Server 2016 Temporal Table Query Plan Behaviour

In this latest T-SQL Tuesday, Rob Farley takes a look at a couple of unexpected aspects of query plans you might observe when using Temporal Tables in SQL Server 2016.  Read more...
By Additional Articles 2016/08/04 | Source: | Category: temporal tables
Rating: (not yet rated)  Rate this |   Briefcase | 2,632 reads

Defensive Programming

Learning to program defensively can prevent and catch errors early.  Read more...
By Steve Jones 2016/08/04 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 108 reads

Byte Me: Earning in the Grave

By Bob Lang 2016/08/03 | Source: | Category: byte me
Rating: (not yet rated) |  Discuss |   Briefcase | 42 reads

Stairway to Exploring Database Metadata Level 1: Why Should You Care About the Dynamic Online Catalog?

In this first level, we look at the overview of what metadata is contained in each database, gain some understanding of the different types of information, and examine a few basic examples.  Read more...
By Phil Factor 2016/08/03 | Source: | Category: stairway series
Rating: |  Discuss |   Briefcase | 1,194 reads

Free eBook: Performance Tuning with SQL Server Dynamic Management Views

Dynamic Management Views (DMVs) are a significant and valuable addition to the DBA's troubleshooting armory, laying bare previously unavailable information regarding the under-the-covers activity of your database sessions and transactions.  Read more...
By Additional Articles 2016/08/03 (first published: 2013/08/21) | Source: Redgate | Category: performance tuning
Rating:  Rate this |   Briefcase | 71,075 reads
<< Newer    Items 41 to 60 of 14988    Older >>