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,390 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,715 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,371 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,516 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 | 171 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,440 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,204 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 | 490 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,828 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,241 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 | 542 reads
 

Question of the Day

Guest

By Steve Jones 2018/02/16 | Category: security
Rating: (not yet rated) |  Discuss |   Briefcase | 466 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
37206 586721 SSC Guru  
2.
Jeff Moden
32996 540255 SSC Guru  
3.
Steve Jones - SSC Editor
20516 349800 SSC Guru  
4.
Grant Fritchey
15055 236880 SSC Guru  
5.
Lynn Pettis
14701 238609 SSC Guru  
Latest forum posts