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

Rss
Headlines today   November 20, 2017

Automatic Plan Correction

SQL Server 2017 lets you solve parameter sniffing problems - Automatically!  Read more...
Rating: |  Discuss |   Briefcase | 71 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 | 381 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 | 353 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,564 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,812 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,842 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 | 401 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,670 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,828 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,797 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 | 175 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 | 392 reads
Question of the Day

Binary Date Conversions

By J. Drew Allen 2017/11/20 | Category: date
Rating: (not yet rated) |  Discuss |   Briefcase | 148 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...  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
GilaMonster
48495 464849 SSC Guru  
2.
Jeff Moden
46703 428397 SSC Guru  
3.
Steve Jones - SSC Editor
29583 279645 SSC Guru  
4.
Grant Fritchey
20977 184664 SSC Guru  
5.
Lynn Pettis
19684 188157 SSC Guru  
Latest forum posts