User-defined Data Type Basics
This article discusses an often-overlooked feature of SQL Server called user-defined data types.
SQL LiteSpeed - Lightning Fast Backups
A look at a fantastic new backup product from DBAssociates. This is the only 3rd party backup product that I would use or recommend.
Building a Demo Server - Part 2
Everyone does demos. You need them to sell your software, but the demo server presents some challenges. Continuing this series, this article looks at moving data between servers.
Setting a Default Database for your Logins
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!
How Safe are Your Passwords?
How safe are your SQL passwords? Use these free tools to find out how secure your passwords are and generate more secure passwords.
Utilizing fn_virtualfilestats
In this example, we will attempt to get some statistical information on file-group utilization to assist us with IO monitoring.
Comments on PASS Community Summit 2002
Andy attended the recent PASS Community Summit and had a great time. Read some of the highlights from his perspective and maybe decide that you'll want to attend next year!
Pro Developer: Improving Your Career In Any Economy
Like many other areas of business, the tech industry has weathered the occasional slump over the past few decades. It's only natural that the fate of techies is closely linked to the tides of the business. However, in any economy, weak or strong, some people prosper and advance while others suffer the consequences.
Review of Developing Windows Based Applications for VB.Net and C#.Net
Andy talks briefly about why the company he works for has decided to require all developers to obtain the MCSD, then takes a look at the book they chose for the initial round of study for the first exam.
Blogs
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Forums
Microsoft Security Changes and SQL Server
Comments posted to this topic are about the item Microsoft Security Changes and SQL...
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Downtime Caused by the Postgres Transaction ID Wraparound Problem
Comments posted to this topic are about the item Downtime Caused by the Postgres...
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers