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

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

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,077 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 | 226 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

Free eBook: Troubleshooting SQL Server: A Guide for the Accidental DBA

Three SQL Server MVPs (Jonathan Kehayias, Ted Krueger and Gail Shaw) provide fascinating insight into the most common SQL Server problems, why they occur, and how they can be diagnosed using tools such as Performance Monitor, Dynamic Management Views and server-side tracing. The focus is on practical solutions for removing root causes of these problems, rather than "papering over the cracks".  Read more...
By Press Release 2018/12/05 (first published: 2013/08/07) | Source: Redgate | Category: troubleshooting
Rating:  Rate this |   Briefcase | 101,452 reads

Transferring Data with JSON in SQL Server

JSON is a viable option for transferring data between systems. It has the ability to include schema information along with the data which is an advantage over CSV files. In this article, Phil Factor demonstrates how he takes advantage of JSON when exporting or importing tables.  Read more...
By Additional Articles 2018/12/05 | Source: SimpleTalk | Category: json
Rating: (not yet rated)  Rate this |   Briefcase | 2,516 reads

Revving the Error

Changing error messages can be problematic at times.  Read more...
By Steve Jones 2018/12/04 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 41 reads

PackPrecScale CLR function

CLR can be used to pack Precision and Scale of a SqlDecimal  Read more...
By Claude Martel 2018/12/04 | Source: SQLServerCentral.com | Category: clr
Rating: (not yet rated) |  Discuss |   Briefcase | 391 reads

Create, protect and manage non-production databases with SQL Provision

SQL Provision allows teams to create a secure, scalable and repeatable process for managing data as it moves through your SQL Server estate, without causing administrative burdens. To find out more and how it can work alongside your existing database DevOps practices, check out this article.   Read more...
By 2018/12/04 | Source: Redgate | Category: sql provision
Rating: (not yet rated)  Rate this |   Briefcase | 1,950 reads

Overview of Azure SQL Database Information Protection

Information protection becomes one of the dominant factors that drive modern database design and implementation. This becomes particularly evident when operating in a cloud computing environment, with Azure SQL Database serving as one of the prime examples of this trend. Microsoft delivers relevant features by leveraging several different security-related Azure services. In this article, we will provide an overview of this functionality.  Read more...
By Additional Articles 2018/12/04 | Source: Database Journal | Category: azure sql database
Rating: (not yet rated)  Rate this |   Briefcase | 1,648 reads

GitHub Downtime

GitHub experienced downtime and a problem with two nodes of database servers.  Read more...
By Steve Jones 2018/12/03 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 41 reads

Cost estimation for SQL Server Azure VMs

This article provides pricing guidance for SQL Server virtual machines in Azure.  Read more...
By Deepak Prasad Sahu 2018/12/03 | Source: SQLServerCentral.com | Category: azure iaas vm
Rating: |  Discuss |   Briefcase | 530 reads

Data with Provenance

File systems and document databases are the wild lands of data privacy. Phil Factor explains the value of JSON Schema in adding provenance to your document data.  Read more...
By Phil Factor 2018/12/03 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 38 reads

Monitoring Changes in Permissions, Users, Roles and Logins

Compliance means keeping a close grip on any changes to the permissions and access control of a database. Sadly, the law has had to acknowledge, from bitter experience, that it is not just external intruders who want to do this, but it could also be attempts at fraud or data theft from within the organisation. Permission changes are certainly one of the things that security experts advise you look out for; you need the equivalent of CCTV trained on your servers.  Read more...
By 2018/12/03 | Source: Redgate | Category: sql monitoring
Rating: (not yet rated)  Rate this |   Briefcase | 2,456 reads

Adding a Primary Key to a Prepopulated Table using a SQL Server Integration Services Package

In this tip we look at how you can use SSIS to build a package to add a primary key to an existing table that does not already have a primary key.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 1,930 reads

Solving FIFO Queues Using Windowed Functions

One common request often seen in T-SQL is working with queues of information. In this piece, J. Drew Allen will show to use windowing functions and the OVER clause to process a FIFO queue.  Read more...
By J. Drew Allen 2018/11/30 (first published: 2016/10/06) | Source: SQLServerCentral.com | Category: fifo queues
Rating: |  Discuss |   Briefcase | 3,802 reads

Understanding a Database

The ways in which you might try and reverse engineer a database design are on Steve's mind today.  Read more...
By Steve Jones 2018/11/30 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 71 reads

A Basic Technique for Masking Address Data using Data Masker

Grant Fritchey shows how to use Data Masker to obfuscate address data, wile ensuring that the masked data retains the characteristics and distribution of real address information.  Read more...
By 2018/11/30 | Source: Redgate | Category: data masking
Rating: (not yet rated)  Rate this |   Briefcase | 2,502 reads

The Curse of Cursor Options

Books Online says the FAST_FORWARD option has "performance optimizations enabled," but they didn't say if they were good. It turns out they're not.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 2,856 reads

Tougher Privacy Laws

A proposal for tougher privacy laws in the US is out.  Read more...
By Steve Jones 2018/11/29 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 39 reads
<< Newer    Items 21 to 40 of 17435    Older >>