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 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 | 342 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 | 675 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,024 reads
Previous headlines

Automatic Plan Correction

SQL Server 2017 lets you solve parameter sniffing problems - Automatically!  Read more...
Rating: |  Discuss |   Briefcase | 135 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 | 691 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 | 697 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,667 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,093 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,149 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 | 414 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 | 659 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 | 480 reads
Question of the Day

CHECKSUM() and NULL

By Thomas Franz 2017/11/21 | Category: checksum
Rating: (not yet rated) |  Discuss |   Briefcase | 368 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
50156 467178 SSC Guru  
2.
Jeff Moden
47994 430456 SSC Guru  
3.
Steve Jones - SSC Editor
30365 280971 SSC Guru  
4.
Grant Fritchey
21581 185693 SSC Guru  
5.
Lynn Pettis
20359 189138 SSC Guru  
Latest forum posts