The Real World: Rebuilding Index - 1 Instance, 106 Databases
The article show a simple way we managed to schedule index rebuild and reorg for an SQL instance with 106 databases used by one application using a Scheduled job.
Automate SQL Server Express Backups and Purge Old Backups
SQL Server Express Edition does not include SQL Server Agent in order to schedule the SQL Server database backups. Here's how to automate the backups for SQL Server Express Edition and make sure the old backup files are deleted.
SQL Monitor Custom Metric: Tempdb Allocation Contention
If your code uses temporary tables, variable tables or dynamic cursors, this metric can help identify whether you have contention on tempdb allocation. Tempdb is shared by all databases and is used for many operations in a SQL Server instance, so it is common for tempdb to cause performance problems.
Salaries and Experience
Experience matters in setting your salary, but Steve Jones reminds us there are different types of experience, and there's more to life than money.
What’s going on, on my server, right now?
Quick and easy way to monitor server activity and be notified from alerts.
Managing Test Data as a Database CI Component - Part 1
Constructing a test environment for your databases can be a difficult task at the best of times. Once you’ve actually acquired the hardware needed and architected the environment, you still have to arrange and securely transport the data. And with the rising demand for fast feedback and continuously integrated processes, having all of this automated and operating at speed is a challenge all of its own.
Cascaded Parameters in SQL Server Reporting Services
You have a reporting requirement where a user has two or more parameters for a single report, but the values for one parameter depend on the values chosen in a previous parameter. Ghanesh Prasad explains how to create cascaded parameters in SQL Server Reporting Services to solve this issue.
SQL Saturday #371 - Tampa, FL
SQL Saturdau is coming to Tampa on February 28, 2015. This is a free training event for those wanting to learn about SQL Server. Register while space is available.
How to use the IsNothing Inspection Function in SSRS
SSRS includes multiple functions that can be used in within an expression. This article hopes to just show an example of how to use the IsNothing function in an SSRS report.
Blogs
What Does It Mean to Make Data AI-Ready?
By James Serra
Making Data AI-Ready, Part 1 (This is the first article in a three-part series...
Using the Data API Builder–VS Live San Diego Resources
By Steve Jones
Thanks for attending my sessions. Resources below: Slides: Using Data API Builder GitHub repo: ...
Running a Local LLM On Your Laptop Resources
By Steve Jones
Thanks to everyone that attended my sessions at VS Live San Diego yesterday. It...
Forums
Hyperscale Replicas II
Comments posted to this topic are about the item Hyperscale Replicas II
Practical Reporting Queries with CROSS APPLY (Part 3)
Comments posted to this topic are about the item Practical Reporting Queries with CROSS...
Your Favorite Quotes
Comments posted to this topic are about the item Your Favorite Quotes
Question of the Day
Hyperscale Replicas II
How many Azure SQL DB Hyperscale HA replicas can be configured as of Sept 2026?
See possible answers