Are you a new SQL Server administrator? A network admin or developer who got the responsibility for a SQL Server dropped on your head? Steve Jones starts a new series looking at a few of the things that you might want to know if you've never worked with SQL Server before.
2004-04-15
19,741 reads
Good enough for your bookshelf? This one meets that requirement for Brian, click the link to find out why.
2004-04-13
8,904 reads
According to this article Mangione will be working on security products. Paul Flessner and several other managers will take over the SQL team.
2004-04-13
69 reads
Leo reviews a new product as a follow up to his recent article about Monitoring Failed Job Steps.
2004-04-12
4,443 reads
This article shows some options to retrieve all the metadata you'll need to write scripts that write scripts. No, that's not a goof, this article is about code generation.
2004-04-09
8,670 reads
Probably not a task you'll have to do very often, all the better that someone has laid out how to do it in good detail!
2004-04-08
9,875 reads
If you are (or want to be) a power user, this book should be on your shelf. How many books have you read that have you using a debugger to step into the sql server process? James gives it a thumbs up!
2004-04-07
6,638 reads
In this article by Steve Jones, he shows you how to manipulate strings.
2004-04-05
17,704 reads
One of the strengths of Visual Studio .NET is its features for rapid application development, or prototyping. If, for example, you want to develop a Windows form that lets you maintain the data in one table of a database, you can usually do that in 20 minutes or less. This article will show you how.
2004-04-01
291 reads
Do you have the need for more speed on your servers? How do you go about squeezing more speed out of the database when faced with an upgrade? Steve Jones walks through some of his thought process when looking at ugprade for one of his servers.
2004-03-30
6,474 reads
By John
Recently, the world was reminded of just how fragile the internet can be. Two...
By Brian Kelley
In Parts 1-3, I covered how I prepare for a certification exam. In this...
By Steve Jones
I was chatting with the product managers at Flyway and one asked me whether...
I have a view where I am casting a datetimeoffset(7) field to smalldatetime or...
hi for the 2 years i've been here I believe we've had "encryption" turned...
Hi I have an overnight process that moves allot of claims records Been working...
In SQL Server 2025, what does this return?
DECLARE @player varchar(20) = 'Bo Nix', @num VARCHAR = '10' SELECT @player || @numSee possible answers