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

   Items 1 to 20 of 14455    Older >>
 

Foreign Key Indexes and Binding

Understand what FK's do and how they use indexes. Then use my script to see if they're using good indexes.  Read more...
By Steve Hood 2016/02/10 | Source: SQLServerCentral.com | Category: foreign keys
Rating: |  Discuss |   Briefcase | 2,105 reads

Byte Me: Literal Thinking

By Bob Lang 2016/02/10 | Source: SQLServerCentral.com | Category: byte me
Rating: (not yet rated) |  Discuss |   Briefcase | 73 reads

Free eBook: Fundamentals of SQL Server 2012 Replication

Fundamentals of SQL Server 2012 Replication provides a hands-on introduction to SQL Server replication. The book introduces you to the technologies that make up replication, and then walks you through setting up different replication scenarios. When you've finished reading, you should be able to implement your own multi-server replication setup while following the principle of least privilege.  Read more...
By Press Release 2016/02/10 (first published: 2014/02/26) | Source: Redgate | Category: replication
Rating:  Rate this |   Briefcase | 49,328 reads

Cloud Adoption Survey

Are you thinking about the cloud yet? Redgate is conducting some research into cloud adoption to better understand both the drivers and the blockers. Whether or not you’ve taken the plunge yet, they would love to hear from you. Participate in the survey and be entered into a draw to win an Amazon gift card worth $100.  Read more...
By Additional Articles 2016/02/10 | Source: Redgate | Category: azure
Rating: (not yet rated)  Rate this |   Briefcase | 1,365 reads

The Digital Woes of Public Records

Public records have been open in the past, but today's digital access might mean problems.  Read more...
By Steve Jones 2016/02/09 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 67 reads

Enabling TDE on Databases in an AlwaysOn Scenario

Enabling Transparent Data Encryption on Databases in Always On Scenario  Read more...
By Sanjiv Doshetty 2016/02/09 | Source: SQLServerCentral.com | Category: alwayson
Rating: |  Discuss |   Briefcase | 1,561 reads

The SQL Server 2016 Query Store: Accessing Query Store Information Using DMVs

The SQL Server 2016 Query Store provides several new ways of troubleshooting queries, studying their plans, exploring their context settings, and checking their performance metrics. In using the Query Store to ensure that performance is as good as possible, it isn't long before it becomes important to be familiar with the DMVs that are associated with the query store, and using them in custom queries.  Read more...
By Additional Articles 2016/02/09 | Source: SimpleTalk | Category: sql server 2016
Rating: (not yet rated)  Rate this |   Briefcase | 1,672 reads

Thinking About the Cloud?

Are you thinking about the cloud yet? Redgate is conducting some research into cloud adoption to better understand both the drivers and the blockers. Whether or not you’ve taken the plunge yet, they would love to hear from you. Participate in the survey and be entered into a draw to win an Amazon gift card worth $100.  Read more...
By Additional Articles 2016/02/09 | Source: Redgate | Category: cloud
Rating: (not yet rated)  Rate this |   Briefcase | 2,154 reads

Culture and Performance

Culture is important at our workplace. Steve Jones notes this can be important when trying to get the most performance from your employees.  Read more...
By Steve Jones 2016/02/08 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 108 reads

tSQLt and the INSERT EXEC Problem

A proposed solution to the INSERT EXEC problem in tSQLt  Read more...
By Charles Silbergleith 2016/02/08 | Source: SQLServerCentral.com | Category: ms sql
Rating: |  Discuss |   Briefcase | 3,683 reads

SQL, and Ye Shall Find

Phil Factor reflects on how hard it really is to develop a really effective database that meets the SQL Standards, and how as a result we are only beginning to realize fully the vision of relational orthogonality in databases.  Read more...
By Phil Factor 2016/02/08 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 70 reads

Exploration of SQL Server 2016 Always Encrypted – Part 3

In this third article of the exploring SQL Server 2016 Always Encrypted series, Greg Larsen looks at the differences between an Always Encrypted column that uses an encryption type of Deterministic and those that use encryption type of Randomized.  Read more...
By Additional Articles 2016/02/08 | Source: Database Journal | Category: sql server 2016
Rating: (not yet rated)  Rate this |   Briefcase | 1,533 reads

Centrally collect replication conflicts and send an alert

Automatically capture replication conflicts and generate an automated email notification.  Read more...
By Kimberly Killian 2016/02/05 (first published: 2011/10/17) | Source: SQLServerCentral.com | Category: replication
Rating: |  Discuss |   Briefcase | 2,652 reads

Who's Got a Preteen SQL Server?

This week Steve Jones wonders about the age of your instances and whether you are planning on upgrades or aware of how many out of support instances you might have.  Read more...
By Steve Jones 2016/02/05 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 84 reads

Microsoft Survey on Backup and Security

Microsoft is looking for some people to talk to for ~20 minutes via phone/Skype and as a thank you for sharing, will provide a $10 Amazon gift card after the call.  Read more...
By Press Release 2016/02/05 | Source: SQLServerCentral.com | Category: backup and restore
Rating: (not yet rated) |  Discuss |   Briefcase | 336 reads

How to read data from multiple Excel worksheets with SQL Server Integration Services

Read this tip to learn how to import data from multiple Excel worksheets into SQL Server using SSIS.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 2,415 reads

SQL Azure Performance Benchmarking

An evaluation of the SQL Azure Database Performance Levels recommended by the DTU Calculator service, and a comparison with on premise SQL Server performance.  Read more...
By Paul Brewer 2016/02/04 | Source: SQLServerCentral.com | Category: sql azure
Rating: |  Discuss |   Briefcase | 1,001 reads

Monitoring In-Memory OLTP: What's Important?

In-Memory OLTP has evolved to be a great solution. However, a production system that uses it needs careful monitoring to avoid stress conditions becoming problems. As with many new features of SQL Server, it pays to plan a monitoring strategy to ensure that you are alerted as soon as possible when things go awry.  Read more...
By Additional Articles 2016/02/04 | Source: SimpleTalk
Rating:  Rate this |   Briefcase | 1,865 reads

The New Operating System

We have an operating system for how our organizations are run. Steve Jones talks about a new one that might be important for the world rules by software.  Read more...
By Steve Jones 2016/02/04 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 107 reads

Stairway to Database Source Control Level 4: Getting a Database into Source Control (Distributed Repository)

Now that we have our database under source control, we will want to share our work with other developers. If we are in a centralized source control system, our changes may be committed straight into the central repository. When we are working in a distributed system, it means pulling down any changes from other developers, addressing any areas of conflict, and pushing our changes up to allow others to benefit from our work. This allows our changes to be synchronized with the changes other developers have made. This level is principally about setting up a distributed source control system, namely Git, and how to commit database development changes to a local repository, before pushing them into a remote 'central' repository for sharing with other developers. The next level will delve a little deeper into Git's versioning mechanisms, and show some examples of how to share database changes during development, and how to deal with conflicting changes.  Read more...
By Dave Green 2016/02/03 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 1,662 reads
   Items 1 to 20 of 14455    Older >>