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

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,893,794 DBAs, developers and SQL Server users

Headlines today   November 17, 2017

Auto Generate Your Database Documentation

Script provided to create missing extended properties allowing you to auto generate your database documentation.  Read more...
By Andy Jones 2017/11/17 (first published: 2016/02/25) | Source: SQLServerCentral.com | Category: extended property
Rating: |  Discuss |   Briefcase | 6,362 reads

SQL Clone Quick Tip: Offloading DBCC checks

If corruption creeps into a database it can and will derail the best-laid disaster recovery plans. To be certain that a database is corruption-free, you need to run regular DBCC CHECKDB checks on that database. Unfortunately this is a resource-intensive task, but SQL Clone can help.  Read more...
By 2017/11/17 | Source: Redgate | Category: dbcc checkdb
Rating: (not yet rated)  Rate this |   Briefcase | 1,070 reads

Questions About RDS SQL Server That You Were Too Shy to Ask

There are a number of different ways that you can host SQL Server. RDS SQL Server, for example, uses SQL Server within AWS as a simple database service, much like a more versatile alternative to MySQL. Obviously, it is a compromise, in that you lose many of the extras beyond the database. Laerte Junior answers those questions about RDS that people seem to assume you know the answers to, but which you may be too shy to ask.  Read more...
By Additional Articles 2017/11/17 | Source: SimpleTalk | Category: rds sql server
Rating: (not yet rated)  Rate this |   Briefcase | 1,134 reads
Previous headlines

Exporting Custom Messages from Sys.Messages

Learn how to get your custom messages from an existing instance and add them to a new instance.  Read more...
By Steve Jones 2017/11/16 | Source: SQLServerCentral.com | Category: sys.messages
Rating: |  Discuss |   Briefcase | 373 reads

Cleanly Uninstalling Stubborn SQL Server Components

There is a built-in command called msiexec which has an uninstall parameter (-x). This command can be used to remove stubborn programs through brute force. First, though, you need to get an inventory of the GUIDs that represent the programs you need to remove.   Read more...
By Additional Articles 2017/11/16 | Source: MSSQLTips.com | Category: uninstall
Rating: (not yet rated)  Rate this |   Briefcase | 1,260 reads

Webinar: data protection & privacy in the world of DevOps

Microsoft MVP and PASS President Grant Fritchey dispels the myth that database DevOps and compliance can't go hand in hand. After a brief look at how extending DevOps to the database lays solid foundations for data governance and compliance, the focus will then shift to guidance around the upcoming GDPR. Register now.  Read more...
By 2017/11/16 | Source: Redgate | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 1,194 reads

Stairway to MDX - Level 2: The Ordinal Function

Business Intelligence Architect Bill Pearson introduces the MDX Ordinal Function, as a means for generating lists and for conditionally presenting calculations. He also demonstrates the use of the function in creating datasets to support report parameter picklists.  Read more...
By Bill Pearson 2017/11/15 (first published: 2011/02/17) | Source: SQLServerCentral.com | Category: mdx
Rating: |  Discuss |   Briefcase | 16,779 reads

Free eBook: Inside the SQL Server Query Optimizer

This free eBook from Redgate Software will take you from the fundamentals of Statistics, Cost Estimation, Index Selection, and the Execution Engine, and guide you through the inner workings of the Query Optimization process, and throws in a pragmatic look at Parameterization and Hints along the way.  Read more...
By Press Release 2017/11/15 (first published: 2012/12/11) | Source: SQLServerCentral.com | Category: books
Rating:  Rate this |   Briefcase | 31,542 reads

Remembering passwords in SQL Compare and SQL Data Compare

The Redgate SQL Compare team have recently added a feature to automatically populate your SQL Server credentials when you’re using SQL Compare or SQL Data Compare - here are the details of the new feature.  Read more...
By 2017/11/15 | Source: Redgate | Category: sql compare
Rating: (not yet rated)  Rate this |   Briefcase | 1,222 reads

Consuming hierarchical JSON documents in SQL Server using OpenJSON

Over the years, Phil was struck by the problems of reading and writing JSON documents with SQL Server, and wrote several articles on ways of overcoming these problems. Now that SQL Server 2016 onwards has good JSON support, he thought that the articles would be forgotten. Not so, they continue to be popular, so he felt obliged to write about how you can use SQL Server's JSON support to speed the process up.  Read more...
By Additional Articles 2017/11/15 | Source: SimpleTalk | Category: json
Rating: (not yet rated)  Rate this |   Briefcase | 1,706 reads

From the SQLServerCentral Blogs

Getting Query Execution Statistics

If you hate things that are slow, I bet you certainly want to know the reason for the slowness. So,...  Read more...
By Dharmendra Keshari 2017/11/17 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,752 reads

Learning to Give Presentations Well (Part 1)

I’ve given technical presentations for years. I’ve also taught in churches and youth groups years before that. For me, speaking...  Read more...
By Brian Kelley 2017/11/17 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 965 reads
Question of the Day

Adding custom messages

By Steve Jones 2017/11/17 | Category: sys.messages
Rating: (not yet rated) |  Discuss |   Briefcase | 378 reads

In SQL Server 2016, I want to add a custom message. In testing as a serveradmin, I run this code. What happens?

EXEC sys.sp_addmessage @msgnum = 50000,
@severity = 10,
@msgtext = N'This is... 
Top Members (last 30 days)
# Name Score Level
30 days All-time
47521 460560 SSC Guru  
Jeff Moden
45668 424309 SSC Guru  
Steve Jones - SSC Editor
28633 276977 SSC Guru  
Grant Fritchey
20621 182768 SSC Guru  
Lynn Pettis
19276 186431 SSC Guru  
Latest forum posts