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

Headlines today   November 20, 2017

Automatic Plan Correction

SQL Server 2017 lets you solve parameter sniffing problems - Automatically!  Read more...
Rating: (not yet rated) |  Discuss |   Briefcase | 43 reads

The real origins of the Agile Manifesto

Many people think the Agile Manifesto was born in in February 2001, when 17 people met at the Snowbird ski resort in Utah. But there’s a problem, a big problem - in fact, one about the size of the USA’s first ever jet fighter. In this blog post, Matt Hilbert looks back to 20th century aircraft design, and finds some very familiar ideas.  Read more...
By 2017/11/20 | Source: Redgate | Category: agile
Rating: (not yet rated)  Rate this |   Briefcase | 282 reads

Importing Historical Stock Prices from Yahoo Finance into SQL Server

Rick Dobson demonstrate a clean end-to-end solution for importing historical stock ticker prices from Yahoo Finance into a SQL Server table using Python.  Read more...
By Additional Articles 2017/11/20 | Source: MSSQLTips.com | Category: python
Rating: (not yet rated)  Rate this |   Briefcase | 261 reads
Previous headlines

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,522 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,748 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,777 reads

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 | 397 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,629 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,784 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,796 reads

From the SQLServerCentral Blogs

Figuring out Time-Out Prone queries

Recently, I was helping one of the community attendees on the SQL Server Query Time-Out issue. Once we are done...  Read more...
By Dharmendra Keshari 2017/11/20 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 162 reads

SQL Server 2017 – Interleaved Execution

I worked on testing interleaved execution with Microsoft back in January, I didn’t do much, just tested the functionality against...  Read more...
By Arun Sirpal 2017/11/20 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 382 reads
Question of the Day

Binary Date Conversions

By J. Drew Allen 2017/11/20 | Category: date
Rating: (not yet rated) |  Discuss |   Briefcase | 89 reads

What results do you get when you run the following query?

DECLARE @holidays TABLE(
holiday DATE,
holidayDatetime AS CAST(holiday as datetime)

INSERT @holidays
VALUES('2017-01-02'), ( '2017-01-16'), ( '2017-05-29'), ( '2017-07-04'), ( '2017-09-04'), ( '2017-11-23'), ( '2017-11-24'), ( '2017-12-25')

SELECT CAST(MAX(CAST(holiday AS... 
Top Members (last 30 days)
# Name Score Level
30 days All-time
48264 464574 SSC Guru  
Jeff Moden
46539 428161 SSC Guru  
Steve Jones - SSC Editor
29459 279491 SSC Guru  
Grant Fritchey
20966 184579 SSC Guru  
Lynn Pettis
19604 188047 SSC Guru  
Latest forum posts