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

<< Newer    Items 21 to 40 of 16010    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 2017/08/16 (first published: 2013/08/21) | Source: Redgate | Category: performance tuning
Rating:  Rate this |   Briefcase | 82,424 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 | 2,460 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,895 reads

Hiring Heterogeneously

Hiring a diverse group of people can make your team work better. Steve Jones has a few thoughts today.  Read more...
By Steve Jones 2017/08/15 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 176 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 | 924 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 | 3,613 reads

Hiring Guitarists

Hiring senior people is hard, but Steve Jones stumbled upon an idea that compares hiring technology people to hiring a senior level technology expert.  Read more...
By Steve Jones 2017/08/14 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 316 reads

The art of getting it right

Phil Factor advocates paying attention when it doesn't matter to prepare for when it does.  Read more...
By Phil Factor 2017/08/14 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 37 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 | 2,139 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 | 4,546 reads

Using multiple custom SQL formatting styles in SQL Prompt

Usually, when coding SQL, you will want to go along with the coding style of the team you are working with. This article shows how to use SQL Prompt formatting styles to create and maintain multiple code styles, each for a dedicated purpose, and to switch between them and apply a new style to existing code, with ease.  Read more...
By 2017/08/14 | Source: Redgate | Category: t-sql
Rating: (not yet rated)  Rate this |   Briefcase | 3,260 reads

What's in your CLR?

For today's Friday poll we have a guest editorial from Jeff Moden. The head of the anti-RBAR alliance has spent a lot of time trying to help others write better T-SQL and solve their problems with code that performs well. However this Friday Jeff asks about the CLR and how you are using it, or not using it, in the real world.  Read more...
By Jeff Moden 2017/08/11 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 590 reads

The ABCs of Database Creation

Creating SQL Server databases is easier than the internet may lead us to believe.  Read more...
By Brandie Tarvin 2017/08/11 (first published: 2015/10/29) | Source: SQLServerCentral.com | Category: database design
Rating: |  Discuss |   Briefcase | 7,553 reads

Introduction to Azure SQL Data Sync

The majority of Azure SQL Database related features reach their General Availability (GA) stage relatively quickly. There are however, some exceptions. The most prominent example in this category is likely Azure SQL Data Sync, which has remained in Preview since its introduction 7 years ago. Fortunately, there are signs that this service might be finally reaching production-ready state. In thius article, Martin Policht will introduce its main characteristics.  Read more...
By Additional Articles 2017/08/11 | Source: Database Journal | Category: azure
Rating: (not yet rated)  Rate this |   Briefcase | 3,376 reads

Accelerating Your Career

There are any number of ways to help your career move forward. Steve Jones talks about one way you might not have thought about today.  Read more...
By Steve Jones 2017/08/10 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 434 reads

Filegroup Restoring and Join Elimination

This article is just a short follow up of previous article on filegroup restoring that describes one issue with join elimination optimization.  Read more...
By Bogdan SAHLEAN 2017/08/10 | Source: SQLServerCentral.com | Category: filegroup
Rating: |  Discuss |   Briefcase | 657 reads

SQL Server R Services: The Basics

It is possible to do a great deal with R within SQL Server, but it is best to start by doing analysis in R on numeric data from SQL Server and returning the results to SQL Server. There is great value to be gained even with this basic foundation. Robert Sheldon is on hand to give you a kick start with the first in his series on beginning with R in SQL Server.  Read more...
By Additional Articles 2017/08/10 | Source: SimpleTalk | Category: r services
Rating:  Rate this |   Briefcase | 5,110 reads

My Problem, or Yours?

Things always go wrong, but how do you handle the situation?  Read more...
By Andy Warren 2017/08/09 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 76 reads

Stairway to AlwaysOn Level 2: Storage 101

In this new level of the stairway, we examine the storage knowledge you need for an AlwaysOn configuration.  Read more...
By Perry Whittle 2017/08/09 (first published: 2014/10/01) | Source: SQLServerCentral.com | Category: always on
Rating: |  Discuss |   Briefcase | 7,102 reads

Free eBook: Understanding SQL Server Concurrency

When you can’t get to your data because another application has it locked, a thorough knowledge of SQL Server concurrency will give you the confidence to decide what to do.  Read more...
By Press Release 2017/08/09 (first published: 2013/07/17) | Source: Redgate | Category: concurrency
Rating:  Rate this |   Briefcase | 87,233 reads
<< Newer    Items 21 to 40 of 16010    Older >>