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

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

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 | 42 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,382 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,597 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 | 544 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,414 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,236 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 | 823 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 | 3,934 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,712 reads

Bones of SQL - The Calendar Table

This article introduces the concept of the Calendar table to SQL newcomers and illustrates use of a few columns they might not have imagined.  Read more...
By Bob Hovious 2017/11/24 (first published: 2016/09/08) | Source: SQLServerCentral.com | Category: calendar
Rating: |  Discuss |   Briefcase | 7,213 reads

The Most Wanted Upgrade

This Black Friday Steve wonders what hardware you might desire.  Read more...
By Steve Jones 2017/11/24 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 59 reads

How advanced is database DevOps in financial services?

Whether you’re exploring the advantages of DevOps or already fully immersed in the journey, including the database brings additional advantages. But how are you performing compared to the competition? What could you do better? What’s the benchmark you should be aiming for?  Read more...
By 2017/11/24 | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 2,733 reads

Implied Predicate and Partition Elimination

Erik Darling's delighted to see that SQL Server does some creative partition elimination.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 2,712 reads

Happy Thanksgiving 2017

Happy Thanksgiving from the SQLServerCentral staff.  Read more...
By Steve Jones 2017/11/23 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 33 reads

Databases in Azure… Where to begin? Create a Database and log in!

Ready to create your first Database in Azure. Here are the step by step instructions with plenty of definitions and terms.  Read more...
By Michael Morin 2017/11/23 (first published: 2016/06/16) | Source: SQLServerCentral.com | Category: azure sql database
Rating: |  Discuss |   Briefcase | 2,534 reads

Extending DevOps practices to SQL Server databases with ReadyRoll and VSTS

In this demo heavy session you’ll see how Redgate’s SQL Toolbelt allows you to take a local development database, source control it, set up automated builds and automate deployments to an Azure SQL database in less than an hour using VSTS.  Read more...
By 2017/11/23 | Source: Redgate | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 5,178 reads

SQL Server R Services: Generating Sparklines and Other Types of Spark Graphs

By being able to run R from SQL Server, you have available to you not just a convenient way of performing analysis on data but also a wide range of more specialized graphical facilities. Rob Sheldon illustrates the point by demonstrating how you can create sparklines that can then be embedded in reports.  Read more...
By 2017/11/23 | Source: SimpleTalk | Category: sql server r services
Rating: (not yet rated)  Rate this |   Briefcase | 2,672 reads
<< Newer    Items 41 to 60 of 16338    Older >>