SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
<< Previous headlines | Later headlines >>
SQLServerCentral.com Headlines from 2017/11/27 to 2017/12/04

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 | 4,360 reads

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,760 reads

Is This Database Being Used?

Can we delete this database, or is someone still using it?  Read more...
By Ginger Keys Daniel 2017/12/04 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 1,971 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,975 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 | 3,087 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,399 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,613 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,974 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 | 4,171 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 | 419 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,824 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,680 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 2018/09/06 (first published: 2013/07/30) | Source: Redgate | Category: execution plans
Rating:  Rate this |   Briefcase | 108,658 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,453 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,520 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 | 648 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 | 3,595 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 | 7,323 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 | 947 reads