Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,738,038 DBAs, developers and SQL Server users

Rss
Headlines today   July 24, 2014

Columnstore Index Changes in SQL Server 2014

SQL Server 2012 introduced columnstore indexes, which can immensely improve the performance of OLAP queries. How were they updated and improved in SQL Server 2014?  Read more...
By Edward Pollack 2014/07/24 | Source: SQLServerCentral.com | Category: columnstore indexes
Rating: |  Discuss |   Briefcase | 2,460 reads

Restoring the SQL Server Master Database Even Without a Backup

Many DBAs back up their user databases, but not their system databases. Whatever the reason for the lack of a backup, John Grover explains how to save yourself (mostly) should you ever find yourself with no viable master database and no good backup.  Read more...
By Additional Articles 2014/07/24 | Source: MSSQLTips.com | Category: restore database
Rating: (not yet rated)  Rate this |   Briefcase | 5,007 reads

SQL in the City Workshop - Continuous Integration Stairway

Red Gate’s running a half-day training workshop at their UK head office in Cambridge on Aug 8. It’ll show you how to link your database source control repository to your build system as the starting point for continuous integration.   Read more...
By Additional Articles 2014/07/24 | Source: SQL in the City | Category: events
Rating: (not yet rated)  Rate this |   Briefcase | 3,759 reads
Previous headlines

Stairway to T-SQL: Beyond The Basics Level 9: Dynamic T-SQL Code

There times when you need to write T-SQL code that creates specific T-SQL Code and executes it. When you do this you are creating dynamic T-SQL code. When writing dynamic T-SQL you need to understand how dynamic code opens the possibilities for a SQL injection attack.  Read more...
By Gregory Larsen 2014/07/23 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 4,731 reads

Free eBook: Performance Tuning with SQL Server Dynamic Management Views

Dynamic Management Views (DMVs) are a significant and valuable addition to the DBA's troubleshooting armory, laying bare previously unavailable information regarding the under-the-covers activity of your database sessions and transactions.  Read more...
By Additional Articles 2014/07/23 (first published: 2013/08/21) | Source: Red-Gate | Category: performance tuning
Rating:  Rate this |   Briefcase | 23,734 reads

Calculating and Verifying Check Digits in T-SQL

A lot of numbers that we use everyday such as Bank Card numbers, Identification numbers, and ISBN codes, have check digits. As part of the routine data cleansing of such codes we must check that the code is valid- but do we? Dwain Camps shows how it can be done in SQL in such a way that it could even be used in a constraint, and keep bad data out of the database.  Read more...
By Additional Articles 2014/07/23 | Source: SimpleTalk | Category: calculation
Rating: (not yet rated)  Rate this |   Briefcase | 6,693 reads

SQL-only ETL using a bulk insert into a temporary table (SQL Spackle)

This article demonstrates a method of importing a data file directly into a temporary table and selectively inserting data from the temporary table into a SQL Server table, all in a single set of SQL commands.  Read more...
By Stan Kulp 2014/07/22 | Source: SQLServerCentral.com | Category: bulk insert
Rating: |  Discuss |   Briefcase | 5,703 reads

Is Source Control Really That Boring?

The SSC team has put together a little quiz on database source control to go with Rob Richardson, Robert Sheldon, and Tony Davis' new book, SQL Server Source Control Basics. Do you daydream about source control... or daydream to avoid it?  Read more...
By Additional Articles 2014/07/22 | Source: SQLServerCentral.com | Category: survey
Rating: |  Discuss |   Briefcase | 1,276 reads

Traits of a DBA - Part Two – The Personal Side of a DBA

A good DBA needs to have good technical skills but he also has to have good personal skills. In this article, Greg Larsen discusses the personal skills a DBA should have.  Read more...
By Additional Articles 2014/07/22 | Source: Database Journal | Category: dba basics
Rating:  Rate this |   Briefcase | 7,699 reads

Data Mining: Part 12 DMX for Data Mining

In this lesson we will learn the basics of DMX and create some samples.  Read more...
By Daniel Calbimonte 2014/07/21 | Source: SQLServerCentral.com | Category: data
Rating: |  Discuss |   Briefcase | 1,287 reads
 
Ask SQL Server Central



From the SQLServerCentral Blogs

T-SQL Window Functions – Part 4: Analytic Functions

This is a reprint with some revisions of a series I originally published on LessThanDot. You can find the links...  Read more...
By DataOnWheels 2014/07/24 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 4,812 reads

Quick Tips–SQL Prompt Aliases for Every Table

I love SQL Prompt, and think it’s a great productivity tool. Even before I worked at Red Gate, I love...  Read more...
By Steve Jones 2014/07/24 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 4,152 reads
Question of the Day

Exit Stage Right

By Dave 2014/07/24 | Category: data warehousing
Rating: (not yet rated) |  Discuss |   Briefcase | 676 reads

Evaluate the following statement and choose the most correct answer:


The staging process for importing data with Master Data Services (MDS) in SQL Server 2014 has changed since 2008 R2....  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
vpriya132
520 681 SSChasing Mays  
2.
cruice
427 427 SSC-Addicted  
3.
Shakeel Ahmed Ansari
338 588 Mr or Mrs. 500  
4.
BWFC
313 890 SSC Eights!  
5.
GilaMonster
280 42443 SSC-Forever  
Latest forum posts