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

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

Moving Dynamic Data Masked Data to New Locations

In this level of the Stairway to Dynamic Data Masking we examine how masking affects data movement.  Read more...
By Steve Jones 2017/09/13 | Source: SQLServerCentral.com | Category: dynamic data masking
Rating: |  Discuss |   Briefcase | 346 reads

A Backup Change

Steve Jones talks about backup of data today and the challenges of managing this at scale.  Read more...
By Steve Jones 2017/09/13 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 41 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 2017/09/13 (first published: 2014/02/26) | Source: Redgate | Category: replication
Rating:  Rate this |   Briefcase | 67,860 reads

Protecting SQL Server from Ransomware

The problem of ransomware seems to be increasing. Major organizations are being hit and their servers are being affected. K. Brian Kelley explains some of the basic things you can do to reduce your expose to ransomeware.  Read more...
By Additional Articles 2017/09/13 | Source: MSSQLTips.com | Category: ransomware
Rating: (not yet rated)  Rate this |   Briefcase | 3,118 reads

Pattern Recognition via Principal Components Analysis

We'll look at using principal components analysis to help visualise your data and detect underlying structure or patterns.  Read more...
By Nick Burns 2017/09/12 | Source: SQLServerCentral.com | Category: r language
Rating: |  Discuss |   Briefcase | 676 reads

The Randomness of Analog

A look back at the random nature of finding information in libraries and bookstores. A feeling Steve Jones misses.  Read more...
By Steve Jones 2017/09/12 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 50 reads

SQL Data Aggregation Aggravation

When we have to deal with and store a lot of data, it makes sense to aggregate it so that we store only the information we actually need. If we get this right, this works well, but the design of the system takes care and thought because the problems can be subtle and various. Joe Celko describes some of the ways that things can go wrong and end up providing incorrect, inaccurate or misleading results.  Read more...
By Additional Articles 2017/09/12 | Source: SimpleTalk | Category: t-sql
Rating: (not yet rated)  Rate this |   Briefcase | 3,144 reads

Guide available for enhancing privacy and addressing GDPR requirements with the Microsoft SQL platform

The EU Global Data Protection Regulation (GDPR) goes into effect on May 25, 2018 - and we know that many of you are searching for guidelines and recommendations for how to properly handle the data privacy and data protection requirements stipulated by the GDPR. This guide provides technical guidance and best practices for addressing data privacy concerns and enhancing your overall data protection and security strategy with Microsoft SQL technologies.  Read more...
By 2017/09/12 | Source: Microsoft MSDN | Category: data privacy
Rating:  Rate this |   Briefcase | 3,031 reads

Final Thoughts

Walt Mossberg is retiring and Steve has a few thoughts on his last column.  Read more...
By Steve Jones 2017/09/11 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 62 reads

Challenge Your Code Design

How to structure your T-SQL objects and incorporate design principles.  Read more...
By Gary Strange 2017/09/11 | Source: SQLServerCentral.com | Category: query tuning
Rating: |  Discuss |   Briefcase | 1,215 reads

The struggle to renormalize data

You are given an export of a NoSQL database, in JSON, and asked to import it into a relational database. Sounds easy? It isn't and Phil Factor explain why.  Read more...
By Phil Factor 2017/09/11 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 73 reads

What Mail Items Have Been Sent With Database Mail

Have you ever wondered how much database mail you have sent in the past day or week? What about those database mail items that were not successfully sent. In this tip, Greg Larsen shows you how to review the database mail items that have been processed by SQL Server.  Read more...
By Additional Articles 2017/09/11 | Source: Database Journal | Category: database mail
Rating: (not yet rated)  Rate this |   Briefcase | 2,728 reads

The Control Poll

Do you use version control for your databases? For your application code? Is there a time when you think it's not needed? Steve Jones asks the question today.   Read more...
By Steve Jones 2017/09/08 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 135 reads

DBAs and the ITIL Framework

Most IT departments are moving toward ITIL-aligned practices. Gain a general understanding of the ITIL framework and how Database Administrators can take advantage of it.  Read more...
By John F. Tamburo 2017/09/08 (first published: 2015/10/26) | Source: SQLServerCentral.com | Category: itil
Rating: |  Discuss |   Briefcase | 6,825 reads

Creatures of habit, snowflakes, and integration tax

Why are practices like version control, continuous integration and automated deployment being introduced to application development but left on the shelf when it comes to the database? In search of some answers, Redgate spoke to Donovan Brown, Principal DevOps Manager at Microsoft and DevOps advocate. Also known as The Man in the Black Shirt, his unofficial tagline is #RubDevOpsOnIt. He lives DevOps - here's what he had to say.  Read more...
By Additional Articles 2017/09/08 | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 3,342 reads

Setup and Implement SQL Server 2016 Always On Distributed Availability Groups

SQL Server 2016 introduced a new feature called Distributed Availability Group. A Distributed Availability Group is a special type of Availability Group that spans two separate Availability Groups. Edwin Sarmiento explains.  Read more...
By Additional Articles 2017/09/08 | Source: MSSQLTips.com | Category: sql server 2016
Rating: (not yet rated)  Rate this |   Briefcase | 3,077 reads

Using Tools that Fit

Equipment can matter for IT professionals. Read a few thoughts from Andy Warren.  Read more...
By Andy Warren 2017/09/07 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 50 reads

The Shortcomings of Predictive Accuracy

In prediction, accuracy is key. But it's not all it's cracked up to be as we will explore.  Read more...
By Nick Burns 2017/09/07 | Source: SQLServerCentral.com | Category: r language
Rating: |  Discuss |   Briefcase | 697 reads

Why don’t you unit test SQL Server code?

This post will show the benefits of test-driven development and including automated SQL Server unit testing within your release pipeline. Even if you have a large code base and no existing unit tests, you can start introducing tests now to make your database code more robust to change.  Read more...
By Additional Articles 2017/09/07 | Source: Redgate | Category: unit testing
Rating: (not yet rated)  Rate this |   Briefcase | 4,924 reads

SQL Graph Objects in SQL Server 2017: the Good and the Bad

Graph databases are useful for certain types of database tasks that involve representing and traversing complex relationships between entities. These can be difficult to do in relational databases and even trickier to report on. Until now, we have had the choice of doing it awkwardly in SQL Server or having an ancillary database to tackle this type of task. SQL Server 2017 will be bringing graph capabilities to the product but will these features prove to be good enough to allow us to dispense with specialised Graph databases? Dennes Torres decided to find out.  Read more...
By Additional Articles 2017/09/07 | Source: SimpleTalk | Category: sql server 2017
Rating:  Rate this |   Briefcase | 2,820 reads
<< Newer    Items 21 to 40 of 16093    Older >>