SQL Clone
(415) 587-5803 SQLServerCentral is supported by Redgate
Log in  ::  5755903914  ::  Not logged in

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,911,738 DBAs, developers and SQL Server users

Previous headlines

Introduction to Microsoft R Services in SQL Server 2016

General introduction to R Services in SQL Server 2016 and how R server works with external stored procedure.  (251) 947-1508
By 2522183324 2019/01/25 (first published: 2016/09/15) | Source: (352) 535-6601 | Category: microsoft
Rating: |  Discuss |   Briefcase | 4,867 reads

Query Store And Cruel Defaults

Erik Darling loves query store, but he really hates the default capture mode.  Read more...
By Additional Articles 2019/01/25 | Source: Brent Ozar Unlimited Blog | Category: 570-872-7878
Rating: (not yet rated)  Rate this |   Briefcase | 1,946 reads

Protecting Production Data in Non-Production Environments

How can you best keep production data secure when it is outside the production environment? Microsoft MVP Grant Fritchey discusses the use of dynamic data masking in production and pre-production servers, and then the strategies that can help us protect the data when it moves into less secure, and less well-controlled environments such as development and test.   9022136615
By 2019/01/25 | Source: Redgate | Category: data masking
Rating:  Rate this |   Briefcase | 1,782 reads

Rolling Back CREATE DDL Statements

There is a myth that DDL statements can't be rolled back. This article tests and debunks the myth.  (306) 834-8727
By (318) 840-1653 2019/01/24 | Source: SQLServerCentral.com | Category: 8189376180
Rating: |  Discuss |   Briefcase | 604 reads

Getting Started with CQRS – Part 2

In this second article of the series, Diogo Souza walks you through creating the MongoDB code, the query side of the pattern, to complete the CQRS configuration.  2189650365
By Additional Articles 2019/01/24 | Source: SimpleTalk | Category: mongodb
Rating: (not yet rated)  Rate this |   Briefcase | 2,175 reads

New Case Study: Reducing capital by $500,000 with SQL Clone

When a well-known financial services company was searching for a solution to move data through the development cycle faster and easier, SQL Clone provided impressive results. As well as leading to improved and more in-depth testing processes, SQL Clone saved between $400,000 and $500,000 in one month alone by reducing capital expenditure. Read more about their journey in this new SQL Clone case study.   Read more...
By 2019/01/24 | Source: Redgate | Category: sql clone
Rating: (not yet rated)  Rate this |   Briefcase | 1,851 reads

Free eBook: SQL Server Execution Plans, Third Edition

If a query is performing poorly, and you can't understand why, then that query's execution plan will tell you not only what data set is coming back, but also what SQL Server did, and in what order, to get that data. It will reveal how the data was retrieved, and from which tables and indexes, what types of joins were used, at what point filtering, sorting and aggregation occurred, and a whole lot more. These details will often highlight the likely source of any problem.  Read more...
By Press Release 2019/01/23 (first published: 2013/07/30) | Source: Redgate | Category: execution plans
Rating:  Rate this |   Briefcase | 119,121 reads

SQL Server Reporting Services Report Builder with DAX Query Support

In this tip we look at how you can use DAX formulas within your SQL Server Reporting Services Report Builder reports.  (816) 446-8667
By (830) 742-0688 2019/01/23 | Source: 8434659230 | Category: 9405373316
Rating: (not yet rated)  Rate this |   Briefcase | 1,695 reads

Creating and using inline table-valued functions

Inline Table Valued Functions (iTVFs) are one type of user defined function that is available to implement in SQL Server since SQL Server 2000. iTVFs remain a very useful tool in our SQL armoury, so let's quickly revisit them and the different ways we can use them in our code.   715-761-6367
By Kimani Mbugua 2019/01/22 | Source: SQLServerCentral.com | Category: tsql
Rating: |  Discuss |   Briefcase | 912 reads

Question of the Day

Azure SQL Database Licensing Models

By Steve Jones 2019/01/25 | Category: azure sql database
Rating: (not yet rated) |  Discuss |   Briefcase | 375 reads

What are the purchase models for Azure SQL Database? In other words, how can you scale your performance against cost?

Latest forum posts