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
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
This past week the Exchange 2010 team admitted they had tried SQL Server as a storage platform for Exchange 2010, but then discarded it. Steve Jones wonders why this was the case. Is SQL Server not good enough?
2009-07-20
528 reads
Find the country, region and city of a user from an IP address using SQL Server. Oscar Garcia provides some code and resources if you want to dig into your analytics on your own.
2012-07-20 (first published: 2009-07-09)
55,400 reads
Many DBAs need to work with multiple platforms. New author Jagan Kumar brings us an article that helps to explain Oracle's architecture for those people used to working with SQL Server.
2009-07-02
10,862 reads
Use of event handlers provided in SSIS package to handle runtime errors while the package is running and logging the error information in the database.
2009-06-26
13,851 reads
Face it, you never intended to become a SQL Server expert, but the proliferation of this database engine – and its many editions – requires somebody to feed and care for it. You're the "Microsoft Guy" (or Gal), so whether you wanted to be or not, you were elected. This series of articles is all about making you more effective with SQL Server as an administrator, not a programmer.
2009-06-25
7,556 reads
Learn about the benefits of SQL Server 2008 consolidation on Windows 2008, with details on the different consolidation strategies available to organizations.
2009-04-07
2,707 reads
I'm continually trying to track down what service packs are installed on various SQL Servers I support. I can never find the right support page on Microsoft's site. So here's an article with all the SQL Server version information I can track down. If you know of any older versions or can help me fill out any missing data, please post in the comments and I'll update the article.
2009-02-04
3,287 reads
An interview with Herain Oberoi, group project manager for the SQL Server Business Intelligence and Data Warehouse product.
2009-01-02
2,872 reads
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
By James Serra
Making Data AI-Ready, Part 3 (This is the final article in a three-part series...
Comments posted to this topic are about the item Four Rules for Adding AI...
Hello, the title says it all. Is the SQL Server 2025 section missing?
I am not sure which is the best way to proceed. I have parent...
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers