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)
805 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,955 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,595 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,431 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
Redgate and Rome
By Steve Jones
I’m at the UK Redgate office today, meeting with senior leaders in all areas...
Quick Tip: Check Most DTU Expensive Queries in Azure SQL Database
Optimizing Azure SQL Database performance often begins with identifying the most resource-intensive queries. Understanding...
PowerShell Newbie – Variables
By gbargsley
This is Week 2 of PowerShell Strikes Back – a four-week May series for...
Forums
SSRS Is Dead. Here Are Your Real Options
Comments posted to this topic are about the item SSRS Is Dead. Here Are...
The Distance Metric
Comments posted to this topic are about the item The Distance Metric
The New Wave of Security Threats
Comments posted to this topic are about the item The New Wave of Security...
Question of the Day
The Distance Metric
In the new VECTOR_DISTANCE() function in SQL Server 2025, the first parameter is the distance_metric. What is this?
See possible answers