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

<< Newer    Items 61 to 80 of 16904    Older >>
 

Automating a SQL Server Database Refresh

In this tip we cover the basics of what needs to be done to setup a process to automate refreshing a dev or test environment with a recent database backup.  Read more...
By Additional Articles 2018/05/31 | Source: MSSQLTips.com | Category: refresh
Rating: (not yet rated)  Rate this |   Briefcase | 4,206 reads

Using SQL Data Compare to Synchronize Custom Error Messages

In this recent Redgate article Steve Jones provides a useful trick to Synchronize Custom Error Messages using SQL Data Compare  Read more...
By 2018/05/31 | Source: Redgate | Category: sql data compare
Rating: (not yet rated)  Rate this |   Briefcase | 2,235 reads

How Far Back?

Today Steve Jones discusses the need to restore older backups.  Read more...
By Steve Jones 2018/05/30 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 50 reads

Using SQL Server Dynamic Online Catalog to Solve Problems: Stairway to Exploring Database Metadata Level 2

In this second level of the Stairway, Phil looks at where we go to find information about objects, using triggers as the example.  Read more...
By Phil Factor 2018/05/30 (first published: 2016/09/07) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 1,881 reads

Stairway to Server Management Objects (SMO) Level 1: Concepts and Basics

Learn how to get started working with SMO and PowerShell.  Read more...
By Laerte Junior 2018/05/30 (first published: 2016/05/11) | Source: SQLServerCentral.com | Category: smo
Rating: |  Discuss |   Briefcase | 3,436 reads

Free eBook: Defensive Database Programming

Resilient T-SQL code is code that is designed to last, and to be safely reused by others. The goal of defensive database programming, the goal of this book, is to help you to produce resilient T-SQL code that robustly and gracefully handles cases of unintended use, and is resilient to common changes to the database environment.  Read more...
By Press Release 2018/05/30 (first published: 2013/08/28) | Source: Redgate | Category: defensive programming
Rating: (not yet rated)  Rate this |   Briefcase | 95,984 reads

PowerShell Day-to-Day Admin Tasks – Part 6: Real-Time IT Dashboard

Creating a real-time IT dashboard is essential for IT professionals for managing their environments and to be proactive. A Few months ago, a great tool called ‘PowerShell Universal Dashboard’ or ‘PoshUD’ was officially released. In this article, Nicolas Prigent describes PoshUD, and how to use it to monitor your infrastructure using PowerShell.  Read more...
By Additional Articles 2018/05/30 | Source: SimpleTalk | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 3,822 reads

TRY_CONVERT

An introduction to the TRY_CONVERT function, introduced in SQL Server 2012.  Read more...
By Matthew McGiffen 2018/05/29 | Source: SQLServerCentral.com | Category: try_convert()
Rating: |  Discuss |   Briefcase | 1,810 reads

Tables Without Clustered Indexes

When databases are being designed and developed, your developers might have overlooked creating clustered indexes on some of your database tables. Having a useful clustered index on your tables will improve the performance of your queries. Here Greg Larsen shows a simple script to identify those tables in your database that don’t have a clustered index.   Read more...
By Additional Articles 2018/05/29 | Source: Database Journal | Category: clustered index
Rating:  Rate this |   Briefcase | 4,563 reads

No More Downtime

Windows is improving its ability to be patched without downtime.  Read more...
By Steve Jones 2018/05/29 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 45 reads

Configuring R Services in SQL Server 2016

R Services provides in-database analytics in SQL Server 2016. In this article we step through configuring R Services and get you started with in-database analytics.  Read more...
By Nick Burns 2018/05/28 (first published: 2016/01/27) | Source: SQLServerCentral.com | Category: revolutionr
Rating: |  Discuss |   Briefcase | 4,156 reads

Happy Memorial Day 2018

Happy Memorial Day  Read more...
By Steve Jones 2018/05/28 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 24 reads

Are you GDPR Ready?

With the GDPR in effect, Steve Jones talks about the changes that are taking place for many organizations.  Read more...
By Steve Jones 2018/05/28 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 38 reads

Create Azure VMs with PowerShell Part 2

In this article, Robert Cain describes the steps to set up a VM using PowerShell using his PSAzure module.  Read more...
By Additional Articles 2018/05/28 | Source: SimpleTalk | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 2,421 reads

Finding code smells using SQL Prompt: TOP without ORDER BY in a SELECT statement

SQL Server’s TOP clause in a SELECT statement is very useful and intuitive, but it allows you to leave out the associated ORDER BY clause that clarifies what you had in mind: TOP by what aspect? Phil Factor explains how to find code smells using SQL Prompt: TOP without ORDER BY in a SELECT statement   Read more...
By 2018/05/28 | Source: Redgate | Category: sql prompt
Rating: (not yet rated)  Rate this |   Briefcase | 3,068 reads

The Oddest Thing

Steve wonders what strange items live in your workspace.  Read more...
By Steve Jones 2018/05/25 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 85 reads

SQL Server System Audit Report

Ensuring that your SQL Server is secure is the job of every Database Administrator. In this article I will provide a script to help perform easier audits of your system.  Read more...
By Rudy Panigas 2018/05/25 (first published: 2016/02/02) | Source: SQLServerCentral.com | Category: audit
Rating: |  Discuss |   Briefcase | 4,659 reads

Where Clustered Index Keys Dare

We’ve blogged a couple times about how clustered index key columns get stored in your nonclustered indexes. But where they get stored is a matter of weird SQL trivia. You see, it depends on how you define your nonclustered index.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 3,418 reads

Choosing Between Table Variables and Temporary Tables

People can, and do, argue a great deal about the relative merits of table variables and temporary tables. Sometimes, as when writing functions, you have no choice; but when you do you’ll find that both have their uses, and it’s easy to find examples where either one is quicker. In this article, Phil Factor explains the main factors involved in choosing one or the other, and demonstrates a few simple ‘rules’ to get the best performance.  Read more...
By 2018/05/25 | Source: Redgate | Category: tsql
Rating: (not yet rated)  Rate this |   Briefcase | 4,991 reads

Using FORMAT() for Dates

Learn how the FORMAT() function works for dates.  Read more...
By Steve Jones 2018/05/24 | Source: SQLServerCentral.com | Category: format()
Rating: |  Discuss |   Briefcase | 1,664 reads
<< Newer    Items 61 to 80 of 16904    Older >>