SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

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

Can the database be included in DevOps in financial services?

For many DBAs who work in financial services, deploying database changes is the most taxing part of the job. Being required to review thousands of lines of script can take days, depending on how many errors you find. Even when database deployments are better planned, it’s not an easy journey, and DBAs are often regarded as the blocker in the process, the ones who are causing the problem rather than trying to resolve it  Read more...
By 2017/11/09 | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 2,813 reads

How to Do a SQL Server Architecture Review

How do you get management to help you figure out if a cluster or an AG is right for you? In this post, Brent Ozar explains the steps involved when doing a review of your SQL Server architecture.  Read more...
By Additional Articles 2017/11/09 | Source: Brent Ozar Unlimited Blog | Category: architecture
Rating:  Rate this |   Briefcase | 4,307 reads

Should We Move to Azure?

This week Steve Jones asks about moving to the cloud and how interesting that might be to the community?  Read more...
By Steve Jones 2017/11/08 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 220 reads

Stairway to AlwaysOn Level 4: Analyse and Deploy a Windows Server Failover Cluster

In level 4 of the stairway to AlwaysOn we look at creating a Windows Server Failover Cluster.  Read more...
By Perry Whittle 2017/11/08 (first published: 2014/12/10) | Source: SQLServerCentral.com | Category: cluster
Rating: |  Discuss |   Briefcase | 4,844 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 Redgate's SQL Backup tool.  Read more...
By Press Release 2017/11/08 (first published: 2014/03/05) | Source: Redgate | Category: ebook
Rating:  Rate this |   Briefcase | 64,312 reads

SQL Server R Services: Working with Data Frames

Although you can get started with R in SQL Server without understanding data frames, they are a key structure of the R language that are the equivalent of SQL Server table variables. They give you many ways of manipulating and analyzing data and passing it between R and SQL Server. For a database professional, they provide a clear and familiar concept when getting to grips with integrating R into the database.  Read more...
By Additional Articles 2017/11/08 | Source: SimpleTalk | Category: r services
Rating: (not yet rated)  Rate this |   Briefcase | 2,981 reads

What are you worth?

When negotiating your salary, it helps to know what the ranges are for your experience and area. Steve Jones gives a little advice today.  Read more...
By Steve Jones 2017/11/07 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 409 reads

Importing Files in Parallel with SSIS

Run multiple instances of your package in parallel so that each instance processes a portion of the total number of files  Read more...
Rating: |  Discuss |   Briefcase | 1,014 reads

How to record T-SQL execution times using a SQL Prompt snippet

In this quick tip, Phil Factor shares the SQL Prompt snippet he uses as a standard testbed for getting execution times for procedures and functions.  Read more...
By 2017/11/07 | Source: Redgate | Category: sql prompt
Rating: (not yet rated)  Rate this |   Briefcase | 3,782 reads

Dynamic Data Masking on Azure SQL Database

Azure SQL Database’s Dynamic Data Masking (DDM) feature limits the exposure of sensitive information to non-privileged users. DDM can mask either the full value or partial value in a column. This method can also mask Social Security and Credit Card Numbers without making any changes to the application. Read on to learn more.  Read more...
By Additional Articles 2017/11/07 | Source: Database Journal | Category: azure sql database
Rating: (not yet rated)  Rate this |   Briefcase | 1,908 reads

Looking Back at the Summit

Steve Jones looks back at the PASS Summit from last week.  Read more...
By Steve Jones 2017/11/06 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 53 reads

Name Value Pairs Table Handling

While Name Value Pairs Tables are anathema to Relational Database professionals, it is sometimes useful to consider such a structure in a production application. This article illustrates the use of User-defined Table Type to improve such handling.  Read more...
By Jerome Boyer 2017/11/06 | Source: SQLServerCentral.com | Category: user-defined table type
Rating: |  Discuss |   Briefcase | 1,220 reads

SQL Code Smells

Some time ago, Phil Factor wrote his booklet 'SQL Code Smells', collecting together a whole range of SQL Coding practices that could be considered to indicate the need for a review of the code. It was published as 119 code smells, even though there were 120 of them at the time. Phil Factor has continued to collect them and the current state of the art is reflected in this article. There are now around 150 of these smells and SQL Code Guard is committed to cover as many as possible of them.  Read more...
By Additional Articles 2017/11/06 | Source: SimpleTalk | Category: sql
Rating:  Rate this |   Briefcase | 5,413 reads

The Importance of Clear Data Displays

An accident on a ship is being blamed on unclear data visualization.  Read more...
By Steve Jones 2017/11/06 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 54 reads

Core T-SQL

Steve Jones thinks there is a list of core skills that any database developer or DBA needs. This week he asks you for a list of those things you think should be included.  Read more...
By Steve Jones 2017/11/03 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 726 reads

Additional Data Files and Proportional Fill

Additional files can be added to to a database to increase the storage. When more data is added to the files, Extended Events shows how SQL Server spreads data across multiple files.  Read more...
By David Fundakowski 2017/11/03 (first published: 2016/07/25) | Source: SQLServerCentral.com | Category: filegroups
Rating: |  Discuss |   Briefcase | 1,664 reads

Why it’s time to think seriously about SQL Server 2017

SQL Server 2017 is now on general release. The latest version of the heavyweight platform is more than the sum of its parts, however, because it doesn’t just deliver new functionality. Alongside the list of extra features, it also changes two important ways we think about the platform itself.  Read more...
By 2017/11/03 | Source: Redgate | Category: sql server 2017
Rating: (not yet rated)  Rate this |   Briefcase | 5,837 reads

Azure SQL Database Long-Term Backup Retention

Azure SQL Database provides a number of benefits that leverage resiliency and redundancy built into the underlying cloud infrastructure. In addition to Point-in-Time Restore as well as Geo-Restore and Active Geo-Replication, you have the option of implementing long-term backup retention of Azure SQL Database.  Read more...
By Additional Articles 2017/11/03 | Source: Database Journal | Category: azure sql database
Rating: (not yet rated)  Rate this |   Briefcase | 2,179 reads

Good Practices for Software Development

We always want to follow the best, or at least good, practices for software development. However do you know what those are? Steve Jones notes there's at least one that isn't often followed.  Read more...
By Steve Jones 2017/11/02 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 350 reads

Loading partitioned table incrementally using SSIS

This article gives an example of loading partitioned tables incrementally using SSIS  Read more...
By Shubhankar Thatte 2017/11/02 | Source: SQLServerCentral.com | Category: partitioning
Rating: |  Discuss |   Briefcase | 697 reads
<< Newer    Items 41 to 60 of 16278    Older >>