Specifically, I needed to parse a zip code (5-digit) from a client comments fields where the number was in different positions such as "Customer 999999999 should be at zip code 99999" and "99999 zipcode" and "should be zip code 99999 phone 9999999999". My stored procedure first filters on a [Comments] field string that contains variations […]
2006-11-08 (first published: 2006-06-13)
518 reads
Commenting seems to be the bane of every programmer, database or otherwise. Sachin Dedhiya brings us a look at brings some standards to how you should comment your code in a SQL Server database.
2006-06-13
7,135 reads
For several times i had faced a problem of having “special” users, that need to create and run their own DTSs. I produced this script after implementing all the steps needed to allow normal users to do and run their DTSs.I hope it will be helpful at least for some of you.
2006-06-23 (first published: 2006-06-12)
295 reads
Backs up the SQL Server EM registration from the registry. Assumes that EM is configured to save common, not by user/independently. I recommend changing EM to Store locally for all users, (not independently) and create a weekly scheduled job to backup the HKLM..\..\Registered Servers X branch.Configure EM to store settings for the local machine, all […]
2006-06-26 (first published: 2006-06-12)
329 reads
SQLServerCentral.com is offering Integration Services training at our new training center. Sign up today and learn from Brian Knight, MVP and SSIS Guru.
2006-06-12
8,560 reads
Use this Perl script to produce an audit report of both share permissions and NTFS permissions of the shared folders. To report share permissions:Use shareperms.pl -p -SMyServer1 to report on a single server.Or use shareperms.pl -p -SMyServer1,MyServer2 for multiple servers.You can also use a text file as input: shareperms.pl -p -CServers.txtTo report NTFS permissions use […]
2006-06-27 (first published: 2006-06-11)
349 reads
Lightweight and adaptable, but with proper emphasis on the design phase, the ICONIX methodology can help you avoid Constant Refactoring After Programming...
2006-06-09
1,977 reads
The following T-SQL query batch will show you which tables was changed since last execute. Tracking information: (1) changes row count /insert,update,delete/; (2) changes IDENTITY value; (3) changes physical allocations /used pages/; (4) added new tables; (5) dropped tables. The batch must be initialized before using (at least once executed). I use this batch to […]
2006-06-12 (first published: 2006-06-08)
759 reads
Training is an important part of anyone's life in technology, especially if you are a SQL Server DBA or developer. With the release of 2005, the entire paradigm of working with SQL Server has changed and you need to be working on your own personal knowledge base. Steve Jones takes a look at how you can get training and shake the funding loose as well.
2006-06-08
7,023 reads
XML is becoming more and more the mainstream for data transfers between systems. Web services and SOAP communications are built into SQL Server 2005, requiring the more and more DBAs understand how to work with XML. Raj Vasant has written a number of articles on XML and brings us a look at how XML should and should not be used.
2006-06-05
9,801 reads
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
By Vinay Thakur
As Open Source – PostgreSQL and AI is a growing and powerful DB system,...
By gbargsley
A New Chapter: Why I Made the Move from Dayforce to ESO Over the...
WA:08218154393 Jl. A. R. Hakim No.2, Mangkukusuman, Kec. Tegal Tim., Kota Tegal, Jawa Tengah...
WA:08218154393 Jl. Pemuda No.28-32, Panggang III, Panggang, Kec. Jepara, Kabupaten Jepara, Jawa Tengah 59411
Comments posted to this topic are about the item How Clustering can be Used...
How can I change the location in which the SQL Server error log is written in SQL Server 2025?
See possible answers