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

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,897,377 DBAs, developers and SQL Server users

Previous headlines

Autogenerating SSIS file import packages using Biml

Tired of building tons of similar SSIS packages for importing files into your data warehouse? Learn how to autogenerate them using Biml.  Read more...
By Johan Åhlén 2018/02/16 (first published: 2015/09/10) | Source: SQLServerCentral.com | Category: integration services (ssis)
Rating: |  Discuss |   Briefcase | 5,680 reads

An Easier Way of Pivoting Data in SQL Server

There are several methods to pivot, or transpose, data in T-SQL, but most are difficult to understand and write. Phil Factor demonstrates how to take advantage of JSON support, introduced with SQL Server 2016, to create a function that makes pivoting data simple.  Read more...
By 2018/02/16 | Source: SimpleTalk | Category: pivoting
Rating:  Rate this |   Briefcase | 3,100 reads

Right-sizing for a cloud service

When it’s time to purchase new resources for one or more applications, the non-scientific approach of guesstimating the requirements can be expensive, whether for on-premises capital expenditures or cloud-based services.  Read more...
By 2018/02/16 | Source: Redgate | Category: cloud
Rating: (not yet rated)  Rate this |   Briefcase | 1,361 reads

Azure DWH part 26: Creating your ASDW in Cloud Shell using PowerShell

In this article, we will show how to create an ASDW in PowerShell using the Cloud Shell.  Read more...
By Daniel Calbimonte 2018/02/15 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 169 reads

How to Test SQL Server Functions and Procedures using SQL Prompt

When writing functions or procedures, a common chore is to devise and implement the tests that ensure that the routine always works as expected.  Read more...
By 2018/02/15 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 2,310 reads

When Does Index Size Change Index Choice?

Erik purposely fragments indexes trying to slow down queries.  Read more...
By Additional Articles 2018/02/15 | Source: Brent Ozar Unlimited Blog | Category: indexes
Rating: (not yet rated)  Rate this |   Briefcase | 2,047 reads

Calculating DTU's for Azure SQL Database

This calculator will help you determine the number of DTUs for your existing SQL Server database(s) as well as a recommendation of the minimum performance level and service tier that you need before you migrate to Azure SQL Database.  Read more...
Rating: |  Discuss |   Briefcase | 487 reads

Free eBook: SQL Server Internals: In-Memory OLTP

In this free eBook, Kalen Delaney explains how Microsoft's 2016 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 2018/02/14 (first published: 2015/05/13) | Source: Redgate | Category: ebook
Rating:  Rate this |   Briefcase | 44,734 reads

SQL Server Machine Learning Services – Part 4: Finding Data Anomalies with Python

Python is widely used to analyze data. One such use is to find anomalies or outliers. In this article, Robert Sheldon demonstrates how to create a support vector machine (SVM) to score test data so that outliers can be viewed on a scatter plot.  Read more...
By Additional Articles 2018/02/14 | Source: SimpleTalk | Category: python
Rating: (not yet rated)  Rate this |   Briefcase | 2,110 reads

Restore a Database with CDC Enabled

In this post, I’m going to talk about an issue that I found while restoring a backup of CDC enabled database to different SQL instance. You may receive below warning message that includes information about the cause of the warning, which can help you to resolve the issue.  Read more...
Rating: |  Discuss |   Briefcase | 538 reads
 

Question of the Day

Guest

By Steve Jones 2018/02/16 | Category: security
Rating: (not yet rated) |  Discuss |   Briefcase | 446 reads

I see I have a guest user in my database, but in SSMS the user has a red x next to the name. How do I enable this user in...  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
GilaMonster
37234 585677 SSC Guru  
2.
Jeff Moden
32888 539205 SSC Guru  
3.
Steve Jones - SSC Editor
20462 349158 SSC Guru  
4.
Grant Fritchey
14807 236240 SSC Guru  
5.
Lynn Pettis
14721 238187 SSC Guru  
Latest forum posts