Should IT managers understand technical issues, or is a full appreciation of the technology somehow unworthy and unnecessary for senior staff? In such a rapidly changing industry where fortunes are made and lost by attempting to exploit gaps in the market too thin to see with the naked eye, the answer would seem obvious. However, I have repeatedly come across amazing gaps in the technical knowledge of managers.
2006-05-31
2,425 reads
This is a good explanation on how to acctually bill a customer for your service over a credit card in your web application.
2006-05-26
2,841 reads
2006-05-22
2,852 reads
Drops the specified column from the specified table as well as any constraints that depend on the column. By default the script will just find the corresponding column and constraints.Comes in handy for patching databases.
2006-11-29 (first published: 2006-05-17)
978 reads
For many of us, working with the identity property allows us to easily generate a sequential series of numbers. But what if you need to generate a sequence according to some pattern, like one that includes the year? New author Asif Sayed brings us a technique and the code for generating a patterned sequence.
2006-05-17
9,057 reads
Person name may have these combination in database1. firstname only2. middlename only3. lastname only4. firstname + middlename5. firstname + lastname6. middlename + lastnameAnd firstname, middlename, lastname may contain null or empty string in data. but usee want to display Fullname without spaces then how will combine all.
2007-06-28 (first published: 2006-05-15)
1,176 reads
One of the hard parts of being a consultant, either full time or after hours for extra money, is finding a job. SQLServerCentral.com has a new partner that can help you solve this problem, find a job, and maybe a new career.
2006-05-15
5,050 reads
As many of you know, data driven subscriptions is not a feature available with SQL 2000 RS Standard Edition. However, you can accomplish this using the supplied stored procedure. It may not be as pretty as the version in SQL Enterprise, but this one gets the job done, and it is very ……useful!I have not […]
2006-11-13 (first published: 2006-05-11)
622 reads
2006-11-14 (first published: 2006-05-08)
103 reads
This is the basic structure of how to dynamically create a pivot table recordset for SQL 2000. In this example, I am using SUM, but it could just as easy be COUNT or any other aggregate function.
2006-05-26 (first published: 2006-05-08)
1,882 reads
It’s that time of year again! EightKB is back on August 20th at 13:00...
By Steve Jones
I got a notification from a question I’d posted at SQL Server Central: Getting...
By SQLPals
SQL Server sa Account Security: Rename, Disable & Best Practices In...
Comments posted to this topic are about the item Are You Working More Hours?
Comments posted to this topic are about the item Stairway to Reliable Database Deployments...
Comments posted to this topic are about the item A Limited Startup
I add this parameter to SQL Server 2025 in the Configuration Manager:
-mDynamicsWhat does this do? See possible answers