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

<< Newer    Items 21 to 40 of 16003    Older >>

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 | 33 reads

SQL Server Management Studio Tips

Complete guide about hidden gems of SSMS 
By Konstantin Taranov 2017/08/14 | Source: SQLServerCentral.com | Category: ssms
Rating: |  Discuss |   Briefcase | 2,044 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,334 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 | 2,982 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 | 586 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,526 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,189 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 | 431 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 | 646 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 | 4,860 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,094 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,138 reads

Microsoft IT: A Case Study on “Hekaton” against RPM – SQL Server 2014 CTP1

This paper shares the approach used to understand and determine: 1) Using ‘Hekaton’ in SQL Server 2014 against RPM, including performance analysis. 2) Understand the specifics involved while migrating to Hekaton.   Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 3,237 reads

Sliding Scale Parallelism: Why Stop At DOP?

Erik Darling wonders why SQL Server doesn't have more granular parallelism options.  Read more...
By Additional Articles 2017/08/09 | Source: Brent Ozar Unlimited Blog | Category: parallelism
Rating: (not yet rated)  Rate this |   Briefcase | 3,188 reads

What's Your Approach?

What's your approach to work commitments ?  
By Nitin Bhojwani 2017/08/08 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 80 reads

Fixing Plan Issues in the Middle of the Night

Do you hate when someone wakes you up in the middle of the night and tells you that some query is slower and you need to investigate it? With SQL Server 2017 you might easily do this, or even let SQL Server do this job for you.  Read more...
By Jovan Popovic 2017/08/08 | Source: SQLServerCentral.com | Category: query store
Rating: |  Discuss |   Briefcase | 888 reads

How to Automatically Create and Refresh Development and Test Databases

In order to be able to deliver database changes more quickly, there are several tasks that must be automated. It can be a daunting job to ensure that the whole team has the latest database build when there is a proliferation of copies, and the database is big. Phil illustrates a solution by taking a set of Redgate tools to show how they can be used together, via PowerShell, to build a database from object-level source, stock it with data, document it, and then provision any number of test and development servers with the database build, taking care to save any DDL changes to the existing copies of the database.  Read more...
By Additional Articles 2017/08/08 | Source: SimpleTalk | Category: database delivery
Rating:  Rate this |   Briefcase | 3,934 reads

Removing sensitive data from a database

It’s fairly widely known that just because you delete data from a database, it doesn’t mean it’s gone from the data file itself, but the question is, how should you go about removing it?  Read more...
By 2017/08/08 | Source: Redgate | Category: deleting data
Rating: (not yet rated)  Rate this |   Briefcase | 5,139 reads

To-do list: good, bad or indifferent?

Using a list to keep track of what you should work on is only as good as the plan or goal behind it.  Read more...
By Ben Kubicek 2017/08/07 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 68 reads
<< Newer    Items 21 to 40 of 16003    Older >>