Do you have a need to generate bar codes for an application? Check out this new product, reviewed by Dinesh Asanka, that uses Reporting Services to help you easily print bar codes.
2006-03-09
6,723 reads
One of the lesser used features of SQL Server is the ability to access the functionality in various DLLs using a COM interface. Dinesh Asanka brings us a basic article with a few examples in how you can work with COM components from inside SQL Server 2000.
2005-10-31
12,508 reads
How many times have you wished you could throttle the CPU use of SQL Server? Or for a database? Prevent your developers from using too many resources while sharing the server with production or QA. ArmTech for Windows can do this and Dinsesh Asanka brings us a review of how this product worked in his environment.
2005-07-26
5,476 reads
SQL Server can support many different languages through Unicode. Author Dinesh Asanka brings us a basic article on how the server supports different languages.
2005-07-04
14,442 reads
SQL Server 2000 has an amazing ETL tool in Data Transformation Services that is included at no charge, something none of the other database vendors include. DTS has great flexibility to make your job easier, but it has some quirks in this version. The Multi Phase Data Pump is hidden inside the tool, but can provide a great programming environment and Dinesh Asanka brings us a look at what you can do wit this tool.
2005-03-29
11,992 reads
SQL Server and Access are usually linked together as Access used for applications at the beginning of their lifecycle that are later moved to SQL Server when the load gets too high or the data sizes grow. There are often cases where you may also want to use SQL Server as a backend to an Access application. But how do you get your data from Access to SQL Server? Author Dinesh Asanka brings us an overview of the various ways that you can move your Access database to SQL Server.
2005-02-21
16,924 reads
On this site, we have taken a contrarian approach to looking at the ways to configure SQL Server with our Worst Practices series. However Microsoft still looks at it from the other side and release a tool called the Best Practices Analyzer for SQL Server. Author Dinesh Asanka brings us a short look at this tool.
2004-11-11
12,622 reads
Auditing in SQL Server is something that is becoming more and more prevelant, and will likely become more regulated over time. Dinesh Asanka brings us a new article on the basics of SQL Servers most powerful auditing configuration, C2 level auditing.
2004-11-03
38,043 reads
Version control in SQL Server is fairly immature, to put it nicely. Fortunately it's also an area that a number of vendors are working to make smoother. Dinesh Asanka looks at dbMaestro, a tool from Extreme Technologies to help you track changes in multiple databases.
2004-10-20
7,611 reads
Continuing his series on SQL Server and InfoPath 2003, the new reporting tool that has been added to Office. This time Dinesh looks at a practical application using expense entry along with some more features of this new tool.
2004-09-14
7,089 reads
Do you know if your SQL Server is really running at its best? To...
You can find the slides of my session on the €100 DWH in Azure...
By Steve Jones
This value is something that I still hear today: our best work is done...
Comments posted to this topic are about the item Single User SQL Server on...
Comments posted to this topic are about the item All the Costs of Downtime
Comments posted to this topic are about the item How Well Does the MSSQL...
How can I start SQL Server on Linux in single-user mode to restore the master database?
See possible answers