This article describes the "beta" version of Simple-Talk's SQL formatting tool, SQL Prettifier. It provides links both to try it out online and to download the full source code (members only). Please give us your feedback! We will be offering prizes for any fixes and improvements that make it into "v1". I'd like this to become the de-facto (excuse the pun) tool for presenting code in the Simple-Talk articles, blogs and forums.
The second in a series from Adindam Banerjee on server performance and capacity planning. This time Arindam takes a look at the memory requirements for SQL Server.
SqlBulkTool is a command line utility that is used to quickly create a mirror of a database. It reads its configuration from an XML file containing source and destination command strings and a list of all the tables to mirror and then handles the work of copying the database in an automated and highly parallelized way.
This is the second of a two-part article that explores the language features of SQL Full-text Search (SQL FTS), an component of SQL Server 7 and above that allows fast and efficient querying of large amounts of unstructured textual data. Part I dealt with index time language options, covering how words or tokens are broken from the text stream emitted from the iFilters and stored in the index.
Performance tuning often seems like it can be more of an art than a science. However there are a number of fundamentals that can help you tune most of the queries that you will write or have issues with their performance. Don Peterson brings us a look at how he tuned a query in the real world to avoid a conversion that can cause a query to run slower.
In Part I and Part II of this series, we saw how to install the SQL Server 2005 Data Service component. In this section of this series, I am going to illustrate how to install SQL Server 2005 Database Services and SQL Server Analysis Services on a host machine using an .ini file.
Reporting Services has proven itself to be an amazing platform on which to develop all types of reports. Author Asif Sayed brings us some .NET code for using Reporting Services to return data recursively in a report.
In this video demonstration, you'll quickly learn how to create a basic cube using the Cube Wizard upon a data warehouse. Brian walks through the entire process in this 10 minute video to get you started with creating a browsing a cube. Free registration required.
In this section of this series, I am going to illustrate how to install SQL Server 2000 Database Services on a server using various command line switches.
Our first SSIS class in July is sold out, but we've got another in August and one in October as well.
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
By John
Today is Christmas and while I do not expect anybody to actual be reading...
I have a couple of SQL Agent job steps which run PowerShell commands of...
Comments posted to this topic are about the item Database security permissions save script
I have a SQL Agent job for backing up a set of Analysis Services...
I want to use the new BASE64_ENCODE() function in SQL Server 2025, but return a string that isn't large type. What is the longest varbinary string I can pass in and still get a varchar(8000) returned?
See possible answers