Having been at the sharp end of many successful SQL Server solutions, I believe there are some fundamental principles that all successful SQL Server installations have in common. Whilst the challenges in delivering an enterprise-scale database-intensive application can be wide and varied, there are a few basic practises that will give you the best possible chance of success.
2007-04-05
2,570 reads
Here's the scenario: 1. You have been given a script to run.2. You do not know the database name.3. You know which server.Substitute the word "TABLENAME" with the table name in the script and run in query analyzer. This query will check every database on the server and return the name of the database with […]
2007-04-26 (first published: 2007-04-04)
472 reads
Importing data files is always a challenge for a DBA, especially when the files might vary in format. Having one codebase is important and new author Mark Balasundram brings us the template for a high performance application to do just that.
2008-03-13 (first published: 2007-04-04)
17,509 reads
In the previous articles, Jacob Sebastian looked at using XML to save a sales order with variable numbers of line items to a SQL Server
2000 database. In this part, he expands upon the processing to access that data from multiple nodes.
2007-04-03
7,126 reads
Dice.com recently completed a salary survey for 2007. If you didn't participate, Steve Jones summarizes the results for DBAs.
2008-03-24 (first published: 2007-04-03)
10,146 reads
I regularly use SQLIO.EXE to gauge the maximum throughput a disk subsystem can sustain. Recently Microsoft released SQLIOSIM.EXE to provide better results for this type of test. However they didn't release any documentation on the tool and I could never figure out what it was trying to tell me. It looks like they finally did release a Knowledge Base article on SQLIOSIM. Give it a spin. I'd be curious to hear what you think of the tool.
2007-03-30
2,768 reads
In part 2 of this series, Jacob Sebastion continues looking at XML in SQL Server 2000 with some advanced XML processing.
2007-03-29
7,691 reads
The script details about the workaround for using Dynamic SQL inside T-SQL user defined functions. Basically, T-SQL doesn't allow developers to perform/write any actions/statments which would affect the database's state. As a key note factor for any migration process from oracle to sql server developers need to do a work around on using execute immediate(for […]
2007-04-18 (first published: 2007-03-27)
4,030 reads
How many times have you tried to save a sales order to your database? For many DBAs this is a common scenario and one of the challenges is the many round trips for the various line items. Jacob Sebastian brings us the first part of a four part series looking at how you can use XML to reduce the round trips in SQL Server 2000.
2007-03-27
12,872 reads
SQL Server 2005 has greatly expanded the XML capabilities of this platform, but should you use it in your database? New author and
MVP Simon Munro brings us a look at how he has used XML and where it might fit in your database.
2008-03-11 (first published: 2007-03-26)
6,259 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
GO
See possible answers