SQL Server backups are key to recovering from a disaster or some type of data failure, but the real magic happens when the backup is restored. In this tip we look at a new enhancment in SQL Server 2012 for point in time recovery using the new timeline feature.
Come to a free day of training on Mar 3, 2012 in Mountain View, CA
Come to a free day of SQL training on Mar 3 in Tyger Valle, Western Cape in South Africa.
A Friday poll that's a break from work, and should be a bit of fun. Today Steve Jones asks about movies, and what's been interesting from the last year.
Integration Services is one of the more flexible tools available on the SQL Server platform. Jason Brimhall shows us a way to remove old files, either backups or flat files, after a configurable period of time.
There are several aspects that can take a toll on performance for your Analysis Services cubes. Some problems could be related to the source systems, some could be because of poor design of your cube and MDX queries and some could be related to network issues.
What's the benefit of virtual machines and hypervisors? Steve Jones has a few comments on them and their future.
This article will show you how to configure the FTP task in SSIS send files to remote server using the FTP protocol.
With database applications, the process of test and integration can be frustratingly slow because so much of it is based on manual processes. Everyone seems to agree that automation of the process provides the answer to accomodating shorter development cycles, but how, exactly? Dave Green describes a successful process that integrates third-party tools.
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,...
By Brian Kelley
If you want to learn better, pause more in your learning to intentionally review.
Comments posted to this topic are about the item The Long Name
Comments posted to this topic are about the item Eight Minutes
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
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?