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

   Items 1 to 20 of 17431    Older >>
 

I may need to re-think the use of table variables

Table variables have been fixed in SQL 2019, so now I have to decide if I will use them again.  Read more...
By Ben Kubicek 2018/12/11 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 60 reads

Database Snapshot Use Case: Service Migration

In this article, we show how we used Database Snapshots as a rollbackup plan for a database migration from one data centre to another. Database Snapshots proved to be the best route since we sould not afford the time a backup/restore approach would take.  Read more...
By Kenneth Igiri 2018/12/11 | Source: SQLServerCentral.com | Category: database
Rating: (not yet rated) |  Discuss |   Briefcase | 329 reads

Adopting Compliant Database DevOps at PASS

To help meet the requirements of the GDPR, PASS teamed up with Redgate to implement Compliant Database DevOps. This benchmark process has streamlined PASS’ database development pipeline, and strengthened their ability to uphold data privacy regulations such as the GDPR.   Read more...
By 2018/12/11 (first published: 2018/11/14) | Source: Redgate
Rating: (not yet rated)  Rate this |   Briefcase | 5,494 reads

SQL Server 2019 Community Technical Preview (CTP) 2.1 is Available Now

Microsoft announced the release or CTP 2.1 for SQL Server 2019. This is the second CTP released for SQL Server 2019, and it has lots of new exciting features, like " UDF inlining". Read on to find out more!  Read more...
By Additional Articles 2018/12/11 | Source: Database Journal | Category: sql server 2019
Rating: (not yet rated)  Rate this |   Briefcase | 1,228 reads

Microservices for Databases

The idea of using microservices is gaining traction, but Steve Jones notes that the issues of databases might prevent adoption for many applications.  Read more...
By Steve Jones 2018/12/10 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 181 reads

An Overview of STRING_SPLIT()

Learn how to use the STRING_SPLIT() function in T-SQL.  Read more...
By Steve Jones 2018/12/10 | Source: SQLServerCentral.com | Category: string_split()
Rating: |  Discuss |   Briefcase | 1,237 reads

The Worst Data Breech

A new law in Australia might be a source for the worst data breeches we could have.  Read more...
By Steve Jones 2018/12/10 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 48 reads

Building Better Test Data with SQL Provision

In this article, Microsoft MVP Steve Jones shows how SQL Provision can help create test data that complies with regulations that prohibit the sharing of sensitive or personal data, but still looks and behaves like the real deal.   Read more...
By 2018/12/10 | Source: Redgate | Category: test data
Rating: (not yet rated)  Rate this |   Briefcase | 1,231 reads

SQL Server Logical Reads – What do they really tell us?

In this article, we will examine this counter’s true meaning and provide examples that prove it can sometimes be quite misleading  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 1,695 reads

Treating SQL Server as an Object with PowerShell

It’s easy to use invoke-sqlcmd to send T-SQL statements to SQL Server from PowerShell. There is, however, a rich PowerShell library, sqlps, that can be used instead. In this article, Greg Moore shows how to use sqlps to treat a SQL Server instance as an object.  Read more...
By Additional Articles 2018/12/10 | Source: SimpleTalk | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 461 reads

When a Service Pack or Cumulative Update Install Fails by Evaporating

Learn a few possible solutions to a frustrating issue when you attempt to patch a SQL Server installation.  Read more...
By Mike Hinds 2018/12/07 (first published: 2016/01/11) | Source: SQLServerCentral.com | Category: service packs
Rating: |  Discuss |   Briefcase | 3,172 reads

Automation at Work

The future of work might be a problem if things go as Steve expects.  Read more...
By Steve Jones 2018/12/07 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 58 reads

Best practices for SQL Provision

In order to get the best out of SQL Provision, it’s a good idea to think about how it would best fit into your workflows and network architecture. We’ve put together a set of guidelines which can help you to optimize efficiency, performance, security, and reliability, and recommend that you consider these when planning a proof-of concept or rollout of SQL Provision in your organization. Read the How To Guide.   Read more...
By 2018/12/07 | Source: Redgate | Category: sql provision
Rating: (not yet rated)  Rate this |   Briefcase | 2,408 reads

How Much Memory is “Normal” for SQL Servers?

When I look at a SQL Server, one of the first things I check is, “How much memory does this thing have relative to the amount of data we’re hosting on here?” I’ve long used some seat-of-the-pants numbers, but armed with data from SQL ConstantCare® users who opted into public data sharing, let’s do a little deeper analysis.  Read more...
By Additional Articles 2018/12/07 | Source: Brent Ozar Unlimited Blog | Category: memory
Rating: (not yet rated)  Rate this |   Briefcase | 3,587 reads

Configuring SQL Server Always on Azure Servers(Iaas)

Configuration of SQL Server Always on in Azure Virtual machines differs in multiple ways comparing with the on-premise Implementations. This article will help you to have a handy note to configure always on in Azure servers from a DBA perspective.  Read more...
By Vishnu Gupthan 2018/12/06 | Source: SQLServerCentral.com | Category: always on
Rating: |  Discuss |   Briefcase | 237 reads

Write more compact SQL Server code using new features

Learn about new functions in SQL Server 2016 and 2017 to have more readable and compact code including STRING_AGG, TRIM, TRANSLATE and DROP... IF EXISTS.  Read more...
By Additional Articles 2018/12/06 | Source: MSSQLTips.com | Category: string_ag
Rating: (not yet rated)  Rate this |   Briefcase | 3,097 reads

MoSQL

Google is promoting more RDBMS based systems.  Read more...
By Steve Jones 2018/12/06 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 69 reads

How to reset your development database in seconds using SQL Clone

Let’s say you’re making experimental changes to your development database and, to explore a hypothesis, you’ve just dropped a table. How long does it take you to restore the database to its previous state, so you’re ready to continue testing? If it’s long enough to go fetch a coffee, then it’s too long.  Read more...
By 2018/12/06 | Source: Redgate | Category: sql clone
Rating: (not yet rated)  Rate this |   Briefcase | 2,025 reads

Adding Disks - Level 3 of the Stairway to SQL Server on Linux

In this level we examine how to add disks to separate our data, log, and tempdb files.  Read more...
By Danilo Dominici 2018/12/05 | Source: SQLServerCentral.com | Category: sql server on linux
Rating: |  Discuss |   Briefcase | 224 reads

Lax Security is Harmful for Employment

Data breaches do more than harm an organization. There's a human cost.  Read more...
By Steve Jones 2018/12/05 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 53 reads
   Items 1 to 20 of 17431    Older >>