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

Rss
Headlines today   July 23, 2014

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: (not yet rated) |  Discuss |   Briefcase | 1,645 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 | 19,059 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 | 1,919 reads
Previous headlines

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 | 2,735 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: (not yet rated) |  Discuss |   Briefcase | 745 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 | 3,792 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,149 reads

13 Questions about SQL Server Data Types You were Too Shy to Ask

Although SQL Data Types seem to cause a lot of grief for database developers and can be tricky in their use, we seem to be expected to know all about them, and so it is embarrassing to ask questions about them in forums. Rob Sheldon continues in his mission to answer all those questions that we hesitate to ask.  Read more...
By Additional Articles 2014/07/21 | Source: SimpleTalk | Category: data types
Rating:  Rate this |   Briefcase | 8,914 reads

SQL in the City: Save the Date

SQL in the City is coming back to London and Seattle in 2014. The London event will take place on October 24 (before Tech Ed Europe) and in Seattle on November 3 (before PASS Summit). Keep an eye on the event website and @redgate for updates.  Read more...
By Press Release 2014/07/21 | Source: SQL in the City | Category: events
Rating: (not yet rated)  Rate this |   Briefcase | 6,363 reads

Stairway to XML: Level 2 - The XML Data Type

Robert Sheldon describes SQL Server's XML Data Type, and shows that it is as easy to configure a variable, column, or parameter with the XML data type as configuring one of these objects with any other datatype  Read more...
By Rob Sheldon 2014/07/18 (first published: 2012/09/26) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 12,383 reads
 
Ask SQL Server Central



From the SQLServerCentral Blogs

5 Tips for Finding SQL Server System Data

Regardless of the type of development (application or reporting) that you are performing on SQL Server.  There are 5 items...  Read more...
By derekwilson74 2014/07/23 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,595 reads
Question of the Day

Collation, Unicode & Joins

By Sean Pearce 2014/07/23 | Category: tsql
Rating: (not yet rated) |  Discuss |   Briefcase | 393 reads

What will the following query return? 


SELECT
COUNT(*) AS Result
FROM
sys.databases d1
INNER JOIN
sys.databases d2
ON UNICODE(CAST(d1.name AS VARCHAR(255)) COLLATE Latin1_General_CS_AS) = UNICODE(CAST(d2.name AS NVARCHAR(255)) COLLATE SQL_Latin1_General_CP850_BIN)
WHERE
d1.database_id <= 4
AND d2.database_id <= 4;
  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
vpriya132
526 680 SSChasing Mays  
2.
cruice
342 342 Old Hand  
3.
BWFC
317 890 SSC Eights!  
4.
Shakeel Ahmed Ansari
311 553 Mr or Mrs. 500  
5.
GilaMonster
280 42434 SSC-Forever  
Latest forum posts