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

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

Free eBook: SQL Server Backup and Restore

In this free eBook Shawn McGehee offers advice on query tuning, cutting stored procedures, and system process design and implementation for high availability. Discover how to perform backup and restore operations using SQL Server Management Studio (SSMS), basic T-SQL scripts and Redgate's SQL Backup tool.  Read more...
By Press Release 2017/04/12 (first published: 2014/03/05) | Source: Redgate | Category: ebook
Rating:  Rate this |   Briefcase | 56,922 reads

Automating database deployments to and from source control using SQL Compare and PowerShell

Phil Factor shows how you can use the SQL Compare Pro command line with PowerShell to automate the task of getting a new database into version control, creating a new database build script, and creating a database migration script.  Read more...
By Additional Articles 2017/04/12 | Source: Redgate | Category: sql compare
Rating: (not yet rated)  Rate this |   Briefcase | 3,332 reads

Does Speed Compromise Quality?

In a more rapid, DevOps environment, is code quality compromised?  Read more...
By Steve Jones 2017/04/11 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 53 reads

Dynamic SSRS report documentation via a ReportServer.dbo.Catalog query

This article demonstrates a method of generating SSRS report documentation by using an SSRS report that queries the ReportServer.dbo.Catalog table.  Read more...
By Stan Kulp 2017/04/11 | Source: SQLServerCentral.com | Category: reporting services (ssrs)
Rating: |  Discuss |   Briefcase | 3,015 reads

SQL Clone Trivia Quiz - win a $10 gift card every weekday in April

To celebrate the recent launch of their new database provision tool, Redgate are giving you the chance to win a $10 Amazon or Starbucks gift card every weekday this month. To enter the prize draw, just answer the daily SQL Clone trivia question on the right-hand side of the homepage.  Read more...
By 2017/04/24 (first published: 2017/04/04) | Source: Redgate | Category: competition
Rating: |  Discuss |   Briefcase | 1,003 reads

Changing SQL Server Collation After Installation

In some scenarios we can find different SQL Server collations between the server instance and its databases. Douglas P. Castilho explains a simple way to correct the collations in a few steps.  Read more...
By Additional Articles 2017/04/11 | Source: MSSQLTips.com | Category: collation
Rating: (not yet rated)  Rate this |   Briefcase | 2,742 reads

Step by Step Configuring a Dedicated Network for Availability Group

In this article, I will show a procedure to isolate the replication traffic from the public network.   Read more...
By Ganapathi varma Chekuri 2017/04/10 | Source: SQLServerCentral.com | Category: alwayson
Rating: |  Discuss |   Briefcase | 527 reads

How do you define employee satisfaction?

This article explores aspects of a job that help one feel satisfied at work.  Read more...
By Ben Kubicek 2017/04/10 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 58 reads

SQL Server Encryption: Always Encrypted

Is 'Always Encrypted' SQL Server 2016's most widely important new feature? It is significant that 'Always Encrypted' in SQL Server is in all editions of SQL Server. Because of the increasing importance of encryption to data governance, it allows encryption for the sensitive application data for everywhere beyond the application's client connection, including network, server, database and storage. Robert Sheldon explains what it is, why you should try it out, and how to set about it.  Read more...
By Additional Articles 2017/04/10 | Source: SimpleTalk | Category: always encrypted
Rating: (not yet rated)  Rate this |   Briefcase | 3,511 reads

Stop or Start, Big or Small. The Scalability of Azure SQL Data Warehouse

Learn how to scale an Azure SQL Datawarehouse up or down, and how to pause it when not in use.  Read more...
Rating: (not yet rated) |  Discuss |   Briefcase | 222 reads

SQL Clone Trivia Quiz - win a $10 gift card every weekday in April

To celebrate the recent launch of their new database provision tool, Redgate are giving you the chance to win a $10 Amazon or Starbucks gift card every weekday this month. To enter the prize draw, just answer the daily SQL Clone trivia question on the right-hand side of the homepage.  Read more...
By 2017/04/24 (first published: 2017/04/04) | Source: Redgate | Category: competition
Rating: |  Discuss |   Briefcase | 1,003 reads

By Design

Just because something works, is it prudent to implement a solution knowing there is a chance this design flaw will be stricken from future revs of SQL Server? It depends.  Read more...
By Rodney Landrum 2017/04/10 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 41 reads

Staging Deployments

This week Steve Jones is asking if you stage your database changes ahead of application changes.  Read more...
By Steve Jones 2017/04/07 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 203 reads

Refactoring SQL Server code

A look on how to approach improving the quality of our SQL Server code.  Read more...
By Ed Elliott 2017/04/07 (first published: 2015/11/11) | Source: SQLServerCentral.com | Category: refactoring
Rating: |  Discuss |   Briefcase | 7,541 reads

SQL Clone Trivia Quiz - win a $10 gift card every weekday in April

To celebrate the recent launch of their new database provision tool, Redgate are giving you the chance to win a $10 Amazon or Starbucks gift card every weekday this month. To enter the prize draw, just answer the daily SQL Clone trivia question on the right-hand side of the homepage.  Read more...
By 2017/04/24 (first published: 2017/04/04) | Source: Redgate | Category: competition
Rating: |  Discuss |   Briefcase | 1,003 reads

SQL Server 2016 Online ALTER COLUMN Operation

Learn about the time savings, blocking scenarios, limitations and more for the SQL Server 2016 online ALTER COLUMN operation.  Read more...
By Additional Articles 2017/04/07 | Source: MSSQLTips.com | Category: alter column
Rating: (not yet rated)  Rate this |   Briefcase | 2,846 reads

Dealing with Supervision

Working with someone that micro-managers you or watches your every action can be hard. Steve Jones has a few thoughts.  Read more...
By Steve Jones 2017/04/06 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 234 reads

SQL Server Cluster Automatic Memory Management

Don't waste memory in a cluster! Learn how to allocate memory between instances.  Read more...
By Jason Givens 2017/04/06 | Source: SQLServerCentral.com | Category: cluster
Rating: |  Discuss |   Briefcase | 633 reads

SQL Clone Trivia Quiz - win a $10 gift card every weekday in April

To celebrate the recent launch of their new database provision tool, Redgate are giving you the chance to win a $10 Amazon or Starbucks gift card every weekday this month. To enter the prize draw, just answer the daily SQL Clone trivia question on the right-hand side of the homepage.  Read more...
By 2017/04/24 (first published: 2017/04/04) | Source: Redgate | Category: competition
Rating: |  Discuss |   Briefcase | 1,003 reads

Clean Your Buffers for Accurate Performance Testing

In order to do accurate performance testing between multiple runs of a SQL Server command or scripts you need to remember to clean the buffer, procedure and system cache between each test run.  Read more...
By 2017/04/06 | Source: Database Journal | Category: performance testing
Rating:  Rate this |   Briefcase | 2,886 reads
<< Newer    Items 41 to 60 of 15652    Older >>