Is Windows 2003 really faster for a SQL Server/IIS environment? Let us do all the leg work for you! We are about to upgrade the SQLServerCentral.com web and SQL Server from Windows 2000 to Windows 2003. As part of the case study, we are going to capture a baseline of the server's overall performance before the upgrade and then again after the upgrade. We will then document the experience and benchmark numbers.
2003-06-10
12,880 reads
Have you ever had the problem where a user ran a query against your SQL Serer and crashed it or made the server unusable since the CPU was spiked at 100%? A SQL Server black box is the equivalent of a flight data record. The black box records all queries being passed to your SQL Server and other useful information like errors.
2003-04-11
16,849 reads
Join SQLServerCentral.com co-founder Brian Knight for this free webcast on SQL Server security best practices. In this session on Technet, we will look at how to protect your system from internal and external security factors. We will look at the types of permissions in your database objects, implementing column and row-level security, and protecting yourself from SQL Injection attacks. We'll also cover best practices for basic and advanced protection for your SQL Server system.
2003-04-02
1,994 reads
Brian Knight recently had the basic need to retrieve a record from the database at random. What seemed to be an easy task quickly became a complex one. This case showed an interesting quirk with T-SQL that was resolved in an equally quirky way. This quick article shows you a method to retrieve random data or randomize the display of data.
2003-03-26
9,392 reads
Last week the SQL Sapphire (or SQL Slammer) virus hit corporate networks throughout the Internet. Although damage has not been estimated yet, it is sure to be in the tens of millions of dollars. So who is to blame when a virus like this manhandles a corporate environment?
2003-02-03
5,845 reads
On Friday the 24th, a virus that preys on a SQL Server vulnerability began to attack networks, taking down many networks. This brief network describes the virus and how to protect yourself from it.
2003-01-27
10,815 reads
Recently, the SQLServerCentral.com labs had the chance to get a sneak peak at Lumigents latest creation, Entegra, which is scheduled to ship in the second week in December. Entegra monitors database activity and provides a complete record of access to the data and changes to database structure and permissions.
2002-11-13
3,311 reads
If you're still on SQL Server 2000 SP2, beware! Microsoft has released a number of fixes that have now been rolled up into this cumulative patch to fix major security flaws in SQL Server.
2002-10-07
4,632 reads
Oops, a developer just forgot a WHERE clause when he ran his delete statement. Lumigent Log Explorer 3.0 can peer into the transaction log and find the culprit and roll it back. Read the review here of Lumigent's latest version.
2002-07-23
4,013 reads
Brian Knight recently had the opportunity to look at a very unique product in the industry. MYdbPAL automates many of the tasks that database professionals perform on a day-to-day basis. Read his review here.
2002-07-16
4,344 reads
By HeyMo0sh
As someone who’s worked with data for over 20 years and with many cloud...
By HeyMo0sh
2025 belongs to the AI startups. If you peek into the tech headlines, you’ll...
By Vinay Thakur
it has been a year since i have not written much on the blog...
Comments posted to this topic are about the item A Quick Restore
Comments posted to this topic are about the item Guarding Against SQL Injection at...
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers