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

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

A day in the life of a developer with SQL Prompt

There is a lot more to SQL Prompt than IntelliSense and code completion. Tony Davis takes a developer's eye view of its features, as they slot into a typical day of database development work, covering Prompt's snippets, Actions, custom code styling, safe database refactoring, as well as safety net features such as tab coloring and tab history.  Read more...
By 2017/12/04 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 3,308 reads

Importing JSON Data from Web Services and Applications into SQL Server

To support many applications, it makes sense for the database to work with JSON data, because it is the built-in way for a JavaScript or TypeScript application to represent object data. It can mean less network traffic, looser coupling, and less need for the application developer to require full access to the base tables of the database. However, it means that the database must do plenty of checks first before importing. Phil Factor explains how it can be easily done.  Read more...
By Additional Articles 2017/12/04 | Source: SimpleTalk | Category: json
Rating: (not yet rated)  Rate this |   Briefcase | 3,534 reads

Bones of SQL - Practical Calendar Queries

After the first article created a Calendar table, learn how to use this in a practical sense with some common queries.  Read more...
By Bob Hovious 2017/12/01 (first published: 2016/10/13) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 3,189 reads

Not Useless Features

There are some useless features in SQL Server, but Steve Jones wants to know which ones aren't and need investment.  Read more...
By Steve Jones 2017/12/01 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 79 reads

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,795 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 | 4,007 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,312 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 | 62 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,579 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,191 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 | 360 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,824 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,404 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,606 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 | 554 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,244 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 | 830 reads
<< Newer    Items 41 to 60 of 16350    Older >>