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,255 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,390 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,679 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,567 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,143 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,502 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,845 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,582 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,754 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,318 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,685 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 | 770 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
434 7993 SSCertifiable  
2.
ALPESH.KARP
366 1264 Ten Centuries  
3.
Hugo Kornelis
312 7152 SSCertifiable  
4.
Orlando Colamatteo
291 7700 SSCertifiable  
5.
Rick.Cornell.SME
258 5302 SSCertifiable  
Latest forum posts