(savvinov) In the database world (especially among the database developers) a commit is often viewed as some sort of a virtual “save” button — i.e. it’s something that you need to do to make your changes permanent.
Other News
Using grant connect through to manage database links
(John Hallas) Nobody can say that I am not current and topical with my posts. This post refers to functionality that was introduced in 9i, however I have just come across it and thought it useful enough to blog about it.
How to recover deleted tablespace?
(abdel-mawla) Sometimes, MySQL tablespace file(s) might be deleted by mistake, e.g. delete the shared tablespace (ibdata1) or an individual tablespace (table_name.ibd).
Improving the Visual Studio Account Management Experience
(Ji Eun Kwon) Anyone who has built an application in Visual Studio that uses several services (e.g. roaming Visual Studio settings, accessing Azure services in Server Explorer, or using Windows Store) has probably experienced what we’ve come to call “sign-in Whack-A-Mole,” with prompts popping up wh
Merge Join
Merge Joins are another technique used by SQL Server to join tables with a large number of records. A merge join works effectively when the data from both tables is sorted in the same order. It takes the data from each table and works through both tables simultaneously, moving forward in either table when the value from the opposite table […]
SQL Server 2014 Merge Replication Optimization Tips (Part 2)
SQL Server 2014 Merge Replication Optimization Tips (Part 2) Do not forgive to script your replication configuration. Because scripting the replication configuration is a key part of any disaster recovery plan for a replication topology, you should script your replication configuration from the replication wizards or from the Replication folder in Microsoft SQL Server Management Studio. If you do not...
This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here
Linux swap space and DB2
(Jack Vamvas) To view the linux swap space and usage ,use one of these commands
Managing the Database Administrator – The Team
(Lockwood Lyon) Assigning tasks to DBAs is based upon task complexity, schedules and service level agreements, and the DBA’s expertise. Some DBAs tend to be generalists. New DBAs start out this way, and only develop specialized in-depth knowledge later in their careers.
What is the Difference between GROUP BY and ORDER BY
(Kris Wenzel) All the examples for this lesson are based on Microsoft SQL Server Management Studio and the AdventureWorks2012 database.
Specifying Allowed Values, Sample Values and Descriptions For Function Parameters In Power Query–Part 2
(Chris Webb) In part 1 of this series I showed how you can set properties for Power Query function parameters so that saw a description, an example value and a dropdown list containing allowed values when they invoked the function. In this post I’ll show a slightly more complex use of this functiona