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

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

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: MSSQLTips.com
Rating: (not yet rated)  Rate this |   Briefcase | 4,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: SQLServerCentral.com | 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: SQLServerCentral.com | Category: restore
Rating: |  Discuss |   Briefcase | 617 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,186 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: SQLServerCentral.com | 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: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 45 reads

Failover

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: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 74 reads

SELECT INTO vs INSERT INTO on Columnstore

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: SQLServerCentral.com | Category: performance and tuning
Rating: |  Discuss |   Briefcase | 16,818 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: SQLServerCentral.com | Category: reporting services (ssrs)
Rating: |  Discuss |   Briefcase | 11,092 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,347 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: SQLServerCentral.com | Category: database design
Rating: |  Discuss |   Briefcase | 1,850 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: SQLPerformance.com | Category: temporal tables
Rating: (not yet rated)  Rate this |   Briefcase | 2,628 reads

Defensive Programming

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

Byte Me: Earning in the Grave

By Bob Lang 2016/08/03 | Source: SQLServerCentral.com | 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: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 1,190 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,069 reads

Create a SQL Server Reporting Services Report from an Analysis Services Tabular Database

Daniel Calbimonte walks through the steps to creating a SQL Server Reporting Services (SSRS) Report from an Analysis Services Tabular Database.  Read more...
By Additional Articles 2016/08/03 | Source: MSSQLTips.com | Category: ssrs
Rating:  Rate this |   Briefcase | 5,011 reads

Changing Replication Passwords

A how-to guide for configuring replication agents after a password change  Read more...
By Lucinda Young 2016/08/02 | Source: SQLServerCentral.com | Category: replication
Rating: |  Discuss |   Briefcase | 640 reads

Strengthening the Foundations of Software Architecture

The term 'Architecture' seems to imply a plan that you can't easily subsequently deviate from. It's true that, if you abandon software architecture, you end up with a big ball of mud, but maybe the art of software is to make change much easier by planning how to implement each feature, tackling dependency issues, splitting functionality into small discrete components and considering how they should interact with each other.  Read more...
By Additional Articles 2016/08/02 | Source: SimpleTalk | Category: architecture
Rating: (not yet rated)  Rate this |   Briefcase | 4,540 reads

Moving Fast at Redgate

It's possible to change a software development team and dramatically improve things. Steve Jones highlights an example from Redgate Software.   Read more...
By Steve Jones 2016/08/02 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 79 reads
<< Newer    Items 41 to 60 of 14984    Older >>