SMO is a very useful way of automating a wide range of routine database jobs, but Phil Factor laments Microsoft's apparent ambivalence towards the technology, including a lack of anything remotely resembling adequate documentation.
Today we have a guest editorial from Andy Warren that looks at stress and how it impacts your job. He offers a few ways that you might better deal with it as well.
This challenge invites you to identify the longest sequence of alphabets from a string.
How to incorporate data mining directly into the Data Flow of SQL Server 2008 R2 Integration Services-based packages.
This article demonstrates basic VB.NET code that will enable SSIS package developers to write useful custom SSIS script tasks.
This editorial was originally published on Jan 11, 2007 and is being re-run as Steve is on vacation. A fun poll today asking what you like to eat at work.
SQL Server is used to support many applications and one such feature of most applications is the storage of passwords. Sometimes there is a need to reset a password using a temporary password or generate a random password for a new user. In this tip I cover a simple stored procedure to generate random passwords that can be incorporated into your applications.
This article will help to get some basic information from your databases that may help you in different situations.
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?