The Term 'Big Data' is nothing more than a fad, and we'll soon be cringing with embarrassment at the thought that we ever used it. However, the data, and the challenges to processing it that it presents, will stay with us. If jargon like 'Big Data' helps us focus on the problems, then let’s use it: temporarily, perhaps.
2012-05-07
3,718 reads
Red Gate Software has released SQL Backup Pro 7 with pioneering new features focused on SQL Server backup verification. SQL Backup Pro 7’s step-by-step scheduling wizards aim to simplify the process of restoring and verifying backups.
2012-05-04
752 reads
With SSIS, you can perform a lookup on data in the course of a task, using referenced data from any OLE DB source. It is a useful feature that enables you to check on the validity of data, or interpret it before proceeding. Robert Sheldon explains.
2012-05-04
3,260 reads
The 2012 Exceptional DBA awards are back. Learn how you can enter and win a trip to the 2012 PASS Summit.
2012-05-03
719 reads
Chuck Hoffman shows a technique using sets for selecting records from hierarchies such as Manager / Employee structures.
2012-05-03
9,727 reads
SQL Server 2012 introduces three new built-in conversion functions: PARSE, TRY_ PARSE, and TRY_CONVERT. These functions were introduced to be more familiar to users of expression languages. They perform a subset of the functionality of the pre-existing conversion functions. This article will introduce these three new functions and their usage.
2012-05-03
3,858 reads
This article gives 20 tips how to modify MySQL views to make it compatible with Microsoft SQL Server.
2012-05-02
4,078 reads
The FileTable feature of SQL Server 2012 is an enhancement to the FILESTREAM feature which was introduced in SQL Server 2008. In this tip we will take a look at how to use FileTable feature of SQL Server 2012.
2012-05-02
5,245 reads
How to setup and use Central Management Server to manage a disperse environment.
2012-04-30
9,867 reads
SQL Server Reporting Services provides several ways to analyze data; one of them is creating Chart reports. Arshad Ali demonstrates how to create, modifying and beautifying the chart report quickly and easily.
2012-04-30
4,053 reads
By Steve Jones
Another of our values: The facing page has this quote: “We admire people who...
By Ed Elliott
Running tSQLt unit tests is great from Visual Studio but my development workflow...
By James Serra
I remember a meeting where a client’s CEO leaned in and asked me, “So,...
Hi, We have low latency high volume system. I have a table having 3...
Comments posted to this topic are about the item The Long Name
Comments posted to this topic are about the item Eight Minutes
I run this code to create a table:
When I check the length, I get these results:
A table name is limited to 128 characters. How does this work?