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

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

PowerShell Module to Read Directory Contents and Store in a SQL Server Table

In this tip we will walk through how to create a PowerShell module to get a list of files and subfolders of a Windows folder and store this information in a SQL Server table.  Read more...
By Additional Articles 2018/12/12 | Source: MSSQLTips.com | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 2,036 reads

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 | 85 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 | 469 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 | 6,639 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,936 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 | 188 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,392 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 | 57 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,668 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 | 2,216 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 | 880 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,191 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 | 61 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,904 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 | 4,072 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 | 248 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 | 74 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,495 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,403 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 | 229 reads
<< Newer    Items 21 to 40 of 17452    Older >>