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

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

Balloons and Data

A common misconception for users is how tempdb, and data files in general work.   Read more...
By Steve Jones 2017/05/09 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 261 reads

Best option for working with Files in SSIS

This time we will compare different solutions to copy system folders using different SSIS tasks.  Read more...
By Daniel Calbimonte 2017/05/09 | Source: SQLServerCentral.com | Category: ssis
Rating: |  Discuss |   Briefcase | 1,482 reads

Date and Time Conversions Using SQL Server

There are many instances when dates and times don't show up at your doorstep in the format you'd like it to be, nor does the output of a query fit the needs of the people viewing it. One option is to format the data in the application itself. Another option is to use the built-in functions SQL Server provides to format the date string for you.  Read more...
By 2017/05/09 | Source: MSSQLTips.com | Category: date conversion
Rating:  Rate this |   Briefcase | 3,908 reads

View R Plots from within SQL Server Management Studio

Describes how to view R plots in SSMS and gives a brief introduction to R plotting  Read more...
By Bill Palace 2017/05/08 | Source: SQLServerCentral.com | Category: r services
Rating: |  Discuss |   Briefcase | 1,069 reads

Deploying Multiple SSIS Projects via PowerShell

When there are several SSIS projects with packages in a SQL Server Database or Data Warehouse development, automated deployments as part of Continuous Integration can get tricky. Nat Sundar describes how he created a Deployment script that is intended to provision a Data Warehouse for System Integrated testing (SIT).  Read more...
By Additional Articles 2017/05/08 | Source: SimpleTalk | Category: ssis
Rating:  Rate this |   Briefcase | 3,581 reads

Three Days and a Notebook

Steve Jones is off to Seattle for the rest of the week attending Microsoft Build 2017.  Read more...
By Steve Jones 2017/05/08 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 51 reads

Basic data masking for development work using SQL Clone and SQL Data Generator

This article describes a lightweight copy-and-generate approach for making a sanitized version of a production database available to development teams with SQL Clone and SQL Data Generator.  Read more...
By Additional Articles 2017/05/08 | Source: Redgate | Category: data masking
Rating: (not yet rated)  Rate this |   Briefcase | 3,318 reads

The Power BI Pivot

This week Steve looks at the Power BI announcement of a new server product.  Read more...
By Steve Jones 2017/05/08 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 52 reads

Azure Machine Learning - Your first experiment

In this chapter, we will show how to create a Machine Learning experiment from our Azure SQL Warehouse.  Read more...
By Daniel Calbimonte 2017/05/05 (first published: 2016/06/14) | Source: SQLServerCentral.com | Category: azure
Rating: |  Discuss |   Briefcase | 3,983 reads

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 | 103 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,529 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,460 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 | 61 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,185 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,728 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,850 reads

Byte Me: Entrepreneurial

By Bob Lang 2017/05/03 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 90 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,061 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,821 reads
<< Newer    Items 61 to 80 of 15760    Older >>