SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
<< Previous headlines | Later headlines >>
SQLServerCentral.com Headlines from 2018/07/31 to 2018/08/07

Join Redgate’s SQL data catalog early access program

Redgate wants your help to develop a product for SQL Server data classification that meets today’s compliance and DevOps needs. If you’re interested in taking part in research and providing feedback on new releases, please register for the early access program.   Read more...
By 2018/08/07 | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 3,073 reads

Steps to Migrate Oracle Database to Azure SQL Database

In the world of paradigm shifts, many organizations are looking at the prospect of a technology migration, where capabilities are moved to a new set of technologies, supporting and enabling the business for the future. On other hand, a technology or platform may reach the end of its life for other business reasons, like ease of use, increased cost, etc.  Read more...
By Additional Articles 2018/08/07 | Source: Database Journal | Category: oracle
Rating: (not yet rated)  Rate this |   Briefcase | 2,957 reads

Representing XML data in SQL Server

In this article, we will see how to use the FOR XML statement in SQL Server to represent the result of queries in XML format.  Read more...
By Diogo Castro 2018/08/07 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 1,132 reads

The ‘Right to be Forgotten’ and Data Masker for SQL Server

The right to be forgotten is one of the main features of new data protection legislation across the globe. Under Article 17 of one such piece of legislation in Europe, the GDPR, individuals have the right to have personal data erased from all systems and data the company may be storing about them.  Read more...
By 2018/08/06 | Source: Redgate | Category: gdpr
Rating: (not yet rated)  Rate this |   Briefcase | 2,891 reads

How to Successfully Deliver IT Projects in a Not-so-Agile Organization

Agile methodology for software delivery is accepted at many organizations but is not used everywhere. In this article, Mohammad Rizvi gives advice on how to successfully implement a software project in a non-Agile environment.  Read more...
By Additional Articles 2018/08/06 | Source: SimpleTalk | Category: agile database techniques
Rating: (not yet rated)  Rate this |   Briefcase | 3,754 reads

SQL Server Data Table as CRM Data Source on VBA Form

Using SQL SERVER Database as Data Source FOR MS Access VBA Switchboard and Data Entry Form. I am presenting, once again, a method of connecting and upgrading a SQL data source into a VBA presentation process.   Read more...
By Thomas Stricker 2018/08/06 | Source: SQLServerCentral.com | Category: sql server 2014
Rating: |  Discuss |   Briefcase | 475 reads

Interpreting Missing Index Recommendations

Pinal Dave explains how missing index hints are like restaurant appetizers.  Read more...
By Additional Articles 2018/08/03 | Source: Brent Ozar Unlimited Blog | Category: missing index
Rating: (not yet rated)  Rate this |   Briefcase | 5,197 reads

SQL Authentication Via AD Groups Part II: Who has what access?

In a previous article, we discussed how to liberate the DBA from SQL Logins with AD Groups. A good point was raised: How can the DBA know who has what access? Here is a solution.  Read more...
By John F. Tamburo 2018/08/03 (first published: 2016/02/18) | Source: SQLServerCentral.com | Category: active directory
Rating: |  Discuss |   Briefcase | 4,730 reads

Understanding your Azure EA Billing Data and Building a Centralized Data Storage Solution

Many organizations are moving to Azure and other cloud providers. Understanding how resources are being used and what is spent is very important. In this article, Feodor explains his solution for automating the collection of the Enterprise Agreement billing from Azure into an Azure SQL Database where it can be analyzed.  Read more...
By Additional Articles 2018/08/02 | Source: SimpleTalk | Category: azure
Rating: (not yet rated)  Rate this |   Briefcase | 3,155 reads

Why code quality is vital in the world of database DevOps

With more than 75% of organizations now having developers in their teams who work across both applications and databases, you need to ensure code quality is continually enforced. Matt Hilbert explains why.  Read more...
By 2018/08/02 | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 4,093 reads

Using a Derived Table to Compare Data with Values from a Previous Year

Comparing year on year sales is a fundamental requirement in much commercial analysis - here you learn how to do this in SQL  Read more...
By Adam Aspin 2018/08/02 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,433 reads

Stairway to Biml Level 7 – Populating the Database for a Custom Biml Framework

In this next level of the Stairway to Biml, we look at a custom framework in Biml.  Read more...
By Andy Leonard 2018/08/01 | Source: SQLServerCentral.com | Category: biml
Rating: (not yet rated) |  Discuss |   Briefcase | 247 reads

Rolling up multiple rows into a single row and column for SQL Server data

Do you need a way to roll-up multiple rows into one row and one column. You know you can roll-up multiple rows into one row using Pivot, but you need all of the data concatenated into a single column in a single row. this tip looks at a simple approach to accomplish this.  Read more...
By Additional Articles 2018/08/01 | Source: MSSQLTips.com | Category: rollup
Rating: (not yet rated)  Rate this |   Briefcase | 4,798 reads

Free eBook: Performance Tuning with SQL Server Dynamic Management Views

Dynamic Management Views (DMVs) are a significant and valuable addition to the DBA's troubleshooting armory, laying bare previously unavailable information regarding the under-the-covers activity of your database sessions and transactions.  Read more...
By Additional Articles 2018/12/19 (first published: 2013/08/21) | Source: Redgate | Category: performance tuning
Rating:  Rate this |   Briefcase | 104,971 reads

Scaling SQL Monitor to Large SQL Server Estates

Most organizations are finding that the size and number of databases that need to be monitored is increasing, unlike the number of people available to do the work. In this article Tony Davis explains how SQL Monitor can help with the demands of bigger databases and higher numbers of monitored servers.  Read more...
By 2018/07/31 | Source: Redgate | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 3,455 reads

Finding a String Anywhere in Another String

Optimize searching for a string within another string with this string storage and indexing technique.  Read more...
By Janeta Parakosova 2018/07/31 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 1,609 reads

Introduction to Azure Cosmos DB Global Distribution

Global distribution of updatable data stores is one of the more challenging goals that software designers and architects have been struggling with over the years. Addressing this challenge has become increasingly pressing as the rapid growth of cloud technologies increased the need for deployments capable of spanning multiple geographical areas. In this article, we will provide an introduction to global distribution-related functionality in Cosmos DB.  Read more...
By Additional Articles 2018/07/31 | Source: Database Journal | Category: azure cosmos db
Rating: (not yet rated)  Rate this |   Briefcase | 3,317 reads