SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
<< Previous headlines | Later headlines >>
SQLServerCentral.com Headlines from 2017/12/22 to 2017/12/29

SQL Clone v2.4 – run scripts during image creation

SQL Clone 2.4 incorporates a new T-SQL script runner that the team can use to mask sensitive or personal data, or to modify security and other configuration settings, prior to creating a clone.  Read more...
By 2017/12/29 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 3,296 reads

Questions About Amazon Data Migration Service (AWS DMS) That You Were Too Shy to Ask

Can you imagine it? You are in a group of smart database people, and they are debating the finer points about AWS DMS, and you don't even know what the letters stand for. You just feel too shy to ask those basic questions that seem ridiculous once you're up to speed. Laerte Junior answers all the questions you need answers for when facing the prospect of getting familiar with Amazon's useful Database Migration Service.  Read more...
By Additional Articles 2017/12/29 | Source: SimpleTalk | Category: aws
Rating:  Rate this |   Briefcase | 5,300 reads

Level 4 - Building the Hyper-V VM

In this level of the Stairway to Server Virtualization, learn how to build a Hyper-V virtual machine for SQL Server.  Read more...
By David Klee 2017/12/29 (first published: 2015/10/07) | Source: SQLServerCentral.com | Category: virtualization
Rating: |  Discuss |   Briefcase | 4,677 reads

Would you like to see Redgate tools inside SQL Operations Studio?

You may already have heard about Microsoft’s new DevOps platform for database development, SQL Operations Studio. Related to this, Redgate is doing some research into cross-platform data tools. Read this blog post to find out more about what they're doing, and how you can get involved.  Read more...
By 2017/12/28 | Source: Redgate | Category: sql operations studio
Rating: (not yet rated)  Rate this |   Briefcase | 3,249 reads

Quickly Restricting Database Access

There may be times when you need to perform maintenance against a database that requires you to keep normal database users from connecting to your database while the maintenance is being performed. You want to stop users from connecting right away, but you want the database to be in a state that you can perform maintenance.   Read more...
By Additional Articles 2017/12/28 | Source: Database Journal | Category: access control
Rating:  Rate this |   Briefcase | 5,412 reads

An Introduction: Level 1 of the Stairway to Row-Level Security

Learn the basics of how Row-Level Security works in SQL Server.  Read more...
By Steve Jones 2017/12/28 | Source: SQLServerCentral.com | Category: row level security (rls)
Rating: |  Discuss |   Briefcase | 1,191 reads

Current State of the NewSQL/NoSQL Cloud Arena

Choosing the right data platform is not an easy task. Warner Chaves compares the capabilities of the big three Database as a Service (DBaaS) offerings, Microsoft’s Cosmos DB, Google’s Cloud Spanner, and Amazon’s DynamoDB, to help you make the right choice for your application.  Read more...
By Additional Articles 2017/12/27 | Source: SimpleTalk | Category: nosql
Rating: (not yet rated)  Rate this |   Briefcase | 3,014 reads

Stairway to SQL Server Extended Events Level 3: Working with the Extended Events UI

In the next installment of our stairway to Extended Events, we delve into the Live Data and Target Data Viewers.  Read more...
By Erin Stellato 2017/12/27 (first published: 2016/05/25) | Source: SQLServerCentral.com | Category: extended events (xe)
Rating: |  Discuss |   Briefcase | 2,485 reads

Free eBook: Understanding SQL Server Concurrency

When you can’t get to your data because another application has it locked, a thorough knowledge of SQL Server concurrency will give you the confidence to decide what to do.  Read more...
By Press Release 2018/12/12 (first published: 2013/07/17) | Source: Redgate | Category: concurrency
Rating:  Rate this |   Briefcase | 103,635 reads

Query Plan Oddities: Two Identical Missing Indexes

Brent demos a single query plan that asks for 2 identical indexes on the same table.  Read more...
By Additional Articles 2017/12/26 | Source: Brent Ozar Unlimited Blog | Category: query plans
Rating: (not yet rated)  Rate this |   Briefcase | 3,104 reads

Azure DWH part 22: Dynamic Management Views

The DMV are very effective and important to administer ASDWH. In this article we will show some important DMVs.  Read more...
Rating: |  Discuss |   Briefcase | 222 reads

Support for static data added to Source Control for Oracle

With the speed of software development increasing, more and more companies and organizations are recognizing that version controlling code is becoming as important for databases as it is for applications. In recognition of this, Source Control for Oracle has been upgraded so that it now version controls static data within databases as well as database schemas.  Read more...
By 2017/12/25 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 2,236 reads

Cascading Update and Delete for SQL Server 2017 Temporal Tables

Ameena Lalani looks at cascading updates and deletes when using temporal tables in SQL Server.  Read more...
By Additional Articles 2017/12/25 | Source: MSSQLTips.com | Category: sql server 2017
Rating: (not yet rated)  Rate this |   Briefcase | 3,190 reads

The Case of the Shrinking CFO, err Database

Shrink SQL Server databases quickly and with virtually no contention.  Read more...
By Edward Polley 2017/12/25 (first published: 2015/08/17) | Source: SQLServerCentral.com | Category: shrink
Rating: |  Discuss |   Briefcase | 4,255 reads

New Azure SQL Database Standard Tier Sizes

Tim Radney of SQLskills talks about the various Standard tiers available in Azure SQL Database – what they get you, and how much they cost.  Read more...
By Additional Articles 2017/12/22 | Source: SQLPerformance.com | Category: azure sql database
Rating: (not yet rated)  Rate this |   Briefcase | 3,928 reads

Securing Reporting Services Reports

Learn how you can get the userid of someone connected to Reporting Services and use that information to determine if they can view the report.  Read more...
By Mohamed Idttalbe 2017/12/22 (first published: 2010/05/18) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 8,036 reads