;jlknfdskl kljhdsaf lkjh sda lkjdaf
;jlknfdskl kljhdsaf lkjh sda lkjdaf;jlknfdskl kljhdsaf lkjh sda lkjdaf;jlknfdskl kljhdsaf lkjh sda lkjdaf;jlknfdskl kljhdsaf lkjh sda lkjdaf;jlknfdskl kljhdsaf lkjh sda lkjdaf;jlknfdskl kljhdsaf lkjh sda lkjdaf;jlknfdskl kljhdsaf lkjh sda lkjdaf;jlknfdskl kljhdsaf lkjh sda lkjdaf;jlknfdskl kljhdsaf lkjh sda lkjdaf;jlknfdskl kljhdsaf lkjh sda lkjdaf;jlknfdskl kljhdsaf lkjh sda lkjdaf;jlknfdskl kljhdsaf lkjh sda lkjdaf;jlknfdskl kljhdsaf lkjh sda lkjdaf;jlknfdskl kljhdsaf lkjh sda lkjdaf;jlknfdskl kljhdsaf lkjh sda lkjdaf;jlknfdskl kljhdsaf lkjh sda lkjdaf
Directory:
SecurityProNews > Articles > Database
Date: 2004-07-29
|
Junking Your Databases for Fun...
af'dblk ;ldfsjk g ;lksfjd gl;kj stg l;kfdsjg ;lkjsdf glk l;dsfkjg l;kjsdf;glk l;kjds gl;kj fd ;lkjfdsg l;jg ;lkjg ;fljkg ;ljkfds ;glkjfdgl; af'dblk ;ldfsjk g ;lksfjd gl;kj stg l;kfdsjg ;lkjsdf glk l;dsfkjg l;kjsdf;glk l;kjds gl;kj fd ;lkjfdsg l;jg ;lkjg ;fljkg ;ljkfds ;glkjfdgl; af'dblk ;ldfsjk g ;lksfjd gl;kj stg l;kfdsjg ;lkjsdf glk l;dsfkjg l;kjsdf;glk l;kjds gl;kj fd ;lkjfdsg l;jg ;lkjg ;fljkg ;ljkfds ;glkjfdgl; af'dblk ;ldfsjk g ;lksfjd gl;kj stg l;kfdsjg ;lkjsdf glk l;dsfkjg l;kjsdf;glk l;kjds gl;kj fd ;lkjfdsg l;jg ;lkjg ;fljkg ;ljkfds ;glkjfdgl; af'dblk ;ldfsjk g ;lksfjd gl;kj stg l;kfdsjg ;lkjsdf glk l;dsfkjg l;kjsdf;glk l;kjds gl;kj fd ;lkjfdsg l;jg ;lkjg ;fljkg ;ljkfds ;glkjfdgl;
Directory:
SecurityProNews > Articles > Database
Date: 2004-07-29
|
Alert! Alert! Alert! Backup and Restore – Baby!
At many organizations I doubt red lights flash with the sound of blaring sirens when backups fail in production environments, but I believe at every organization backups are one of the most critical IT functions. Of all backups, database backups, by most accounts, are considered the most critical. I know this is certainly true for me as a SQL Server DBA. I am sure at one point in all of our careers we were too busy to check all of our backups across all SQL Servers, with a million responsibilities on a daily basis. I know some of us were lucky and made it unscathed, while others were not so lucky with backup failures that caused extensive data loss and long downtimes. Now when IT Departments are forced to "do more with less," it is time to put the necessary SQL Server Alerts in place for backup and restore operations in order to more easily monitor and streamline this critical process.
Directory:
SecurityProNews > Articles > Database
Date: 2004-04-27
|
Backing Up And Restoring Your MySQL Database
If you've been using MySQL database to store your important data, it is imperative that you make a backup of your data to prevent any loss of data. This article shows you how to backup and restore data in your MySQL database. This process can also be used if you have to move your data to a new server.
Directory:
SecurityProNews > Articles > Database
Date: 2004-03-11
|
...And How Do You Expect Me to Audit SQL Server?
Is your organization faced with pending audits resulting in long and tedious meetings to try to achieve compliance? Have you been hearing a foreign set of acronyms around the water cooler like HIPAA, SOX, GLBA and SAS 70? Have these new sets of requirements been causing consternation for your DBAs, Developers and Management? Have you been trying to figure how you are going to write the code to capture the data needed for the continuous audits in between the remainder of the company projects?
Directory:
SecurityProNews > Articles > Database
Date: 2004-03-08
|
SQL Server Parallel Execution Plans
Microsoft SQL Server introduced parallel query processing capability in version 7.0. The purpose of parallel query execution is to complete a query involving a large amount of data more quickly than possible with a single thread on computers with more than one processor.
Directory:
SecurityProNews > Articles > Database
Date: 2004-01-26
|
Keep Your SQL Servers Synchronized with SQL Compare and SQL Data Compare
Managing multiple versions of the same database across different environments (i.e. Development, Test, Production, and Disaster Recovery site) is perhaps one of the most important and least favorable Database Administrative duties. Whether it's synchronizing database objects or actual data, creating utilities to perform this obligatory task is somewhat of a dreaded chore. I mean, think of it, when was the last time you looked forward to creating one of these utility jobs? My point exactly!
Directory:
SecurityProNews > Articles > Database
Date: 2004-01-13
|
How to Interact with SQL Server's Data and Procedure Cache
As you have worked with SQL Server, you probably have run across the terms data cache and procedure cache, and may have wondered what exactly a cache was. SQL Server is configured to use a physical pool of memory on the server, and it will allocate the majority of this memory pool to hold data pages that have been read, along with the compiled execution plans for all previously-run Transact-SQL statements. It is this dynamic pool of memory that is being referred to by the data cache and procedure cache. Before SQL Server 7.0, the data cache and procedure cache were two separate pools of memory and could be controlled separately. In SQL Server 7.0 and SQL Server 2000, one pool of memory is used both for data and execution plans.
Directory:
SecurityProNews > Articles > Database
Date: 2003-12-15
|
|
