Are you over 18 and want to see adult content?
More Annotations
A complete backup of drinksdirect.co.uk
Are you over 18 and want to see adult content?
A complete backup of tackledirect.com
Are you over 18 and want to see adult content?
A complete backup of brooklynnavyyard.org
Are you over 18 and want to see adult content?
A complete backup of xn--80afej9aap.xn--p1ai
Are you over 18 and want to see adult content?
Favourite Annotations
Panduan Beli HP | Tempat Riset Sebelum Membeli HP Baru
Are you over 18 and want to see adult content?
A complete backup of scoobydoo1969.blogspot.com
Are you over 18 and want to see adult content?
A complete backup of 3rdbell-bd.blogspot.com
Are you over 18 and want to see adult content?
Guitar Lessons | Seattle & Online
Are you over 18 and want to see adult content?
A complete backup of hottabych-mag.kz
Are you over 18 and want to see adult content?
A complete backup of hijosdemariasantisimavenezuela.com
Are you over 18 and want to see adult content?
شهر فافا | خرید موبایل | خرید لپ تاپ | خرید لوازم جانبی کامپیوتر
Are you over 18 and want to see adult content?
Text
DATABASEJOURNAL.COM
USING SQL SERVER'S DEFAULT TRACE TO IDENTIFY AUTOGROW We all know that you should try to size tempdb appropriately, so it doesn’t need to autogrow shortly after starting up SQL Server. It isn’t always easy to do this. Therefore, when you first implement a new server and/or add new databases you should monitor the autogrowth events on tempdb. By monitoring the autogrowth events you can easily determine if you have sized tempdb appropriately. UNDERSTANDING LOGICAL STANDBY DATABASES Steps in Creating Logical standby Database: 1. Take a hotbackup of the primary database. Bring a tablespace to backup mode, copy the datafiles of that tablespace using an OS command, and bring the tablespace back online. STEP BY STEP GUIDE TO MIGRATE SQL SERVER DATA TO SQLSEE MORE ONDATABASEJOURNAL.COM
GET SSAS DATABASE PROPERTIES WITH POWERSHELL AND AMO Now let’s create a Windows PowerShell script that displays some of the database properties of any SQL Server Analysis server and database that we pass as parameter.. Create a file, C:\AMOScripts\get-SSASDBproperty.ps1, using notepad and copy and pastethe
ACCESS DATA DEFINITION LANGUAGE (DDL): CREATING AND Once you have gotten a handle on DML, you will want to explore the world of DDL, Data Definition Language. This article looks at how DDL is used to create and alter database objects, such as tables and considers some scenarios where this technique will save time and in TOP 10 FEATURES OF SQL 2008 R2 Introduction. Microsoft SQL Server 2008 R2 is the latest release of SQL Server. This article will introduce the top 10 features and benefits of SQL Server 2008 R2. ORACLE'S BULK COLLECT AND LIMIT CAN BE A PROBLEM Had there been 18 rows, or had the LIMIT been 7, the insert would have completed, but it would have been a false sense of security as the next FORALL/BULK COLLECT/LIMIT process could fail because the row source wasn't an even multiple of the LIMIT. 14 USEFUL DBA TASKS FOR SOLVING DATABASE PERFORMANCE A checklist of DBA tasks involved with keeping an Oracle Database running smoothly can be quite handy. This 14 point checklist, while not actual performance tuning activities are tasks that a DBA needs to know and they will often be part of a solution to remedy a database performance problem. AUTOMATE DATABASE BACKUPS WITH MYSQLDUMP AND POWERSHELL One of the Database Administrator's most important duties is performing regular scheduled database backups. To this end, tools like mysqldump are indispensable. Now, with the introduction of PowerShell, database backups can be more automated than ever. PERFORM ROUTINE SERVER CHECKS USING POWERSHELLSEE MORE ONDATABASEJOURNAL.COM
USING SQL SERVER'S DEFAULT TRACE TO IDENTIFY AUTOGROW We all know that you should try to size tempdb appropriately, so it doesn’t need to autogrow shortly after starting up SQL Server. It isn’t always easy to do this. Therefore, when you first implement a new server and/or add new databases you should monitor the autogrowth events on tempdb. By monitoring the autogrowth events you can easily determine if you have sized tempdb appropriately. UNDERSTANDING LOGICAL STANDBY DATABASES Steps in Creating Logical standby Database: 1. Take a hotbackup of the primary database. Bring a tablespace to backup mode, copy the datafiles of that tablespace using an OS command, and bring the tablespace back online. STEP BY STEP GUIDE TO MIGRATE SQL SERVER DATA TO SQLSEE MORE ONDATABASEJOURNAL.COM
GET SSAS DATABASE PROPERTIES WITH POWERSHELL AND AMO Now let’s create a Windows PowerShell script that displays some of the database properties of any SQL Server Analysis server and database that we pass as parameter.. Create a file, C:\AMOScripts\get-SSASDBproperty.ps1, using notepad and copy and pastethe
ACCESS DATA DEFINITION LANGUAGE (DDL): CREATING AND Once you have gotten a handle on DML, you will want to explore the world of DDL, Data Definition Language. This article looks at how DDL is used to create and alter database objects, such as tables and considers some scenarios where this technique will save time and in TOP 10 FEATURES OF SQL 2008 R2 Introduction. Microsoft SQL Server 2008 R2 is the latest release of SQL Server. This article will introduce the top 10 features and benefits of SQL Server 2008 R2. ORACLE'S BULK COLLECT AND LIMIT CAN BE A PROBLEM Had there been 18 rows, or had the LIMIT been 7, the insert would have completed, but it would have been a false sense of security as the next FORALL/BULK COLLECT/LIMIT process could fail because the row source wasn't an even multiple of the LIMIT. UNDERSTANDING LOGICAL STANDBY DATABASES Steps in Creating Logical standby Database: 1. Take a hotbackup of the primary database. Bring a tablespace to backup mode, copy the datafiles of that tablespace using an OS command, and bring the tablespace back online. ACCESS DATA DEFINITION LANGUAGE (DDL): CREATING AND Once you have gotten a handle on DML, you will want to explore the world of DDL, Data Definition Language. This article looks at how DDL is used to create and alter database objects, such as tables and considers some scenarios where this technique will save time and in COMPACT AN ACCESS DATABASE WITH VBS SCRIPT The Problem with Compacting. If you have worked with Microsoft Access databases for any length of time, you have no doubt noticed that the mdb file itself tends to bloat as you work with it. HOW TO REMOVE TRANSPARENT DATA ENCRYPTION FROM A DATABASE There may be a time when you want to turn off transparent data encryption on one of your TDE enabled databases. In this tip, Greg Larsen shows you how simple it SQL SERVER STORED PROCEDURES OPTIMIZATION TIPS In his latest article, Alexander Chigrik offers twelve useful tips for ensuring that you've constructed your SQL Server stored procedures to perform in the most efficient manner possible. ORACLE RAC: CHECKING RAC STATUS WITH SQL/OS LEVEL Brief intro. Our last article was about monitoring RAC, which we will get back to in upcoming articles. Monitoring can be a daunting task for a DBA but fortunately, the ORACLE'S PGA_MAX_SIZE AND _PGA_MAX_SIZE CONTROL TWO Oracle provides two parameters that affect the PGA that look very similar but operate very differently. One of these parameters is the well-known pga_max_size and the other is HOW TO RESEED YOUR IDENTITY COLUMN VALUE IN SQL SERVER Have you deleted a bunch of rows from a table that has an identity column value? Do you now find that when you insert a new row, you find that the identity column value was set to one higher than the highest identity column value that your table original had? HOW TO MOVE A TDE ENCRYPTION KEY TO ANOTHER SQL SERVER If you have a database backup of a Transparent Data Encryption (TDE) enabled database, the database backup will contain encrypted data. Because the database backup contains encrypted data you can’t just restore it to any instance. You can only restore the database backup to an instance that contains the same certificate used to originally encrypt the database. ORACLE'S BULK COLLECT AND LIMIT CAN BE A PROBLEM Had there been 18 rows, or had the LIMIT been 7, the insert would have completed, but it would have been a false sense of security as the next FORALL/BULK COLLECT/LIMIT process could fail because the row source wasn't an even multiple of the LIMIT. SQL PERMISSIONS: DATAREADER & DATAWRITER ROLES In a previous article I discussed how the Public role works and some of the potential pitfalls. In this article I'd like to continue that discussion by looking at four of the fixed database roles; db_datareader, db_datawriter, db_denydatareader, anddb_denydatawriter.
STEP BY STEP GUIDE TO MIGRATE SQL SERVER DATA TO SQLSEE MORE ONDATABASEJOURNAL.COM
USING SQL SERVER'S DEFAULT TRACE TO IDENTIFY AUTOGROWDEFAULT TRACE ENABLEDDEFAULT TRACE SQL SERVERSQL SERVER TRACE FILE LOCATIONSQL SERVER TRACE LOGHOW TO USE SQL SERVER We all know that you should try to size tempdb appropriately, so it doesn’t need to autogrow shortly after starting up SQL Server. It isn’t always easy to do this. Therefore, when you first implement a new server and/or add new databases you should monitor the autogrowth events on tempdb. By monitoring the autogrowth events you can easily determine if you have sized tempdb appropriately. ACCESS DATA DEFINITION LANGUAGE (DDL): CREATING ANDDDL LANGUAGE Once you have gotten a handle on DML, you will want to explore the world of DDL, Data Definition Language. This article looks at how DDL is used to create and alter database objects, such as tables and considers some scenarios where this technique will save time and in UNDERSTANDING LOGICAL STANDBY DATABASES Steps in Creating Logical standby Database: 1. Take a hotbackup of the primary database. Bring a tablespace to backup mode, copy the datafiles of that tablespace using an OS command, and bring the tablespace back online. SQL SERVER STORED PROCEDURES OPTIMIZATION TIPSSQL SERVER STOREDPROCEDURES EXAMPLES
In his latest article, Alexander Chigrik offers twelve useful tips for ensuring that you've constructed your SQL Server stored procedures to perform in the most efficient manner possible. GENERATING RANDOM NUMBERS AND STRINGS IN ORACLE Generating random numbers or strings is oft-times a necessity. Oracle provides a random number generator that is faster than writing your won random generation logic in PL/SQL, and can generate both character and alphanumeric strings. Perhaps it is time to learn more about the DBMS_RANDOM package. DISPLAYING AND REMOVING UNPRINTABLE HEXADECIMAL CHARACTERS There are times when you might need to look at your SQL Server data in hexadecimal format. Occasionally some string data will contain unprintable characters, which can cause downstream problems, if not detected and removed. Read on to learn how to display and remove unprintable hexadecimal characters from SQL Server data. HOW TO MOVE A TDE ENCRYPTION KEY TO ANOTHER SQL SERVER If you have a database backup of a Transparent Data Encryption (TDE) enabled database, the database backup will contain encrypted data. Because the database backup contains encrypted data you can’t just restore it to any instance. You can only restore the database backup to an instance that contains the same certificate used to originally encrypt the database. ORACLE'S BULK COLLECT AND LIMIT CAN BE A PROBLEMORACLE BULK COLLECT LIMITBULK COLLECT ORACLEORACLE BULK COLLECT INSERT EXAMPLEORACLE BULK COLLECT INTO TABLEORACLE BULK COLLECT INTO ARRAYORACLE BULK COLLECTINTO COLLECTION
Had there been 18 rows, or had the LIMIT been 7, the insert would have completed, but it would have been a false sense of security as the next FORALL/BULK COLLECT/LIMIT process could fail because the row source wasn't an even multiple of the LIMIT. SQL PERMISSIONS: DATAREADER & DATAWRITER ROLES In a previous article I discussed how the Public role works and some of the potential pitfalls. In this article I'd like to continue that discussion by looking at four of the fixed database roles; db_datareader, db_datawriter, db_denydatareader, anddb_denydatawriter.
STEP BY STEP GUIDE TO MIGRATE SQL SERVER DATA TO SQLSEE MORE ONDATABASEJOURNAL.COM
USING SQL SERVER'S DEFAULT TRACE TO IDENTIFY AUTOGROWDEFAULT TRACE ENABLEDDEFAULT TRACE SQL SERVERSQL SERVER TRACE FILE LOCATIONSQL SERVER TRACE LOGHOW TO USE SQL SERVER We all know that you should try to size tempdb appropriately, so it doesn’t need to autogrow shortly after starting up SQL Server. It isn’t always easy to do this. Therefore, when you first implement a new server and/or add new databases you should monitor the autogrowth events on tempdb. By monitoring the autogrowth events you can easily determine if you have sized tempdb appropriately. ACCESS DATA DEFINITION LANGUAGE (DDL): CREATING ANDDDL LANGUAGE Once you have gotten a handle on DML, you will want to explore the world of DDL, Data Definition Language. This article looks at how DDL is used to create and alter database objects, such as tables and considers some scenarios where this technique will save time and in UNDERSTANDING LOGICAL STANDBY DATABASES Steps in Creating Logical standby Database: 1. Take a hotbackup of the primary database. Bring a tablespace to backup mode, copy the datafiles of that tablespace using an OS command, and bring the tablespace back online. SQL SERVER STORED PROCEDURES OPTIMIZATION TIPSSQL SERVER STOREDPROCEDURES EXAMPLES
In his latest article, Alexander Chigrik offers twelve useful tips for ensuring that you've constructed your SQL Server stored procedures to perform in the most efficient manner possible. GENERATING RANDOM NUMBERS AND STRINGS IN ORACLE Generating random numbers or strings is oft-times a necessity. Oracle provides a random number generator that is faster than writing your won random generation logic in PL/SQL, and can generate both character and alphanumeric strings. Perhaps it is time to learn more about the DBMS_RANDOM package. DISPLAYING AND REMOVING UNPRINTABLE HEXADECIMAL CHARACTERS There are times when you might need to look at your SQL Server data in hexadecimal format. Occasionally some string data will contain unprintable characters, which can cause downstream problems, if not detected and removed. Read on to learn how to display and remove unprintable hexadecimal characters from SQL Server data. HOW TO MOVE A TDE ENCRYPTION KEY TO ANOTHER SQL SERVER If you have a database backup of a Transparent Data Encryption (TDE) enabled database, the database backup will contain encrypted data. Because the database backup contains encrypted data you can’t just restore it to any instance. You can only restore the database backup to an instance that contains the same certificate used to originally encrypt the database. ORACLE'S BULK COLLECT AND LIMIT CAN BE A PROBLEMORACLE BULK COLLECT LIMITBULK COLLECT ORACLEORACLE BULK COLLECT INSERT EXAMPLEORACLE BULK COLLECT INTO TABLEORACLE BULK COLLECT INTO ARRAYORACLE BULK COLLECTINTO COLLECTION
Had there been 18 rows, or had the LIMIT been 7, the insert would have completed, but it would have been a false sense of security as the next FORALL/BULK COLLECT/LIMIT process could fail because the row source wasn't an even multiple of the LIMIT. UNDERSTANDING LOGICAL STANDBY DATABASES Steps in Creating Logical standby Database: 1. Take a hotbackup of the primary database. Bring a tablespace to backup mode, copy the datafiles of that tablespace using an OS command, and bring the tablespace back online. 14 USEFUL DBA TASKS FOR SOLVING DATABASE PERFORMANCE A checklist of DBA tasks involved with keeping an Oracle Database running smoothly can be quite handy. This 14 point checklist, while not actual performance tuning activities are tasks that a DBA needs to know and they will often be part of a solution to remedy a database performance problem. PERFORM ROUTINE SERVER CHECKS USING POWERSHELL Database administrators tend to perform a lot of routine checks, referred to as sanity checks, on a daily, weekly, and monthly basis. Rob Gravelle shows you how to write some PowerShell scripts to automate a couple of fairly common sanity checks. SQL SERVER STORED PROCEDURES OPTIMIZATION TIPS In his latest article, Alexander Chigrik offers twelve useful tips for ensuring that you've constructed your SQL Server stored procedures to perform in the most efficient manner possible. STEP BY STEP GUIDE TO MIGRATE SQL SERVER DATA TO SQL Overview. In a previous article we discussed Data Migration Assistant (DMA) and how DMA can help in migrating an older version of SQL Server to SQL Server 2017. In this article, we will walk through a step by step approach to assess your SQL Server migration using DMA. This activity will help you to understand the behavior of the existing SQL Server and what changes need to be made to TRACKING ROLLBACK PROGRESS IN ORACLE From the second session, we can now monitor the progress of the rollback using the same queries as before. This time the first query reports a rollback is in progress: HOW TO REMOVE TRANSPARENT DATA ENCRYPTION FROM A DATABASE There may be a time when you want to turn off transparent data encryption on one of your TDE enabled databases. In this tip, Greg Larsen shows you how simple it is to remove Transparent DataEncryption.
T-SQL BEST PRACTICES By looking at the above output, you can see that my re-write only has one event displayed in Profile. Moreover, by looking at the CPU, Reads, Writes, and Duration columns you can see this re-write used significantly less resources. HOW TO RESEED YOUR IDENTITY COLUMN VALUE IN SQL SERVER Have you deleted a bunch of rows from a table that has an identity column value? Do you now find that when you insert a new row, you find that the identity column value was set to one higher than the highest identity column value that your table original had? WHERE IS MY SQL SERVER CONFIGURATION MANAGER All it takes to get SQL Server Configuration Manager to show up in the start menu or taskbar is to right click on the snap-in and then select “Pin to Start” or “Pin to taskbar” options, as shown below.Advertisement
Close X
MS SQL
Oracle
DB2
Access
MySQL
PostgreSQL
Sybase
PHP
SQL Etc
SQL Scripts & SamplesTips
Database Forum
Rss Feed
DATABASE JOURNAL HOMEDATABASE ARTICLES
DATABASE TUTORIALSMS SQL
ORACLE
DB2
MS ACCESS
MYSQL
RESOURCES
SQL SCRIPTS & SAMPLESTIPS
DATABASE FORUM
SLIDESHOWS
FREE NEWSLETTERS:
subscribe
Database Journal |DBA Support|SQLCourse
|SQLCourse2
Advertiser DisclosureSearch Search
DATABASE MANAGEMENT & PROGRAMMING NEWS, ARTICLES & TUTORIALS FOR DATABASE ADMINISTRATORS FEATURED DATABASE ARTICLESRSS FEED
WHAT BACKUPS DO I HAVE?05/12/2021
As a DBA you need to check periodically to make sure you have backups. I would recommend you do this daily. TIP 75 - IMPROVING THE PERFORMANCE OF A TABLE VARIABLE USING OPTIMIZERHINT RECOMPILE
04/01/2021
To improve the performance of your code that uses numerous table variables, consider adding the optimizer hint RECOMPILE. TYPE DEFINITION CHANGE IN ORACLE 21C03/04/2021
Oracle 21c now offers the possibility of using some PL/SQL data types in SQL*PLus, with some restrictions. Read on to see what types are available and how to use them. OVERVIEW: SIX BACKUP OPTIONS FOR SAP HANA ON AZURE VMS02/25/2021
You've got a number of options open to you to perform backups of SAP HANA running in Azure virtual machines (VMs). TIP 74 – CHANGING COST THRESHOLD FOR PARALLELISM02/24/2021
Anytime the optimizer calculates a plan that exceeds a given threshold, the optimizer will consider using plans that will goparallel.
DATABASE TIPS
OVERVIEW: SIX BACKUP OPTIONS FOR SAP HANA ON AZURE VMS02/25/2021
You've got a number of options open to you to perform backups of SAP HANA running in Azure virtual machines (VMs).RECENT HEADLINES
ORACLE
TYPE Definition Change in Oracle 21c03/04
more...
MS SQL
Tip 74 – Changing Cost Threshold for Parallelism02/24
more...
MS ACCESS
more...
DB2
more...
Acceptable Use PolicyAn eWEEK Property
Terms of Service |
About Us | Privacy Notice| Contact Us |
Advertise
| Sitemap | California - Do Not Sell My Information Copyright 2021 TechnologyAdvice. All Rights Reserved. ADVERTISER DISCLOSURE: Some of the products that appear on this site are from companies from which TechnologyAdvice receives compensation. This compensation may impact how and where products appear on this site including, for example, the order in which they appear. TechnologyAdvice does not include all companies or all types of products available in the marketplace.Details
Copyright © 2024 ArchiveBay.com. All rights reserved. Terms of Use | Privacy Policy | DMCA | 2021 | Feedback | Advertising | RSS 2.0