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

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

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,423 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,459 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 | 389 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

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,884 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,600 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 | 522 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,400 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,862 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,792 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,447 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,783 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

T-SQL Decommenter Part IV

Examination of the comprehensive test suite for the T-SQL Decommenter, along with explanation of the modifications made to produce the production version.  Read more...
By Toby Ovod-Everett 2018/11/29 | Source: SQLServerCentral.com | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 460 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,271 reads

Meeting Preparation for SQL Server Projects

Learn how to prepare for technical meetings including knowing your environment, being calm, business values, solution focus and more.  Read more...
By Additional Articles 2018/11/29 | Source: MSSQLTips.com | Category: meetings
Rating: (not yet rated)  Rate this |   Briefcase | 2,369 reads

Mitigate Issues Early

When you know there's a problem, it's better to solve it early rather than late.  Read more...
By Steve Jones 2018/11/28 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 27 reads
<< Newer    Items 21 to 40 of 17431    Older >>