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

<< Newer    Items 61 to 80 of 15751    Older >>
 

Thinking Time

Taking time away from life and just thinking is important.  Read more...
By Steve Jones 2017/05/05 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 102 reads

Exploring Azure Storage for SQL Server DBAs – Part 2

Managed Disks have simplified way that Azure storage interacts with the users' virtual machines, thanks to the way that it eliminates the need to deal with the Storage Account. It is now easier to add new disks to a virtual machine, either in PowerShell or via the portal. The Storage Spaces feature in Windows Server can be used to aggregate disks together and obtain higher levels of performance. Joshua Feierman explains how to do it all.  Read more...
By Additional Articles 2017/05/05 | Source: SimpleTalk | Category: azure storage
Rating:  Rate this |   Briefcase | 3,508 reads

Dude, where’s my database? Inventory management by Foundry

Have trouble keeping track of your SQLServer estate? Redgate Foundry are currently researching the area - here's what they've been up to, and how you might be able to help.   Read more...
By Additional Articles 2017/05/05 | Source: Redgate | Category: inventory
Rating: (not yet rated)  Rate this |   Briefcase | 2,454 reads

IoT Pros and Cons

The Internet of Things is coming, and there will be good and bad aspects of it.  Read more...
By Steve Jones 2017/05/04 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 60 reads

Performance Tuning Using Extended Events: Part 3

Identifying Performance Tuning Opportunities Using Extended Events: Part 3 Aggregate Report  Read more...
By Brian Davey 2017/05/04 | Source: SQLServerCentral.com | Category: extended events
Rating: |  Discuss |   Briefcase | 1,179 reads

SQL Server Join Example

What are all of the JOIN options in SQL Server? What is the significance of each of the options? How does the syntax work? Jeremy Kadlec answers these questions and more.  Read more...
By Additional Articles 2017/05/04 | Source: MSSQLTips.com | Category: joins
Rating: (not yet rated)  Rate this |   Briefcase | 3,719 reads

How to Move a Table to a Different File Group

There may be a time when you want to move a table from one file group to another. It's easy if it contains a clustered index. Read on to learn more.  Read more...
By Additional Articles 2017/05/04 | Source: Database Journal
Rating:  Rate this |   Briefcase | 2,838 reads

Byte Me: Entrepreneurial

By Bob Lang 2017/05/03 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 88 reads

Stairway to DAX and Power BI - Level 7: Function / Iterator Function Pairs: The DAX AVERAGE() and AVERAGEX() Functions

Business Intelligence architect, Analysis Services Maestro, and author Bill Pearson explores the DAX AVERAGE() and AVERAGEX() functions, comparing and contrasting the two. He then provides some hands-on exposure to the use of each, particularly in combination with other DAX functions, in generating arithmetic means within our PowerPivot model designs.  Read more...
By Bill Pearson 2017/05/03 (first published: 2014/09/17) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 3,057 reads

Build Dynamic Backup Locations with Minion Backup

See how Minionware Backup gives you the ability to customize backup files and locations.  Read more...
By Sean McCown 2017/05/03 | Source: Minionware | Category: minionware
Rating: |  Discuss |   Briefcase | 146 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 2017/05/03 (first published: 2013/07/30) | Source: Redgate | Category: execution plans
Rating:  Rate this |   Briefcase | 90,806 reads

Why is my clone so small?

Using very few megabytes and taking very little time, SQL Clone can quickly creates multiple copies of very large databases. How? It might sound like magic, but it's not; in this blog post Redgate developer Chris Hurley goes into the details of how the technology works.  Read more...
By Additional Articles 2017/05/03 | Source: Redgate | Category: sql clone
Rating: (not yet rated)  Rate this |   Briefcase | 3,151 reads

OUTPUT Clause Basics (For Inserts and Deletes)

When INSERTING or DELETING rows from a table, the OUTPUT clause can be used to return a dataset containing the changes made. Mat Richardson explains how.  Read more...
By Mat Richardson 2017/05/02 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,854 reads

How to implement a T-SQL code formatting standard using SQL Prompt

Louis Davidson shows how to save a defined SQL formatting style as a shareable template that you can quickly share with your coworkers.  Read more...
By Additional Articles 2017/05/02 | Source: Redgate | Category: formatting
Rating: (not yet rated)  Rate this |   Briefcase | 5,019 reads

The Secret Password

The secret passwords we store in systems might be secure from discovery, but are they secure from use?  Read more...
By Steve Jones 2017/05/02 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 66 reads

Azure Load Balancers and SQL Server

Load balancing in Azure has more importance for the DBA, because it is essential for Windows Server Failover Clustering in Azure, whether it is for AlwaysOn Availaiblity Groups, Failover Clustered Instances, or any other highly-available solution. Azure load balancing works out the location of the availability group, and routes traffic there. The load balancer detects a failure, and routes traffic to the new primary replica. Joshua Feierman gives an overview of what is required.  Read more...
By Additional Articles 2017/05/02 | Source: SimpleTalk | Category: azure
Rating:  Rate this |   Briefcase | 3,186 reads

More Open Data

A new site from Steve Ballmer opens lots of data to the public.  Read more...
By Steve Jones 2017/05/01 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 66 reads

SQL Server Unit Testing in Visual Studio

Unit test stored procedures in Visual Studio using an existing database or new SQL scripts  Read more...
By David Fundakowski 2017/05/01 | Source: SQLServerCentral.com | Category: unit testing
Rating: |  Discuss |   Briefcase | 1,220 reads

Introducing a DevOps Workgroup to Farm Credit Services of America

If you are introducing DevOps workflows into a large organization, you’ll need to plan carefully and prioritize tasks, adapt, maintain a thick skin, communicate constantly, and ensure that all teams have a chance to contribute their solutions. Bob Walker explains how FCSA set up a DevOps Workgroup, its philosophy and its goals for improving database and application deployment processes.  Read more...
By Additional Articles 2017/05/01 | Source: SimpleTalk | Category: devops
Rating:  Rate this |   Briefcase | 2,126 reads
<< Newer    Items 61 to 80 of 15751    Older >>