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

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

SQL Server Stored Procedure to Compress Non Partitioned Tables

My SQL Server database has some very big tables that can be compressed. The tables are simple, non-partitioned tables and I want a quick tool to compress them. I  Read more...
By Additional Articles 2016/08/12 | Source: | Category: compression
Rating: (not yet rated)  Rate this |   Briefcase | 2,530 reads

An object lesson about what is really important

A story I heard a long time ago reminds us to choose what is really important.  Read more...
By Ben Kubicek 2016/08/11 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 91 reads

Executing Multiple Threads to Create a Load

Learn a few techniques for executing multiple sets of queries at once.  Read more...
By Steve Jones 2016/08/11 | Source: | Category: performance testing
Rating: |  Discuss |   Briefcase | 1,595 reads

SSIS in SSDT: The Basics

SQL Server Integration Services (SSIS) is a fast and reliable way of importing and exporting data, but it can be tricky to learn, initially. Rob Sheldon provides a beginner's guide to get you started with using SSIS with Visual Studio and SQL Server Data Tools (SSDT).  Read more...
By Additional Articles 2016/08/11 | Source: SimpleTalk | Category: ssis
Rating: (not yet rated)  Rate this |   Briefcase | 4,707 reads

DBA Salary Survey

We're running a salary survey to find out what database professionals earn in the real world. The survey is completely anonymous, and the results will be published here in a few weeks time.  Read more...
By 2016/08/11 | Source:
Rating:  Rate this |   Briefcase | 3,800 reads

Keyboard Hardlines

The potential vulnerabilities of wireless devices might be a security issue for databases.  Read more...
By Steve Jones 2016/08/10 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 65 reads

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 | 1,009 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,154 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,250 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,441 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 | 71 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,484 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 | 628 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,195 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 | 64 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 | 46 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 | 78 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,846 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,100 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,368 reads
<< Newer    Items 41 to 60 of 14994    Older >>