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

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,853,283 DBAs, developers and SQL Server users

Previous headlines

Improving Performance for Some LIKE “%string%” Searches (SQL Spackle)

If you've ever wondered if you can do better than an INDEX SCAN when you do a LIKE "%string%" search, read on...  Read more...
By Dwain Camps 2016/02/12 (first published: 2014/04/07) | Source: SQLServerCentral.com | Category: sql like search
Rating: |  Discuss |   Briefcase | 35,545 reads

SQL Server System Views: The Basics

When maintaining or refactoring an unfamiliar database, you'll need a fast way to uncover all sorts of facts about the database, its tables, columns keys and indexes. SQL Server's plethora of system catalog views, INFORMATION_SCHEMA views, and dynamic management views contain all the metadata you need, but it isn't always obvious which views are best to use for which sort of information. Many of us could do with a simple explanation, and who better to provide one than Rob Sheldon?  Read more...
By Additional Articles 2016/02/12 | Source: SimpleTalk | Category: system views
Rating: (not yet rated)  Rate this |   Briefcase | 2,969 reads

Moved to 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/12 | Source: Redgate | Category: azure
Rating: (not yet rated)  Rate this |   Briefcase | 1,794 reads

SSIS: Case sensitivity may expose issues with change deployment

Because SSIS is case sensitive, random VS_NEEDSNEWMETADATA errors on case-insensitive databases may indicate issues in your database change management & deployment process.  Read more...
Rating: |  Discuss |   Briefcase | 1,148 reads

SQL Server 2016 Row Level Security Block and Filter Predicates Example

Rajendra Gupta takes a look at the additional enhancements made to Row Level Security in SQL Server 2016 CTP 3.1 and explores the new features with examples.  Read more...
By Additional Articles 2016/02/11 | Source: MSSQLTips.com | Category: sql server 2016
Rating: (not yet rated)  Rate this |   Briefcase | 1,582 reads

Redgate Cloud Research

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/11 | Source: Redgate | Category: azure
Rating: (not yet rated)  Rate this |   Briefcase | 1,984 reads

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,604 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,812 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 | 2,448 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,694 reads
 
Ask SQL Server Central



Question of the Day

The RPO

By Steve Jones 2016/02/12 | Category: backup and restore
Rating: (not yet rated) |  Discuss |   Briefcase | 799 reads

I have the following backup schedule for my SALES instance.


Full backup - Every Monday, 11pm
Differential backup - every night at 8pm
Transaction log backups - Every 15 minutes, from midnight on.
...  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
Ed Wagner
423 7995 SSCertifiable  
2.
ALPESH.KARP
366 1264 Ten Centuries  
3.
Orlando Colamatteo
317 7734 SSCertifiable  
4.
Hugo Kornelis
312 7153 SSCertifiable  
5.
sqlquaker
259 261 SSC Veteran  
Latest forum posts