This week we have another article from Andy that discusses some changes he made at work in conjunction with clustering all his database servers. Not a how-to, just comments about what was changed and why. Worth reading just for the reminder about the potential gotcha that @@ServerName can represent.
2003-04-09
6,160 reads
Andy recently implemented a SAN and shares some of the info he picked up during the purchase and implementation. This article also discusses briefly the differences between SAN and NAS, and has some links to other sites for more info as well.
2003-03-28
8,077 reads
Several months ago Andy posted a 'Review of Developing Windows Based Applications for VB.Net and C#.Net' and mentioned that his company was requiring all developers to achieve the MCAD within 12 months. Read this to find out how the first exam went, how they studied, what they achieved, and their plans for taking the rest of the exams.
2003-03-21
7,737 reads
This week Andy looks at where, when, and how jobs should be run and why you need to think about those items before you build the job. Part of this is deciding what runs on production servers and what doesn't.
2003-03-11
7,123 reads
Jobs are pretty basic aren't they? They are until you get a couple hundred, or a thousand. Andy continues talking about managing jobs by standardizing how you handle notifications and failures, and talks about an interesting idea to monitor jobs separately from SQL Agent. Worth reading!
2003-02-14
8,381 reads
How many jobs do you have? 10? 100? 1000? Andy makes the point that what works to manage for a small number of jobs doesn't work when that number doubles or triples (well, unless you only had 1 job to start with!). In part one of two, this article looks at ideas for using categories and naming conventions to get things under control.
2003-01-31
10,497 reads
This one is pretty interesting, Andy discusses a few things he sees in comments that not only fail to add value, they end up costing extra time. There's room for discussion here, but definitely a discussion worth having - comments can make you or break you, here's a chance to think about what you think is important in commenting and pass that on to your development team.
2003-01-23
10,769 reads
Andy had a semi-disaster similar to the one he wrote about last year. Interesting to see the kinds of problems that happen to other people. This article raises some interesting points that are outside the scope of basic disaster recovery, looking at how/when to move databases to a different server and how to reduce the server load dynamically.
2003-01-14
7,050 reads
Are you using default values for your parameters? Using named parameters when you call the proc or passing the values by ordinal? Should you be? Andy thinks 6 out of 10 of our readers will agree with his point of view, we'll be a little more conservative and guess that 5 of out 10 will be closer.
2003-01-08
8,201 reads
Andy discusses reasons why he thinks setting the default database to anything other than master is a mistake. We think he does a good job of covering the pros and cons, read the article and join the discussion!
2002-12-11
9,842 reads
By DataOnWheels
It was awesome to see the Kentucky data community come out for the first...
By Brian Kelley
Tomorrow, April 16, 2024, I will be giving another webcast; this one will be...
By Steve Jones
the wends– n. the frustration that you’re not enjoying an experience as much as...
I am building a report to show customer journeys and their arrears levels. I...
hi, I have seen people use exists when exists is required and no cols...
Hello all, I am thinking of creating a "shopping cart" in our application. My...
Can I create In-Memory OLTP tables in SQL Server Express?
See possible answers