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,437 DBAs, developers and SQL Server users

Previous headlines

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,709 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,572 reads

Why SQL Developers Keep Making The Same Mistakes

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

Segment Data into Deciles

This short article shows a simple example of how to segment data into deciles  Read more...
Rating: |  Discuss |   Briefcase | 625 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 | 2,047 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,483 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 | 314 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,176 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,362 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 | 404 reads
 

Question of the Day

Creating XML Indexes

By Steve Jones 2018/07/20 | Category: create xml index
Rating: (not yet rated) |  Discuss |   Briefcase | 436 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
CONSTRAINT PurchaseOrderPK PRIMARY KEY ,
PONumber VARCHAR(100) ,
CustomerName VARCHAR(100)...  Read more...
Latest forum posts