When you are using SSIS, there soon comes a time when you are confronted with having to do a tricky task such as searching for particular connection strings in all your SSIS packages, or checking the execution history of scheduled SSIS jobs. You can do this type of work effectively in T-SQL as Feodor Georgiev explains.
2012-03-02
2,397 reads
How to change the port number for connections to SQL Server.
2012-03-01
13,650 reads
In this tip we cover what CONTROL SERVER is, how to detect its use and a possible way to exploit this permission.
2012-03-01
2,469 reads
SQL Server 2012 brings new security enhancements, one of which is to create user defined server roles, which simplifies instance wide administration and helps to increase the security of the instance by letting you define different groups with different sets of permissions as per their role and responsibilities.
2012-02-29
3,032 reads
How to grant Windows privileges to the SQL Server's service account.
2012-02-28
8,633 reads
2012-02-28 (first published: 2010-10-20)
9,599 reads
Phil Factor demonstrates how to generate T-SQL scripts for databases, selected database objects, or table contents from PowerShell and SMO.
2012-02-28
3,400 reads
Distributed queries on linked servers are not the greatest idea from a performance standpoint, but they can be quite useful.
2012-02-27
23,277 reads
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.
2012-02-27
3,196 reads
Come to a free day of training on Mar 3, 2012 in Mountain View, CA
2012-02-27
1,360 reads
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?