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

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

SQL Server Database Provisioning: Getting Started with SQL Clone

This article serves as a ‘first look’ at cloning databases with SQL Clone. It will review some of the database provisioning challenges that we seek to overcome, explain briefly how SQL Clone works, and then walk through a simple example of cloning a database.  Read more...
By 2017/12/01 | Source: Redgate | Category: provisioning
Rating: (not yet rated)  Rate this |   Briefcase | 2,776 reads

Even More SQL Server Features that Time Forgot

SQL Server works well, and Microsoft does everything it can to keep it relevant and competitive: As with everything in real life, it doesn't don't always get it completely right, and Rob Sheldon continues his quest through the jungle of past features to rediscover and explore the ones that time forgot. Here, he comes across Lightweight Pooling, XML Indexes, Stretch Databases, SQL Variants, Transaction Savepoints and In-Memory OLTP.  Read more...
By Additional Articles 2017/12/01 | Source: SimpleTalk | Category: sql server
Rating: (not yet rated)  Rate this |   Briefcase | 3,981 reads

The Difference Between Rollup and Cube

Learn about the fundamental differences between the ROLLUP and CUBE operators.  Read more...
By Ben Richardson 2017/11/30 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,295 reads

Certifying Schools

Schools don't necessarily teach people how to code, but they could do a better job.  Read more...
By Steve Jones 2017/11/30 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 61 reads

Free Database Unit-Testing Framework for SQL Server

Learn how to implement an advanced and cost-effective database unit-testing framework with tSQLt in SQL Server Management Studio.  Read more...
By Additional Articles 2017/11/30 | Source: MSSQLTips.com | Category: unit testing
Rating: (not yet rated)  Rate this |   Briefcase | 3,576 reads

Free virtual event: SQL in the City Streamed

Technical sessions will dive into the latest Microsoft SQL Server releases, and cover topical issues such as data compliance, protection & privacy.  Read more...
By 2017/12/08 (first published: 2017/11/30) | Source: Redgate | Category: events
Rating: (not yet rated)  Rate this |   Briefcase | 3,154 reads

Stairway to DAX and Power BI - Level 12: Function / Iterator Function Pairs: The DAX CountA() and CountAX() Functions

Business Intelligence Architect, Analysis Services Maestro, eight-year Microsoft Data Platform MVP and author Bill Pearson introduces the DAX CountA() and CountAX() functions, discussing the syntax, uses and operation of each. He then provides hands-on exposure to CountA() and CountAX(), in counting non-empty cells in a column, and in counting nonblank results when evaluating the result of an expression over a table, respectively.  Read more...
By Bill Pearson 2017/11/29 | Source: SQLServerCentral.com | Category: dax
Rating: (not yet rated) |  Discuss |   Briefcase | 359 reads

Free eBook: SQL Server Execution Plans, Second Edition

Every day, out in the various online forums devoted to SQL Server, and on Twitter, the same types of questions come up repeatedly: Why is this query running slowly? Why is SQL Server ignoring my index? Why does this query run quickly sometimes and slowly at others? My response is the same in each case: have you looked at the execution plan?  Read more...
By Press Release 2017/11/29 (first published: 2013/07/30) | Source: Redgate | Category: execution plans
Rating:  Rate this |   Briefcase | 98,820 reads

DMO Word Scramble

A Database Management Object word scramble for you to enjoy.  Read more...
By Kenneth Fisher 2017/11/29 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 43 reads

How to deploy changes to Azure SQL Database using SQL Compare and Azure Active Directory

This quick tip shows how to connect to Azure SQL Database instances from SQL Compare, using its built-in Active Directory authentication mode, giving you an easier and more secure way to, for example, deploy schema changes from version control to an Azure SQL Database.   Read more...
By 2017/11/29 | Source: Redgate | Category: azure sql database
Rating: (not yet rated)  Rate this |   Briefcase | 2,401 reads

Simple SQL: Handling Location Datatypes

How do you record locations in SQL? Most relational database systems support spatial and geographical data, generally using the round-earth system based on the SQL specification of the Open Geospatial Consortium (OGC). However, this is not the only approach, as Joe Celko explains.  Read more...
By Additional Articles 2017/11/29 | Source: SimpleTalk | Category: tsql
Rating: (not yet rated)  Rate this |   Briefcase | 2,605 reads

Database Cloning Tools in Lower Environments

With exciting products like SQL Clone making their debut, the DBA will need to think through the approach to implementing such powerful tools. Done properly, these tools will provide a massive benefit to both the DBA and developer.  Read more...
By John F. Tamburo 2017/11/28 | Source: SQLServerCentral.com | Category: cloning
Rating: |  Discuss |   Briefcase | 553 reads

We Need DevOps for Performance

CosmosDB has ways to tune performance based on throttle metrics. We probably need some DevOps style feedback and adjustment for relational systems.  Read more...
By Steve Jones 2017/11/28 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 42 reads

What to Do When You Get a “Cache is Out of Date” Error Message

Greg Larsen shows how to fix the “cache is out of date” error message when SQL Server Management Studio starts up.  Read more...
By Additional Articles 2017/11/28 | Source: Database Journal | Category: error messages
Rating: (not yet rated)  Rate this |   Briefcase | 2,419 reads

What's your opinion on database DevOps?

Gartner predicts that the transition to agile and DevOps will be as disruptive to IT as lean was to manufacturing during the 1980s. What about you? Are you implementing a DevOps way of working? Do the same approaches apply to the database? Take part in this Redgate survey and they'll send you a copy of the research – and enter you in a prize draw to win a $250 Amazon voucher.  Read more...
By 2017/11/28 | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 2,243 reads

Track Sensitive Data with SQL Server Extended Properties

A major priority in our industry today is protecting and tracking sensitive data. See how you can utilize SQL Server Extended Properties to do just that.  Read more...
By Ron Smith 2017/11/27 | Source: SQLServerCentral.com | Category: extended properties
Rating: |  Discuss |   Briefcase | 829 reads

Practice Until You Don't Get It Wrong

We will all make mistakes, but practice can help reduce the errors we cause.  Read more...
By Steve Jones 2017/11/27 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 78 reads

A well-earned break from the database

Databases, like sheep, get get into some surprising scrapes. However, as long as you've planned for all the common mishaps, your conscience should be clear to take a well-earned holiday.  Read more...
By Phil Factor 2017/11/27 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 49 reads

How to manage and monitor large SQL Server estates

Managing a couple of SQL Servers is a whole different ball game compared to managing 10’s or 100’s of servers. With so much available data to take in, this webinar will guide you through what’s important and what’s noise.  Read more...
By 2017/11/27 | Source: Redgate | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 4,047 reads

SQL Saturday statistics – Web Scraping with R and SQL Server

Tom wants to check a simple query: How many times has a particular topic been presented and from how many different presenters.  Read more...
By Additional Articles 2017/11/27 | Category: sql saturday
Rating: (not yet rated)  Rate this |   Briefcase | 2,719 reads
<< Newer    Items 41 to 60 of 16346    Older >>