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

Rss
Headlines today   November 21, 2017

DBAs and the ITIL Framework, Part II: Asset Management

See how the ITIL Framework's Asset Management standards make the DBA's job easier. Use the CMDB and DML to keep your data assets under tight control.  Read more...
By John F. Tamburo 2017/11/21 | Source: SQLServerCentral.com | Category: itil
Rating: |  Discuss |   Briefcase | 392 reads

Preparing your data platform for peak period sales

In the last few years, Black Friday and Cyber Monday have become synonymous with both getting a good bargain and causing retail pandemonium. So how can you prepare your data platform for the increase in traffic?  Read more...
By 2017/11/21 | Source: Redgate | Category: data platform
Rating: (not yet rated)  Rate this |   Briefcase | 893 reads

More SQL Server Features that Time Forgot

SQL Server produces some great features, but it would be impossible to get them spot-on target every time. We are now quietly advised to use caution about using some of them, such as AutoShrink or the Index Advisor. Others, like the database diagramming tool, almost seem to have been quietly abandoned. Robert Sheldon investigates.  Read more...
By Additional Articles 2017/11/21 | Source: SimpleTalk | Category: sql server
Rating: (not yet rated)  Rate this |   Briefcase | 2,330 reads
Previous headlines

Automatic Plan Correction

SQL Server 2017 lets you solve parameter sniffing problems - Automatically!  Read more...
Rating: |  Discuss |   Briefcase | 141 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 | 752 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 | 770 reads

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,682 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 | 2,133 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 | 2,215 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 | 418 reads
 

From the SQLServerCentral Blogs

Power BI Custom Visuals Class (Module 76 – Image Timeline)

In this module you will learn how to use the Image Timeline Custom Visual.  The Image Timeline is a great...  Read more...
By Devin Knight 2017/11/21 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 768 reads

Launching SQL Server on Linux in Single User Mode

There was a question this morning on the SQL Server Community Slack channel from SvenLowry about how to launch SQL...  Read more...
By Anthony Nocentino 2017/11/21 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 642 reads
Question of the Day

CHECKSUM() and NULL

By Thomas Franz 2017/11/21 | Category: checksum
Rating: (not yet rated) |  Discuss |   Briefcase | 426 reads

What will the following query return:


SELECT CHECKSUM(x) chk_x,
CHECKSUM(y) chk_y,
CHECKSUM(z) chk_z
FROM (VALUES (CAST(NULL AS INT),
CAST(NULL AS VARCHAR(10)),
CAST(NULL AS DATETIME))
) sub (x, y, z)  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
GilaMonster
50519 467719 SSC Guru  
2.
Jeff Moden
48291 431008 SSC Guru  
3.
Steve Jones - SSC Editor
30522 281294 SSC Guru  
4.
Grant Fritchey
21740 185978 SSC Guru  
5.
Lynn Pettis
20561 189392 SSC Guru  
Latest forum posts