You need to provide data validation at the server level for complex strings like phone numbers, email addresses, etc. You may also need to do data cleanup / standardization before moving it from source to target. Although SQL Server provides a fair number of string functions, the code developed with these built-in functions can become complex and hard to maintain or reuse.
What happens when you have bad IT people working in your company? Steve Jones says that they always will be around, but we might not want to enable them to continue in this business when we find them.
This article provides a practical example of minimizing the growth of a distribution database.
Depending on your anticipated workload and which SQL Server components you have installed, there are a number of instance level...
A free day of training in Denver on Mar 5, 2011. Learn about Windows, .NET, SQL Server, Sharepoint and more. Spread the word to people you know in the area.
Steve Jones talks a little about the 2011 MVP Summit and what the annual event means to the average DBA.
Learn how you can setup Database Mirroring using disparate file paths and drive letters.
Earlier in the month I shared with you 10 Things That Every DBA Should Do and so it only seems natural...
A Thousand Men Marching Still Only March As Fast As One Man.
la·ten·cy - Computers . the time required to locate the first bit or character in a storage location, expressed as access timeminus word time.
Often when talking to people...
To query an Analysis Services cube, MDX is used as the query language. In most business settings, one would find a set of queries that are common across a number of user query requirements. To cater to this, even with a modest size IT team, there is a good chance that the same queries are developed redundantly either within a SSAS MDX script or repetitively in an ad-hoc manner in client applications. In this tip we would look at how to reuse queries without redeveloping them over and over.
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Jl. Komp. Rs. Fatmawati No.1, Cilandak Bar., Kec. Cilandak, Kota Jakarta Selatan, Daerah Khusus...
CSTelpon : 0853-73737551 Jl. Lenteng Agung Raya No.26 E-F, Ps. Minggu, Kota Jakarta Selatan,...
CSTelpon : 0853-73737551 Centennial Tower, Jl. Gatot Subroto No.Kav 24-25 lantai GF unit C,...
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers