In bringing the SQLServerCentral.com training center online, one of the challenges Andy Warren faced was developing an automated way to install software. Here we see some of the gotchas and difficulties that you might encounter as well with unattended installations of SQL Server.
2006-08-10
11,499 reads
Not many people enjoy using Globally Unique Identifiers (GUIDs), partly because they are cumbersome to type and work with for humans. However they fill a need and can provide some interesting benefits. SQL Server expert Andy Warren takes us through what a GUID is and how you can use it easily in your code.
2006-07-27
16,336 reads
How much time do you spend developing your career? Are you actively looking to improve your professional skills? Andy Warren takes a look at how you can focus yourself and a few ideas for your employer as well.
2006-07-11
7,185 reads
SQL Server guru Andy Warren has been working with all aspects of SQL Server for many years and is slowly upgrading his skills to SQL Server 2005. Here he takes a look at SMO basics, which is the replacement for DMO.
2006-06-28
10,395 reads
Attaching and detaching databases is old hat these days right? Do you know how to reattach a database that has more than 16 files? Or do you know what happens if you try to reattach a database that had two log files but one is missing/deleted? And even if you know the answer to that - do you know how to fix it without restoring from backup? Maybe it's not ALL old hat just yet!
2006-06-23 (first published: 2002-04-05)
24,233 reads
Part 1 of a 4 part series about ADO, this is a beginner level article designed to get you started using the ADO connection object. If you haven't used ADO so far, why not see what it's all about?
2006-05-26 (first published: 2001-11-08)
31,276 reads
How do you easily copy DTS packages from one server to another? DTS, BCP, T-SQL? Are there advantages to using one method over another? Andy did some research - read the article and see what works and what doesn't!
2006-05-05 (first published: 2002-03-19)
38,159 reads
Replication is a great tool, but it has a number of restrictions on what you can do with replicated databases. Typically you cannot easily move a replicated database, but our own Andy Warren brings us a technique that can get around this.
2006-02-01
15,013 reads
The guys that build software rarely get exposure of credit. Maybe that's why so many of them turn to open source where they get more well known. After a meeting at TechEd 2005, Andy Warren had the chance to get some interesting interview questions answered by Brooke Philpott, one of the 2 core developers of sqlSentry. And not a marketing guy.
2006-01-19
5,766 reads
Access can be a very quick and easy to use tool for working with SQL Server data and for quick and dirty projects, it might be the best tool. But there can be performance issues at times and Andy Warren digs into some of these based on some analysis of what Access does behind the scenes.
2006-01-02
8,158 reads
By Kevin3NF
Everything in SQL Server is waiting for something…this is by design. And most people...
By DataOnWheels
Hey fellow data friends! Wow, March was an absolutely crazy month (in the best...
We value your privacy. This policy explains what personal data we collect and why. What...
Comments posted to this topic are about the item The Subtle Differences Between COALESCE...
Comments posted to this topic are about the item SQL Server Collations
Why would using variables in place of hard coded numbers impact a query's performance? ...
At what levels can we set the collation in SQL Server 2022?
See possible answers