Article number four in this popular series continues exposing Worst Practices! This week Andy continues his tirade by talking about why case sensitive databases should be BANNED from the planet. Is he right or just OUT OF CONTROL? Read the article and join the discussion - your comment may lead to an article, that's what generated this one!
2005-07-08 (first published: 2001-10-29)
29,254 reads
Version control of stored procedures is not exactly a SQL Server 2000 strong point. In fact, it is downright abysmal and there have been lots of ideas and solutions put forth to solve the problem. Andy Warren brings us a new one that's small and lightweight and may help you after getting inspired at TechEd 2005.
2005-06-17
12,767 reads
Our own Andy Warren recently spent a week in Santa Clara at the Software Development Magazine's SExpo 05. He shares a few notes on the experience. This conference is for all platforms and might be something for you if you are a software developer.
2005-05-05
3,297 reads
Do you use the maintenance plans or hate them? Wish they would do more? Curious about how they work under the hood? Cmon, you gotta read this one! Trust us, it's not another "how-to" article! Well, maybe just a little bit!
2005-03-04 (first published: 2002-04-11)
34,061 reads
Andy Warren takes a look at SQLCompare, a tool that lets you compare two SQL databases and create a script to synchronize the differences.
2005-01-14 (first published: 2001-06-06)
16,241 reads
2004-12-01
1,388 reads
2004-11-24
1,271 reads
Andy started a contest this summer to see who could develop a T-SQL method of keeping a bowling score. He's finally gotten around to the results after the damage from the hurricanes was cleaned up. See who won and see the code that does the trick.
2004-11-19
5,925 reads
2004-11-16
1,411 reads
2004-11-08
1,586 reads
By HeyMo0sh
Learning any kind of theory is easy, but adapting FinOps and watching it rescue...
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
Comments posted to this topic are about the item The day-to-day pressures of a...
Comments posted to this topic are about the item The Problem Isn't Always Your...
Comments posted to this topic are about the item Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers