SQL Server

More Topics
Microsoft SQL Server Database Properties Auto Close screenshot
SQL Server
Worst Practice: Allowing AutoClose on SQL Server DatabasesWorst Practice: Allowing AutoClose on SQL Server Databases

Simply stated, allowing or enabling AutoClose on production SQL Server databases is a worst practice. What is AutoClose and why is it bad? AutoClose is a database option or setting—set on a database by database basis (meaning that it can’t be controlled at the server level).

byMichael K. Campbell
Sep 8, 2011
|
1 Min Read
computer keyboard with blue tool key
SQL Server
Free Tool: SQL Sentry's Plan ExplorerFree Tool: SQL Sentry's Plan Explorer
byKevin Kline, SolarWinds
Sep 6, 2011
1 Min Read
ITPro Today logo logo in a gray background |
Innovations of the 2010s (SQL Server 2012 – 2019)
Improved Support for Window Functions in SQL Server 2012 CTP3Improved Support for Window Functions in SQL Server 2012 CTP3
byITPro Today
Aug 31, 2011
1 Min Read
Microsoft Visual Studio Administrator screenshot of Databse3
SQL Server
First Look: Denali's New SQL Server Developer Tools - Part 1First Look: Denali's New SQL Server Developer Tools - Part 1
byMichael Otey
Aug 25, 2011
1 Min Read
ITPro Today logo logo in a gray background |
SQL Server
Software Patents: Encouraging Litigation or Innovation?Software Patents: Encouraging Litigation or Innovation?
byBrian Moran
Aug 25, 2011
1 Min Read
ITPro Today logo logo in a gray background |
SQL Server
Being a SQL Server Pro Is Hard Work!Being a SQL Server Pro Is Hard Work!
byMegan Keller
Aug 24, 2011
1 Min Read
ITPro Today logo logo in a gray background | ITPro Today logo
SQL Server
Comparative Review: Database Schema Comparison Tools
Comparative Review: Database Schema Comparison Tools
Aug 24, 2011
|
1 Min Read
byRobert Davis
database word cloud
SQL Server
Finding Potentially Unused Views in Your Databases
Finding Potentially Unused Views in Your Databases
Aug 23, 2011
|
1 Min Read
byMichael K. Campbell
Always On on a superman shirt
Innovations of the 2010s (SQL Server 2012 – 2019)
SQL Server 2012 AlwaysOn vs. Database Mirroring
SQL Server 2012 AlwaysOn vs. Database Mirroring
Aug 22, 2011
|
1 Min Read
byMichael Otey
Introducing the SQL Server Utility
Early Versions (SQL Server 2000 – 2008)
Introducing the SQL Server Utility
Introducing the SQL Server Utility
Aug 22, 2011
|
1 Min Read
byRoss Mistry
ITPro Today logo logo in a gray background | ITPro Today logo
SQL Server
How to prevent enormous SQL Server error log files
How to prevent enormous SQL Server error log files
Aug 19, 2011
|
1 Min Read
byPaul Randal
Microsoft Visual Studio 2010 Start Page
SQL Server
Exploring Visual Studio 2010's Database Tools
Exploring Visual Studio 2010's Database Tools
Aug 19, 2011
|
1 Min Read
byMichael Otey
Microsoft SQL Server Replication Schema Option Parser screenshot
SQL Server
Free Tool: Replication Schema_Option Translator
Free Tool: Replication Schema_Option Translator
Aug 17, 2011
|
1 Min Read
byMichael K. Campbell
Indiana automobile license plate
SQL Server
Use T-SQL to Generate a Sequence
Use T-SQL to Generate a Sequence
Aug 16, 2011
|
1 Min Read
byItzik Ben-Gan
Microsoft SQL Server 2008 logo
Early Versions (SQL Server 2000 – 2008)
SQL Server 2008 R2 Appliances
SQL Server 2008 R2 Appliances
Aug 16, 2011
|
1 Min Read
byMichael Otey
SQL Server Parallel vs Sequential Package Properties screenshot
SQL Server
Designing SSIS Packages for High Performance
Designing SSIS Packages for High Performance
Aug 15, 2011
|
1 Min Read
byStacia Misner
ITPro Today logo logo in a gray background | ITPro Today logo
Early Versions (SQL Server 2000 – 2008)
Controlling MAXDOP of executing queries
Controlling MAXDOP of executing queries
Aug 11, 2011
|
1 Min Read
byPaul Randal
ITPro Today logo logo in a gray background | ITPro Today logo
SQL Server
Rebalancing data across files in a filegroup
Rebalancing data across files in a filegroup
Aug 3, 2011
|
1 Min Read
byPaul Randal
datacenter switch showing multiple white cords
SQL Server
An Overview of SQL Server High Availability Options
An Overview of SQL Server High Availability Options
Aug 2, 2011
|
1 Min Read
byMichael Otey
BIxPress 301 Standard Edition screenshot
SQL Server
Review: BI xPress
Review: BI xPress
Jul 27, 2011
|
1 Min Read
byBrian Erlich
ITPro Today logo logo in a gray background | ITPro Today logo
SQL Server
New Features in SQL Server Denali CTP 3 for Developers
New Features in SQL Server Denali CTP 3 for Developers
Jul 27, 2011
|
1 Min Read
byMichael K. Campbell
ITPro Today logo logo in a gray background | ITPro Today logo
SQL Server
Determining How Much Data Has Changed
Determining How Much Data Has Changed
Jul 26, 2011
|
1 Min Read
byIain Kick
blue and silver computer mouse
Early Versions (SQL Server 2000 – 2008)
SQL Server 2005's APPLY, Part 2
SQL Server 2005's APPLY, Part 2
Jul 25, 2011
|
1 Min Read
byItzik Ben-Gan
Optimizing SQL Server Performance in a Virtual Environment
Server Virtualization
Optimizing SQL Server Performance in a Virtual Environment
Optimizing SQL Server Performance in a Virtual Environment
Jul 25, 2011
|
1 Min Read
byDenny Cherry
ITPro Today logo logo in a gray background | ITPro Today logo
Innovations of the 2010s (SQL Server 2012 – 2019)
WPC 2011: Windows Server 8, System Center, SQL Server, and Windows Azure Announcements
WPC 2011: Windows Server 8, System Center, SQL Server, and Windows Azure Announcements
Jul 13, 2011
|
1 Min Read
byPaul Thurrott
ITPro Today logo logo in a gray background | ITPro Today logo
SQL Server
Solutions to TSQL Challenge – Reoccurring Visits
Solutions to TSQL Challenge – Reoccurring Visits
Jul 7, 2011
|
1 Min Read
byITPro Today
ITPro Today logo logo in a gray background | ITPro Today logo
SQL Server
Solve Blocking Problems
Solve Blocking Problems
Jun 27, 2011
|
1 Min Read
byKurt Survance
Microsoft System Center Advisor
SQL Server
Microsoft System Center Advisor
Microsoft System Center Advisor
Jun 23, 2011
|
1 Min Read
byKevin Kline, SolarWinds
ITPro Today logo logo in a gray background | ITPro Today logo
SQL Server
Forcing Collation in the WHERE Clause - 22 Jun 2011
Forcing Collation in the WHERE Clause - 22 Jun 2011
Jun 23, 2011
|
1 Min Read
byMichael K. Campbell
ITPro Today logo logo in a gray background | ITPro Today logo
SQL Server
The Curious Case of: the empty heap table
The Curious Case of: the empty heap table
Jun 22, 2011
|
1 Min Read
byPaul Randal
Screenshot of SQL Server Log Shipping example
SQL Server
3 Log Shipping Techniques
3 Log Shipping Techniques
Jun 22, 2011
|
1 Min Read
byRobert Davis
Introducing PowerPivot for SharePoint
SQL Server
Introducing PowerPivot for SharePoint
Introducing PowerPivot for SharePoint
Jun 21, 2011
|
1 Min Read
byTyler Chessman
ITPro Today logo logo in a gray background | ITPro Today logo
SQL Server
Protect Your SQL Objects from Unwanted Changes
Protect Your SQL Objects from Unwanted Changes
Jun 21, 2011
|
1 Min Read
bySanjay Joshi
man typing on computer keyboard with data in the background
Early Versions (SQL Server 2000 – 2008)
SQL Server 2005's Apply, Part 1
SQL Server 2005's Apply, Part 1
Jun 20, 2011
|
1 Min Read
byItzik Ben-Gan
Hardening SQL Server
SQL Server
Hardening SQL Server
Hardening SQL Server
Jun 20, 2011
|
1 Min Read
byRobert Davis

Editor's Choice

the interface of the PowerShell search tool with a hand holding a magnifying glass on a background of a blue sky and clouds in the shape of gears
PowerShell
How I Built My Own PowerShell Multi-File Search Tool
How I Built My Own PowerShell Multi-File Search Tool

Oct 22, 2024

burnout gif featuring a mannequin surrounded by office technology on fire
Career Tips
Am I Burned Out? How To Identify and Address Burnout in IT
Am I Burned Out? How To Identify and Address Burnout in IT

Oct 24, 2024

MLOps
Ops and More
Choosing Between Cloud and On-Prem MLOps: What's Best for Your Needs?
Choosing Between Cloud and On-Prem MLOps: What's Best for Your Needs?

Oct 23, 2024

Exclusive ITPro Resources
See all ITPro Resources

Featured Technical Explainers

AI chip
Cloud Computing
Cloud vs. On-Prem AI Accelerators: Choosing the Best Fit for Your AI Workloads
Cloud vs. On-Prem AI Accelerators: Choosing the Best Fit for Your AI Workloads
SaaS concept on a tablet
Cloud Computing
Why SaaS Backup Matters: Protecting Data Beyond Vendor Guarantees
Why SaaS Backup Matters: Protecting Data Beyond Vendor Guarantees
DevOps logo on top of code
DevOps
DevOps: Key to Faster, More Efficient Government Software Development
DevOps: Key to Faster, More Efficient Government Software Development
Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.
Newsletter Sign-Up

Recent What Is

cartoon shows a person next to a checklist and several icons that represent disaster scenarios
Disaster Recovery
BCDR Basics: A Quick Reference Guide for Business Continuity & Disaster RecoveryBCDR Basics: A Quick Reference Guide for IT Pros
technology interface with a person's hand drawing gears and cogs
PowerShell
Introduction To PowerShell Environment VariablesIntroduction To PowerShell Environment Variables
Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.
Newsletter Sign-Up