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

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

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 2018/01/03 (first published: 2013/08/21) | Source: Redgate | Category: performance tuning
Rating:  Rate this |   Briefcase | 87,912 reads

The top 10 considerations when designing a data platform

Designing a data platform for a new product or service is a fascinating and exciting challenge. It’s also a daunting one.  Read more...
By 2018/01/03 | Source: Redgate | Category: data platform
Rating: (not yet rated)  Rate this |   Briefcase | 3,362 reads

Automatic Plan Correction

SQL Server 2017 lets you solve parameter sniffing problems - Automatically!  Read more...
By Wayne Sheffield 2018/01/02 (first published: 2017/11/20) | Source: SQLServerCentral.com | Category: automatic plan correction
Rating: |  Discuss |   Briefcase | 972 reads

Understanding Your Value

Data can help you understand the value you bring to a company as a data professional.  Read more...
By Steve Jones 2018/01/02 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 84 reads

Create Size-based Backups for SQL Server 2017

Jeffrey Yao explains how to generate backups based on the amount of data that has changed for differential and transaction log backups.  Read more...
By Additional Articles 2018/01/02 | Source: MSSQLTips.com | Category: sql server 2017
Rating: (not yet rated)  Rate this |   Briefcase | 3,126 reads

How you can improve your SQL with code analysis in SQL Prompt

You could think of the code analysis feature in SQL Prompt as a machine-assisted code review. The rules that are used to check your code point out questionable areas that might be missed during regular testing.  Read more...
By 2018/01/02 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 3,608 reads

Happy New Year 2018

Today starts 2018  Read more...
By Steve Jones 2018/01/01 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 21 reads

PowerShell Tool Time: Controlling Our Tools

The next installment of the Powershell Tool Time series shows you how to manage backup files by   Read more...
By Mike Fal 2018/01/01 (first published: 2015/09/16) | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 4,552 reads

Can you prevent deletes and inserts without a WHERE clause from running?

Erik writes a script to do what it says on the tin.  Read more...
By Additional Articles 2018/01/01 | Source: Brent Ozar Unlimited Blog | Category: delete
Rating: (not yet rated)  Rate this |   Briefcase | 4,352 reads

Sizing New Servers

Steve Jones talks hardware, which he mostly doesn't worry about for SQL Servers.  Read more...
By Steve Jones 2018/01/01 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 36 reads

Level 4 - Building the Hyper-V VM

In this level of the Stairway to Server Virtualization, learn how to build a Hyper-V virtual machine for SQL Server.  Read more...
By David Klee 2017/12/29 (first published: 2015/10/07) | Source: SQLServerCentral.com | Category: virtualization
Rating: |  Discuss |   Briefcase | 4,578 reads

The End of 2017

Today ends the work year for Steve and many of you.  Read more...
By Steve Jones 2017/12/29 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 29 reads

Questions About Amazon Data Migration Service (AWS DMS) That You Were Too Shy to Ask

Can you imagine it? You are in a group of smart database people, and they are debating the finer points about AWS DMS, and you don't even know what the letters stand for. You just feel too shy to ask those basic questions that seem ridiculous once you're up to speed. Laerte Junior answers all the questions you need answers for when facing the prospect of getting familiar with Amazon's useful Database Migration Service.  Read more...
By Additional Articles 2017/12/29 | Source: SimpleTalk | Category: aws
Rating:  Rate this |   Briefcase | 3,521 reads

SQL Clone v2.4 – run scripts during image creation

SQL Clone 2.4 incorporates a new T-SQL script runner that the team can use to mask sensitive or personal data, or to modify security and other configuration settings, prior to creating a clone.  Read more...
By 2017/12/29 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 2,937 reads

An Introduction: Level 1 of the Stairway to Row-Level Security

Learn the basics of how Row-Level Security works in SQL Server.  Read more...
By Steve Jones 2017/12/28 | Source: SQLServerCentral.com | Category: row level security (rls)
Rating: |  Discuss |   Briefcase | 839 reads

Back From Vacation and Ready To Go

Steve is back and ready to move things forward.  Read more...
By Steve Jones 2017/12/28 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 29 reads

Quickly Restricting Database Access

There may be times when you need to perform maintenance against a database that requires you to keep normal database users from connecting to your database while the maintenance is being performed. You want to stop users from connecting right away, but you want the database to be in a state that you can perform maintenance.   Read more...
By Additional Articles 2017/12/28 | Source: Database Journal | Category: access control
Rating:  Rate this |   Briefcase | 3,637 reads

Would you like to see Redgate tools inside SQL Operations Studio?

You may already have heard about Microsoft’s new DevOps platform for database development, SQL Operations Studio. Related to this, Redgate is doing some research into cross-platform data tools. Read this blog post to find out more about what they're doing, and how you can get involved.  Read more...
By 2017/12/28 | Source: Redgate | Category: sql operations studio
Rating: (not yet rated)  Rate this |   Briefcase | 2,931 reads

Stairway to SQL Server Extended Events Level 3: Working with the Extended Events UI

In the next installment of our stairway to Extended Events, we delve into the Live Data and Target Data Viewers.  Read more...
By Erin Stellato 2017/12/27 (first published: 2016/05/25) | Source: SQLServerCentral.com | Category: extended events (xe)
Rating: |  Discuss |   Briefcase | 2,118 reads

The Slow Week

This is usually a slow time for many companies between two holidays, but it doesn't need to be unproductive.  Read more...
By Steve Jones 2017/12/27 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 47 reads
<< Newer    Items 41 to 60 of 16439    Older >>