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

<< Newer    Items 41 to 60 of 15747    Older >>
 

Performance Myths: Table variables are always in-memory

Guest author Derik Hammer dismisses the common myth that table variables perform better than temp tables because they are always in memory.  Read more...
By Additional Articles 2017/05/11 | Source: SQLPerformance.com | Category: performance
Rating: (not yet rated)  Rate this |   Briefcase | 5,100 reads

What do you do when you have a repetitive task to do?

When faced with repetitive tasks how do you go about doing them in a focused timely manner?  Read more...
By Ben Kubicek 2017/05/11 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 77 reads

So, you didn’t get the job; maybe it is YOUR fault.

Why I am now motivated to brand myself.  Read more...
By Rodney Hess 2017/05/10 | Source: SQLServerCentral.com | Category: employement
Rating: |  Discuss |   Briefcase | 79 reads

Free eBook: SQL Server Internals: In-Memory OLTP

In this free eBook, Kalen Delaney explains how Microsoft's new In-memory OLTP engine works. In her book, learn how to use lock- and latch-free data structures to allow non-blocking data processing, and find out how to migrate existing tables to Hekaton.  Read more...
By Press Release 2017/05/10 (first published: 2015/05/13) | Source: Redgate | Category: ebook
Rating:  Rate this |   Briefcase | 35,884 reads

AlwaysON Availability Group and Jobs Part 1

In this article (consist from 2 parts) , I will be focusing on one of the practical solutions for management of internal SQL Server jobs in AlwaysOn Availability Groups scenarios.   Read more...
Rating: |  Discuss |   Briefcase | 702 reads

Using an R Package within SQL Server with Real time analysis in Power BI

We all know how easy it is to run R, together with dependent packages, from SQL Server on order to do statistical analysis, and then turn the result into a real-time graph using Power BI; but can you actually do it? Saurabh Desai gives a step-by-step hand-holding guide to turn even the most timid into a BI guru. There is nothing difficult in using R in SQL Server 2016 once you know the steps.  Read more...
By 2017/05/10 | Source: SimpleTalk | Category: r package
Rating:  Rate this |   Briefcase | 4,028 reads

SQL Data Mask: now featuring configurable masks

SQL Data Mask is the latest prototype to come out of Redgate Foundry. It copies your database while anonymizing personal data, and you can use it to mask your databases right now, free of charge. Here are the details.  Read more...
By Additional Articles 2017/05/10 | Source: Redgate | Category: data masking
Rating: (not yet rated)  Rate this |   Briefcase | 3,617 reads

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 | 260 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,464 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,897 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,045 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,538 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,312 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 | 51 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,951 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 | 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,502 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,453 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
<< Newer    Items 41 to 60 of 15747    Older >>