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)
509 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,112 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)
287 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)
321 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,548 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)
332 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)
745 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,018 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,792 reads
By Kevin3NF
In parts 1 and 2 of this series, we’ve gathered info and done the...
By Steve Jones
At SQL Saturday Boston 2025, I gave a presentation on local LLMs and there...
By gbargsley
Are you diversifying your DBA skillset? My recent job search made one thing clear:...
Hi we run 2019 standard. Our warehouse's ssis based etl is klunky but so...
Comments posted to this topic are about the item Unlocking High-Concurrency Inserts in SQL...
Comments posted to this topic are about the item Vector Datatype
The new Vector datatype in SQL Server 2025 is a binary type that has a few parameters. What parameters are required?
See possible answers