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

Headlines today   July 19, 2018

Segment Data into Deciles

This short article shows a simple example of how to segment data into deciles  Read more...
Rating: |  Discuss |   Briefcase | 539 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,401 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 | 955 reads
Previous headlines

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 | 289 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 | 95,911 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,028 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 | 388 reads

Help Redgate do a better job (and win a $250 Amazon voucher)

Could you spare a few minutes to help Redgate improve its products and services? They’re running a survey of their users and the wider SQL Server community and they’d appreciate your insights. As a thank you for taking part, you’ll also be entered in a prize draw for a $250 Amazon Voucher.   Read more...
By 2018/07/17 (first published: 2018/07/09) | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 3,652 reads

Using SQL Server's Default Trace to Identify Autogrow Events in tempdb

We all know that you should try to size tempdb appropriately, so it doesn’t need to autogrow shortly after starting up SQL Server. It isn’t always easy to do this. Therefore, when you first implement a new server and/or add new databases you should monitor the autogrowth events on tempdb. By monitoring the autogrowth events you can easily determine if you have sized tempdb appropriately.  Read more...
By Additional Articles 2018/07/17 | Source: Database Journal | Category: default trace
Rating: (not yet rated)  Rate this |   Briefcase | 1,439 reads

Fixing ‘A required Privilege is not held by client’ Error

This article is to explain a scenario I started facing in my work environment after some Windows Security patches rolled out . A required privilege is not held by the client. The step failed.   Read more...
By Vishnu Gupthan 2018/07/16 | Source: SQLServerCentral.com | Category: required privilege
Rating: |  Discuss |   Briefcase | 339 reads

From the SQLServerCentral Blogs

Code I’d Hate To Live Without: T-SQL Tuesday #104

It’s TSQL Tuesday again! This time our respected host is Bert Wagner (b/t). Quick aside, if you haven’t seen his...  Read more...
By Kenneth Fisher 2018/07/19 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 2,585 reads

Code I Can’t Live Without–T-SQL Tuesday #104

Bert Wagner has a good invitation this month, a T-SQL Tuesday question about code, specifically code you can’t live without....  Read more...
By Steve Jones 2018/07/19 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 2,575 reads
Question of the Day

ALTER Transactions

By Steve Jones 2018/07/19
Rating: (not yet rated) |  Discuss |   Briefcase | 485 reads

I run this code, how many columns are returned in the SELECT and is there an error? (select 2)

CREATE TABLE dbo.PurchaseOrder (PO VARCHAR(100));
ALTER TABLE dbo.PurchaseOrder ADD CustomerName VARCHAR(100);

ROLLBACK... 
Latest forum posts