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

<< Newer    Items 81 to 100 of 16811    Older >>
 

Approaches to masking email addresses

There are several ways to to anonymize / pseudonymize email addresses. This post discusses a few frequently used approaches, as well as how you can use Redgate Data Masker for SQL Server to achieve realistic masking of email columns.  Read more...
By 2018/04/24 | Source: Redgate | Category: data masking
Rating: (not yet rated)  Rate this |   Briefcase | 2,949 reads

Cloud Snake Oil

The Cloud isn't always what it seems and Steve notes that paying attention to finances might be the most important thing.  Read more...
By Steve Jones 2018/04/24 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 70 reads

Alerts and Notfications for SQL Server Login, Database User and Role Membership Changes

Check out these scripts to create SQL Server jobs and Alerts when a login is created or dropped, a database user is added or dropped and when logins are added or removed from server roles or users are added or removed from database roles.  Read more...
By Additional Articles 2018/04/24 | Source: MSSQLTips.com | Category: alerts
Rating: (not yet rated)  Rate this |   Briefcase | 2,944 reads

New IT Departments

The more IT departments change, the more they stay the same.  Read more...
By Steve Jones 2018/04/23 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 100 reads

Cancelling DBCC SHRINKFILE with EMPTYFILE

A fun experiment using DBCC SHRINKFILE to rebalance data.  Read more...
By Steve Jones 2018/04/23 | Source: SQLServerCentral.com | Category: dbcc shrinkfile
Rating: |  Discuss |   Briefcase | 792 reads

How to Programmatically Identify When Your SQL Server Was Last Started

Greg Larsen shows you a quick trick to programmatically script a way to identify when SQL Server was last started.  Read more...
By Additional Articles 2018/04/23 | Source: Database Journal | Category: administration
Rating:  Rate this |   Briefcase | 3,441 reads

Spring into the Latest Features at the Luxemborg User Group

The next meeting of the Luxemborg SQL Server User Group has some great sessions planned.  Read more...
By Additional Articles 2018/04/23 | Source: SQLServerCentral.com | Category: user groups
Rating: |  Discuss |   Briefcase | 73 reads

Custom Metrics for Detecting Problems with Ad-hoc Queries

A common SQL Server crime is the unnecessary overuse of ad-hoc queries by applications. In this article, Phil Factor shares some custom queries for monitoring problems that can be caused by this.  Read more...
By 2018/04/23 | Source: SimpleTalk | Category: monitoring
Rating: (not yet rated)  Rate this |   Briefcase | 2,674 reads

Keep It All

We could use more intelligence in our backup systems, since we don't need to keep all those files.  Read more...
By Steve Jones 2018/04/20 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 48 reads

Making Deployments Simpler with Re-runnable Scripts

Make sure your SQL Server database release scripts to make life easier.  Read more...
By Ed Elliott 2018/04/20 (first published: 2015/11/17) | Source: SQLServerCentral.com | Category: releases
Rating: |  Discuss |   Briefcase | 5,419 reads

How to Show the Execution Plan of a Running Query

By looking at a query execution plan, you can determine which steps are used to resolve the query. But what if you just want to find out what the query plans are for only the queries that are currently running?  Read more...
By Additional Articles 2018/04/20 | Source: Database Journal | Category: execution plans
Rating: (not yet rated)  Rate this |   Briefcase | 3,952 reads

The Right Connection

Making a connection to the wrong database had disastrous results for Travis-CI.  Read more...
By Steve Jones 2018/04/19 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 60 reads

Do you check your backups?

Backups. Are you confident you can restore? Do you have a process that ensures you can recover your systems? Learn how one system works in the cloud.  Read more...
By Michael Higgins 2018/04/19 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 841 reads

SQL Server Graph Databases – Part 2: Querying Data in a Graph Database

Along with Graph Databases, Microsoft has introduced the new MATCH function for querying them. Robert Sheldon explains how to use the new function.  Read more...
By Additional Articles 2018/04/19 | Source: SimpleTalk | Category: sql server graph database
Rating: (not yet rated)  Rate this |   Briefcase | 3,085 reads

5 challenges to scaling DevOps at enterprise level

Many large enterprises launch small DevOps initiatives within certain departments, but subsequently find that scaling DevOps across the organization faces a number of challenges that must be overcome.  Read more...
By 2018/04/19 | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 2,496 reads

Stairway to Columnstore Indexes Level 5: Adding New Data To Columnstore Indexes

Earlier levels have shown how Columnstore Indexes work effectively with static data. In most tables however, data is hardly ever static. We are constantly inserting new rows, and updating or deleting existing rows. If you think about what this means for a columnstore index, you will realize that this comes with some unique challenges.  Read more...
By Hugo Kornelis 2018/04/18 (first published: 2015/11/04) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 3,695 reads

Free eBook: SQL Server Execution Plans, Second Edition

Every day, out in the various online forums devoted to SQL Server, and on Twitter, the same types of questions come up repeatedly: Why is this query running slowly? Why is SQL Server ignoring my index? Why does this query run quickly sometimes and slowly at others? My response is the same in each case: have you looked at the execution plan?  Read more...
By Press Release 2018/04/18 (first published: 2013/07/30) | Source: Redgate | Category: execution plans
Rating:  Rate this |   Briefcase | 103,823 reads

Why sp_prepare Isn’t as “Good” as sp_executesql for Performance

Erik Darling shows how execution plan estimates suffer.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 3,124 reads

Good Security Needs Layers

A good security system needs layers since our applications and platforms don't exist in a vacuum.  Read more...
By Steve Jones 2018/04/18 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 34 reads
<< Newer    Items 81 to 100 of 16811    Older >>