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

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,889,451 DBAs, developers and SQL Server users

Rss
Headlines today   August 17, 2017

Testing COALESCE with tSQLt

Learn how you can use tSQLt to test your COALESCE queries.  Read more...
By Steve Jones 2017/08/17 | Source: SQLServerCentral.com | Category: tsqlt
Rating: |  Discuss |   Briefcase | 846 reads

How to Read a Transaction Log Backup

The transaction log backup is stored in SQL Server proprietary format, just like the transaction log itself. Even though the transaction log backup is in a special format, Microsoft has provided us with the fn_dump_dblog() function to read transaction log backups. This function is undocumented, so you should use care when using this function in a production environment.  Read more...
By Additional Articles 2017/08/17 | Source: Database Journal | Category: transaction log
Rating: (not yet rated)  Rate this |   Briefcase | 1,614 reads
Previous headlines

Stairway to SQL Server Automated Database Testing Level 1: Why You Need TDD

The first article in this Stairway Series makes the case for test-driven development.  Read more...
By Sebastian Meine 2017/08/16 (first published: 2014/12/31) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 6,173 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 2017/08/16 (first published: 2013/08/21) | Source: Redgate | Category: performance tuning
Rating:  Rate this |   Briefcase | 81,702 reads

Monitoring Azure Cloud and Hybrid Environments

Cloud-based services and applications must still be monitored just like the on-premise ones. You still need most of your data center activities that ensure that your planning, budgeting, security and service-level obligations are met wherever the data and services are actually hosted. There is much to be said for an integrated approach to providing a unified view of entire application workloads on-premise. hybrid and cloud using the same tools wherever possible.  Read more...
By Additional Articles 2017/08/16 | Source: SimpleTalk | Category: azure
Rating: (not yet rated)  Rate this |   Briefcase | 1,498 reads

New permissions features brings access control to SQL Clone

SQL Clone permissions has been high on the wish-list for users and the new feature addresses it in an intuitive way that enables you to allocate and change permissions quickly and easily.  Read more...
By 2017/08/16 | Source: Redgate | Category: sql clone
Rating: (not yet rated)  Rate this |   Briefcase | 1,014 reads

Using Database Master Keys in SQL Server

Learn the basics of Database Master Keys and how you can use them in SQL Server.  Read more...
By Steve Jones 2017/08/15 | Source: SQLServerCentral.com | Category: encryption
Rating: |  Discuss |   Briefcase | 812 reads

Let’s Corrupt a Database Together, Part 3: Detecting Corruption

Having already shown how to corrupt a database, and then how nonclustered indexes can be corrupted independently, in this post Brent Ozar explains how you can detect corruption.  Read more...
By Additional Articles 2017/08/15 | Source: Brent Ozar Unlimited Blog | Category: corruption
Rating:  Rate this |   Briefcase | 2,589 reads

SQL Server Management Studio Tips

Complete guide about hidden gems of SSMS  Read more...
By Konstantin Taranov 2017/08/14 | Source: SQLServerCentral.com | Category: ssms
Rating: |  Discuss |   Briefcase | 1,909 reads

SQL Server function to check dynamic SQL syntax

Although most of what you read tells you to stay away from dynamic SQL, the reality is there are places where writing T-SQL code dynamically just makes sense. The one downside to dynamic SQL is that if it is not written correctly the code will fail. Eli Leiba shares a function that he created to help determine if the dynamic code is OK prior to execution.  Read more...
By Additional Articles 2017/08/14 | Source: MSSQLTips.com | Category: dynamic code analysis
Rating: (not yet rated)  Rate this |   Briefcase | 3,704 reads
 

Ask SQL Server Central

From the SQLServerCentral Blogs

Power BI NFL Football Stats Comparisons and Analysis Report is now available!

For the past few years I’ve combined my love of professional football and analytics by releasing a series of Power...  Read more...
By dustinryan 2017/08/17 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,427 reads

Change RegisterAllProvidersIP setting on an existing Availability Group

Was working with a client who had an existing Availability Group, but did not have the RegisterAllProvidersIP setting enabled on...  Read more...
By willassaf@gmail.com 2017/08/17 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 629 reads
Question of the Day

Distributed Replay Targets

By Steve Jones 2017/08/17 | Category: distributed replay
Rating: (not yet rated) |  Discuss |   Briefcase | 386 reads

I've captured a trace on a SQL Server 2012 instance that I want to replay on a different instance for upgrade testing. What versions of SQL Server can I target...  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
GilaMonster
76346 281673 SSC Guru  
2.
Jeff Moden
64816 263097 SSC Guru  
3.
Steve Jones - SSC Editor
40431 176572 SSC Guru  
4.
Lynn Pettis
29233 116805 SSC Guru  
5.
Lowell
27002 92567 SSC Guru  
Latest forum posts