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

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

The conflict between data protection and DevOps

Data breaches are the new normal – according to the Identity Theft Resource Center there were nearly 1,600 of them in 2017 in the US alone, exposing 179 million records. No wonder companies want to keep data confidential and protected. At the same time, however, the increasing pace of business means developers need to create and release code in much shorter DevOps timescales. Steve Jones discussed ways to solve this conflict  Read more...
By 2018/08/13 | Source: Redgate | Category: data protection
Rating: (not yet rated)  Rate this |   Briefcase | 1,665 reads

The Worst Day

Today Steve Jones reminisces about his career and asks you to do the same.  Read more...
By Steve Jones 2018/08/10 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 80 reads

Learning about FOR JSON

Links and information about the FOR JSON clause in SQL Server 2016.  Read more...
By Site Owners 2018/08/10 (first published: 2015/10/05) | Source: SQLServerCentral.com | Category: for json
Rating: |  Discuss |   Briefcase | 4,455 reads

Rounding Tips and Tricks

This article shows different options to use the rounding functions in SQL Server.  Read more...
By Luis Cazares 2018/08/10 (first published: 2016/09/20) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 3,018 reads

Common Entity Framework Problems: N + 1

Richie explains why your app is running so many queries.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 2,619 reads

Using a CTE as a Tally Table

Sometimes you need to output blank lines - in effect displaying Records for Missing Data. This article explains how to use a CTE to do this  Read more...
By Adam Aspin 2018/08/09 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,640 reads

Unwired for Weeks

Steve looks back at a few weeks of vacation.  Read more...
By Steve Jones 2018/08/09 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 47 reads

The Top Five Things That DBAs Need to Monitor

Being a database administrator is much more than knowing how to install SQL Server and set up a database. One of the most important responsibilities is being proactive by monitoring the instances in their care. But, what should be monitored? Here are the top five things to monitor when you are a SQL Server DBA  Read more...
By Additional Articles 2018/08/09 | Source: SimpleTalk | Category: dba
Rating: (not yet rated)  Rate this |   Briefcase | 5,127 reads

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 | 2,230 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 | 71 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,923 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,243 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,890 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 | 58 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 | 935 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,591 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,634 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 | 59 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 | 434 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,581 reads
<< Newer    Items 21 to 40 of 17080    Older >>