Create a Web-Based CRUD Automation Framework with Python
Implement a CRUD automation framework that handles insert and simple queries, an easy way to talk to a database without needing to write any database-access code.
2009-07-09
1,967 reads
Additional Articles
Automating Performance Monitor Statistics Collection for SQL Server and Windows
You have about 100 SQL Servers installed in your production environment. You have performance problems on few of the servers, but they happen during the time when you are not watching the servers. So, how can you automate performance statistics collection on all the servers around the clock so we have the statistics for 24/7/365.
2009-07-08
3,919 reads
Monitoring group of Linked Sql Servers from a Sql Server
The main purpose of article is to understand how to monitor group of Linked Sql Servers from a Sql Server.
2009-07-08
2,443 reads
10+ tips for working smarter with SQL
The sharper your SQL skills become, the more robust and error-free your solutions will be. Here are a dozen practical tips to get you started
2009-07-07
7,621 reads
Limit Groups by Number Using Transact-SQL or MS Access
You can easily limit or group a recordset, but doing both to the same recordset takes a bit of hand coding. Find out how both SQL Server and MS Access can handle the task.
2009-07-07
2,354 reads
Different ways to execute an SSIS package
In SQL Server 2005 and higher versions there are different ways in which one can execute an SSIS package. Let us go through each option one by one.
2009-07-06
4,591 reads
Resources for Upgrading to SQL Server 2008
Use these resources as aids in upgrading to SQL Server 2008. These references are from the downloadable white paper:
2009-07-06
2,842 reads
Remote BLOB Store Provider Library Implementation Specification
This is a specification to be used by those creating a storage provider plug-in library for the SQL Server 2008 Remote BLOB Store feature.
2009-07-03
1,269 reads
Taking Advantage of Sample Reporting Services Reports
Recent installments of our series dedicated to SQL Server 2005 Express Edition have discussed the Reporting Services component. This article provides an overview of sample reports that you can take advantage of in order to familiarize yourself with the more advanced graphical designer features present in SQL Server 2005 Express Edition-based Reporting Services.
2009-07-03
2,764 reads
Avoiding the EAV of Destruction
A forum posting, from someone who wanted a better solution to the common problem of handling global settings in a database, leads Joe Celko into a fascinating discussion of the ramifications of the various solutions.
2009-07-02
2,239 reads
Blogs
A New Word: Etherness
By Steve Jones
etherness – n. the wistful feeling of looking around a gathering of loved ones,...
Vibe Coding a Login Tracking System
By Steve Jones
A customer was asking about tracking logins and logouts in Redgate Monitor. We don’t...
4 CPE Opportunity (Virtual) for Charity
By Brian Kelley
Every year, the South Carolina State Internal Auditors Association and the South Carolina Midlands...
Forums
T-SQL in SQL Server 2025: The || Operator
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Your Value from a Conference
Comments posted to this topic are about the item Your Value from a Conference
UNISTR Basics
Comments posted to this topic are about the item UNISTR Basics
Question of the Day
UNISTR Basics
What does this code return in SQL Server 2025+? (assume the database has an appropriate collation)
SELECT UNISTR('Hello 4E16754C') AS 'A Classic';
A: 
B: 
See possible answers