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

<< Newer    Items 61 to 80 of 15000    Older >>
 

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 | 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: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 46 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 | 80 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,868 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,108 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,373 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,871 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,648 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 | 111 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,210 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,094 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,038 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 | 649 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,555 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 | 80 reads

How to Run Scheduled Jobs in Azure SQL Databases

This article will help you to schedule jobs in Azure SQL.  Read more...
By Daniel Calbimonte 2016/08/01 | Source: SQLServerCentral.com | Category: azure sql database
Rating: |  Discuss |   Briefcase | 739 reads

Introduction to Azure SQL Database Temporal Tables

As announced on June 1, 2016, SQL Server 2016 has reached its general availability. This means that you finally have the option to implement some of its new features in the production environment. While we still have to wait for their full support in Azure SQL Database V12, it is likely that their preview stage will be concluded soon. In this article, we will focus on Temporal tables, which is one example of these new features.  Read more...
By Additional Articles 2016/08/01 | Source: Database Journal | Category: azure sql database
Rating: (not yet rated)  Rate this |   Briefcase | 4,072 reads

Adding Old Features?

Is Row Level Security a new feature? Or should MS work on improving old ones?  Read more...
By Phil Factor 2016/08/01 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 50 reads

Passwords Under Pressure

Passwords are a problem, especially when we're in a hurry. What should we do?  Read more...
By Steve Jones 2016/08/01 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 74 reads
<< Newer    Items 61 to 80 of 15000    Older >>