In this short demonstration, you'll learn how to use DDL database triggers to prevent changes to product and audit changes to comply with Sarbanes-Oxley and other change management requirements. Free registration required.
Depending on your age, you may not want to know this number, but as you advance in your career, this might be a problem that you look to solve one day. Peter Larsson takes a few minutes to work out a function in T-SQL that can be used to solve this or any similar question.
Visual Studio developers have enjoyed the benefits of intellisense for some time, but us SQL Server users have had to work from memory. Wayne Fillis was so enthralled with a new offering from Red Gate he wrote a short review and sent it in. Check out his thoughts and how this product can help you.
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 an entry level look at how temp tables work in SQL along with some tips about how to use them effectively.
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.
By Brian Kelley
The following came across my YouTube feed today. It’s an interview with General James...
By Steve Jones
“You don’t need more time because you already have all the time that you...
I don’t currently manage Microsoft 365 Copilot in an enterprise environment, but it is...
Comments posted to this topic are about the item What Did Healthy Look Like?
Comments posted to this topic are about the item DML Trigger Types
Comments posted to this topic are about the item PostgreSQL in action with Opensearch
How many types of DML triggers are there?
See possible answers