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

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

Testing PowerShell Modules with Pester

In the third article of this series on testing PowerShell code with Pester, Robert Cain demonstrates how to test the functions in a PowerShell module.  Read more...
By Additional Articles 2018/11/12 | Source: SimpleTalk | Category: pester
Rating: (not yet rated)  Rate this |   Briefcase | 1,532 reads

Datatypes and the Default Mask with Dynamic Data Masking

This article digs deeper into the ways that Dynamic Data Masking works with different data types.  Read more...
By Steve Jones 2018/11/09 (first published: 2016/03/23) | Source: SQLServerCentral.com | Category: dynamic data masking
Rating: |  Discuss |   Briefcase | 1,777 reads

Data Breach Danger

Is a data breach a danger to those identified in the data. A court says no, but Steve Jones wonders if this is a bad decision.  Read more...
By Steve Jones 2018/11/09 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 162 reads

Unused Indexes - Are they really unused or have they just not been used YET?

Tara explains when index DMVs gets reset by telling a story from her dark past.  Read more...
By Additional Articles 2018/11/09 | Source: Brent Ozar Unlimited Blog | Category: indexing
Rating: (not yet rated)  Rate this |   Briefcase | 2,690 reads

2019 State of Database DevOps – Take the survey!

Database development practices are more integral than ever to DevOps success. How are we saving time, automating processes, deploying more frequently, all whilst keeping business critical data secure? Take part in the survey for an advanced copy of the research report, and a chance to win a $250 Amazon voucher.   Read more...
By 2018/11/15 (first published: 2018/11/26) | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 2,241 reads

The Cost of Switching

With so many companies looking at other platforms, when should an organization consider changing their database? Steve Jones has a few thoughts.  Read more...
By Steve Jones 2018/11/08 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 243 reads

T-SQL Decommenter Part I

Introduction to a T-SQL query that remove comments from T-SQL code  Read more...
By Toby Ovod-Everett 2018/11/08 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,305 reads

Azure EA Financial Reporting and Granular Access to Data Through the Enterprise

With the billing data from your Azure Enterprise Agreement collected into one database, it is still necessary to break down the costs and provide access to the correct departments and individuals. This is important for chargeback and further analysis. In this article, Feodor Georgiev demonstrates how to provide granular access to the billing data.  Read more...
By Additional Articles 2018/11/08 | Source: SimpleTalk | Category: azure
Rating: (not yet rated)  Rate this |   Briefcase | 1,756 reads

Help Redgate improve Data Masker for SQL Server?

Redgate are looking for people to help them get a deep understanding of compliance and SQL Server data masking requirements in order to ensure they can provide a world class solution. In return for your feedback you’ll have early access to new releases, insights into new features and their ongoing support to get up and running.   Read more...
By 2018/11/08 | Source: Redgate | Category: data masking
Rating:  Rate this |   Briefcase | 1,444 reads

Stairway to Columnstore Indexes Level 13: Improvements in SQL Server 2016

This stairway series was started in 2015. As such, the focus was on SQL Server 2012 and SQL Server 2014 only. When SQL Server 2016 was released, with lots of improvements in the columnstore technology, I decided to finish the planned levels with the original focus on SQL Server 2012 and 2014, and add one extra level with a brief overview of the improvements available in SQL Server 2016.  Read more...
By Hugo Kornelis 2018/11/07 (first published: 2017/06/07) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 1,723 reads

Wasted Work

One of the benefits of DevOps is less wasted work.  Read more...
By Steve Jones 2018/11/07 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 67 reads

Free eBook: Fundamentals of SQL Server 2012 Replication

Fundamentals of SQL Server 2012 Replication provides a hands-on introduction to SQL Server replication. The book introduces you to the technologies that make up replication, and then walks you through setting up different replication scenarios. When you've finished reading, you should be able to implement your own multi-server replication setup while following the principle of least privilege.  Read more...
By Press Release 2018/11/07 (first published: 2014/02/26) | Source: Redgate | Category: replication
Rating:  Rate this |   Briefcase | 80,062 reads

Simple way to Import XML Data into SQL Server with T-SQL

In this tip we look at a simple way to import a simple XML document into a SQL Server table.  Read more...
By Additional Articles 2018/11/07 | Source: MSSQLTips.com | Category: xml datasource
Rating:  Rate this |   Briefcase | 2,751 reads

Caution about Restoring via SSMS v17

A default value has changed in the SSMS v7 restore wizard, and the consequences can be severe.  Read more...
Rating: |  Discuss |   Briefcase | 1,509 reads

In Memorium

A sad week for the SQL Family  Read more...
By Steve Jones 2018/11/06 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 92 reads

How Big is Your Transaction Log?

If you are not managing the transaction log space used by a database, the transaction log might grow uncontrollably. With SQL Server 2017 there is a new dynamic management function (DMF) that exposes statistical information about a database transaction log. One of the things you can do with the information returned from this DMF is to determine how full a database transaction log file is.  Read more...
By Additional Articles 2018/11/06 | Source: Database Journal | Category: transaction log
Rating: (not yet rated)  Rate this |   Briefcase | 3,471 reads

SQL Clone V3: New features heighten visibility and manageability of clones and images.

With a brand new dashboard, activity feed and search functionality there is a lot happening in the SQL Clone v3 release. Check out the full breakdown of the update and get onto the latest version.   Read more...
By 2018/11/06 | Source: Redgate | Category: sql clone
Rating:  Rate this |   Briefcase | 1,540 reads

The Short Summit

Steve is only attending the PASS Summit for a few days, and has a few thoughts.  Read more...
By Steve Jones 2018/11/05 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 46 reads

Import flat files to SQL Server on Linux using Azure Data Studio

Have you ever wonder how to import flat files to SQL Server on Linux? In this article, I will share my experience loading data to a Linux SQL Server instance using the new Azure Data Studio data import extension from macOS.  Read more...
By Carlos Robles 2018/11/05 | Source: SQLServerCentral.com | Category: linux
Rating: |  Discuss |   Briefcase | 258 reads

Azure and Windows PowerShell: Using VM Extensions

In the third part of his series, Nicolas Prigent describes how to run post-deployment configuration and automation tasks on Azure Virtual Machines. Nicolas explains how to use Azure VM Extensions using the Azure PowerShell module to save time during the provisioning process.  Read more...
By Additional Articles 2018/11/05 | Source: SimpleTalk | Category: azure
Rating: (not yet rated)  Rate this |   Briefcase | 1,750 reads
<< Newer    Items 21 to 40 of 17356    Older >>