2001-11-16
2,505 reads
2001-11-16
2,505 reads
In this view, Steve thinks that certifications are invaluable (especially in this economy).
2001-11-13
3,422 reads
A new series on SQL Server Central - Two of our regular columnists take opposing looks at certification. In our first of the series, Steve Jones takes on Andy Warren in a certification debate.
2001-11-12
139 reads
A brief description of some well known, and not so well known programming languages. Have you worked with any of these?
2001-11-09
2,982 reads
Continuing with Andy Warren's series on Worst Practices for a DBA, Steve Jones joins in this week with his worst practice.
2001-11-06
7,246 reads
Steve Jones presents his case for why certifications should be required. Read this and the counter point article by Andy Warren to hear the other side of this argument - then post your comments
2001-11-04
5,623 reads
This stored procedure performs a full backup on all databases on a server. It takes a parameter for a drive letter and will create the backup structure as needed. The standard backup structure is "\mssql\backup\".
2001-10-22
560 reads
Running a script automatically from SQL Server is easier than you think. Here are a few methods you can use.
2001-10-17
17,130 reads
2001-10-15
1,861 reads
Total SQL Analyzer is a new product that can help document your SQL Server. This review examines the product and some of it's features.
2001-10-10
8,167 reads
By Zikato
TSQL ScriptDOM is a useful library for parsing scripts into an abstract syntax tree....
By DataOnWheels
Over the past few months, I have debated starting a new blog to discuss...
By Steve Jones
It’s that time of the month again, and once again, I’m late and I’m...
So folks we have around 30/40 sql server failover cluster insatnce with each having...
Hello, How to add a UNIX_TIMESTAMP at my publish_date please CREATE TABLE [dbo].[latest_info]( [id]...
hi, need to known weather fast farwand cursor is faster than a while loop...
I run this code on SQL Server 2022 to get a list of all the indexes and their key columns. What is returned?
SELECT
INDEX_COL (N'AdventureWorks2017.Sales.SalesOrderDetail') See possible answers