Microsoft Announces a New Security Program
Microsoft has announced a new security program to help system administrators secure their sites. Worth a read.
2001-10-19
4,120 reads
Microsoft has announced a new security program to help system administrators secure their sites. Worth a read.
2001-10-19
4,120 reads
Have you ever experienced a T-SQL query, a stored procedure, view or a trigger returning unexpected results. In this article by Raj Gill, he shows you how ANSI DEFAULTS may be to blame.
2001-10-18
10,775 reads
Microsoft has announced a new certification for system administrators. This is below an MCSE, but includes an elective which may be SQL Server.
2001-10-18
1,223 reads
Alexander Chigrik presents a few UDFs he has developed for getting meta data about your database objects.
2001-10-17
4,093 reads
Running a script automatically from SQL Server is easier than you think. Here are a few methods you can use.
2001-10-17
16,796 reads
2001-10-15
3,964 reads
2001-10-15
1,860 reads
2001-10-12
3,567 reads
This article covers some of the common issues and questions when you cluster SQL Server 2000 and Windows 2000.
2001-10-11
13,607 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,160 reads
By James Serra
There are three Azure SQL products with so many different deployment options, service tiers,...
By Steve Jones
I hosted this month’s T-SQL Tuesday party with my invitation asking about tracking permissions....
By Steve Jones
I was asked to do some a little thinking and brainstorming recently. Rather than...
Hi, Does anyone have experience with MEMORYBROKER_FOR_RESERVE ? when suddenly there is somehow constantly...
I just learned that my database was created on my C:\ drive in the...
I am needing to migrate a MSSQL db to MySQL, on a different server...
I have a complex database with a few filegroups and files. Can I run a backup command like this? (assume file/filegroup names are valid).
BACKUP DATABASE [complex] FILE = N'thirdone' , FILE = N'thirdtwo' , FILEGROUP = N'second' TO DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL16.SQL2022\MSSQL\Backup\complex.bak' WITH NOFORMAT, NOINIT, NAME = N'complex-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10 GOSee possible answers