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

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,904,378 DBAs, developers and SQL Server users

Headlines today   July 20, 2018

SQL Server Migration

Some SQL migrations require keeping the server name, instance name, IP, and port number. Geoff Ruble shares some notes on his recent experience with a SQL Server migration.  Read more...
By Geoff Ruble 2018/07/20 (first published: 2015/10/12) | Source: SQLServerCentral.com | Category: migration
Rating: |  Discuss |   Briefcase | 4,659 reads

SQL Code Analysis from a PowerShell Deployment Script

Database code analysis becomes more important as the team doing the database development gets bigger and more diverse in skills. In this article Phil Factor discusses SQL Code Analysis from a PowerShell Deployment Script  Read more...
By 2018/07/20 | Source: Redgate
Rating: (not yet rated)  Rate this |   Briefcase | 1,233 reads

Why SQL Developers Keep Making The Same Mistakes

They learned by reading your old code. 
By Additional Articles 2018/07/20 | Source: Brent Ozar Unlimited Blog | Category: sql server
Rating: (not yet rated)  Rate this |   Briefcase | 2,189 reads
Previous headlines

Segment Data into Deciles

This short article shows a simple example of how to segment data into deciles  Read more...
Rating: |  Discuss |   Briefcase | 608 reads

Power BI Introduction: Working with Parameters in Power BI Desktop —Part 4

Power BI allows you to use parameters to make your reports dynamic. In this article, Robert Sheldon demonstrates how parameters can be used to substitute connection information, query filters, or even calculations within the query.  Read more...
By Additional Articles 2018/07/19 | Source: SimpleTalk | Category: power bi
Rating: (not yet rated)  Rate this |   Briefcase | 1,738 reads

Making the database key to DevOps with comprehensive, customizable monitoring

The speed of business today demands that the development and deployment of applications is fast-moving, with frequent yet error-free releases. That’s why the adoption of DevOps is trickling down from Amazon, Facebook, Google and the other usual suspects to every company that relies on technology to drive its communications or sales with users.  Read more...
By 2018/07/19 | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 1,216 reads

Creating a Logical SQL Server: Level 2 of the Stairway to Azure SQL Database

In this second level of the Stairway to Azure SQL Database, we cover the basics of building a logical server using the portal and PowerShell.  Read more...
By Arun Sirpal 2018/07/18 | Source: SQLServerCentral.com | Category: azure sql database
Rating: (not yet rated) |  Discuss |   Briefcase | 305 reads

Free eBook: Troubleshooting SQL Server: A Guide for the Accidental DBA

Three SQL Server MVPs (Jonathan Kehayias, Ted Krueger and Gail Shaw) provide fascinating insight into the most common SQL Server problems, why they occur, and how they can be diagnosed using tools such as Performance Monitor, Dynamic Management Views and server-side tracing. The focus is on practical solutions for removing root causes of these problems, rather than "papering over the cracks".  Read more...
By Press Release 2018/07/18 (first published: 2013/08/07) | Source: Redgate | Category: troubleshooting
Rating:  Rate this |   Briefcase | 96,061 reads

SQL Server Reporting Services Rest API

What functionality is available in the SQL Server Reporting Services REST API and how should you use it?  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 2,214 reads

Setting Permissions to Drop a Database

Learn which permissions are required to drop a database and see a test to show that these apply.  Read more...
By Steve Jones 2018/07/17 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 397 reads

From the SQLServerCentral Blogs

T-SQL Tuesday #104: Just Can’t Cut That Cord

We all have our favorite scripts, tools or utilities. Those are the things that help make our jobs easier. Some...  Read more...
By Jason Brimhall 2018/07/20 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,619 reads

Finding Inconsistent Key Values–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...  Read more...
By Steve Jones 2018/07/20 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,444 reads
Question of the Day

Creating XML Indexes

By Steve Jones 2018/07/20 | Category: create xml index
Rating: (not yet rated) |  Discuss |   Briefcase | 384 reads

I need a new table that contains an XML column. I run this DDL:

CREATE TABLE dbo.PurchaseOrder
PurchaseOrderKey INT IDENTITY(1, 1) NOT NULL
PONumber VARCHAR(100) ,
CustomerName VARCHAR(100)... 
Latest forum posts