What Specification Server Should I Buy?
Simon Sabin is always cagey about giving advice on the sort of hardware to run SQL Server on, but admits to some general rules.
Simon Sabin is always cagey about giving advice on the sort of hardware to run SQL Server on, but admits to some general rules.
When IT starts to stand for 'Implement This', even the keenest DBA begins to dream of farming Alpacas as a career-change...and we ask our readers how they would have solved the DBA's dilemma.
There are some issues associated with managing identity columns with replication in your SQL Server database. As with previous releases of software, SQL Server 2005 requires that database administrators use special care when replicating tables with identity columns.
While SQL Server's Profiler is a great tool, it can be hard to work with and we can easily miss information in the results. New author Solomon Rutzky brings us a short article that can help you to better configure your traces to get the information you need.
A primary objective of any analytic architecture is business enablement - the ability to provide business users with access to quality information that can be used to drive decision-making.
This article series features a demo app affectionately named Something Not Entirely Unlike Access, which employs a variety of methods to obfuscate the "Accessian" features.
The sixth installment of the XML Workshop for SQL Server shows how the XML Schemas fit into the XML subsystem. Regular author Jacob Sebastian brings structure to your XML documents with a few schema examples.
Part 6 of "Microsoft Windows PowerShell and SQL Server 2005 SMO" illustrates how to use PowerShell and PowerShell script to backup databases.
BI Architect Bill Pearson begins a three-part sub-series on Caching Options within Reporting Services 2005. In this article, we focus upon Report Session Caching.
Reporting Services makes building rich reports easy, including images and fancy layouts, with a nice wizard. But adding in background images is a little more complex and Andy Warren brings us a quick tutorial for SQL Server 2005's Reporting Services
By Brian Kelley
In information security (INFOSEC), there several foundational concepts and principles. One of the ones...
By Steve Jones
the standard blues– n. the dispiriting awareness that the twists and turns of your...
By Chris Yates
A brief introduction to the tool and its advantages for database migrations DevOps is...
Comments posted to this topic are about the item One more reason to use...
I'm tracing activity on one database and would like to include the client_app_name in...
select Custno, Addr1, City, Res_Phone, Bus_Phone, Fax_Phone, Marine_Phone, Pager_Phone, Other_Phone, email1, email2 from customer...
I want to mark a transaction in the log as a recovery point. How do I do this in my code if I use the transaction, myTran?
See possible answers