NetApp Dynamic Backup Script
TSQL Script to backup selected databases. Use this to override the script generated by snapmanager for sql in a sql job which doesn't cater for new or deleted databases
2011-08-09 (first published: 2011-07-27)
806 reads
SQL Server
Paging Doctor Powershell
Use Powershell to create a single script that checks over your server and every SQL instance on it to help pinpoint problems.
2014-04-11 (first published: 2011-04-04)
12,559 reads
Setting All Tempdb Data Files to the Same Size
How to set all tempdb datafiles to same size to meet best practice.
2010-07-19
15,960 reads
How to find unused Stored Procedures in SQL Server 2005/2008
Use dynamic PivotTables to identify unused Stored Procedures in a SQL Server 2005/2008 database
2010-04-15
28,600 reads
A High Level Comparison Between Oracle and SQL Server - Part III
Part III of the Oracle / SQL Server comparison looks at the configuration options for each database, their storage options as well as the startup and shutdown procedures.
2010-03-30
4,344 reads
A High Level Comparison Between Oracle and SQL Server - Part II
Part II or the Oracle / SQL Server comparison dives deeper into databases by exploring the architectural differences.
2010-03-26
4,935 reads
Microsoft SQL Server vs. MySQL
Is Microsoft SQL Server superior to MySQL or not? What are the pros and cons of using SQL Server over MySQL? Is MySQL mature enough to compete with a big player like Microsoft and Oracle? Can we fairly compare both products?
2010-01-29
9,361 reads
A Neural Network in SQL Server
Modeling and programming a neural Network in SQL Server from new author Silvia Cobialca. Learn how you might be able to implement this AI construct in SQL Server to make predictions.
2009-10-27
12,436 reads
Best Practice - Increasing the Number of SQL Server Error Logs
By default, there are six achieved SQL Server Error Logs along with the ERRORLOG which is currently used. However, it is a Best Practice to increase the number of SQL Server Error Logs from the default value of six. In this tip, you will see the steps which you need to follow to increase the number of SQL Server Error Logs.
2009-09-21
2,211 reads
Best Practice - Increasing the Number of SQL Server Error Logs
By default, there are six achieved SQL Server Error Logs along with the ERRORLOG which is currently used. However, it is a Best Practice to increase the number of SQL Server Error Logs from the default value of six. In this tip, you will see the steps which you need to follow to increase the number of SQL Server Error Logs.
2009-09-21
3,332 reads
Blogs
Giving AI Agents Visibility Into SQL Server with MCP
I’ve been thinking a lot lately about what it actually takes to make an...
The Book of Redgate: Profits
By Steve Jones
Redgate is a for-profit company. We look to make money by building and selling...
Session Materials for Techorama & DataGrillen 2026
I’ve uploaded the slides for my Techorama session Microsoft Fabric for Dummies and my...
Forums
Stop Prompting Your AI Agent. Give It a Playbook.
Comments posted to this topic are about the item Stop Prompting Your AI Agent....
Finish the quote
Comments posted to this topic are about the item Finish the quote
Everything I Needed to Know Used to be Found in One Book
Comments posted to this topic are about the item Everything I Needed to Know...
Question of the Day
Finish the quote
Finish this quote (for a fun Memorial Day question):
Do not try and bend the spoon. That's impossible. ...See possible answers