TSQL Virus or Bomb?
Joseph discusses some common and not so common security threats including the possibility of a TSQL virus and bombs planted from within the organization.
2003-12-29
5,833 reads
Articles
Yukon News
This article on CNET has some info about how Yukon affects the MS strategy in other areas.
2003-12-29
3,447 reads
Review of MySQL/PHP Database Applications
We haven't had a book review in a while and this one may not be of interest to all of you, but we decided to take a chance and post it anyway! As Andy notes in the review, odds are that you'll deal with one or both of these applications sooner or later, might be worth thinking about taking a look at what they can do. (Reviewed)
2003-12-26
3,370 reads
Automatically Gathering Server Information Part 2
The second part of Steve Jones's series on having SQL Server automatically report information to a DBA.
2003-12-25
13,197 reads
Automatically Gathering Server Information Part 1
The first part of Steve Jones's series on having SQL Server automatically report information to a DBA.
2003-12-24
16,065 reads
Using WMI
Get started with using WMI (Windows Mgmt Instrumentation) by seeing two good scripts to start with, one to reboot the server, another to list all the services.
2003-12-23
10,023 reads
Date Time Values and Time Zones
Dinesh looks at the date functions, how to work with time zones (or not), and does a brief comparison to see how you do similar tasks in Oracle.
2003-12-22
15,266 reads
Dealing With Changing Data
As Chris points out, in most applications these days you end up having to go with optimistic locking, which presents a few challenges. Chris works through the list of options. If you're building web/disconnected apps and need anything besides last update wins, this one is for you.
2003-12-19
9,490 reads
Finding Real Dependencies
Sysdepends is a neat idea, but in practice it's not always accurate. This article talks about why it's not always reliable and presents some code (recursive even!) that will let you find all the dependencies by querying the system tables.
2003-12-18
9,464 reads
Two Best Practices!
This article presents two best practices. One is about how to construct good table aliases, the other is about using ANSI join syntax. Good stuff!
2003-12-17
10,858 reads
Blogs
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
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,...
Forums
Backup to Immutable Storage
Comments posted to this topic are about the item Backup to Immutable Storage
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
Question of the Day
Backup to Immutable Storage
In SQL Server 2025, a backup can be made on Azure Immutable Storage. What changes in how the backup is created?
See possible answers