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,737,797 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 | 486 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 | 1,238 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 | 1,029 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,279 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 | 22,732 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 | 5,617 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,176 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,173 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 | 6,735 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,230 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 | 1,159 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 | 1,051 reads
Question of the Day

Exit Stage Right

By Dave 2014/07/24 | Category: data warehousing
Rating: (not yet rated) |  Discuss |   Briefcase | 121 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
519 680 SSChasing Mays  
2.
cruice
390 390 Old Hand  
3.
Shakeel Ahmed Ansari
322 568 Mr or Mrs. 500  
4.
BWFC
313 890 SSC Eights!  
5.
GilaMonster
279 42437 SSC-Forever  
Latest forum posts