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

<< Newer    Items 21 to 40 of 17072    Older >>
 

The march of DevOps from the backroom to the boardroom

By encouraging collaboration and teamwork, removing the barriers between development and operations, and introducing automation, DevOps speeds up software delivery and enables features to move from the fingers of developers into the hands of customers faster  Read more...
By 2018/08/09 | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 1,963 reads

Dynamic SQL Crossword

This crossword is based on terms you might come across in an article about Dynamic SQL.  Read more...
By Kenneth Fisher 2018/08/08 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 69 reads

Stairway to Columnstore Indexes Level 10: Optimizing Queries For Batch Mode (Part 1)

In this level, Hugo Kornelis looks at how to rewrite your queries to best take advantage of batch mode.  Read more...
By Hugo Kornelis 2018/08/08 (first published: 2016/11/23) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 1,909 reads

Free eBook: Defensive Database Programming

Resilient T-SQL code is code that is designed to last, and to be safely reused by others. The goal of defensive database programming, the goal of this book, is to help you to produce resilient T-SQL code that robustly and gracefully handles cases of unintended use, and is resilient to common changes to the database environment.  Read more...
By Press Release 2018/08/08 (first published: 2013/08/28) | Source: Redgate | Category: defensive programming
Rating: (not yet rated)  Rate this |   Briefcase | 98,028 reads

SQL Server Index Tutorial Overview

Although there are many different things that can be done to improve the performance of a database system, creating an index is the main tool in every DBA's toolbox that is used when we are trying to improve the performance of a query.   Read more...
By Additional Articles 2018/08/08 | Source: MSSQLTips.com | Category: indexing
Rating: (not yet rated)  Rate this |   Briefcase | 3,633 reads

The Ideal IDE

We have lost of IDEs that we can use with SQL Server. Steve Jones lists his favorite.  Read more...
By Steve Jones 2018/08/07 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 56 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 | 912 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,330 reads

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 | 2,372 reads

Will Terminators Be Required?

The use of terminators in T-SQL is incredibly inconsistent. Steve Jones thinks it will always be this way.  Read more...
By Steve Jones 2018/08/06 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 57 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 | 429 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,329 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,413 reads

Is SQL Server Mature?

This Friday Steve Jones is wondering if the SQL Server platform does the job well enough for most people, or are there holes that need to be filled with new features.   Read more...
By Steve Jones 2018/08/03 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 232 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,600 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 | 4,952 reads

Handling Inconvenient Requests

Brad gives a little guidance on how you might want to respond to inconvenient requests with an eye on doing yourself a favor.  Read more...
By Brad McGehee 2018/08/02 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 307 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,186 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 | 3,934 reads
<< Newer    Items 21 to 40 of 17072    Older >>